Access Controls  «Prev  Next»

Creating multipage Forms - Exercise

Course project: Adding a Tab control to a form

Objective: Create a form and add the Tab control.

Exercise scoring

You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background - Overview

Recall that you are the Access database administrator for the marketing and documentation departments of companies in the software and networking business. For one of your large clients, you need to create a form that allows the user to enter standard information and display all the projects for clients.

Download files

As we stated in the first module, the Consulting307.mdb database is included in the compressed download file available on the Resources page. If you have already downloaded the database, continue to work in that version.

Instructions

  1. Create a new form with the Design view, using the Clients table as the record source.
  2. Add a Tab control.
  3. Change the Caption property for the first page to read Main Information.
  4. Change the Caption property for the second page to read Projects.
  5. Add the following fields to the first page: Company, FirstName, LastName, Address, City, State, and Zip.
  6. On the second page, add a Subform control that displays the projects for each client.

Hints

Remember to click on the Page tab to point to a certain page.