The condition that requires a value in a specified field to be identical to the specified condition is called a(n)
You can tell if a field will appear in the query datasheet if there is a check mark in the field's ________check box in the design grid.
To include a field in a query, you can click and _______the field from the field list to the design grid.
In a form with a main form and a subform, there will be two sets of _________________ buttons for use in selecting records from each of the tables.
The Access feature that can guide you through the creation of a report by asking questions is called the _____________.
When creating a form based on two tables, you create a subform for data from the _____ table.
When you create a form containing data from two tables that have a one-to-many relationship, Access uses the defined relationship between the two tables to automatically join the tables through the _______________that exists in both tables.
External Data and Import
You can import a table from another Access database into your current database using the ____________ tab of the ________ group on the Ribbon.
A defined query for an open database can be selected by double-clicking in the _______________ of the Database window.
When creating a form based on two tables, you create a form for data from the ________ table.
Forms for tables that have a one-to-many relationship will have a(n) _________form and a subform
To create a form based on two tables, you must first define a(n) ___________ between the two tables.
If you have a Customer ID field with values like 1234, you should use the _________data type.
In a given table, a field is defined as a(n) ____________ when its values uniquely identify each record in the table.
You use the ____________________ tab if you want to import data from an Excel worksheet.
The aggregate function, _______, returns the number of the non null field values in a selection of records.
If a form shows two forms of two different tables, the bottom form is for the _________.
A range of values may be specified as selection criteria by using the __________ operator.
Operators used in selection criteria in a query, such as equal, not equal, or greater than, are known as ___________ operators.
When you sort a field with a Yes/No data type in _________ sort order, the no values display first, followed by the yes values.
Reference _______ is a feature built in to Access to prevent data inconsistency in related tables.
The ____________ relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table.
The ____ operator will cause a record to be selected only if two or more conditions are satisfied.
Statistical information, such as totals and averages, can be calculated in a query by using a(n) ________________.
The join line for a one-to-many relationship will show the ________ symbol on the "many" end of the line.
The F5 key is a toggle that you use to switch between the Table Design grid and the Field Properties pane
You can import a table from another Access database into your current database using the Import button on the Ribbon.
The Navigation Pane divides database objects into categories, and each category contains groups