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

Designing to omit ____________________ will help to produce good and valid database designs.

Case 1-2 Now that Joe has created the tables and determined the primary and foreign keys,he needs to determine the data types for the fields in each table. -What data type should Joe use for the Social Security Number field? Why?

To undo the most recent change to a table structure,tap or click the ____ button on the Quick Access Toolbar.

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

Identify the letter of the choice that best matches the phrase or definition. -Field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

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.

Form view displays a single record at a time.

When Access first creates a database,it automatically creates a table.

Each customer has one book rep,but each book rep can have many customers.This is an example of a one-to-many relationship.

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 the Navigation Pane,tap or click the ____ Button.

Standard properties are associated with all Microsoft Office documents and include author,title,and subject.

A(n)____ contains information about a given person,product,or event.

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

The AutoError Correction feature of Access corrects common data entry errors.

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

One way to undo changes to a field is to click the Undo button on the status bar.

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

A unique identifier also is called a(n)____________________.

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.