Question 1

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

Accepted Answer

Relationsh

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

The Input Mask property contains how many parts?

Accepted Answer

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

Question 5

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 6

>=#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 7

Access 2007-2016 databases are not readable by Access 2003.

Accepted Answer

A) True 
 B)False

Question 8

The .j p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT true about field properties?

Accepted Answer

A)  Modifying them helps ensure database accuracy. 
B)  Some are required, and some are optional. 
C)  They are the same for each data type. 
D)  They can be used to change the way data is displayed. 
A)  Modifying them helps ensure database accuracy. 
B)  Some are required, and some are optional. 
C)  They are the same for each data type. 
D)  They can be used to change the way data is displayed.

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Accepted Answer

A) True 
 B)False

Question 14

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Accepted Answer

A)  indexes 
B)  tables 
C)  links 
D)  properties 
A)  indexes 
B)  tables 
C)  links 
D)  properties

Question 15

How does the Enforce Referential Integrity option relate to the creation of orphan records?

Accepted Answer

Enforce Referential Integrity is a set o

Question 16

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 17

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 18

You can edit or delete a relationship once it has been created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

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

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

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

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

The Input Mask property contains how many parts?

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

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

Access 2007-2016 databases are not readable by Access 2003.

The .j p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

Which of the following is NOT true about field properties?

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

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) ____ key field is the field used on the "one" side of a one-to-many relationship.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

How does the Enforce Referential Integrity option relate to the creation of orphan records?

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Where do you modify field properties?

You can edit or delete a relationship once it has been created in the Relationships window.

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

You can enter optional field descriptions in Table ____ View.

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

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

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

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

The Input Mask property contains how many parts?

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

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

Access 2007-2016 databases are not readable by Access 2003.

The .j p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group. _________________________

Which of the following is NOT true about field properties?

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

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) ____ key field is the field used on the "one" side of a one-to-many relationship.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

How does the Enforce Referential Integrity option relate to the creation of orphan records?

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Where do you modify field properties?

You can edit or delete a relationship once it has been created in the Relationships window.

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

You can enter optional field descriptions in Table ____ View.

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