Exam 8: Advanced Forms and Reports

Match the following controls with the type of data they would contain: I. Text box II. Label III. Image IV. Calculated V. Subform/Subreport A. Form title B. Picture C. Field D. Form or report inside of another form or report E. Aggregated function

The title of a report would be an example of a(n) ________ control.

Match the following field properties with how they affect the form: I. Row Source II. Allow Additions III. Allow Deletions IV. Allow Edits V. Tab Stop A. Records can be deleted. B. Records can be changed. C. What table or query provides the data for the Combo Box. D. Will pressing the tab key stop at this field. E. New records can be created.

Match the following controls with how they would be used: I. Page Break II. Combo Box III. Bound IV. Unbound V. Calculated A. Simple math is one possibility B. Is considered static C. Is considered dynamic D. Provide a menu of options E. Aid in correct pagination

________ controls are connected to a field on a query or table.

Adding which control will insure that your reports are paginated correctly?

A common control which displays the values in a field is called what type of control?

Because tables are often related in Access, one result is that forms can get more complex.

What does the Label control display as a default when used in a form or report?

Which of the following is not true about what restrictions can be set for a form?

________ can be created from tables, queries, or existing forms.

Match the following desired outcomes with the controls that would be used to produce that outcome: I. Force new pages to start at the end of each group II. Display a nice purple line after the data section III. Allow the user to choose options from a list during data entry IV. Decide how much a 10% raise would be for each employee V. Add descriptive text to explain a field which displays travel pictures A. Line B. Calculated control in a Text box C. Combo Box D. Page Break E. Label

Which of the following statements is true about changing the width of sections?

Which of the following would not be an example of an unbound control?

What key is often used in a form to advance from one field to another?

Match the following terms with their descriptions: I. Bound control II. Unbound control III. Calculated control IV. Combo Box control V. Control A. Not connected to a field B. Menu of options C. Results of an expression D. Connected to a field E. Object on a form or report

Which of the following views is not used with forms or reports?

Which of the following are not customizations you can make to a form?

The reason the value displayed in fields on a form change when the data in the table changes is that the fields on a form are bound controls.

What happens to the controls in a section if you turn off the section?