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

Identify the letter of the choice that best matches the phrase or definition. -Field can store a unique sequential number that Access assigns to the record.

-In the accompanying figure,the database name,Bavant Publishing appears on the ____________________.

To change the name of a field,press and hold or right-click the column heading for the field,tap or click ____ on the shortcut menu,and then type the desired field name.

The Navigation Pane contains a list of all the objects in the database.

A(n)____________________ is software 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.

To change the name of a field,press and hold or right-click the column heading for the field,and then tap or click Rename Field on the shortcut menu.____________________

Field names cannot contain ____.

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

Access is a ____.

-In the accompanying figure,the entire area that displays on the screen is called the ____________________ work area.

-In the accompanying figure,the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

To preview and then print the contents of a table,use Table Preview.

A unique identifier also is called a primary key.

Layout view shows a report on the screen and allows the user to make changes to the report.

A field with the ____ data type can store a unique sequential number that Access assigns to a record.Access will increment the number by 1 as each new record is added.

The determination of database requirements is part of a process known as ____________________.

A field with a Yes/No data type can store only one of two values.The choices are ____.

-In the accompanying figure,____________________ for the open objects appear at the top of the work area.

File names cannot contain a(n)____.

A field whose data type is ____ can store text that can be used as a hyperlink address.