Question 1

The options on the REPORT DESIGN TOOLS tabs are used to modify a report.

Accepted Answer

A) True 
 B)False  True

Question 2

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. 
A)  ascending 
B)  descending 
C)  either a. or b. 
D)  neither a. nor b. B

Question 3

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 
A)  many-to-many 
B)  one-to-one 
C)  many-to-one 
D)  one-to-many B

Question 4

When designing your own on-screen form using the Form Wizard, first click the ____ tab.

Accepted Answer

A)  CREATE 
B)  HOME 
C)  EXTERNAL DATA 
D)  DATABASE TOOLS 
A)  CREATE 
B)  HOME 
C)  EXTERNAL DATA 
D)  DATABASE TOOLS

Question 5

Click the Open (blank) record button to add a new record.

Accepted Answer

A) True 
 B)False

Question 6

Layout View provides maximum flexibility for designing a form, but requires more time on your part.

Accepted Answer

A) True 
 B)False

Question 7

You can modify the design of any form by right-clicking the tab at the top of the form and selecting ____________________ View.

Accepted Answer

The answer of You can modify the design of any...

Question 8

Forms that you create need to be saved separately from the database file.

Accepted Answer

A) True 
 B)False

Question 9

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 
A)  one-to-one 
B)  one-to-many 
C)  many-to-many 
D)  many-to-one

Question 10

When you add a(n) grouping level, records are sorted according to entries in the group field.

Accepted Answer

A) True 
 B)False

Question 11

When working with a report, add ____.

Accepted Answer

A)  no more than three fields 
B)  no more than five fields 
C)  no more than seven fields 
D)  as many fields as you would like 
A)  no more than three fields 
B)  no more than five fields 
C)  no more than seven fields 
D)  as many fields as you would like

Question 12

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 13

In a(n) many-to-many relationship, a record in one table can be related to several records in another table and vice versa.

Accepted Answer

A) True 
 B)False

Question 14

The report ____ is used to identify the report so that you can open it in the future.

Accepted Answer

A)  number 
B)  name 
C)  primary key 
D)  database link 
A)  number 
B)  name 
C)  primary key 
D)  database link

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

Case-Based Critical Thinking Questions Case 18-1 Darcy wants to publish some of her reports on the Internet so that other people on her team can easily access them. Please answer the questions below. To get started, Darcy opens the report she wants to convert to a Web page and then clicks the ____ tab.

Accepted Answer

A)  HOME 
B)  CREATE 
C)  EXTERNAL DATA 
D)  DATBASE TOOLS 
A)  HOME 
B)  CREATE 
C)  EXTERNAL DATA 
D)  DATBASE TOOLS

Question 17

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 
A)  Table dialog box 
B)  Report dialog box 
C)  Print dialog box 
D)  Save As dialog box

Question 18

Design View provides maximum flexibility for designing a form, but requires more time on your part.

Accepted Answer

A) True 
 B)False

Question 19

When using the Report Wizard, select the table that ____.

Accepted Answer

A)  contains data to be merged with the report 
B)  contains relational links 
C)  contains data for the report 
D)  contains fields to place the printed data 
A)  contains data to be merged with the report 
B)  contains relational links 
C)  contains data for the report 
D)  contains fields to place the printed data

Question 20

You can organize your data into ____ using a table, which is the best way to view the data contained in a large number of records.

Accepted Answer

A)  rows 
B)  columns 
C)  both a. and b. 
D)  neither a. nor b. 
A)  rows 
B)  columns 
C)  both a. and b. 
D)  neither a. nor b.

Exam 18: Finalizing a Database

The options on the REPORT DESIGN TOOLS tabs are used to modify a report.

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

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.

When designing your own on-screen form using the Form Wizard, first click the ____ tab.

Click the Open (blank) record button to add a new record.

Layout View provides maximum flexibility for designing a form, but requires more time on your part.

You can modify the design of any form by right-clicking the tab at the top of the form and selecting ____________________ View.

Forms that you create need to be saved separately from the database file.

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

When you add a(n) grouping level, records are sorted according to entries in the group field.

When working with a report, add ____.

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

In a(n) many-to-many relationship, a record in one table can be related to several records in another table and vice versa.

The report ____ is used to identify the report so that you can open it in the future.

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

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

Design View provides maximum flexibility for designing a form, but requires more time on your part.

When using the Report Wizard, select the table that ____.

You can organize your data into ____ using a table, which is the best way to view the data contained in a large number of records.

Computer Hardware

Peripheral Devices

System and Application Software

Installing Software

Getting Started With Windows

Working With Windows Settings and Accounts

Working With Files

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Creating a Worksheet

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Creating a Database

Networks

Working With E-Mail

Browsing the Web

Computer Benefits and Risks

Filters