Exam 2: Databases and Database Objects: an Introduction

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

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

The TextCheck feature of Access corrects common mistakes when entering text in a cell.

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 create a query using the Query Wizard, click ____ on the Ribbon and then click the Query Wizard button.

In the accompanying figure, the Business Analyst Table displays in ____.

To move a field, click the column heading for the field to be moved to select the field, and then ____________________ the field to the desired position.

A unique identifier also is called a record key.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

A field that has an AutoIncrement data type can store a unique sequential number that Access assigns to a record.

To add a record to a table, click the ____ record button.

Critical Thinking Questions Case 1-2 Now that Phil 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 Phil use for the Hourly Pay Rate field? Why?

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

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

If it is desirable to have a name other than the field name appear at the top of a column in Datasheet view, change the field's ____________________ to a different name.

Modified Multiple Choice You can create a table in ____.

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

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

To import data to a table, click the ____ tab on the Ribbon.