1. What method can you use to add a new table to your database?
a. Use Design View to create a table
b. Enter data directly by using a datasheet
c. Both of above
d. All of the above
Correct Answer: c

2. Which action do you use in a a macro to automatically send a report snapshot in an email message?
a. Use mail
b. Send object
c. Run macro
d. All of the above
Correct Answer: b

3. How can you display sales grouped by country, region, and salesperson, all at the same time?
a. Use the Sort Descending command.
b. Use the Pivot table view command
c. Use the find command on specified groups
d. All of above
Correct Answer: b

4. The checking operation performed on input data is called the
a. Validation of data
b. Verification of data
c. Cross check
d. Control of data
Correct Answer: a

5. A form defines
a. Wqhere data is placed on the screen
b. The width of each field
c. Both a and b
d. All of the above
Correct Answer: c
1. How do you insert a graphic of your company’s logo on a report?
a. Click the image button on the toolbox and drag on the report to draw a place holder for the graphics
b. You can’t. Microsoft Access won’t let you insert graphics files.
c. Select Insert > Picture from the menu
d. Select Tools > Insert Picture from the menu
Correct Answer: a

2. The Fill/Back Color button on the formatting toolbar applies color to:
a. The border fo the selected control
b. The text in the selected control
c. All aspects of the control
d. The background of the selected control
Correct Answer: d

3. Which type of query extract the data and put them into separate table?
a. A parameter query
b. A make-table query
c. An update query
d. A crosstab query
Correct Answer: b

4. Which of the following criterion is NOT written using the proper syntax?
a. “Haris”
b. <500
c. NO VALUE
d. Between #1/1/2000# and #12/31/2000#
Correct Answer: c