Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which Short Text field property should you use to specify whether an entry was required for the field?

Accepted Answer

A)  Default Value 
B)  Default 
C)  Required 
D)  Test 
A)  Default Value 
B)  Default 
C)  Required 
D)  Test

Question 3

In the accompanying figure, the data type of the PaymentDate field is ____________________.

Accepted Answer

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

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

What 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 8

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Accepted Answer

A) True 
 B)False

Question 9

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

Accepted Answer

A)  Format 
B)  Default Value 
C)  Validation Rule 
D)  Input Mask 
A)  Format 
B)  Default Value 
C)  Validation Rule 
D)  Input Mask

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

The answer of   ____________________ is the data type...

Question 13

The goal of building one-to-many relationships between tables is to minimize ____ data.

Accepted Answer

A)  redundant 
B)  textual 
C)  numeric 
D)  rarely used 
A)  redundant 
B)  textual 
C)  numeric 
D)  rarely used

Question 14

In the accompanying figure, the "one" side of a one-to-many relationship is referenced by which item?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 15

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 16

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 17

A printout of the Relationships window is called the ____________________ report.

Accepted Answer

The answer of A printout of the Relationships window is...

Question 18

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

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

Question 20

You can enter optional field descriptions in Table ____ View.

Accepted Answer

A)  SQL 
B)  Query 
C)  Design 
D)  Layout 
A)  SQL 
B)  Query 
C)  Design 
D)  Layout

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

Which Short Text field property should you use to specify whether an entry was required for the field?

In the accompanying figure, the data type of the PaymentDate field is ____________________.

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.

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

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

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

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

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

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

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

The goal of building one-to-many relationships between tables is to minimize ____ data.

In the accompanying figure, the "one" side of a one-to-many relationship is referenced by which item?

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

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

A printout of the Relationships window is called the ____________________ report.

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

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.

You can enter optional field descriptions in Table ____ View.

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

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

Which Short Text field property should you use to specify whether an entry was required for the field?

In the accompanying figure, the data type of the PaymentDate field is ____________________.

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.

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

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

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

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

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

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

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

The goal of building one-to-many relationships between tables is to minimize ____ data.

In the accompanying figure, the "one" side of a one-to-many relationship is referenced by which item?

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

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

A printout of the Relationships window is called the ____________________ report.

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

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.

You can enter optional field descriptions in Table ____ View.

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