Question 1

Which of the following relationships describes one row 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 one-to-many relationship,one row of data in Table A is associated with many rows of data in TableE) B) and D)
F) A) and C)

Question 2

To be considered relational,a database must meet certain specifications.What are these specifications?

Accepted Answer

First,the data in the database must be s...

Question 3

Which of the following number data types stores numbers from -1028 to 1028 with a precision of 28 significant digits?

Accepted Answer

A)   Byte
B)   Integer
C)   Long Integer
D)   DecimalE) C) and D)
F) B) and C)

Question 4

You can add a new table into a database from the Create tab.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following wildcard characters does Access use in validation rules to match any single character,which also includes numbers?

Accepted Answer

A)   (?) 
B)   (*) 
C)   (#) 
D)   ($) E) All of the above
F) A) and C)

Question 6

In Access,which of the following indicates the many sides of a relationship?

Accepted Answer

A)   foreign key
B)   infinity symbol
C)   metadata
D)   many symbolE) A) and B)
F) B) and C)

Question 7

What must be added into a table before relationships between tables can be established?

Accepted Answer

A)   primary key
B)   foreign key
C)   relationships
D)   none of the aboveE) A) and B)
F) None of the above

Question 8

Which of the following must you do before adding a field between existing fields?

Accepted Answer

A)   enter a field name
B)   enter a data type
C)   select a primary key
D)   insert a new rowE) B) and C)
F) A) and D)

Question 9

The process of verifying the accuracy,or integrity,of data is known as data integrity.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is used to enter records into a table?

Accepted Answer

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

Question 11

Which of the following characters separates the parts of an input mask?

Accepted Answer

A)   #
B)   $
C)   ;
D)   [ ]E) C) and D)
F) None of the above

Question 12

A Short Text field can have a size from 0-50.

Accepted Answer

A) True 
 B)False

Question 13

In Access,what are field properties and why is it important to know how to set field properties?

Accepted Answer

Field properties describe the specific d...

Question 14

What steps are required to design a relational database?

Accepted Answer

For a database to be of value to an orga...

Question 15

Which of the following field validation rules requires the user to enter a value that is less than 5?

Accepted Answer

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

Question 16

When data is entered that violates a validation rule,Access automatically displays a message box alerting the user to the problem.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is a problem that can happen to larger databases?

Accepted Answer

A)   adding and deleting records takes longer
B)   querying tables takes longer
C)   running reports takes longer
D)   all of the aboveE) All of the above
F) A) and D)

Question 18

Which of the following relationships describes one row of data in Table A being associated with only one row 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 one-to-one relationship,one row of data in Table A is associated with only one row of data in TableE) A) and C)
F) A) and B)

Question 19

When printing,which of the following is affected by page orientation?

Accepted Answer

A)   paper size
B)   margins
C)   the direction of printing on the page
D)   the number of copiesE) A) and C)
F) B) and C)

Question 20

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

Accepted Answer

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

Exam 9: Designing and Managing Databases

To be considered relational,a database must meet certain specifications.What are these specifications?

Correct AnswerverifiedFirst,the data in the database must be s...View AnswerShow Answer

Which of the following relationships describes one row of data in Table A being associated with only one row of data in Table B?

Correct AnswerverifiedShow Answer

When data is entered that violates a validation rule,Access automatically displays a message box alerting the user to the problem.

Correct AnswerverifiedShow Answer

Which of the following characters separates the parts of an input mask?

Correct AnswerverifiedShow Answer

In Access,what are field properties and why is it important to know how to set field properties?

Correct AnswerverifiedField properties describe the specific d...View AnswerShow Answer

What must be added into a table before relationships between tables can be established?

Correct AnswerverifiedShow Answer

Which of the following is used to enter records into a table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following field validation rules requires the user to enter a value that is less than 5?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following must you do before adding a field between existing fields?

Correct AnswerverifiedShow Answer

Which of the following wildcard characters does Access use in validation rules to match any single character,which also includes numbers?

Correct AnswerverifiedShow Answer

A Short Text field can have a size from 0-50.

Correct AnswerverifiedShow Answer

Which of the following number data types stores numbers from -10< sup >28< / sup > to 10< sup >28< / sup > with a precision of 28 significant digits?

Correct AnswerverifiedShow Answer

Which of the following is a problem that can happen to larger databases?

Correct AnswerverifiedShow Answer

The process of verifying the accuracy,or integrity,of data is known as data integrity.

Correct AnswerverifiedShow Answer

When printing,which of the following is affected by page orientation?

Correct AnswerverifiedShow Answer

In Access,which of the following indicates the many sides of a relationship?

Correct AnswerverifiedShow Answer

You can add a new table into a database from the Create tab.

Correct AnswerverifiedShow Answer

What steps are required to design a relational database?

Correct AnswerverifiedFor a database to be of value to an orga...View AnswerShow Answer

Correct Answer
verified
First,the data in the database must be s...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Field properties describe the specific d...
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

Correct Answer
verified
For a database to be of value to an orga...
View Answer