Question 1

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 2

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 3

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 4

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt.
-What is the first clue that data is not properly normalized?

Accepted Answer

You see a lot of rep

Question 5

Describe third normal form.

Accepted Answer

Third normal form builds on se

Question 6

Referential integrity helps create orphan records.

Accepted Answer

A) True 
 B)False

Question 7

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information.
-Suppose the student database includes two tables, one containing standard information such as student ID, name, and address, and the other containing student ID and immunization dates for required immunizations, one record per student. What would be the proper relationship between the tables?

Accepted Answer

The answer of You work in the registrar's office of...

Question 8

Match each term with the correct choice.
-A property that displays the default field name at the top of the field column

Accepted Answer

A) Zero-length string 
B) Null 
C) Caption 
D) Normalizing 
E) Northwind 
A) Zero-length string 
B) Null 
C) Caption 
D) Normalizing 
E) Northwind

Question 9

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 10

-In the figure above, what type of control is to the left of the Employee Sales by Country label?

Accepted Answer

A)  check box 
B)  combo box 
C)  command button 
D)  option button 
A)  check box 
B)  combo box 
C)  command button 
D)  option button

Question 11

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

Accepted Answer

The answer of A(n) ____________________ keeps track of the order...

Question 12

-The Sales Reports form in the figure above is an example of which type of Access form?

Accepted Answer

A)  Dialog box 
B)  Splash Screen 
C)  Data Entry form 
D)  Switchboard form 
A)  Dialog box 
B)  Splash Screen 
C)  Data Entry form 
D)  Switchboard form

Question 13

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 14

You should always try to create databases that use 1NF normalization rules. _________________________

Accepted Answer

A) True 
 B)False

Question 15

In Table Design View, you can view the properties of ____ field(s) at a time.

Accepted Answer

A)  1 
B)  2 
C)  4 
D)  as many as you select at the same time 
A)  1 
B)  2 
C)  4 
D)  as many as you select at the same time

Question 16

-The figure above is in ____ View.

Accepted Answer

A)  Design 
B)  Datasheet 
C)  Table 
D)  Report 
A)  Design 
B)  Datasheet 
C)  Table 
D)  Report

Question 17

If an employee does not want his/her phone number listed in a company database, and you want to enter two quotation marks with nothing between them to indicate an intentional nothing entry in the field, the ____________________ field property in the employee table must be set to Yes.

Accepted Answer

The answer of If an employee does not want his/her...

Question 18

Normalizing data means ____.

Accepted Answer

A)  analyzing database performance 
B)  structuring it for a relational database 
C)  creating clear and logical data entry forms 
D)  repeating data between two tables 
A)  analyzing database performance 
B)  structuring it for a relational database 
C)  creating clear and logical data entry forms 
D)  repeating data between two tables

Question 19

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

Question 20

-In the figure above, how many foreign key fields are in the Orders table?

Accepted Answer

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

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

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

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

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. -What is the first clue that data is not properly normalized?

Describe third normal form.

Referential integrity helps create orphan records.

Match each term with the correct choice. -A property that displays the default field name at the top of the field column

Which is NOT true of the Caption property?

-In the figure above, what type of control is to the left of the Employee Sales by Country label?

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

-The Sales Reports form in the figure above is an example of which type of Access form?

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

You should always try to create databases that use 1NF normalization rules. _________________________

In Table Design View, you can view the properties of ____ field(s) at a time.

-The figure above is in ____ View.

If an employee does not want his/her phone number listed in a company database, and you want to enter two quotation marks with nothing between them to indicate an intentional nothing entry in the field, the ____________________ field property in the employee table must be set to Yes.

Normalizing data means ____.

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

-In the figure above, how many foreign key fields are in the Orders table?

Getting Started With Microsoft Office 2013

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

Administering the Database

Chapter Access and the Web

Filters

Exam 11: Analyzing Database Design Using Northwind

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

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

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

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. -What is the first clue that data is not properly normalized?

Describe third normal form.

Referential integrity helps create orphan records.

Match each term with the correct choice. -A property that displays the default field name at the top of the field column

Which is NOT true of the Caption property?

-In the figure above, what type of control is to the left of the Employee Sales by Country label?

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

-The Sales Reports form in the figure above is an example of which type of Access form?

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

You should always try to create databases that use 1NF normalization rules. _________________________

In Table Design View, you can view the properties of ____ field(s) at a time.

-The figure above is in ____ View.

If an employee does not want his/her phone number listed in a company database, and you want to enter two quotation marks with nothing between them to indicate an intentional nothing entry in the field, the ____________________ field property in the employee table must be set to Yes.

Normalizing data means ____.

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

-In the figure above, how many foreign key fields are in the Orders table?

Getting Started With Microsoft Office 2013

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

Administering the Database

Chapter Access and the Web

Filters