Exam 1: Access Lesson 1: Understanding Access Fundamentals

To select all records in the database, you can click the datasheet selector box in the upper-left corner of the datasheet.

The keyboard shortcut ____ + O will display the Open dialog box.

Each field in a datasheet is displayed as a row and is identified by its field value at the top.

You can display Backstage view to create a new database using a template, create a new blank database, or open a recently used database by clicking the ____________________ tab.

By default, Access creates an ID field in every table that can serve as the ____.

In Datasheet view, you can navigate among the records in a table using the navigation buttons on the ____.

Case AC 1-2 Sheila's company has just made revisions to the benefits package. Sheila needs to make some changes to the database containing employee information. To select a single record, Sheila would click the record selector box ___.

When a primary key is included in another table, it is called a(n) ____________________ in the second table.

When you start Access, Backstage view is displayed.

Before closing a database, all database objects must be saved and closed.

You can change the field name by clicking the Name & Caption button in the Properties group on the ____ tab and then typing a new field name.

Each field in a table has a(n) ____________________ that determines the types of field values you can enter in that field.

A ____ is a single characteristic or piece of information stored in a database table.

When you ____ a record, a message will be displayed asking you to confirm the action.

____________________ control the appearance and behavior of a field.

When you create a new database, a new table is automatically created and displayed in ____ view.

The ____ on the left side of the Access program window lists all of the objects in the database.

To close Access, click ____ on the File tab.

The Search box at the top of the Open dialog box shows the folder path.