Question 1

The Relationships window shows how well the data has been ____________________.

Accepted Answer

normalized

Question 2

A right outer join is useful in finding orphan records.

Accepted Answer

A) True 
 B)False  True

Question 3

The _____ Builder helps you with the syntax to enter complex criterion

Accepted Answer

A)  Expression 
B)  Criterion 
C)  Syntax 
D)  Rules 
A)  Expression 
B)  Criterion 
C)  Syntax 
D)  Rules A

Question 4

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 5

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 6

A query nested within another query 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 7

Which of the following is NOT a form property?

Accepted Answer

A)  Scroll Bars 
B)  Record Selectors 
C)  Control Source 
D)  Navigation Buttons 
A)  Scroll Bars 
B)  Record Selectors 
C)  Control Source 
D)  Navigation Buttons

Question 8

Press and hold the [ Ctrl ] key while opening a database to bypass the startup options. ____________________

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

A normalized database simplifies overall database maintenance.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

intermedia

Question 13

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

Accepted Answer

A)  Help screen 
B)  attachment field 
C)  sample database template 
D)  online tutorial 
A)  Help screen 
B)  attachment field 
C)  sample database template 
D)  online tutorial

Question 14

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 15

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

A validation rule that specifies that the DateHired field value is always greater than the DateBorn field value is a(n) _____ validation rule.

Accepted Answer

A)  table 
B)  field 
C)  record 
D)  column 
A)  table 
B)  field 
C)  record 
D)  column

Question 18

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 information on courses and the other containing information on students. One student can take many courses and one course can be taken by many students. What would be the proper relationship between the tables?

Accepted Answer

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

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

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

Accepted Answer

A) True 
 B)False

The Relationships window shows how well the data has been ____________________.

A right outer join is useful in finding orphan records.

The _____ Builder helps you with the syntax to enter complex criterion

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

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.

A query nested within another query is called a(n) ____.

Which of the following is NOT a form property?

Press and hold the [ Ctrl ] key while opening a database to bypass the startup options. ____________________

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

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

A normalized database simplifies overall database maintenance.

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

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

Second normal form means ____.

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

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

A validation rule that specifies that the DateHired field value is always greater than the DateBorn field value is a(n) _____ validation rule.

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Filters

Exam 16: Completing a Database Application

The Relationships window shows how well the data has been ____________________.

A right outer join is useful in finding orphan records.

The _____ Builder helps you with the syntax to enter complex criterion

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

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.

A query nested within another query is called a(n) ____.

Which of the following is NOT a form property?

Press and hold the [ Ctrl ] key while opening a database to bypass the startup options. ____________________

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

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

A normalized database simplifies overall database maintenance.

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

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

Second normal form means ____.

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

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

A validation rule that specifies that the DateHired field value is always greater than the DateBorn field value is a(n) _____ validation rule.

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Filters