Question 1

Which of the following field validation rules requires the user to fill in a field?

Accepted Answer

A)   
B)    0
C)   "M" or "F"
D)   Not NullE) B) and D)
F) A) and B)

Question 2

Which of the following characters causes characters to display in lowercase in a short text and long text field?

Accepted Answer

A)   
B)   >
C)   @
D)   [color]E) A) and C)
F) B) and C)

Question 3

What can you do if the data records that you want to use in Access are stored in another file?

Accepted Answer

A)   copy them
B)   cut them
C)   paste them
D)   import themE) None of the above
F) All of the above

Question 4

Which of the following relationships describes many rows of data in Table A associated with many rows of data in Table B?

Accepted Answer

A)   one-to-one
B)   one-to-many
C)   many-to-many
D)   none of the aboveIn a many-to-many relationship,many rows of data in Table A are associated with many rows of data in TableE) B) and C)
F) C) and D)

Question 5

Which of the following options enables you to import data records from Excel?

Accepted Answer

A)   Add option
B)   Append option
C)   Attribute option
D)   Amplify optionE) C) and D)
F) A) and B)

Question 6

Before adding a new field between an existing field in a table,you must insert a new row.

Accepted Answer

A) True 
 B)False

Question 7

As a database grows larger,what are three concerns you should be aware of?

Accepted Answer

Over time,as you use your database,the d...

Question 8

What is a primary key called that is made up of more than one field?

Accepted Answer

A)   primary key
B)   foreign key
C)   concatenated key
D)   combined keyE) None of the above
F) A) and D)

Question 9

Which of the following displays a list of data values from which the user can choose?

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

When using wildcards in validation rules,which of the following must surround the criteria of your expression?

Accepted Answer

A)   &
B)   ( ) 
C)   " "
D)   !E) B) and C)
F) A) and D)

Question 12

Which of the following print options allows you to select different print options before sending the contents of the current object immediately to the printer?

Accepted Answer

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

Question 13

Describe the following relationships: a one-to-one relationship,a one-to-many relationship,and a many-to-many relationship.Provide an example of when each type is useful.

Accepted Answer

In a one-to-one relationship,one row of ...

Question 14

The notation 1:1 is used to describe the one-to-many relationship.

Accepted Answer

A) True 
 B)False  False

Question 15

If a field must have a value you should set the Required property to Yes.

Accepted Answer

A) True 
 B)False

Question 16

Using Access,what is the significance of data integrity and data validation? What are data integrity rules?

Accepted Answer

The usefulness of your database depends ...

Question 17

When you insert a new row between fields,the new row is inserted below the selected field.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following field validation rules prevents the user from typing 0 into a field?

Accepted Answer

A)   
B)    0
C)   "M" or "F"
D)   Not NullE) A) and C)
F) All of the above

Question 19

Which of the following record validation rules prevents the user from entering the same value into both Field1 and Field2?

Accepted Answer

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

Question 20

What must you do if you make any changes to the relationships between tables?

Accepted Answer

A)   print them
B)   save them
C)   copy them
D)   delete themE) A) and D)
F) C) and D)

Exam 9: Designing and Managing Databases

Which of the following field validation rules requires the user to fill in a field?

Correct AnswerverifiedShow Answer

Which of the following characters causes characters to display in lowercase in a short text and long text field?

Correct AnswerverifiedShow Answer

What can you do if the data records that you want to use in Access are stored in another file?

Correct AnswerverifiedShow Answer

Which of the following relationships describes many rows of data in Table A associated with many rows of data in Table B?

Correct AnswerverifiedShow Answer

Which of the following options enables you to import data records from Excel?

Correct AnswerverifiedShow Answer

Before adding a new field between an existing field in a table,you must insert a new row.

Correct AnswerverifiedShow Answer

As a database grows larger,what are three concerns you should be aware of?

Correct AnswerverifiedOver time,as you use your database,the d...View AnswerShow Answer

What is a primary key called that is made up of more than one field?

Correct AnswerverifiedShow Answer

Which of the following displays a list of data values from which the user can choose?

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

When using wildcards in validation rules,which of the following must surround the criteria of your expression?

Correct AnswerverifiedShow Answer

Which of the following print options allows you to select different print options before sending the contents of the current object immediately to the printer?

Correct AnswerverifiedShow Answer

Describe the following relationships: a one-to-one relationship,a one-to-many relationship,and a many-to-many relationship.Provide an example of when each type is useful.

Correct AnswerverifiedIn a one-to-one relationship,one row of ...View AnswerShow Answer

The notation 1:1 is used to describe the one-to-many relationship.

Correct AnswerverifiedFalse

If a field must have a value you should set the Required property to Yes.

Correct AnswerverifiedShow Answer

Using Access,what is the significance of data integrity and data validation? What are data integrity rules?

Correct AnswerverifiedThe usefulness of your database depends ...View AnswerShow Answer

When you insert a new row between fields,the new row is inserted below the selected field.

Correct AnswerverifiedShow Answer

Which of the following field validation rules prevents the user from typing 0 into a field?

Correct AnswerverifiedShow Answer

Which of the following record validation rules prevents the user from entering the same value into both Field1 and Field2?

Correct AnswerverifiedB

What must you do if you make any changes to the relationships between tables?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Over time,as you use your database,the d...
View Answer

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
In a one-to-one relationship,one row of ...
View Answer

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified
The usefulness of your database depends ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified