Question 1

Explain the term "orphan record" and how to avoid creating one in an Access relational database.

Accepted Answer

An orphan record is a record in the "man

Question 2

This property controls both the values that users can enter into a text box and provides a visual guide as users enter data.

Accepted Answer

A) Format 
B) Caption 
C) Default Value 
D) Input Mask 
A) Format 
B) Caption 
C) Default Value 
D) Input Mask

Question 3

You can modify the Field Size property of a Number field.

Accepted Answer

A) True 
 B)False

Question 4

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 5

In the figure above, the ____________________  field's properties are displayed in the Field Properties pane.

Accepted Answer

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

Question 6

In the figure above, the Data Type of the CustNo field is ____________________ .

Accepted Answer

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

Question 7

Use the Format property for a Date/Time field to display the date 1/17/2010 as January 17, 2010.

Accepted Answer

A) True 
 B)False

Question 8

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT a possible entry for the Field Size property of a Number field?

Accepted Answer

A) Currency 
B) Byte 
C) Long Integer 
D) Single 
A) Currency 
B) Byte 
C) Long Integer 
D) Single

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

A subdatasheet is used to examine field properties.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Field descriptions are entered in Table Design View.

Accepted Answer

A) True 
 B)False

Question 14

In the figure above, item 4 references a ____.

Accepted Answer

A) Field name 
B) Table name 
C) Relationship 
D) Link line 
A) Field name 
B) Table name 
C) Relationship 
D) Link line

Question 15

To move a field list in the Relationships window, drag the table's primary key field .

Accepted Answer

A) True 
 B)False

Question 16

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

Accepted Answer

A) True 
 B)False

Question 17

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 18

The Field Size property is not available for Currency fields.

Accepted Answer

A) True 
 B)False

Question 19

A(n)_______________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Accepted Answer

The answer of A(n)_______________ record is a record in the...

Question 20

The ____ property provides a label used to describe the field.

Accepted Answer

A) Format 
B) Caption 
C) Mask 
D) Default 
A) Format 
B) Caption 
C) Mask 
D) Default

Explain the term "orphan record" and how to avoid creating one in an Access relational database.

This property controls both the values that users can enter into a text box and provides a visual guide as users enter data.

You can modify the Field Size property of a Number field.

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

In the figure above, the ____________________ field's properties are displayed in the Field Properties pane.

In the figure above, the Data Type of the CustNo field is ____________________ .

Use the Format property for a Date/Time field to display the date 1/17/2010 as January 17, 2010.

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Which of the following is NOT a possible entry for the Field Size property of a Number field?

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

A subdatasheet is used to examine field properties.

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

Field descriptions are entered in Table Design View.

In the figure above, item 4 references a ____.

To move a field list in the Relationships window, drag the table's primary key field .

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

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

The Field Size property is not available for Currency fields.

A(n)_______________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

The ____ property provides a label used to describe the field.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

Exam 5: Modifying the Database Structure Question

Explain the term "orphan record" and how to avoid creating one in an Access relational database.

This property controls both the values that users can enter into a text box and provides a visual guide as users enter data.

You can modify the Field Size property of a Number field.

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

In the figure above, the ____________________ field's properties are displayed in the Field Properties pane.

In the figure above, the Data Type of the CustNo field is ____________________ .

Use the Format property for a Date/Time field to display the date 1/17/2010 as January 17, 2010.

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Which of the following is NOT a possible entry for the Field Size property of a Number field?

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

A subdatasheet is used to examine field properties.

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

Field descriptions are entered in Table Design View.

In the figure above, item 4 references a ____.

To move a field list in the Relationships window, drag the table's primary key field .

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

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

The Field Size property is not available for Currency fields.

A(n)_______________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

The ____ property provides a label used to describe the field.

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters