1.                  Which method is correct to manually add a primary key to a table?

A.                  Right-click the grey box beside the field you want to make the key and select Primary key from the right-click menu.

B.                 Choose the Primary Key data type from the Data Type combo box for the field.

C.                 Choose the AutoNumber data type from the Data Type combo box for the field.

D.                 None of the above.

 

2.                  When indexing a field, which of the following options is not a valid Indexing setting?

A.                  No

B.                 Yes (Duplicates OK)

C.                 Yes (No Duplicates)

D.                 Yes (Primary Key Excluded)

 

3.                  Which of the following is a valid operation that can be performed on a field in Design view?

A.                  Inserting a new field

B.                 Moving a field

C.                 Deleting a field

D.                 All of the above functions are valid operations

 

4.                  ODBC stands for…

A.                  Open Data Base Communication

B.                 Open Decimal Base Concept

C.                 Open Data Base Copy

D.                 Open Data Base Connectivity

 

5.                  Which of the following statements concerning the AutoNumber data type are false?

A.                  If you delete a row with an AutoNumber value, the deleted AutoNumber value is reused.

B.                 AutoNumbers are usually used as primary keys because they never repeat themselves.

C.                 AutoNumbers can be positive or negative.

D.                 If you delete a row with an AutoNumber value, the deleted AutoNumber value is never reused.

 

6.                  What is the maximum amount of characters that can be held in a memo field?

A.                  9

B.                 255

C.                 65,536

D.                 As many as you want, as long as there is enough hard drive space to hold the memo and the database together.

 

7.                  Which of the following statements is true?

A.                  Captions can only be used for text data types

B.                 Default values cannot be changed in Datasheet view

C.                 Default values can only be assigned to number data types

D.                 All these statements are false

 

8.                  How many primary keys can a table have?

A.                  1

B.                 2

C.                 3

D.                 You can have as many keys as there are fields.

 

9.                  Which validation rule satisfies the statement "greater than or equal to negative 13"?

A.                  =>-13

B.                 >=-13

C.                 >-13

D.                 None of the above

  

10.              Value lists allow you to make your own data, lookup fields can get their information from _______ and/or _______. (Select all that apply)

A.                  Tables

B.                 Queries

C.                 Forms

D.                 Reports