Question 1

To move a field list in the Relationship window, drag its ____________________.

Accepted Answer

The answer of To move a field list in the...

Question 2

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

Accepted Answer

A) True 
 B)False

Question 3

-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.E) B) and C)
F) A) and D)

Question 4

One-to-one relationships are rare.

Accepted Answer

A) True 
 B)False

Question 5

Match each term with the correct choice.
-A blank entry

Accepted Answer

A)  Zero-length string
B)  Null
C)  Caption
D)  Normalizing
E)  NorthwindF) A) and B)
G) A) and D)

Question 6

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

Accepted Answer

A)   Table Property Sheet
B)   individual field's Property Sheet
C)   Query Validation box
D)   Current Record boxE) A) and D)
F) None of the above

Question 7

A(n) ____________________ primary key consists of two fields, such as OrderID and ProductID.

Accepted Answer

multi-fiel...

Question 8

A right join is the default join between two tables in an Access query. _________________________

Accepted Answer

A) True 
 B)False

Question 9

-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)   NoneE) A) and C)
F) C) and D)

Question 10

A one-to-one relationship occurs when one record of the first table is related to ____________________ record(s) in the second table.

Accepted Answer

The answer of A one-to-one relationship occurs when one record...

Question 11

Northwind is provided by Microsoft as a(n)  ____.

Accepted Answer

A)   Help screen
B)   attachment field
C)   sample database
D)   online tutorialE) None of the above
F) B) and C)

Question 12

A special form used to announce information is called a splash screen.

Accepted Answer

A) True 
 B)False

Question 13

A switchback form is a special form used to help users navigate throughout the rest of the database.

Accepted Answer

A) True 
 B)False

Question 14

-In the figure above, what is the name of the query being constructed?

Accepted Answer

A)   Category Sales for 1995
B)   Product Sales for 1995
C)   ProductSales
D)   CategorySalesE) B) and C)
F) C) and D)

Question 15

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

Accepted Answer

Both appear to be blank entries, but the...

Question 16

What is positioned in the right side of the Field Properties pane?

Accepted Answer

A)   The field list
B)   The last property value choice you made
C)   The Lookup Wizard
D)   A description of the current propertyE) B) and C)
F) All of the above

Question 17

A normalized database increases redundant data.

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____________________ table is a table that stores values used in a field of another table.

Accepted Answer

The answer of A(n) ____________________ table is a table that...

Question 19

You query for zero-length strings using Is Null criteria. _________________________

Accepted Answer

A) True 
 B)False

Question 20

-In the figure above, results are grouped first by ____.

Accepted Answer

A)   Categories
B)   CategoryName
C)   Products
D)   ProductNameE) A) and C)
F) B) and D)

Exam 11: Analyzing Database Design Using Northwind

A one-to-one relationship occurs when one record of the first table is related to ____________________ record(s) in the second table.

Correct AnswerverifiedShow Answer

To move a field list in the Relationship window, drag its ____________________.

Correct AnswerverifiedShow Answer

A special form used to announce information is called a splash screen.

Correct AnswerverifiedShow Answer

You query for zero-length strings using Is Null criteria. _________________________

Correct AnswerverifiedShow Answer

A(n) ____________________ table is a table that stores values used in a field of another table.

Correct AnswerverifiedShow Answer

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

-In the figure above, what is the name of the query being constructed?

Correct AnswerverifiedShow Answer

-In the figure above, results are grouped first by ____.

Correct AnswerverifiedShow Answer

One-to-one relationships are rare.

Correct AnswerverifiedShow Answer

A right join is the default join between two tables in an Access query. _________________________

Correct AnswerverifiedShow Answer

Northwind is provided by Microsoft as a(n) ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedBoth appear to be blank entries, but the...View AnswerShow Answer

Match each term with the correct choice. -A blank entry

Correct AnswerverifiedShow Answer

What is positioned in the right side of the Field Properties pane?

Correct AnswerverifiedShow Answer

A(n) ____________________ primary key consists of two fields, such as OrderID and ProductID.

Correct Answerverifiedmulti-fiel...View AnswerShow Answer

A switchback form is a special form used to help users navigate throughout the rest of the database.

Correct AnswerverifiedShow Answer

-Which statement is true about the figure above?

Correct AnswerverifiedShow Answer

A normalized database increases redundant data.

Correct AnswerverifiedShow Answer

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Both appear to be blank entries, but the...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
multi-fiel...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified