Create an account
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
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together