Exam 3: Access: Creating and Using a Database

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

To change the save location for a database, click ____ in the Favorite Links section.

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

Critical Thinking Questions Case 1 Mary has been asked to create a database for her company. The database is to track employees and the departments for which the employees work. A department can have between 5 and 15 employees. She has determined that she needs the following tables: Employee (Social Security Number, Employee Name, Street Address, City, State, Postal Code, Date Hired, Salary, Department Code)Department (Department Code, Department Name)Which field in the Employee table should be the primary key and why?

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 specify AutoCorrect rules and exceptions to the rules, click ____ on the Office Button menu and then click Proofing in the dialog box that displays.

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

Figure 1-3 In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.

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

When you create a database, you should follow some general guidelines for database design. What are these seven guidelines?

To hide the Navigation Pane, click the ____ Button.

To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ____ on the Print submenu.

In the accompanying figure, the small box or bar to left of each field is called the ____.

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

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

Replication is the storing of a piece of data in more than one place.

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

Figure 1-3 In the accompanying figure, the buttons at the bottom-right edge of the screen are ____________________ buttons, which you use to change the view that is currently displayed.