Question 1

Reports can be modified after they are created.

Accepted Answer

A) True 
 B)False  True

Question 2

When designing a form for an Access database,the term "Inheritance" refers to:

Accepted Answer

A)  The propagation of properties and restrictions from the data field in the underlying table to the field in the form
B)  The propagation of properties and restrictions from the underlying table itself
C)  The ability of all the fields of the form to assume the same color
D)  none of these A

Question 3

Calculated fields are not possible when creating reports in Access.

Accepted Answer

A) True 
 B)False  False

Question 4

Which of these is likely to appear last in a report?

Accepted Answer

A)  Page header
B)  Group header
C)  Detail lines
D)   Report header
E)   any of these could be last

Question 5

Modifying a report layout and other properties can be done using the Report Wizard.

Accepted Answer

A) True 
 B)False

Question 6

The name of a form may contain spaces and capitalized characters.

Accepted Answer

A) True 
 B)False

Question 7

What is the first step in creating a report?

Accepted Answer

A)  Determining what information to display
B)  Analyzing the available information
C)  Restructuring the database
D)  Analyzing the database

Question 8

The Format menu in Access allows users to:

Accepted Answer

A)  Resize objects
B)  Edit objects
C)  Align objects
D)  all of the above

Question 9

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database.In order to allow data entry for each invoice and

Accepted Answer

A)  Table
B)  Query
C)  Form without a subform
D)  Form with a subform
E)  Report

Question 10

Formatting a report is usually a trivial task in Microsoft Access,requiring little time or effort.

Accepted Answer

A) True 
 B)False

Question 11

The first step in creating a report is actually planning the layout of the report.

Accepted Answer

A) True 
 B)False

Question 12

Which of these is an advantage of a subform?

Accepted Answer

A)  The ability to display subordinate information
B)  The ability to be used in the same manner as regular forms
C)  both of these
D)  none of these

Question 13

A report can only reference the data found in a single table-not the data from

Accepted Answer

A) True 
 B)False

Question 14

A report must contain all the information found in the records of the underlying table on which it is based.

Accepted Answer

A) True 
 B)False

Question 15

Clicking the ▌◄ button on the navigation bar of a form causes Access to display:

Accepted Answer

A)  The last record
B)  The record with the lowest primary key
C)  The record with the highest primary key
D)  The first record

Question 16

Forms are the only method of entering data in a database.

Accepted Answer

A) True 
 B)False

Question 17

Subform data must be in a one-to-one relationship with the data on the main form.

Accepted Answer

A) True 
 B)False

Question 18

Which of these is not a section of a database report?

Accepted Answer

A)  Report Header
B)  Page Header
C)  Detail lines
D)  Page Footer
E)  all of these are common sections of a database report

Question 19

A subform is:

Accepted Answer

A)  A subordinate form within a form
B)  A smaller,independent form compared to another form
C)  A specialized form used to create a report
D)  none of these

Question 20

Softcopy reports are unlikely to survive in the near future.

Accepted Answer

A) True 
 B)False

Exam 5: Database Forms and Reports

Reports can be modified after they are created.

When designing a form for an Access database,the term "Inheritance" refers to:

Calculated fields are not possible when creating reports in Access.

Which of these is likely to appear last in a report?

Modifying a report layout and other properties can be done using the Report Wizard.

The name of a form may contain spaces and capitalized characters.

What is the first step in creating a report?

The Format menu in Access allows users to:

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database.In order to allow data entry for each invoice and

Formatting a report is usually a trivial task in Microsoft Access,requiring little time or effort.

The first step in creating a report is actually planning the layout of the report.

Which of these is an advantage of a subform?

A report can only reference the data found in a single table-not the data from

A report must contain all the information found in the records of the underlying table on which it is based.

Clicking the ▌◄ button on the navigation bar of a form causes Access to display:

Forms are the only method of entering data in a database.

Subform data must be in a one-to-one relationship with the data on the main form.

Which of these is not a section of a database report?

A subform is:

Softcopy reports are unlikely to survive in the near future.