Question 1

In what is data in a relational database system organized?

Accepted Answer

A)   fields
B)   records
C)   tables
D)   Design viewE) B) and C)
F) None of the above

Question 2

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

Accepted Answer

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

Question 3

New tables always open in Design view.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following properties indicates the way a field displays in a table?

Accepted Answer

A)   Format property
B)   Lookup property
C)   Required property
D)   Caption propertyE) None of the above
F) A) and B)

Question 5

In Access,which of the following is used to relate,or connect,tables?

Accepted Answer

A)   field
B)   record
C)   table
D)   metadataE) A) and B)
F) C) and D)

Question 6

Design view is used to enter records into a table.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view?

Accepted Answer

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

Question 8

Which of the following wildcard characters does Access use in validation rules to match any single numeric digit?

Accepted Answer

A)   (?) 
B)   (*) 
C)   (#) 
D)   ($) E) A) and D)
F) C) and D)

Question 9

What is an input mask and what are its three parts?

Accepted Answer

An input mask forces a user to enter dat...

Question 10

How does Access store a Yes response for the Yes/ No data type?

Accepted Answer

A)   -2
B)   -1
C)   0
D)   1E) None of the above
F) A) and D)

Question 11

Which of the following number data types stores numbers from -32,768 to 32,767?

Accepted Answer

A)   Byte
B)   Integer
C)   Long Integer
D)   DecimalE) None of the above
F) All of the above

Question 12

When might you want to use the Default Value property?

Accepted Answer

You can use the Default Value property t...

Question 13

Which of the following print options sends 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) B) and D)

Question 14

An input mask only displays when a user clicks into that field.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

Which of the following print options should you use to check that the formatting of a table is appropriate and to make changes to any settings before printing?

Accepted Answer

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

Question 17

An input mask forces a user to enter data using a specific format.

Accepted Answer

A) True 
 B)False

Question 18

A primary key is a field that contains a unique value for each record.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following ensures that records in associated tables have consistent data?

Accepted Answer

A)   referential integrity
B)   primary key
C)   foreign key
D)   Compact & Repair utilityE) B) and C)
F) A) and D)

Question 20

In Access,what are field validation rules called?

Accepted Answer

A)   input masks
B)   expressions
C)   metadata
D)   foreign keysE) All of the above
F) A) and B)

Exam 9: Designing and Managing Databases

When might you want to use the Default Value property?

Correct AnswerverifiedYou can use the Default Value property t...View AnswerShow Answer

Which of the following print options should you use to check that the formatting of a table is appropriate and to make changes to any settings before printing?

Correct AnswerverifiedShow Answer

A primary key is a field that contains a unique value for each record.

Correct AnswerverifiedShow Answer

Which of the following ensures that records in associated tables have consistent data?

Correct AnswerverifiedShow Answer

How does Access store a Yes response for the Yes/ No data type?

Correct AnswerverifiedShow Answer

What is an input mask and what are its three parts?

Correct AnswerverifiedAn input mask forces a user to enter dat...View AnswerShow Answer

New tables always open in Design view.

Correct AnswerverifiedShow Answer

Which of the following wildcard characters does Access use in validation rules to match any single numeric digit?

Correct AnswerverifiedShow Answer

Which of the following number data types stores numbers from -32,768 to 32,767?

Correct AnswerverifiedShow Answer

An input mask forces a user to enter data using a specific format.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Design view is used to enter records into a table.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In what is data in a relational database system organized?

Correct AnswerverifiedShow Answer

In Access,which of the following is used to relate,or connect,tables?

Correct AnswerverifiedShow Answer

In Access,what are field validation rules called?

Correct AnswerverifiedShow Answer

An input mask only displays when a user clicks into that field.

Correct AnswerverifiedShow Answer

Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view?

Correct AnswerverifiedShow Answer

Which of the following print options sends the contents of the current object immediately to the printer?

Correct AnswerverifiedShow Answer

Which of the following properties indicates the way a field displays in a table?

Correct AnswerverifiedShow Answer

Correct Answer
verified
You can use the Default Value property t...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An input mask forces a user to enter dat...
View 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