Return to Home Page        

PRE-TEST FOR MICROSOFT ACCESS

Answer Guide: ( If you answered 20 or more questions correctly, register for the next level of  Access.)

1. A database is __________
   b.  a collection of data organized in a manner that allows access, retrieval, and use of that data
   
2. Which of the following is not a benefit of controlling redundancy
   d.  all of the above are benefits
3. A field that uniquely identifies a particular record in a table is called a ________.
   d.  primary key
4. Access is a(n) ________
   d.  Both a and b
5. To add a record to a table that already contains data, open the table and click the ________.
   b.  New Record
   
6. A record in Access is composed of a ________
   d.  series of fields
7. To make a field the primary key for a table, select the field and then click the ______ button on the toolbar.
   d.  Primary Key
8. To remove a field from a table structure, select the field and then press the _____ key(s).
   a.  delete
   
9. To change to landscape orientation to print a table, on the File menu, click _____
   b.  page setup
   
10. To move from the upper pane, the one where you define fields, in the table window to the lower pane, the one where you define field properties, press the _____ key.
    c.  F6
    
11. To list only certain records in a table, use a(n) _________
    d.  query
12. To add a field to a table structure, select the field below where you would like the new field inserted and then press the _______ key(s).
    d.  Insert
13. To clear all the entries in a design grid, on the _______ menu, click Clear Grid.
    a.  edit
    
14. The wildcard symbols available for use in a query are the _______ and the _____
    b.  question mark (?), asterisk (*)
    
15. Equal to (=), less than (<), and greater than (>) are examples of ______
    c.  comparison operators
    
16. When two or more criteria are connected with AND or OR, the result is called a _______.
    d.  compound criterion
17. To add an additional table to a query, click ______ on the shortcut menu for the Select Query window.
    c.  add table
    
18. Use a query to _________ tables, that is find records in two tables that have identical values in matching fields.
    d.  join
19. To remove a table from a query, right-click any field list for the table and then click _______ on the shortcut menu.
    b.  delete table
    
20. To add a Total row to a design grid, click ________ on the shortcut menu for the Select Query window.
    d.  totals
21. To specify referential integrity, click the __________ button on the toolbar
    b.  relationships
    
22. A(n) __________ key is a field in one table whose values are required to match a primary key of another table.
    d.  matching
23. ____________ rules are rules that the data entered by a user must follow.
    b.  validation
    
24. To search for a specific record in a table, select the field to search and then click the ______ button on the toolbar
    c.  find
    
25. To force all letters in a field to display as uppercase, use the _____ symbol in the Format test box.
    b.  >