FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Advanced Forms and Reports

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) All sections must have the same width.
B) Each section can have its own width.
C) Each section can have its own width within the limits of the width of the form/report.
D) You cannot change the width of sections.

E) A) and B)
F) B) and D)

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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

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

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

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.

Which of the following views is not used with forms or 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

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

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

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

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

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

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

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

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

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

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

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

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.