Question 1

The Append Only property of the Memo field is available for all Access databases, regardless of which version of Access you are using.

Accepted Answer

A) True 
 B)False  False

Question 2

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 C

Question 3

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 health database includes two tables, one table called Students that contains student information such as StudentID, student name, address, and telephone number and the other table called Documentation that contains several records for each student and records the dates and descriptions of various medical documents required by the university. What type of relationship would need to be established between the two tables?

Accepted Answer

one-to-many

Question 4

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 5

Match each term with the correct choice.
-A sample database

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 6

First normal form refers to ____.

Accepted Answer

A)  redundant data in an original table that is extracted, placed in a new table, and related to the first table 
B)  derived fields that are removed 
C)  a 2-dimensional table with rows and columns 
D)  calculated fields that are removed 
A)  redundant data in an original table that is extracted, placed in a new table, and related to the first table 
B)  derived fields that are removed 
C)  a 2-dimensional table with rows and columns 
D)  calculated fields that are removed

Question 7

The Caption property keeps track of the order of the values in an indexed field.

Accepted Answer

A) True 
 B)False

Question 8

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.
-Which window shows you how well the data has been normalized?

Accepted Answer

The answer of Kelsey and Matt are in an advanced...

Question 9

The "" criteria is used to query for ____ values.

Accepted Answer

A)  Like 
B)  Null 
C)  Zero-length string 
D)  Is Null 
A)  Like 
B)  Null 
C)  Zero-length string 
D)  Is Null

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

-In the figure above, which field is the grouping field?

Accepted Answer

A)  CategoryName 
B)  ProductName 
C)  ProductSales 
D)  CategorySales 
A)  CategoryName 
B)  ProductName 
C)  ProductSales 
D)  CategorySales

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

When a query is based on another query's field list, the field list is called a(n) ____.

Accepted Answer

A)  Action 
B)  Sub report 
C)  Append query 
D)  Subquery 
A)  Action 
B)  Sub report 
C)  Append query 
D)  Subquery

Question 15

A normalized database simplifies overall database maintenance.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

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

Question 18

-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 19

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 20

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

The Append Only property of the Memo field is available for all Access databases, regardless of which version of Access you are using.

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

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

Match each term with the correct choice. -A sample database

First normal form refers to ____.

The Caption property keeps track of the order of the values in an indexed field.

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. -Which window shows you how well the data has been normalized?

The "" criteria is used to query for ____ values.

Which of the following is NOT a form property?

-In the figure above, which field is the grouping field?

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

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

When a query is based on another query's field list, the field list is called a(n) ____.

A normalized database simplifies overall database maintenance.

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

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

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

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.

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

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

The Append Only property of the Memo field is available for all Access databases, regardless of which version of Access you are using.

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

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

Match each term with the correct choice. -A sample database

First normal form refers to ____.

The Caption property keeps track of the order of the values in an indexed field.

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. -Which window shows you how well the data has been normalized?

The "" criteria is used to query for ____ values.

Which of the following is NOT a form property?

-In the figure above, which field is the grouping field?

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

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

When a query is based on another query's field list, the field list is called a(n) ____.

A normalized database simplifies overall database maintenance.

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

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

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

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.

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

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