Question 1

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

Accepted Answer

A)  Edit 
B)  Fields 
C)  Properties 
D)  Design 
A)  Edit 
B)  Fields 
C)  Properties 
D)  Design B

Question 2

The Input Mask property provides a pattern for data to be entered using three parts.

Accepted Answer

A) True 
 B)False  True

Question 3

A good Field Size property value for a state abbreviation field is ____.

Accepted Answer

A)  2 
B)  10 
C)  50 
D)  255 
A)  2 
B)  10 
C)  50 
D)  255 A

Question 4

What data type sequences each new record with the next available integer?

Accepted Answer

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

Question 5

Byte, Long Integer, Single, and Double are examples of entries for which property?

Accepted Answer

A)  Field Size 
B)  Format 
C)  Input Mask 
D)  Validation Rule 
A)  Field Size 
B)  Format 
C)  Input Mask 
D)  Validation Rule

Question 6

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Accepted Answer

The answer of The ____________________ property provides an easy-to-use visual...

Question 7

Which of the following is NOT a principle of relational database design?

Accepted Answer

A)  Design each table to contain fields that describe only one subject. 
B)  Identify a primary key field or key field combination for each table. 
C)  Data should be entered before table relationships are built. 
D)  Build one-to-many relationships between the tables of your database using a field common to each table. 
A)  Design each table to contain fields that describe only one subject. 
B)  Identify a primary key field or key field combination for each table. 
C)  Data should be entered before table relationships are built. 
D)  Build one-to-many relationships between the tables of your database using a field common to each table.

Question 8

The Field Properties pane displays information for how many fields at the same time?

Accepted Answer

A)  Only the selected field. 
B)  However many are visible in the window. 
C)  All of the fields in that particular table. 
D)  All of the fields in the entire database. 
A)  Only the selected field. 
B)  However many are visible in the window. 
C)  All of the fields in that particular table. 
D)  All of the fields in the entire database.

Question 9

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button. 
_________________________

Accepted Answer

A) True 
 B)False

Question 10

____ properties allow you to supply a drop-down list of values for a field.

Accepted Answer

A)  Key 
B)  Relationship 
C)  Lookup 
D)  Junction 
A)  Key 
B)  Relationship 
C)  Lookup 
D)  Junction

Question 11

Which of the following is NOT a problem with duplicated data?

Accepted Answer

A)  It is error-prone. 
B)  It limits query capabilities. 
C)  It limits reporting capabilities. 
D)  It creates its own one-to-many relationships. 
A)  It is error-prone. 
B)  It limits query capabilities. 
C)  It limits reporting capabilities. 
D)  It creates its own one-to-many relationships.

Question 12

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

Accepted Answer

A)  record 
B)  field 
C)  object 
D)  property 
A)  record 
B)  field 
C)  object 
D)  property

Question 13

When a Caption property is not entered, the field name is used to label the field.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is NOT shown on a Relationship report?

Accepted Answer

A)  table names 
B)  field names 
C)  primary key field data values 
D)  one-to-many relationship lines 
A)  table names 
B)  field names 
C)  primary key field data values 
D)  one-to-many relationship lines

Question 15

The table that joins to other tables that have many-to-many relationship is called the ____ table.

Accepted Answer

A)  junction 
B)  linking 
C)  primary 
D)  relational 
A)  junction 
B)  linking 
C)  primary 
D)  relational

Question 16

You can access the Lookup properties from either Table Datasheet View or Table Design View.

Accepted Answer

A) True 
 B)False

Question 17

Field descriptions may be entered in Table Design View. _________________________

Accepted Answer

A) True 
 B)False

Question 18

A subdatasheet is used to modify field properties.

Accepted Answer

A) True 
 B)False

Question 19

Each field must be given an associated field description.

Accepted Answer

A) True 
 B)False

Question 20

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Accepted Answer

A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control 
A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

The Input Mask property provides a pattern for data to be entered using three parts.

A good Field Size property value for a state abbreviation field is ____.

What data type sequences each new record with the next available integer?

Byte, Long Integer, Single, and Double are examples of entries for which property?

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Which of the following is NOT a principle of relational database design?

The Field Properties pane displays information for how many fields at the same time?

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button. _________________________

____ properties allow you to supply a drop-down list of values for a field.

Which of the following is NOT a problem with duplicated data?

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

When a Caption property is not entered, the field name is used to label the field.

Which of the following is NOT shown on a Relationship report?

The table that joins to other tables that have many-to-many relationship is called the ____ table.

You can access the Lookup properties from either Table Datasheet View or Table Design View.

Field descriptions may be entered in Table Design View. _________________________

A subdatasheet is used to modify field properties.

Each field must be given an associated field description.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 5: Modifying the Database Structure

To modify fields and field properties in Table Datasheet View, use the ____ tab on the Ribbon.

The Input Mask property provides a pattern for data to be entered using three parts.

A good Field Size property value for a state abbreviation field is ____.

What data type sequences each new record with the next available integer?

Byte, Long Integer, Single, and Double are examples of entries for which property?

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Which of the following is NOT a principle of relational database design?

The Field Properties pane displays information for how many fields at the same time?

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button. _________________________

____ properties allow you to supply a drop-down list of values for a field.

Which of the following is NOT a problem with duplicated data?

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

When a Caption property is not entered, the field name is used to label the field.

Which of the following is NOT shown on a Relationship report?

The table that joins to other tables that have many-to-many relationship is called the ____ table.

You can access the Lookup properties from either Table Datasheet View or Table Design View.

Field descriptions may be entered in Table Design View. _________________________

A subdatasheet is used to modify field properties.

Each field must be given an associated field description.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters