Question 1

What is contained in the header and footer sections of a report?

Accepted Answer

Items such as the title, in the header section will be written only once, at the beginning of the report. Items such as the date and the page, in the report footer will be written only once, at the end of the report.

Question 2

Data rules in the definition of the data field itself are automatically enforced within a form.

Accepted Answer

A) True 
 B)False  True

Question 3

Which of the following is not a method of creating a form?

Accepted Answer

A) Double- clicking "Create form by entering data." 
B) Double- clicking "Create form in design view." 
C) Clicking the New button on the toolbar. 
D) Double- clicking "Create form by using wizard." 
A) Double- clicking "Create form by entering data." 
B) Double- clicking "Create form in design view." 
C) Clicking the New button on the toolbar. 
D) Double- clicking "Create form by using wizard." A

Question 4

What are the commands in Access to compact your database?

Accepted Answer

From within Access, the "Tools," "Databa

Question 5

Records from different tables can be combined when a common value exists between the two tables.

Accepted Answer

A) True 
 B)False

Question 6

To return to the form after viewing the design:

Accepted Answer

A) choose Form, then choose View. 
B) choose Form, then choose View Form. 
C) choose View, then choose Form. 
D) choose View, then choose Form View. 
A) choose Form, then choose View. 
B) choose Form, then choose View Form. 
C) choose View, then choose Form. 
D) choose View, then choose Form View.

Question 7

How can you set Access to automatically compact the database when you exit the program?

Accepted Answer

Select "Tools," foll

Question 8

An Access ___________ is a single file.

Accepted Answer

The answer of An Access ___________ is a single file....

Question 9

If you extend the width of the report in design view, then an extra page will be added to the report.

Accepted Answer

A) True 
 B)False

Question 10

Within Access, you can use the__________ command to cut and paste objects.

Accepted Answer

The answer of Within Access, you can use the__________ command...

Question 11

Information that is to be written only once at the top of the report is referred to as the:

Accepted Answer

A) page header. 
B) page title. 
C) header. 
D) report header. 
A) page header. 
B) page title. 
C) header. 
D) report header.

Question 12

To keep your database file a reasonable size, you should__________ it on a regular basis, such as every time you exit Access.

Accepted Answer

The answer of To keep your database file a reasonable...

Question 13

To view the form's design, choose View, and then choose Design.

Accepted Answer

A) True 
 B)False

Question 14

One caution about using database ___________ is that the size of the database file can grow quickly.

Accepted Answer

The answer of One caution about using database ___________ is...

Question 15

To enter a validation rule from the form's design view:

Accepted Answer

A) choose Edit, then choose Validation Rule. 
B) choose View, then choose Properties. 
C) right- click on the data field, then click Properties. 
D) right- click on the field label, then click Properties. 
A) choose Edit, then choose Validation Rule. 
B) choose View, then choose Properties. 
C) right- click on the data field, then click Properties. 
D) right- click on the field label, then click Properties.

Question 16

Users like to use features such as the __________command that can easily reverse mistakes.

Accepted Answer

The answer of Users like to use features such as...

Question 17

How can data entry be aided by the use of a form?

Accepted Answer

Table forms not only allow for data entr

Question 18

What are the types of objects in an Access database?

Accepted Answer

Objects include tabl

Question 19

A report can be created by choosing the "Create report by using wizard" option.

Accepted Answer

A) True 
 B)False

Question 20

The first step in creating a form using the wizard is to:

Accepted Answer

A) choose the form layout. 
B) choose the fields. 
C) change the name of the form. 
D) choose the correct table. 
A) choose the form layout. 
B) choose the fields. 
C) change the name of the form. 
D) choose the correct table.

Exam 20: Database Forms and Reports

What is contained in the header and footer sections of a report?

Data rules in the definition of the data field itself are automatically enforced within a form.

Which of the following is not a method of creating a form?

What are the commands in Access to compact your database?

Records from different tables can be combined when a common value exists between the two tables.

To return to the form after viewing the design:

How can you set Access to automatically compact the database when you exit the program?

An Access ___________ is a single file.

If you extend the width of the report in design view, then an extra page will be added to the report.

Within Access, you can use the__________ command to cut and paste objects.

Information that is to be written only once at the top of the report is referred to as the:

To keep your database file a reasonable size, you should__________ it on a regular basis, such as every time you exit Access.

To view the form's design, choose View, and then choose Design.

One caution about using database ___________ is that the size of the database file can grow quickly.

To enter a validation rule from the form's design view:

Users like to use features such as the __________command that can easily reverse mistakes.

How can data entry be aided by the use of a form?

What are the types of objects in an Access database?

A report can be created by choosing the "Create report by using wizard" option.

The first step in creating a form using the wizard is to:

Introduction to Information Systems

Information Systems for Competitive Advantage

Using Information Technology to Engage in Electronic Commerce

System Users and Developers

Computing and Communications Resources

Database Management Systems

Systems Development

Information in Action

Information Security

Ethical Implications of Information Technology

Decision Support Systems

Everyday Technology Skills

Web/HTML Project Using Microsoft FrontPage

Web/HTML Project Using Notepad

Web/HTML Student Survey

Web/HTML Book Purchase

Spreadsheet Basics

Spreadsheets with Data Capture - Vacation Choice

Spreadsheets with Data Capture - Movie Ticket Purchase

Database Queries - Customer Database

Database Queries - Inventory Database

Reports Based on Queries

Filters