Question 1

In a ____ relationship, a record in one table can be related to several records in another table and vice versa.

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one

Question 2

You can use the Relationships group on the ____ tab to create, view, and modify relationships between the tables in a database.

Accepted Answer

A)  DATABASE 
B)  DATABASE TOOLS 
C)  TABLES 
D)  DETAILS

Question 3

To move a label and the associated ____, click to select the object, move the pointer over the edge of the object until the pointer changes to a 4-headed arrow shape, then drag the label and data field to a new location.

Accepted Answer

A)  record field 
B)  data field 
C)  query field 
D)  tab field

Question 4

Click the ____ button to sort from Z to A or high to low.

Accepted Answer

A)  ascending 
B)  descending 
C)  either a. or b. 
D)  neither a. nor b.

Question 5

Click the FILE tab, click Print, then click Print again to display the ____.

Accepted Answer

A)  Table dialog box 
B)  Report dialog box 
C)  Print dialog box 
D)  Save As dialog box

Question 6

Most of the time, you'll want to include a subset of the fields on a form.

Accepted Answer

A) True 
 B)False

Question 7

The ____ helps you design an on-screen form in which you can enter and manipulate data for each record of a database.

Accepted Answer

A)  Record Wizard 
B)  Form Wizard 
C)  Field Wizard 
D)  Database Wizard

Question 8

Reports often include totals and subtotals as well as detailed information.

Accepted Answer

A) True 
 B)False

Question 9

A database form allows you to view your data one record at a time.

Accepted Answer

A) True 
 B)False

Question 10

Grouping helps arrange data when you want to produce a report containing ____.

Accepted Answer

A)  totals 
B)  subtotals 
C)  column borders 
D)  row borders

Question 11

The Form Wizard includes a section on laying out your form. Please describe the four types of form layouts.

Accepted Answer

The answer of The Form Wizard includes a section on...

Question 12

A ____ relationship means that a record in one table is related to only one record in another table. This type of relationship is rare in the world of databases.

Accepted Answer

A)  many-to-many 
B)  one-to-one 
C)  many-to-one 
D)  one-to-many

Question 13

The ____________________ form layout places labels next to fields, and lists the fields in columns.

Accepted Answer

The answer of The ____________________ form layout places labels next...

Question 14

As the data in your database changes, the Web page version of the report automatically updates.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ allows you to view your data one record at a time, with the fields of each record arranged on your computer screen as they might be arranged on a printed form.

Accepted Answer

The answer of A(n) ____________________ allows you to view your...

Exam 11: Finalizing a Database

In a ____ relationship, a record in one table can be related to several records in another table and vice versa.

You can use the Relationships group on the ____ tab to create, view, and modify relationships between the tables in a database.

To move a label and the associated ____, click to select the object, move the pointer over the edge of the object until the pointer changes to a 4-headed arrow shape, then drag the label and data field to a new location.

Click the ____ button to sort from Z to A or high to low.

Click the FILE tab, click Print, then click Print again to display the ____.

Most of the time, you'll want to include a subset of the fields on a form.

The ____ helps you design an on-screen form in which you can enter and manipulate data for each record of a database.

Reports often include totals and subtotals as well as detailed information.

A database form allows you to view your data one record at a time.

Grouping helps arrange data when you want to produce a report containing ____.

The Form Wizard includes a section on laying out your form. Please describe the four types of form layouts.

A ____ relationship means that a record in one table is related to only one record in another table. This type of relationship is rare in the world of databases.

The ____________________ form layout places labels next to fields, and lists the fields in columns.

As the data in your database changes, the Web page version of the report automatically updates.

A(n) ____________________ allows you to view your data one record at a time, with the fields of each record arranged on your computer screen as they might be arranged on a printed form.