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

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

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

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

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

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________

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

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

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

Which field in the Project table should be the primary key and why?

Landscape orientation means the printout is across the length (height) of the page.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

Critical Thinking Questions Case 1-1 Joe has been asked to create a Special Projects database for his company. The database is to track employees and the special projects to which the employees may be assigned. A special project can have between 2 and 5 employees assigned to it. He has determined that he needs the following tables: Employee (Social Security Number, Last Name, First Name, Street Address, City, State, Postal Code, Hourly Pay Rate, Project Code) Project (Project Code, Project Name, Total Hours, Completion Date) Which field in the Employee table should be the primary key and why?

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

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

In Datasheet view, a table is represented as a collection of rows and columns called a list.

A field whose data type is ____ can store text that can be used as a hyperlink address.

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.

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

Access is a ____.

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.