Exam 1: Word Module Access Module Creating a Database

Each record in a table is uniquely identified by a foreign key. 

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

In a relational DBMS, a user may create a database structure that contains which of the following?

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

Which Access 2016 view contains commands used to manage Access files and options?

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

The query results are stored in the database in which the query has been created.

Which data type allows field values to contain letters, digits, and other characters?

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

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

The default sort order for records in an Access table is based on the values in the primary key field.

A single characteristic or attribute of a person, place, object, event, or idea is a  table . 

The default primary key for an Access database is the ID field. 

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

It is possible to view all Access objects in the Navigation Pane . 

Files created with Access 2016 may be used with which previous version of Access?

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

Which Access database object(s) might be used to enter, edit, and view records in a database?

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

The default ____________________ provided by Access is the ID field.