1. Certain words have special meaning to Access, and you should avoid using them as table or field names. What are these words called?

2. What tool builds a report containing detailed information about the object in the database?

3. How can you add multiple view button controls to a form at once?

4. You want to validate a proposed modification to a record's value before the table is saved to the database. What data macro can you add to the table to do this?

5. You want to validate a proposed modification to a record's value before the table is saved to the database. What data macro can you add to the table to do this?

6. How can you ensure that each value saved in a particular field is unique from all other values in the field?

7. When backing up an Access database, what is added to the file name automatically?

8. Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?

9. The expression values <=, <>, and > are found in what expression category?

10. When you add a group to a report, what automatically gets added to the structure?

11. The display for numerical data defaults to a '\_alignment, and text data defaults to '\_aligntment

12. What kind of query will display data with both column headers and row headers?

13. Which Access database tool will help you split a single, large, unnormalized data table into multiple related tables that follow the best practices of good database design?

14. What currency format displays a thousand separator, but not a currency symbol, such as $ or €?

15. What program flow function evaluates a condition and either returns a truepart or a falsepart?

16. Which combo box property defines what values appear when the user clicks the drop-down arrow?

17. Which Access database tool will help you split a single, large, unnormalized data table into multiple related tables that follow the best practices of good database design?

18. Which section of a report appears at the top of every page in the printed report?

19. On a report, you want to display a header for each change in month name. How should you set up the Group and Sort options so that they are in the proper chronological order?

20. Which section of a report appears at the top of every page in the printed report?

21. Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?

22. The relationship field in this table has been created with what feature?
'

23. A table contains a field with the lookup properties set as shown. What will be the value of the field when the end user clicks Normal from the combo box when entering a record into the table?
| General | Lookup |
| --------------- | ------------------------------- |
| Display Control | Combo Box |
| Raw Source Type | Value List |
| Raw Source | 1:'High'; 2 :'Normal'; 3: 'Low' |
| Bound Column | 1 |
| Column Count | 2 |
| Column Heads | No |
| Column Widths | 0; 1 |
| List Rows | 16 |
| List Width | Auto |

24. What does the expression Now() evaluate to?

25. In Design view, which area of a form is the primary location for text boxes, buttons, and other control objects?