Create an account
The characteristics of a field, such as name, size, and type, are called the field _______.
Which view would you select if you wanted to define a table yourself from start to finish?
If a primary key from one table is also defined in a second table to form a relationship, the field is called a ________ in the second table.
The ________ data type allows field values containing letters, digits, spaces, and special characters; it is used for long comments and explanations.
For the _______ data type, Access automatically assigns either a sequential or random numbering field.
Which of the following fields does not have a Field Size property? (Text, Number, and AutoNumber Fields DO)
When you are constructing a query, you can see the results at any time by clicking the ________ button.
Using ____, you give Access an example of the information you are requesting; Access then retrieves the information that precisely matches your example.
If there are related records in a related table, you can't delete a record in the primary table until you delete the _______.
Related Records First
In order to delete a record in a table, you must first
Delete any related records in a subdatasheet.
Generalized queries that specify fields and records to be selected are called ______ queries.
You can automatically include all of the fields in a table in a query by _______ the asterisk that appears in the Field List box in Query Design view.
A ______ datasheet is temporary and its contents are based on the criteria you establish in the design grid.
A selection condition that dictates the value in the specified field must precisely match the condition known as a(n) ______ match.
Operators used in selection criteria in a query, such as equal to, not equal to, or greater than are known as _______ operators.
Selection criteria that are placed in different rows in the query design grid indicted an ______ operator.
A calculation can be defined in a query by typing it directly into a field box in the _____.
Statistical information, such as totals and averages, can be calculated in a query by using a(n) ________.
When you run a query that contains a ____ field, Access evaluates the expression defined by the field and displays the resulting value in the query, datasheet, form or report.
A from using all fields in a selected table can be created automatically using the ______.
A form can be used to display fields from multiple records at one time by specifying the ______ layout.
A(n) ______ is an item on a form, report, or other database object that you can manipulate to modify the object's appearance.
Maintaining data using a form is often easier than using a(n) __________ because you can focus on all the changes for a single record at one time.
When a pencil symbol appears in the upper-left portion of the form, it means that the form __________.
Is in Editing Mode
When creating a form that accesses data from two tables, Access uses the defined _____ to join the tables.
When you create a from containing data from two tables that have a one-to-many relationship, you create a(n) _________ for data from the primary table.
In a form created to access two tables, there is/ are ______ navigation buttons displayed.
Two Sets Of
In the Report Wizard dialogue box in which you choose a grouped or ungrouped report, you can display tips for creating reports and examples of reports by clicking the _______ button.
Show Me More Information
When you point to a theme in the gallery of themes, a ______ displays the names of database objects that use that theme.
The _______ quickly creates a form containing all the fields in the table (or query) on which you are basing the form.
Selecting data by means of a query _________.
Displays only the data that matches the query selection criteria
__________ a database rearranges data and objects in a database to make its size smaller.
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