A field used to uniquely identify each record in a table
What is a primary key?
100
The view you use to enter data into a table
What is Datasheet View?
100
The Access database object that asks a question about the data stored in a database and displays specific fields and records that answer the question
What is a query?
100
A field that you create with an expression in a query that does not exist as a field in the database. For example --> Late Fee: InvoiceAmt * .02
What is a calculated field?
200
The database object that actually contains all of the data
What is a table?
200
A data type that allows field values to contain letters, digits, and other characters
What is short text?
200
The symbol that appears in a row selector (at the left of a row) to indicate that the record is being edited
What is the pencil symbol?
200
What you must do to answer a query and display its results
What is run the query?
200
A row that you can add to the Query Design grid that allows you to calculate the sum or average of numeric fields
What is the Total row?
300
One row of a table, containing a complete set of field values for one item
What is a record?
300
The table view that allows you to define or modify a table structure or the properties of the fields in a table
What is Design View?
300
A type of text file in which fields of data are separated by a character such as a comma or tab
What is a delimited text file?
300
The row in the Query Design grid where you choose either "ascending" or "descending" for a specific field to control the order of the records displayed
What is the Sort row?
300
The condition you would enter in the Criteria row for the BirthDate field if you wanted to select records of people born in 1980 or later
What is >=1/1/1980 (or >12/31/1979)?
400
A field that appears in two separate tables and may be used to connect records in the separate tables
What is a common field?
400
A field property that specifies how the field name is displayed in datasheets, forms, and reports
What is the Caption Property?
400
The process of adding, changing, and deleting records in database tables to keep them current and accurate
What is maintaining (or updating)?
400
A criterion, or rule, that determines which records are selected when a query is run
What is a condition?
400
In the Total row of a query, the operator that divides the selected records into groups based on the values in the specified field
What is the Group By operator?
500
A type of relationship between two tables where one record in the first table matches zero, one, or many records in the second table
What is a one-to-many relationship?
500
The condition that happens when you store the same data in more than one table - it wastes space and can cause inconsistencies
What is data redundancy?
500
Rules that Access enforces to maintain consistency between related tables when you enter or update data
What is referential integrity?
500
The logical operator you use in a query when you want a record selected if at least one of the specified conditions is met
What is Or?
500
Functions that perform arithmetic operations on selected records in a database