Exam 11: Access_Module_1

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

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?

Form view displays a single record at a time.

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

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

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

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

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 field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________

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.

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

The ____________________ data type in Access is referred to as Money in SQL Server.

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 compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

In Access, the columns in a table are called records.

In Access, field names cannot contain digits.

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________

Critical Thinking Questions 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 change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.