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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -A commonly accepted shorthand representation for showing the structure of a relational database.

In Access,field names cannot contain digits.

A unique identifier also is called a primary key.

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

-As shown in the accompanying figure,you can move to the end of a table to a position for entering a new record by clicking the Insert record Navigation button.

-In the accompanying figure,the ____________________ Pane contains a list of all the objects in the database.

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.

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

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

When you assign a(n)____ to a field,Access will display the value you assign,rather than the field name,in datasheets and in forms.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.AutoNumber f.Currency b.Layout view g.Metadata c.DBDL h.Print Preview d.Report view i.Short Text e.Long Text j.status bar -View that shows a report on the screen and does not allow changes to the report.

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

You can create a table in ____.

The DATABASE TOOLS tab provides commands to save a database with another name.

____________________ view has more functionality for creating a table than Datasheet view.

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

To define an additional field in Datasheet view,tap or click the ____________________ column heading,select the data type,and then type the field name.

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.____________________

File names cannot contain a(n)____.

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