Question 1

(999)000-000;1;_ would be a possible entry for which field property?

Accepted Answer

A)  Format 
B)  Input Mask 
C)  Caption 
D)  Validation Rule 
A)  Format 
B)  Input Mask 
C)  Caption 
D)  Validation Rule B

Question 2

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  True

Question 3

Match between columns
                        Premises: Determines the largest number that can be entered in a field
Stores numbers from -2,147,483,648 to 2,147,483,647
Stores numbers in the range of 10 to the -324th to +324th power
Stores numbers times 10 to the -38th to +38th power
Stores numbers from 0 to 255

Accepted Answer

The Answer of Long integer and Field size and Single is...

Question 4

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Accepted Answer

A) True 
 B)False

Question 5

In the accompanying figure, item 1 points to a(n) ____.

Accepted Answer

A)  primary key field 
B)  foreign key 
C)  field property 
D)  table name 
A)  primary key field 
B)  foreign key 
C)  field property 
D)  table name

Question 6

In the accompanying figure, the data type for the PaymentAmt field is ____________________.

Accepted Answer

The answer of   In the accompanying figure, the...

Question 7

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

Accepted Answer

The Customers and Sales tables

Question 8

Modifying the Decimal Places property changes the way the data is presented.

Accepted Answer

A) True 
 B)False

Question 9

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

Accepted Answer

A)  primary 
B)  first 
C)  foreign 
D)  infinity 
A)  primary 
B)  first 
C)  foreign 
D)  infinity

Question 10

In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

Accepted Answer

The answer of   In the accompanying figure, the...

Question 11

A field that contains unique information for each record is called a(n) ____ field.

Accepted Answer

A)  text 
B)  data 
C)  linking 
D)  primary key 
A)  text 
B)  data 
C)  linking 
D)  primary key

Question 12

The Field Size property is not available for Currency fields.

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

Accepted Answer

An orphan record is a record in the "man

Question 15

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 16

Anne Michael is working with the table in the accompanying figure.  Explain what will happen when she works with the PaymentNo field in Datasheet View.

Accepted Answer

The PaymentNo field is an Auto

Question 17

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 18

The process of removing and fixing orphan records is often called ____.

Accepted Answer

A)  scrubbing the database 
B)  enforcing rules 
C)  applying syntax 
D)  adding criteria 
A)  scrubbing the database 
B)  enforcing rules 
C)  applying syntax 
D)  adding criteria

Question 19

Which of the following is a clue that a database needs to be redesigned?

Accepted Answer

A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables. 
A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables.

Question 20

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Accepted Answer

Enforce Referential Integrity is a set o

(999)000-000;1;_ would be a possible entry for which field property?

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

Changing the Decimal Places property for a field does not change the actual data stored in the field.

In the accompanying figure, item 1 points to a(n) ____.

In the accompanying figure, the data type for the PaymentAmt field is ____________________.

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

Modifying the Decimal Places property changes the way the data is presented.

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

A field that contains unique information for each record is called a(n) ____ field.

The Field Size property is not available for Currency fields.

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

Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

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

Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

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

The process of removing and fixing orphan records is often called ____.

Which of the following is a clue that a database needs to be redesigned?

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 5: Modifying the Database Structure

(999)000-000;1;_ would be a possible entry for which field property?

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

Changing the Decimal Places property for a field does not change the actual data stored in the field.

In the accompanying figure, item 1 points to a(n) ____.

In the accompanying figure, the data type for the PaymentAmt field is ____________________.

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

Modifying the Decimal Places property changes the way the data is presented.

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

A field that contains unique information for each record is called a(n) ____ field.

The Field Size property is not available for Currency fields.

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

Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

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

Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

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

The process of removing and fixing orphan records is often called ____.

Which of the following is a clue that a database needs to be redesigned?

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters