Question 1

____________________ view allows the database designer to enter both the field names and define the field properties.

Accepted Answer

The answer of ____________________ view allows the database designer to...

Question 2

The "one" table in a one-to-many relationship is the ____________________ table.

Accepted Answer

The answer of The "one" table in a one-to-many relationship...

Question 3

Field names in a table may only be changed in Design view.

Accepted Answer

A) True 
 B)False

Question 4

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 5

By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.

Accepted Answer

A)  data, structure 
B)  data type, structure 
C)  structure, data 
D)  structure, data type

Question 6

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 7

Relationship integrit y is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.

Accepted Answer

A) True 
 B)False

Question 8

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

Accepted Answer

A)  imported 
B)  readable 
C)  delimited 
D)  external

Question 9

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 10

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

Accepted Answer

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

Question 11

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

Accepted Answer

A)  Yes/No 
B)  Memo 
C)  Text 
D)  AutoNumber

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

Access automatically assigns the Number data type to all new fields.

Accepted Answer

A) True 
 B)False

Question 14

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 15

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

Accepted Answer

A) True 
 B)False

Question 16

A primary key that consists of two or more fields is called a(n) redundant key .

Accepted Answer

A) True 
 B)False

Question 17

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

Accepted Answer

A)  values 
B)  letters 
C)  numbers 
D)  mask

Question 18

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Accepted Answer

A)  entered value 
B)  changed value 
C)  default value 
D)  permanent value

Question 19

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

Accepted Answer

The answer of Field value maximum storage size is defined...

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Access Module : Building a Database and Defining Table Relationships

____________________ view allows the database designer to enter both the field names and define the field properties.

The "one" table in a one-to-many relationship is the ____________________ table.

Field names in a table may only be changed in Design view.

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

By choosing the Definition Only option in the Import Objects dialog box, the of a table is imported, but not the .

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

Relationship integrit y is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

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

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

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

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

Access automatically assigns the Number data type to all new fields.

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

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

A primary key that consists of two or more fields is called a(n) redundant key .

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Field value maximum storage size is defined by the Field Size property for the data types including Short Text, Number, and ____________________ only.

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