1. The title bar displays the name of the program, the program icon, and:
a. Menu names.
b. Toolbar buttons.
c. The Minimize, Restore Down/Maximize, and Close buttons.
d. The program's current status.

2. Task panes in Access include Getting Started, Help, and:
a. Search Results.
b. Database Operations.
c. Printing.
d. Troubleshooting.

3. A menu item that displays a dialog box includes a(n):
a. Triangle.
b. Arrow.
c. Checkmark.
d. Ellipsis.

4. Access allows you to create your own, customized toolbars.
a. True
b. False

5. Which function key is used to display the Help task pane?
a. F1
b. F3
c. F5
d. F7

6. Microsoft Access is a _______ program.
a. Word Processing
b. Database Management
c. Presentation
d. Spreadsheet

7. Tables consist of records and:
a. Columns
b. Fields
c. Rows

8. The window that displays the objects in the database is called the:
a. Main Switchboard.
b. Objects window.
c. Forms control.
d. Database window.


9. Database objects include tables, forms, reports, and:
a. Fields
b. Records
c. Queries
d. Projects

10. The Back Up Database command creates copies of pre-selected database objects.
a. True
b. False

Chapter 3
Working with Tables

11. A column in Datasheet view corresponds to a:
a. Row.
b. Record
c. Form
d. Field

12. The buttons that allow you to move to the first, previous, next, or last records are located in the _______ area of the Datasheet view.
a. Scroll bar
b. Toolbar
c. Navigation
d. Workspace

13. Access automatically saves changes to a record when another record becomes active.
a. True
b. False

14. Which type of filtering allows you to select a field and then shows you all the records that match your selection?
a. Filter by Form
b. Filter by Selection
c. Filter by Type
d. Filter by Example

15. Fields are arranged in the PivotChart view by:
a. Dragging them to specific locations.
b. Identifying them in the PivotChart dialog box.
c. Specifying them to the PivotChart Wizard.

Chapter 4
Designing Tables

16. You define the different fields for your table in _______ view.
a. Datasheet
b. Table
c. Design
d. Database

17. Which type of field stores logical, two-valued data?
a. Date/Time
b. Yes/No
c. Text
d. On/Off

18. To link a field to a field in another table, click the field Data Type drop-down arrow, and then click:
a. Create link.
b. Link to field.
c. Hyperlink
d. Lookup Wizard.

19. You can use the Input Mask Wizard to format data and to provide control over what values you can enter into a field.
a. True
b. False

20. What command is used to free unused space in a database file?
a. Compress Database File
b. Reformat Database
c. Defragment Database
d. Compact and Repair Database

Chapter 5
Creating and Running Queries

21. To search a database for specific information, create a:
a. Wizard.
b. Search.
c. Query.
d. Find.

22. To display records that meet certain conditions, enter information into the _______ row.
a. Build
b. Criteria
c. Sort
d. Summary

23. When calculated fields are used in queries, the result of the calculation is saved in an Access table.
a. True
b. False

24. The lines that tell Access how data is related between tables or queries in a database are called _______ lines.
a. Query
b. Double
c. Relational
d. Join

25. To apply rules that protect the relationships between tables when you are adding or deleting records set the _______ option.
a. Protect Relationships
b. Enforce Referential Integrity
c. Multi-Table Join Protection
d. Cascade Delete Related Records

Chapter 6
Using Forms

26. Use a _______ to view or edit records one at a time.
a. Query
b. Table
c. Form
d. Report .

27. The Form Wizard allows you to choose a layout and a _______ for a form.
a. Sort order
b. Record grouping
c. Page length
d. Style

28. Form Design view is used to:
a. Create and edit forms.
b. Create tables.
c. Run macros.

29. The _______ _______ is used to move around a form in Form view.
a. Move box
b. Drag box
c. Navigation bar
d. History list

30. A data access page enables you to work with records using a(n):
a. Word processor.
b. Web browser.
c. Spreadsheet program.
d. SQL database.

Chapter 7
Generating Reports

31. To present database information in a formatted, organized fashion, create:
a. An AutoLayout
b. A Database Wizard
c. A Report
d. A Format

32. The feature that allows you to create a quick report on a table or a query is:
a. AutoReport.
b. AutoLayout.
c. QuickReport.
d.QuickFormat.

33. _______ _______ allows you to view a report before it is printed.
a. Quick Preview
b. Auto Preview
c. Report Preview
d. Print Preview

34. The Report Wizard speeds up the process of creating a report because it does all of the basic work for you.
a. True
b. False

35. The easiest way to create mailing labels is to use:
a. An AutoReport.
b. The Report Wizard.
c. The Label Wizard.
d. The Address Book Wizard.