Access Database Test

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

A form created from two tables that have a ____ relationship creates a main form and a subform.

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

Queries based on more than one table, must have a ______ field.

The + symbol is an example of a(n) ___ operator.

In the criterion, <=250, the operator will return values for the specified field that are ____.

Data may be sorted in the table data sheet, a form, and a _____.

The comparison operator, <>, is used to insert a condition that means _____.

A field in an Access database table that has no value is determined by Access to have a _____ value.

A field used to connect one table logically with another table is called a _____ field.

The common field between two tables in the Relationship window is indicated by a(n) _____.

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a _______ relationship.

The _____ property allows the database designer to explain the purpose of a field or how a field is used.

The _____ property specifies the number of decimal places displayed to the right of the decimal point.

The data type that allows both sequential and random numbering is the ____ data type.

Which Access database object asks a question about the data stored in the database and displays specific fields and records that answer the question?

Each column in an Access table datasheet represents a ____.

The specific content of a field is referred to as the ____.

Which view is used to make design changes to a form while the form is displaying data?

Another term used for the column selector feature is _____.

Data organized as a collection of tables creates this type of data system.

Which of the following is the file extension used for Access 2016 data base files?

To save a table in Access with the name that relates tot eh database (a name other than the Access default name), it is necessary to complete which process?

When copying and pasting records from one table to another, the records must first be copied to the _____.

Which of the following attributes of the table are saved only when the table object is saved?