Question 1

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Accepted Answer

The answer of The Row ____________________ Lookup property stores the...

Question 2

Each field must be given an associated field description.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

A subdatasheet is used to modify field properties.

Accepted Answer

A) True 
 B)False

Question 5

A common place to use an Input Mask property would be for a Phone Number field.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Which of the following is NOT defined in Table Design View?

Accepted Answer

A)  field names 
B)  field entries 
C)  data types 
D)  field properties 
A)  field names 
B)  field entries 
C)  data types 
D)  field properties

Question 8

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 9

Which of the following is NOT a good candidate for a primary key field for a Customer table?

Accepted Answer

A)  Last Name 
B)  Customer Number 
C)  Employee Identification Number 
D)  Customer ID 
A)  Last Name 
B)  Customer Number 
C)  Employee Identification Number 
D)  Customer ID

Question 10

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber. _________________________

Accepted Answer

A) True 
 B)False

Question 11

-Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

Accepted Answer

1. Design each table to contain fields t

Question 12

-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 13

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 14

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

Accepted Answer

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

Question 15

____________________ is the data type for the SalesNo field in the accompanying figure.

Accepted Answer

The answer of ____________________ is the data type for the...

Question 16

Where do you modify field properties?

Accepted Answer

A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form. 
A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form.

Question 17

-In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Accepted Answer

A primary key field is a field that cont

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

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 20

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 Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Each field must be given an associated field description.

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

A subdatasheet is used to modify field properties.

A common place to use an Input Mask property would be for a Phone Number field.

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

Which of the following is NOT defined in Table Design View?

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

Which of the following is NOT a good candidate for a primary key field for a Customer table?

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber. _________________________

-Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

-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.

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

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

____________________ is the data type for the SalesNo field in the accompanying figure.

Where do you modify field properties?

-In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

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

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.

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.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 6: Modifying the Database Structure

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Each field must be given an associated field description.

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

A subdatasheet is used to modify field properties.

A common place to use an Input Mask property would be for a Phone Number field.

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

Which of the following is NOT defined in Table Design View?

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

Which of the following is NOT a good candidate for a primary key field for a Customer table?

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber. _________________________

-Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

-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.

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

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

____________________ is the data type for the SalesNo field in the accompanying figure.

Where do you modify field properties?

-In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

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

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.

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.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters