1. All of the following are action queries, except?

 Delete query
 Update query
 Append query
 Transfer query

2. What happens when you query multiple tables without a defined relationship?

 The query scrambles the data from the table.
The query fails to run.
Access creates a new relationship for you.
Access prompts you to define the relationship you want.

3. Which of the following is not true about a linked table in Access?

 You can link a table only in a database not a project.
 When linking across a local area network be sure to use a universal naming convention path.
 Access can't use a linked table if the indexes you specified aren't current.
The linked table manager will move a database and/or table files to a new location.

4.     A text box and a list box combined describes which of the following?

 Combo box
 Row source property
 List count property
 Drop-down list box

5. Which of the following does not describe a form/sub form combination?

 Hierarchical form
 An unbound form.
 A master/detail form
A parent/child form.

6. Which of the following functions may one use to create a sub form?

 Design view
 The form wizard
 The sub form wizard
All of the above

7. When sorting and grouping data one of the steps is to set the group keep-together property, which of the following is available for that task?

 Per page
 Per column/row
 Whole group
 Both A and B

8. Why would  a database designer use the dlookup function?

 to determine the smallest and largest values in a field based on a specified aggregation, or grouping.
 to get the value of a particular field from a specified set of records
 to count the number of records in an underlying query.
to return the number of records in a table

9. You can use the Dlookup function in all of the following, except?

 in a macro
 In a query expression
 In a property
In visual basic

10. You can copy and paste all of the following images, except?

Kodak Photo Cd (.pcd)
Windows Metafile (.wmf)
FlashPix (.fxp)
Both A and C