Question 1

Access does not require a field description for every field included in a table. _________________________

Accepted Answer

A) True 
 B)False

Question 2

The data type that allows both sequential and random numbering is the ____ data type.

Accepted Answer

A)  Number 
B)  Currency 
C)  AutoNumber 
D)  Long Date

Question 3

____________________ values are never allowed by Access in the primary key field.

Accepted Answer

The answer of  ____________________ values are never allowed by Access...

Question 4

The field name displayed in database objects,including forms and reports,is determined by the Caption property._________________________

Accepted Answer

A) True 
 B)False

Question 5

The Address Quick Start selection adds a group of relationships related to an address including Address,City,State,etc._________________________

Accepted Answer

A) True 
 B)False

Question 6

Changing the order of fields in a database table is an example of changing a table's ____.

Accepted Answer

A)  purpose 
B)  structure 
C)  data 
D)  value

Question 7

The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

Accepted Answer

The answer of  The way field values are stored,displayed,and processed...

Question 8

The Data Type Gallery,which allows the entry of groups of fields using the Quick Start selection,is only available in Datasheet view. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Identify the letter of the choice that best matches the phrase or definition.
- A record in a table that is related to a primary table but has no matching record established with the primary table.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Accepted Answer

The answer of Identify the letter of the choice that...

Question 10

When choosing field names,it is best to choose names that ____.

Accepted Answer

A)  include both numbers and letters in the name 
B)  use only uppercase characters 
C)  describe the content or purpose of the field 
D)  use only lowercase letters and no spaces

Question 11

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Accepted Answer

The answer of  The ____________________ Field Size property of a...

Question 12

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

Accepted Answer

A)  Data type 
B)  Field size 
C)  Required 
D)  Description

Question 13

Which data type allows the designer to define the Field Size property?

Accepted Answer

A)  Long Text 
B)  Hyperlink 
C)  Memo 
D)  AutoNumber

Question 14

Explain how a one-to-many relationship is created using an Access database with two or more tables.  Why is it useful to create a relationship between tables?

Accepted Answer

The answer of  Explain how a one-to-many relationship is created...

Question 15

The default Field Size for the Short Text data type is ____________________ characters.

Accepted Answer

The answer of  The default Field Size for the Short...

Exam 2: Building a Database and Defining Table Relationships

Access does not require a field description for every field included in a table. _________________________

The data type that allows both sequential and random numbering is the ____ data type.

____________________ values are never allowed by Access in the primary key field.

The field name displayed in database objects,including forms and reports,is determined by the Caption property._________________________

The Address Quick Start selection adds a group of relationships related to an address including Address,City,State,etc._________________________

Changing the order of fields in a database table is an example of changing a table's ____.

The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

The Data Type Gallery,which allows the entry of groups of fields using the Quick Start selection,is only available in Datasheet view. _________________________

When choosing field names,it is best to choose names that ____.

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

Which data type allows the designer to define the Field Size property?

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

The default Field Size for the Short Text data type is ____________________ characters.