Question 1

If you often sort on a field, its Indexed property should be set to Yes.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 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. 
The student health database contains a Students table. If each student record in the Students table has a unique StudentID, what special designation would the StudentID field be given in the Students table?

Accepted Answer

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

Question 8

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 9

One of the best ways to teach yourself advanced database skills is to study a well-developed database.

Accepted Answer

A) True 
 B)False

Question 10

The Lookup Report is a valuable tool when creating other objects in the database.

Accepted Answer

A) True 
 B)False

Question 11

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 12

For full access to all of the properties for a field, work in Table Datasheet View.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

A subquery is often used when you need to summarize a group of records and use that results in another query.

Accepted Answer

A) True 
 B)False

Question 16

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Accepted Answer

A) True 
 B)False

Question 17

Press the [F11] key to open the Navigation Pane.

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

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 20

The Allow Multiple Values property is found on the _____tab in Table Design View.

Accepted Answer

A)  Lookup 
B)  Field Properties 
C)  Data Type 
D)  List Box 
A)  Lookup 
B)  Field Properties 
C)  Data Type 
D)  List Box

If you often sort on a field, its Indexed property should be set to Yes.

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

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

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

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

A normalized database decreases ____.

First normal form refers to ____.

One of the best ways to teach yourself advanced database skills is to study a well-developed database.

The Lookup Report is a valuable tool when creating other objects in the database.

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

For full access to all of the properties for a field, work in Table Datasheet View.

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

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

A subquery is often used when you need to summarize a group of records and use that results in another query.

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Press the [F11] key to open the Navigation Pane.

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

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

The Allow Multiple Values property is found on the _____tab in Table Design View.

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

If you often sort on a field, its Indexed property should be set to Yes.

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

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

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

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

A normalized database decreases ____.

First normal form refers to ____.

One of the best ways to teach yourself advanced database skills is to study a well-developed database.

The Lookup Report is a valuable tool when creating other objects in the database.

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

For full access to all of the properties for a field, work in Table Datasheet View.

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

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

A subquery is often used when you need to summarize a group of records and use that results in another query.

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Press the [F11] key to open the Navigation Pane.

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

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

The Allow Multiple Values property is found on the _____tab in Table Design View.

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