Improving Access to Data and Reports for MovinOn Inc. Previously, you created tables, queries,…

Improving Access to Data and Reports for MovinOn Inc.

Previously, you created tables, queries, forms, and reports
to help MovinOn streamline the recording, managing, and viewing of data in the
MovinOn database. After you finish your work with the database, Dora Nettles,
administrative assistant in the Washington warehouse, will serve as the
database manager. Dora is currently training employees on using the MovinOn
database, and reports that some employees are not familiar with Access and
don’t know how to use the Navigation pane to open the queries, forms, and
reports that they need. Dora
»

Improving Access to Data and Reports for MovinOn Inc.

Previously, you created tables, queries, forms, and reports
to help MovinOn streamline the recording, managing, and viewing of data in the
MovinOn database. After you finish your work with the database, Dora Nettles,
administrative assistant in the Washington warehouse, will serve as the
database manager. Dora is currently training employees on using the MovinOn
database, and reports that some employees are not familiar with Access and
don’t know how to use the Navigation pane to open the queries, forms, and
reports that they need. Dora asks you to create an interface that lets users
work with the data without using the Navigation pane.

Complete the following:

Finally, when users are working with the Customer Data Entry
form, Dora wants to make it easy to locate a particular customer. Because users
usually know the customer by the last name of the contact person, add a control
to frmCustomerData that lets you search for a record by selecting a contact’s
last name. Dora wants you to keep this control separate from the data so that
it stands out but is still readily available. (Hint: Consider placing the
control in the form’s header section.)

»