Tables Queries Forms
Table Design Enhancement
Table Field Validation
Custom Validation Messages
Input Mask Mechanics
Access Lookup Fields
Data Typ Aadvantages
Access Database Filters
Multiple Access Queries
Query Field Properties
Specifying Join Properties Queries
Total Queries in Access
Working With Crosstab Queries
Building Modifying Forms
Create Access Form
Add Format to Access Form
Insert Graphic onto Access Form
Access Form Properties
Changing Form Properties
Custom Form properties
Aligning Sizing Multiple Controls
Create Multipage Forms
Adding Chart to Form
Calendar activex Control
Creating multipage Forms - Exercise
Course project: Adding a Tab control to a form
Create a form and add the Tab control.
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
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.
As we stated in the first module, the
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.
Create a new form with the Design view, using the Clients table as the record source.
Add a Tab control.
Change the Caption property for the first page to read
Change the Caption property for the second page to read
Add the following fields to the first page: Company, FirstName, LastName, Address, City, State, and Zip.
On the second page, add a Subform control that displays the projects for each client.
Remember to click on the Page tab to point to a certain page.