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.