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

To show the symbol for the Euro instead of the dollar sign,change the ____ property for the field whose data type is Currency.

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(n)____________________ contains a specific piece of information within a record.

In a(n)____ database such as those maintained by Access,a database consists of a collection of tables,each of which contains information on a specific subject.

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 exit Access,tap or click the ____ button on the right side of the title bar.

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 -Presents information about the database object,the progress of current tasks,and the status of certain commands and keys.

To rename 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 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.

The term list database describes a database that consists of a collection of tables,each of which contains information on a specific subject.____________________

To delete a field in a table,press and hold or right-click the column heading for the field,and then tap or click ____ on the shortcut menu.

To open a table in Design view,press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu

You can place an insertion point by tapping or clicking in the field or by pressing ____.

To save the changes to the layout of a table,tap or click the Save button on the ____.

Changing the column width in a datasheet changes the structure of a table.

Society encourages users to contribute to ____________________ computing,which involves reducing the electricity consumed and environmental waste generated when using computers,mobile devices,and related technologies.

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 -Field can contain only monetary data.

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

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

A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.____________________