Question 1

A form may be created that is based on a query instead of a table.

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Forms are not capable of which of the following?

Accepted Answer

A)  Read-only display
B)  Auto-complete features
C)  Validating input
D)  Preventing all entry errors D

Question 4

If a form contains a subform, then the relationship between the records of the form and the records of the subform are usually related in a ______ relationship.

Accepted Answer

A)  one to one
B)  one to many
C)  many to many
D)  none of these
E)  there is not enough information to answer this question

Question 5

If you misspell a field name, Access will:

Accepted Answer

A)  Correct you
B)  Indicate an error
C)  Assume you are creating a new field
D)  none of theseRenumber all questions below and adjust solutions accordingly

Question 6

Items such as the "item description" and the "unit price" appear at the top of each page of a report.These labels are best placed in the:

Accepted Answer

A)  report header
B)  page header
C)  group header
D)  detail section
E)  page footer

Question 7

Calculated fields are not possible when creating reports in Access.

Accepted Answer

A) True 
 B)False

Question 8

Which of these sections of a database report is likely to occupy the most room on a report?

Accepted Answer

A)  Report Header
B)  Page Header
C)  Detail lines
D)  Page Footer
E)  Report Footer

Question 9

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 10

When selecting a particular data field to include in a report using the Report Wizard, you should click on the ►► button.
Renumber all questions below and adjust solutions accordingly

Accepted Answer

A) True 
 B)False

Question 11

Data field masks help prevent users from entering incorrect value entries.

Accepted Answer

A) True 
 B)False

Question 12

A report can combine the information from various tables in a database.

Accepted Answer

A) True 
 B)False

Question 13

Grouping like data together is a useful guideline to follow when creating usable forms.

Accepted Answer

A) True 
 B)False

Question 14

Which of these is not an example of a calculated field?

Accepted Answer

A)  Unit cost of an item
B)  Grand total
C)  Sales tax
D)  Profit

Question 15

A picture of a bicycle that appears at the top of every invoice form is an example of:

Accepted Answer

A)  An unbound control
B)  A bound control
C)  A lookup function
D)  A query

Question 16

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)  Report footer

Question 17

Reports enable users to:

Accepted Answer

A)  See a paper output of database information
B)  Change information in the underlying database tables
C)  Limit the distribution of the information
D)  Tab from one data field to another at run time

Question 18

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 19

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field), what will happen?

Accepted Answer

A)  Nothing.The same value that was calculated in any prior report will continue to show in the new report
B)  The new report will show a new calculated value
C)  The new report will show the average of the original value and the new value
D)  This depends upon other settings not indicated in the statement

Question 20

Calculated fields in reports use the information in external files exclusively.

Accepted Answer

A) True 
 B)False

Exam 16: Database Forms and Reports

A form may be created that is based on a query instead of a table.

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

Forms are not capable of which of the following?

If a form contains a subform, then the relationship between the records of the form and the records of the subform are usually related in a ______ relationship.

If you misspell a field name, Access will:

Items such as the "item description" and the "unit price" appear at the top of each page of a report.These labels are best placed in the:

Calculated fields are not possible when creating reports in Access.

Which of these sections of a database report is likely to occupy the most room on a report?

A subform is:

When selecting a particular data field to include in a report using the Report Wizard, you should click on the ►► button. Renumber all questions below and adjust solutions accordingly

Data field masks help prevent users from entering incorrect value entries.

A report can combine the information from various tables in a database.

Grouping like data together is a useful guideline to follow when creating usable forms.

Which of these is not an example of a calculated field?

A picture of a bicycle that appears at the top of every invoice form is an example of:

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

Reports enable users to:

Which of these is an advantage of a subform?

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field) , what will happen?

Calculated fields in reports use the information in external files exclusively.