Welcome to Office Jeopardy (Access edition)

1. Welcome to Office Jeopardy(Access edition) Grauer and Barberwww.prenhall.com/grauer Click once to display answer; click the answer to return to the question board

2. Queries and Reports Beyond the Basics Tables and Forms Table Properties Access 101 (c) Grauer and Barber - 2005

3. A set of fields What is a record? Click once to display answer; click the answer to return to the question board

4. The field (or combination of fields) that makes a record unique What is a primary key? Click once to display answer; click the answer to return to the question board

5. A set of records What is a table? Click once to display answer; click the answer to return to the question board

6. The view of a table in which you add, edit, and delete records What is the Datasheet View? Click once to display answer; click the answer to return to the question board

7. Displays a subset of records from a table according to specified criteria What is a filter (or query)? Click once to display answer; click the answer to return to the question board

8. Provides a friendlier interface through which to add, edit, and delete records What is a Form? Click once to display answer; click the answer to return to the question board

9. Recommended field type for phone numbers and zip codes What is a Text field? Click once to display answer; click the answer to return to the question board

10. Field type whose value is created automatically for each record What is an AutoNumber field? Click once to display answer; click the answer to return to the question board

11. The three types of controls on a form What are Bound, Unbound, and Calculated controls? Click once to display answer; click the answer to return to the question board

12. Characteristic of an object that determines how the object looks and behaves What is a Property? Click once to display answer; click the answer to return to the question board

13. Appears at bottom of every page in a report What is a page footer? Click once to display answer; click the answer to return to the question board

14. Has a mathematical formula or function as its data source What is a calculated control? Click once to display answer; click the answer to return to the question board

15. Displays the results of a query What is a Dynaset? Click once to display answer; click the answer to return to the question board

16. Has three arguments: a condition, the result when the condition is true, and the result when the condition is false What is the IIF function? Click once to display answer; click the answer to return to the question board

17. The most common type of query What is a Select query? Click once to display answer; click the answer to return to the question board

18. The primary key of another table What is a Foreign Key? Click once to display answer; click the answer to return to the question board

19. Requires that tables in a database be consistent with one another What is Referential Integrity? Click once to display answer; click the answer to return to the question board

20. Imports or links data from Excel into an Access database What is the Get External Data command? Click once to display answer; click the answer to return to the question board

21. Uses aggregate functions to perform operations on groups of records What is a Totals Query? Click once to display answer; click the answer to return to the question board

22. The table associated with a switchboard What is the Switchboard Items table? Click once to display answer; click the answer to return to the question board

23. Changes the way a field is displayed, but does not affect the stored value What is the Format property? Click once to display answer; click the answer to return to the question board

24. Rejects any record that does not have a value for the field What is the Required property? Click once to display answer; click the answer to return to the question board

25. Rejects any record in which data does not confirm to specified rules for data entry What is Validation Rule property? Click once to display answer; click the answer to return to the question board

26. Facilitates data entry by displaying literal characters such as hyphens in a Social Security Number What is the Input Mask property? Click once to display answer; click the answer to return to the question board

27. Automatically enters a designated value for the field in each new record What is the Default Value property? Click once to display answer; click the answer to return to the question board