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

A field whose data type is ____ can store an OLE object,which is an object linked to or embedded in the table.

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

To view the results of a saved query,press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

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

-In the accompanying figure,the buttons at the bottom-right edge of the screen are ____________________ buttons,which you use to change the view that is currently displayed.

-In the accompanying figure,the Book Rep table displays in ____.

Form view displays a single record at a time.

____ words are words that have a special meaning to Access and cannot be used for the names of fields.

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

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

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 -Can include such information as the file's author,title,or subject.

To compact and repair a database,tap or click the ___ button in the Info gallery in the Backstage view.

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

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

Access is a ____.

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.

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 allows changes to the report.

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

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

The Currency data type is used for fields that contain only monetary data.