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

The Access window consists of a variety of components.These include the ____.

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

-As shown in the accompanying figure,you can use the Last record button to move to the last record in the table.

In Access,table and field names can be up to ____ characters in length.

To create an initial report that can be modified in Layout view,tap or click ____ on the CREATE tab.

To delete a database object,press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

To delete a field,press and hold or right-click the column heading for the field,and then tap or click Remove Field on the shortcut menu.____________________

Identify the letter of the choice that best matches the phrase or definition. -View that shows a report on the screen and allows changes to the report.

To specify AutoCorrect rules and exceptions to the rules,tap or click FILE to open the Backstage view,tap or click ____ ,and then tap or click Proofing in the dialog box that displays.

A hard copy or ____________________ is information that exists on a physical medium such as paper.

____________________ refers to the process of determining the tables and fields that make up the database.

A(n)____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

-In the accompanying figure,book rep names appear more than once in the table.Storing this data on multiple records is an example of redundancy which can cause several problems. What are these problems? What is the solution to the problem?

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

Identify the letter of the choice that best matches the phrase or definition. -View that shows a report on the screen and does not allow changes to the report.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

To change the print orientation from portrait to landscape,tap or click the ____ button on the PRINT PREVIEW tab.

Redundancy means storing the same fact in more than one place.

To change the design of a query,press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To define an additional field in Datasheet view,tap or click the ____ column heading.