1.                  Which of the following does database normalization not accomplish?

A.                  Reduce the size of the database.

B.                 Reduce the chance of corruption.

C.                 Speed up the database.

D.                 Format all reports alike.

 

2.                  What is the difference between a crosstab and a parameter query?

A.                  There is no difference.

B.                 Crosstab queries are for Access 97 and 2000, while parameter queries are for Access 2002 and 2003.

C.                 Crosstab queries summarize data while parameter queries search for data based on user input.

D.                 Parameter queries are built on other parameters while crosstab queries are built on tables.

 

3.                  Why is referential integrity important to a database?

A.                  It establishes a parent-child relationship between tables.

B.                 It formats all tables the same.

C.                 It is only important when indexing.

D.                 It is not important.

 

4.                  Which of the following is not a way to format a report?

A.                  AutoFormat

B.                 Add lines

C.                 Copy the formatting from a table.

D.                 Add pictures

 

5.                  How do you tell Access to index your database?

A.                  It is indexed automatically.

B.                 You must set the option in the table properties in design view.

C.                 Create a form.

D.                 Create a query.

 

6.                  What is the requirement for a parameter query to be created?

A.                  You must work from a pre-established query.

B.                 You must use the Parameter Wizard.

C.                 You must start the process from a customized report.

D.                 You must work from Forms Design Mode.

 

7.                  What is the difference between cascade update and cascade delete?

A.                  There is no difference.

B.                 One is for tables while the other is for forms.

C.                 Cascade update updates data while cascade delete removes data.

D.                 The difference is in the direction of the cascade.

 

8.                  When should indexing be used?

A.                  For large databases.

B.                 For old databases.

C.                 For small databases that have mostly the same values

D.                 For small databases with lots of different values for the same field.

 

9.                  How do you run a parameter query? (Select all that apply.)

A.                  From the Query section of the database window.

B.                 From Design View of the query.

C.                 From any report.

D.                 From the applicable table.

 

10.              What field must be indexed?

A.                  None

B.                 Any AutoNumbered field

C.                 Fields included in a report

D.                 Primary key