Exam 3: Access : Databases and Database Objects : an Introduction

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.

To create a query using the Query Wizard, click ____ on the Ribbon and then click the Query Wizard button.

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject.

Redundancy is the storing of a piece of data in more than one place.

In Access, the rows in a table are called records.

To back up a database, use the Back Up Database command on the ____ tab in the Backstage view.

The Status bar contains a list of all the objects in the database.

A(n)____________________ is a software tool that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data in the database.

A unique identifier also is called a(n)____________________.

To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.

Discuss the difference between the way Access saves a record and the way Excel saves a row in a worksheet.

Now that Phil has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table.What data type should Phil use for the Hourly Pay Rate field? Why?

Database ____ refers to the arrangement of data into tables and fields.

To delete a record, click the record selector for the record, and then press the ____ key(s).

In the accompanying figure, the small box or bar to left of each field is called the ____.

A soft copy is information that exists on a physical medium such as paper.

A unique identifier also is called a record key.

To import data to a table, click the ____ tab on the Ribbon.