Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is not a possible way to customize a form?

Accepted Answer

A) Adding information to the Header of a form 
B) Adding artwork to a form 
C) Adding control buttons to the Title Bar of the form 
D) Using more complete names for fields

Question 3

When selecting a particular data field to include in a report using the report wizard, you should click on the ► button.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not an advantage of form data entry over datasheet data entry?

Accepted Answer

A) It is fast and efficient for data entry 
B) Accidental modification of adjacent records is not possible 
C) In Access, all the fields for a record are usually displayed on the same screen 
D) The forms are customizable by end users at run time

Question 5

Using Microsoft Access, the "PgUp" key on the computer's keyboard can be used to access the previous record in a form.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Reports can be modified after they are created.

Accepted Answer

A) True 
 B)False

Question 8

Which of these is not an example of a control break?

Accepted Answer

A) Changing a name of a client 
B) Change in department in an employee listing 
C) Change in service classification in a phone book listing 
D) Change in zip code in an address listing 
E) none of these

Question 9

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 10

Which of the following is an example of a valid calculated field entry?

Accepted Answer

A) MyField = field1\field2 
B) MyField = field1/field2 
C) My Field: thisField/ThatField 
D) MyField: thisField\ThatField

Question 11

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

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

Calculated fields are not possible when creating reports in Access.

Accepted Answer

A) True 
 B)False

Question 15

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 16

Which of these features is desirable in database form design?

Accepted Answer

A) Use garish colors to attract the user's attention 
B) Create forms that require several screens for display purposes 
C) Use unique fonts for different fields in the same form 
D) Resize data fields to ensure they display all the data in the underlying table

Question 17

In Access, forms allow users only to view database information, but not change it.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is not a part of a form?

Accepted Answer

A) A heading section 
B) A detail section 
C) A design section 
D) A navigation bar

Question 19

Assume that your manager has asked you to prepare a budget for your firm using data stored in an Access database.The best approach for creating the budget would be to use a:

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Database Forms and Reports

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

Which of the following is not a possible way to customize a form?

When selecting a particular data field to include in a report using the report wizard, you should click on the ► button.

Which of the following is not an advantage of form data entry over datasheet data entry?

Using Microsoft Access, the "PgUp" key on the computer's keyboard can be used to access the previous record in a form.

Which of these is an advantage of a subform?

Reports can be modified after they are created.

Which of these is not an example of a control break?

The Format menu in Access allows users to:

Which of the following is an example of a valid calculated field entry?

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

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

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

Calculated fields are not possible when creating reports in Access.

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

Which of these features is desirable in database form design?

In Access, forms allow users only to view database information, but not change it.

Which of the following is not a part of a form?

Assume that your manager has asked you to prepare a budget for your firm using data stored in an Access database.The best approach for creating the budget would be to use a:

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