Exam 33: Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

The width of a field in a report can be changed in either Report or Design views.

The table or query that supplies the underlying data for a form or report is called the ________ or data source.

The Remove Layout command is only available when using Layout view.

You would use a(n)________ to add data into or edit data in a table.

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

The Format tab contains commands to change the font,display,and alignment of the controls on a report.

A ________ is a document that displays database information in a meaningful format.

________ is used to see exactly what a report will look like when it is printed.

When modifying a report,the ________ tab is used to change the layout of a report.

When viewing a report in Layout view,you see that the records are displayed in order based on the primary key field.You prefer print the records in alphabetical order by last names and then by first names.Explain how to sort the report to display records using the last name and first name fields.

When working with forms,the Remove Layout option only appears in ________ view.

The Ascending and Descending buttons are located in the ________ group on the HOME tab.

To create a form,you click Form in the Forms group on the ________ tab.

To add a field to a report using the Add Existing Fields button,you must be in Design view.

Text boxes,buttons,and boxes are examples of form ________.

Design view displays a form's data and layout.

A ________ is a replica of a table or query's Datasheet view that maintains some form properties although the form is limited in design and control options?

After creating a report,you view it in Layout view,you see that the report is extremely wide.You decide to narrow the state field,since the states are displayed using two-letter abbreviations.Explain how you would narrow the width of the state field.

Explain the differences between a form with a subform and a split form.