Exam 4: Access: Creating and Using Professional Forms and Reports

A(n)________ outputs data in a meaningful way to those who view them.

The default sort order for a table is by its primary key.

Match the following terms with their description: I. Subform II. Subreport III. Subquery IV. Datasheet format V. SubForm Wizard A. Provides an easy way to add a subform to form B. This does not exist in Access. C. Displays data in a grid like Excel D. Displays related record on a form E. Displays related records on a report

What can you not do with an Access report?

When modifying a report, on which tab would you find the commands for changing what fields appear on the report?

The ________ control helps you keep your form looking neat and professional by keeping the other controls aligned properly.

Just as with forms, you can add, edit, or delete data in a report.

Good forms need to balance efficiency with a user-friendly interface.

What is not a valid reason to edit a form's layout?

Match the following terms with their description: I. Form II. Application Parts III. Record source IV. Stacked layout V. Tabular layout A. Used to build database objects B. Fields are displayed in a vertical column C. Fields are displayed in horizontal columns D. A user-friendly interface E. Supplies the records for a form or report

The default sort order in reports is ________.

Match the following terms with the group in which they are found on the Create tab: I. Form Design II. Module III. Application Parts IV. Query Design V. SharePoint Lists A. Queries B. Forms C. Macros & Code D. Templates E. Tables

Match the following terms with their description: I. Report Layout Control II. Form controls III. Controls IV. Control Wizard V. Text controls A. Used to keep a uniform look on a form B. This does not exist in Access. C. Used to display values D. Items such as labels and text boxes E. Used to keep a uniform look on a report

What is not an option in the Layout Options for Grouped Data in the Report Wizard?

Using a(n)________ as the record source for a form enables you to pick and choose what fields will be included on the form.

Which form (which will include the existing fields from the data source)can be created with just one click?

What is not a common format for a number control?

When modifying a report, on which tab would you find the commands for changing the margins of the report?