Question 1

The Lookup Wizard creates a one-to-____________________ relationship.

Accepted Answer

many

Question 2

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many 
A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many D

Question 3

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Accepted Answer

A) True 
 B)False  False

Question 4

A numeric field allows you to calculate a(n) ____ statistic in the Totals cell.

Accepted Answer

A)  Average 
B)  Sum 
C)  Count 
D)  All of the above 
A)  Average 
B)  Sum 
C)  Count 
D)  All of the above

Question 5

Which is NOT true of the Caption property?

Accepted Answer

A)  It is an optional property. 
B)  It is used as the default field name at the top of the field column in datasheets. 
C)  It is used as the default field name in labels that describe fields on forms and reports. 
D)  It must match the field name. 
A)  It is an optional property. 
B)  It is used as the default field name at the top of the field column in datasheets. 
C)  It is used as the default field name in labels that describe fields on forms and reports. 
D)  It must match the field name.

Question 6

If you often sort on a field, its Index property should be set to Yes.

Accepted Answer

A) True 
 B)False

Question 7

A normalized database simplifies overall database maintenance.

Accepted Answer

A) True 
 B)False

Question 8

Which function would you use to convert a value to currency?

Accepted Answer

A)  CCurr 
B)  CCur 
C)  CurrencyConverter 
D)  ValueToCurrency 
A)  CCurr 
B)  CCur 
C)  CurrencyConverter 
D)  ValueToCurrency

Question 9

In the figure above, the values of which field are being totaled?

Accepted Answer

A)  CategoryName 
B)  ProductName 
C)  ProductSales 
D)  Category Sales 
A)  CategoryName 
B)  ProductName 
C)  ProductSales 
D)  Category Sales

Question 10

Which of the following is NOT a form property?

Accepted Answer

A)  Border Style 
B)  Record Selectors 
C)  Control Source 
D)  Navigation Buttons 
A)  Border Style 
B)  Record Selectors 
C)  Control Source 
D)  Navigation Buttons

Question 11

A ____ relationship occurs when the primary key field of one table is related to the primary key field of another table.

Accepted Answer

A)  one-to-many 
B)  many-to-one 
C)  one-to-one 
D)  many-to-many 
A)  one-to-many 
B)  many-to-one 
C)  one-to-one 
D)  many-to-many

Question 12

Compare and contrast a zero-length string with a null entry.

Accepted Answer

Both appear to be blank entries, but the

Question 13

Second normal form means ____.

Accepted Answer

A)  calculated fields are removed 
B)  redundant data is extracted into a new table 
C)  totals are removed 
D)  a single table with rows and columns 
A)  calculated fields are removed 
B)  redundant data is extracted into a new table 
C)  totals are removed 
D)  a single table with rows and columns

Question 14

A normalized database increases redundant data.

Accepted Answer

A) True 
 B)False

Question 15

In the figure above, what type of relationship is shown between the Customers and Shippers tables?

Accepted Answer

A)  One-to-many 
B)  One-to-one 
C)  Many-to-many 
D)  None 
A)  One-to-many 
B)  One-to-one 
C)  Many-to-many 
D)  None

Question 16

You should strive to create databases that use ____ rules for normalization.

Accepted Answer

A)  zero normal form 
B)  first normal form 
C)  second normal form 
D)  third normal form 
A)  zero normal form 
B)  first normal form 
C)  second normal form 
D)  third normal form

Question 17

An example of a ____ relationship is when sensitive information such as emergency contact information must be separated from basic demographic data in two tables that are related by their primary key fields.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many 
A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many

Question 18

Which statement is true about the figure above?

Accepted Answer

A)  All direct relationships are one-to-one. 
B)  Referential integrity is not enforced on any relationships. 
C)  All direct relationships are one-to-many. 
D)  All direct relationships are many-to-many. 
A)  All direct relationships are one-to-one. 
B)  Referential integrity is not enforced on any relationships. 
C)  All direct relationships are one-to-many. 
D)  All direct relationships are many-to-many.

Question 19

The default join type for a query with two tables in a one-to-many relationship is the outer join. _________________________

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________  join operation is the default join that applies to one-to-many relationships between two tables in a query.

Accepted Answer

The answer of A(n) ____________________  join operation is the default join...

The Lookup Wizard creates a one-to-____________________ relationship.

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

A numeric field allows you to calculate a(n) ____ statistic in the Totals cell.

Which is NOT true of the Caption property?

If you often sort on a field, its Index property should be set to Yes.

A normalized database simplifies overall database maintenance.

Which function would you use to convert a value to currency?

In the figure above, the values of which field are being totaled?

Which of the following is NOT a form property?

A ____ relationship occurs when the primary key field of one table is related to the primary key field of another table.

Compare and contrast a zero-length string with a null entry.

Second normal form means ____.

A normalized database increases redundant data.

In the figure above, what type of relationship is shown between the Customers and Shippers tables?

You should strive to create databases that use ____ rules for normalization.

An example of a ____ relationship is when sensitive information such as emergency contact information must be separated from basic demographic data in two tables that are related by their primary key fields.

Which statement is true about the figure above?

The default join type for a query with two tables in a one-to-many relationship is the outer join. _________________________

A(n) ____________________ join operation is the default join that applies to one-to-many relationships between two tables in a query.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

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 10: Analyzing Database Design Using Northwind

The Lookup Wizard creates a one-to-____________________ relationship.

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

A numeric field allows you to calculate a(n) ____ statistic in the Totals cell.

Which is NOT true of the Caption property?

If you often sort on a field, its Index property should be set to Yes.

A normalized database simplifies overall database maintenance.

Which function would you use to convert a value to currency?

In the figure above, the values of which field are being totaled?

Which of the following is NOT a form property?

A ____ relationship occurs when the primary key field of one table is related to the primary key field of another table.

Compare and contrast a zero-length string with a null entry.

Second normal form means ____.

A normalized database increases redundant data.

In the figure above, what type of relationship is shown between the Customers and Shippers tables?

You should strive to create databases that use ____ rules for normalization.

An example of a ____ relationship is when sensitive information such as emergency contact information must be separated from basic demographic data in two tables that are related by their primary key fields.

Which statement is true about the figure above?

The default join type for a query with two tables in a one-to-many relationship is the outer join. _________________________

A(n) ____________________ join operation is the default join that applies to one-to-many relationships between two tables in a query.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters