Exam 11: The Four Main Database Objects

Access 2016 uses a different file extension than previous versions of Access.

A structure of a database that is already populated with tables,fields,forms,queries,and reports is a(n)________.

The Back Up Database command is located on ________ view.

The ________ operator in a query selects the records in which the field value is not equal to the value provided.

Reports have ________ views.

________ view shows the data in a form and allows for data entry.

To see how a report would look on a printed page,go to Print ________.

If you want to insert data from another file into an Access database,you must use copy and paste.

Backing up a database will help protect you against any mishaps with the original database such as accidental loss of data.

Operational databases are used for extracting data for decision making.

The data contents within a table can be seen in Design view.

________ an Access database rearranges objects so disk space is used more efficiently.

To create objects,a(n)________ can be used to serve as a step-by-step guide.

The Navigation Pane is used to navigate through a table.

If no sorting sequence is specified when creating a query,Access will sort the results of the query by the ________.

Each column in an Access table is called a(n)________.

Before working in a database,it is beneficial to explore the database ________.

A column in an Access table is called a characteristic.

The import data options are located on the ________ tab.

The ________ view of a table displays the data stored in the table.