Question 1

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 2

A normalized database decreases ____.

Accepted Answer

A)  the ability to create reports 
B)  database performance (speed) 
C)  the ability to create queries 
D)  inaccurate data 
A)  the ability to create reports 
B)  database performance (speed) 
C)  the ability to create queries 
D)  inaccurate data

Question 3

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 4

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 property 
A)  The field list 
B)  The last property value choice you made 
C)  The Lookup Wizard 
D)  A description of the current property

Question 5

A ____ is a type of form used to make choices to modify the contents of another object in the database.

Accepted Answer

A)  switchboard 
B)  dialog box 
C)  splash screen 
D)  startup form 
A)  switchboard 
B)  dialog box 
C)  splash screen 
D)  startup form

Question 6

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 7

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 8

A ____ relationship cannot be created directly between two tables in Access.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  all three types can be directly created with two tables in Access 
A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  all three types can be directly created with two tables in Access

Question 9

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 10

In the figure above, what type of control shows the list of categories (Beverages, Condiments, so forth)?

Accepted Answer

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

Question 11

Referential integrity helps create orphan records.

Accepted Answer

A) True 
 B)False

Question 12

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)  CategorySales 
A)  Category Sales for 1995 
B)  Product Sales for 1995 
C)  ProductSales 
D)  CategorySales

Question 13

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 14

The ____ property, when set to Yes, allows you to add data to a Long Text field, but not change or remove existing data.

Accepted Answer

A)  Paste Structure Only 
B)  Paste Structure and Data 
C)  Append Only 
D)  Append 
A)  Paste Structure Only 
B)  Paste Structure and Data 
C)  Append Only 
D)  Append

Question 15

A table's Property Sheet controls characteristics for the entire table object.

Accepted Answer

A) True 
 B)False

Question 16

A text 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 17

Tables with a many-to-many relationship must be related to an additional table, called a(n) ____________________ table.

Accepted Answer

The answer of Tables with a many-to-many relationship must be...

Question 18

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

Question 19

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 20

The CCur function converts a calculated result to a currency value. _________________________

Accepted Answer

A) True 
 B)False

Normalizing data means ____.

A normalized database decreases ____.

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

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

A ____ is a type of form used to make choices to modify the contents of another object in the database.

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?

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

A ____ relationship cannot be created directly between two tables in Access.

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

In the figure above, what type of control shows the list of categories (Beverages, Condiments, so forth)?

Referential integrity helps create orphan records.

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

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.

The ____ property, when set to Yes, allows you to add data to a Long Text field, but not change or remove existing data.

A table's Property Sheet controls characteristics for the entire table object.

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

Tables with a many-to-many relationship must be related to an additional table, called a(n) ____________________ table.

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

The CCur function converts a calculated result to a currency value. _________________________

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

Normalizing data means ____.

A normalized database decreases ____.

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

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

A ____ is a type of form used to make choices to modify the contents of another object in the database.

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?

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

A ____ relationship cannot be created directly between two tables in Access.

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

In the figure above, what type of control shows the list of categories (Beverages, Condiments, so forth)?

Referential integrity helps create orphan records.

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

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.

The ____ property, when set to Yes, allows you to add data to a Long Text field, but not change or remove existing data.

A table's Property Sheet controls characteristics for the entire table object.

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

Tables with a many-to-many relationship must be related to an additional table, called a(n) ____________________ table.

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

The CCur function converts a calculated result to a currency value. _________________________

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