Question 1

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

Accepted Answer

A) True 
 B)False

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

Question 3

The changes that a user makes to the data in a form at run time do not alter the data in the underlying database table.

Accepted Answer

A) True 
 B)False

Question 4

Data field masks help prevent users from entering incorrect values.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is not a guideline for creating professional data reports?

Accepted Answer

A) Plan before you program 
B) Provide different output formats for different languages 
C) Avoid garish colors and fonts 
D) Fit on one sheet of paper

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

Accepted Answer

A) Data source selection 
B) Grouping 
C) Sorting 
D) Format design 
E) all of these can be defined by the Report Wizard

Question 9

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 10

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 11

Softcopy reports are unlikely to survive in the near future.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The button with symbol "►│" on the navigation bar gets you to the first form in the table.

Accepted Answer

A) True 
 B)False

Question 15

Manual forms, in terms of database form design, are:

Accepted Answer

A) Archaic 
B) Used to guide the development of electronic forms 
C) Used to collect information electronically 
D) Used by many offices already

Question 16

If you change an underlying value used in the calculated field of a report, the value of this calculated field in any subsequent copy of the report will also change.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database.Your manager has asked you to find a way to reduce data input errors.A good approach for reducing data entry errors would be to create a:

Accepted Answer

A) Table 
B) Query 
C) Form 
D) Report 
E) SQL

Question 20

Which of the following would best minimize the vertical space used by a report?

Accepted Answer

A) Reduce vertical space between lines in the report header 
B) Reduce vertical space between lines in the detail portion 
C) Use smaller fonts in Text boxes 
D) all of these are equally efficient for this task

Exam 5: Database Forms and Reports

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

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

The changes that a user makes to the data in a form at run time do not alter the data in the underlying database table.

Data field masks help prevent users from entering incorrect values.

Which of the following is not a guideline for creating professional data reports?

A subform is:

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

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

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?

Reports enable users to:

Softcopy reports are unlikely to survive in the near future.

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

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

The button with symbol "►│" on the navigation bar gets you to the first form in the table.

Manual forms, in terms of database form design, are:

If you change an underlying value used in the calculated field of a report, the value of this calculated field in any subsequent copy of the report will also change.

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

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

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database.Your manager has asked you to find a way to reduce data input errors.A good approach for reducing data entry errors would be to create a:

Which of the following would best minimize the vertical space used by a report?