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

When in Layout or Design view,which of the follow is NOT a form layout tab?

If you need to sort the records contained in a report,you can do so from either the Design view or the ________ of the report.

ACCDB is a file type used to exchange documents independent of software applications and operating systems.

________ view is useful for testing the functionality of the form and adjusting sizes of fields as needed.

When creating a report,________ asks a series of questions and uses the answers to generate a customized report.

Form tool is the most common tool for creating forms.

Report view allows a report to be viewed onscreen in a continuous page layout.

Which form view would be used to perform advanced layout adjustments?

To arrange the state field on a form in alphabetical order,you would use a descending sort.

A field can be deleted from a report in either Layout or Design views.

In Form view,to sort a field containing names from A to Z,click Ascending in the:

When you use the Split Form tool,the ________ views are synchronized with each other at all times.

All of the following are form creation tools EXCEPT:

The ________ creates a customizable form that displays the data in a form in both Form view and Datasheet view at the same time.

To sort the order of records in a form,you need to open the form in:

-Referencing the image above,this form is shown in ________ view.

Give two reasons why using a form is better than using a table when adding,updating,and deleting data.

To add a field to a report,click Add Existing Fields in the:

When viewing a form in Form view,you see that the records are displayed in order based on the primary key field.You prefer to temporarily view the records in alphabetical order by last names.Explain how to change the form to display records using the last name field,and how to return the form to display records in primary key order.