Question 1

Access checks field validation rules when a user navigates out of a field.

Accepted Answer

A) True 
 B)False

Question 2

What does Access do when data is entered that violates a validation rule?

Accepted Answer

A)   displays the Lookup tab
B)   zooms in on the error
C)   switches to datasheet view
D)   displays a message boxE) B) and C)
F) A) and D)

Question 3

The Format property indicates the way a field displays in a table; it doesn't change what is actually stored.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following properties automatically inserts a specified value into a new record in a table?

Accepted Answer

A)   Format property
B)   Lookup property
C)   Default Value property
D)   Caption propertyE) B) and C)
F) A) and D)

Question 5

What must you do if you create a relationship in error?

Accepted Answer

A)   print it
B)   save it
C)   copy it
D)   delete itE) A) and B)
F) None of the above

Question 6

How many parts are there in an input mask?

Accepted Answer

A)   1
B)   3
C)   5
D)   7E) A) and D)
F) B) and D)

Question 7

Which of the following should you use to create a table from scratch?

Accepted Answer

A)   Datasheet view
B)   Design view
C)   Lookup view
D)   Validation viewE) A) and C)
F) C) and D)

Question 8

When importing data records from Excel,what must be true?

Accepted Answer

A)   The Excel file must have been created within the past month.
B)   The Excel file must contain the same number of fields as in the Access file.
C)   The first row of the Excel file must contain the field names from the Access table.
D)   The first row of the Excel file must contain the same number of fields as in the Access table.E) None of the above
F) All of the above

Question 9

It is possible to import data from an Excel file into an Access table.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following displays a drop-down list in both table view and form view when the field's arrow is clicked?

Accepted Answer

A)   Lookup field
B)   text box
C)   input mask
D)   combo boxE) C) and D)
F) All of the above

Question 11

Which of the following forces a user to enter data using a specific format?

Accepted Answer

A)   Lookup field
B)   text box
C)   input mask
D)   combo boxE) B) and D)
F) B) and C)

Question 12

Which of the following print options bypasses the Print dialog box?

Accepted Answer

A)   Quick Print
B)   Print
C)   Print Preview
D)   none of the aboveE) None of the above
F) All of the above

Question 13

If you don't select a format,Access uses the Currency format for a number field.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following refers to the process of verifying the accuracy,or integrity,of data?

Accepted Answer

A)   data validation
B)   metadata testing
C)   data integrity testing
D)   relationship testingE) None of the above
F) B) and C)

Question 15

Which of the following input mask characters requires a user to enter a letter or a number?

Accepted Answer

A)   0
B)   L
C)   A
D)   aE) B) and D)
F) C) and D)

Question 16

Which of the following might be necessary in order to override the constraints imposed by enforcing referential integrity?

Accepted Answer

A)   control changes
B)   create new table relationships
C)   combine tables
D)   cascade updates and deletesE) A) and B)
F) C) and D)

Question 17

Access tables can be printed in a portrait orientation,but not in a landscape orientation.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following record validation rules requires the user to enter a value into either Field1 or Field2,but not into both fields?

Accepted Answer

A)   ([Field1] is Null) XOR ([Field2] is Null) 
B)   [Field1]  [Field2]
C)   (([Field1] > [Field2]) AND [Field2] >10) ) 
D)   none of the aboveE) None of the above
F) All of the above

Question 19

What is the significance of the primary key and why is it especially important to know about it when creating a table in Design view? Also,when might you need to use the AutoNumber data type?

Accepted Answer

A primary key is a field that contains a...

Question 20

When using validation rules it is important that the rules are tested.

Accepted Answer

A) True 
 B)False

Exam 9: Designing and Managing Databases

Which of the following displays a drop-down list in both table view and form view when the field's arrow is clicked?

Correct AnswerverifiedShow Answer

If you don't select a format,Access uses the Currency format for a number field.

Correct AnswerverifiedShow Answer

Which of the following forces a user to enter data using a specific format?

Correct AnswerverifiedShow Answer

What must you do if you create a relationship in error?

Correct AnswerverifiedShow Answer

When using validation rules it is important that the rules are tested.

Correct AnswerverifiedShow Answer

What does Access do when data is entered that violates a validation rule?

Correct AnswerverifiedShow Answer

Which of the following record validation rules requires the user to enter a value into either Field1 or Field2,but not into both fields?

Correct AnswerverifiedShow Answer

Which of the following might be necessary in order to override the constraints imposed by enforcing referential integrity?

Correct AnswerverifiedShow Answer

Which of the following properties automatically inserts a specified value into a new record in a table?

Correct AnswerverifiedShow Answer

Access checks field validation rules when a user navigates out of a field.

Correct AnswerverifiedShow Answer

How many parts are there in an input mask?

Correct AnswerverifiedShow Answer

It is possible to import data from an Excel file into an Access table.

Correct AnswerverifiedShow Answer

The Format property indicates the way a field displays in a table; it doesn't change what is actually stored.

Correct AnswerverifiedShow Answer

Which of the following print options bypasses the Print dialog box?

Correct AnswerverifiedShow Answer

What is the significance of the primary key and why is it especially important to know about it when creating a table in Design view? Also,when might you need to use the AutoNumber data type?

Correct AnswerverifiedA primary key is a field that contains a...View AnswerShow Answer

Which of the following refers to the process of verifying the accuracy,or integrity,of data?

Correct AnswerverifiedShow Answer

Access tables can be printed in a portrait orientation,but not in a landscape orientation.

Correct AnswerverifiedShow Answer

Which of the following should you use to create a table from scratch?

Correct AnswerverifiedShow Answer

Which of the following input mask characters requires a user to enter a letter or a number?

Correct AnswerverifiedShow Answer

When importing data records from Excel,what must be true?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A primary key is a field that contains a...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified