& operator - correct answer combine the contents of two text fields
aggregate function - correct answer calculate on groups of records (also called
... [Show More] built in functions). EX. can average values n a numeric field using avg sql keywords
alias - correct answer the name assigned to a new computed field. can be applied to any field. Uses the AS keyword
American National Standards Institute (ANSI) - correct answer An organization
that oversees the development of voluntary
consensus
standards for products, services,
processes, systems, and
personnel
in the United States. SQL is a standard language according to ANSI and ISO
American Standard Code for Information Interchange (ASCII) - correct answer standardized way to represent characters in numeric form. values 0 through 31
AND operator - correct answer all the conditions must be true for a particular record to be selected
AUTOINCREMENT - correct answer field whose values automatically increment
by 1 as new records are added.
AutoNumber - correct answer The Access data type for a field whose values
automatically increment by 1 as new records are added.
BETWEEN operator - correct answer An operator that allows you to specify
a range of values for the criteria, including the lower number,
the higher number, and all numbers in between.
Boolean - correct answer data type for fields that store only Yes or No (On or Off, True or False) values.
built-in-functions - correct answer A function such as SUM built into the SQL
language
BYTE - correct answer Microsoft Access data type used in the CREATE TABLE statement for a number field of BYTE size (0-255).
calculated field - correct answer A field whose value is calculated from other
fields in the database; also called a computed field
CHAR - correct answer A data type for a fixed-length string field, often
expressed as CHAR(n), where (n) identifies the length.
compound condition - correct answer Two simple conditions (criteria) in a
query that are combined with the AND or OR operators. Can also use the between operator.
computed field - correct answer A field whose value is computed from other
fields in the database; also called a calculated field.
concatenation - correct answer The combination of two or more rows in an
operation, such as a join, or the combination of two or more columns for a primary key field to uniquely identify a given row in the table; also, joining two or more strings of textual data into one piece of data. [Show Less]