Form Design Lab Instructions

November 22nd, 2015

admin

Form Design Lab Instructions
Before creating the following forms, update the field Caption property within the table design so
the field labels will be descriptive of the data. Captions should have spaces between words and
be descriptive, for instance instead of FName, use First Name.
Using the PetCare Database, create the following forms for the PetCare Database. After
creating the forms, submit the PetCare database to the Form Design Lab Assignment link in
Moodle.
All forms, except the switchboard, should be created using the Form Wizard then modified to
apply custom formatting.
GENERAL CHECKPOINTS TO APPLY TO ALL FORMS:
• All controls on the form should be aligned appropriately and the form should look
professional so that all data in the fields and the field captions are visible.
(Demonstrated in Form Design Part 1 video)
• Command buttons should have a transparent Back Style and the mouse pointer should
turn into a Hyperlink Hand when it is over the button.
(Demonstrated in Form Design Part 2 video)
• Form sections (header, detail, and footer) should be sized to minimize unnecessary
white space.
(Demonstrated in Form Design Part 1 video)
Form 1 Description: The form should allow the user to enter data into the SERVICES table.
Name: frmServices
Checklist:
• Create the form using the Form Wizard
o Apply the Columnar Layout
o Apply the Apex Style
o Name the form frmServices
After creating the form, modify the design as follows:
• Change the Title to be Service Entry Form in the Form Header.
• Add a label to the Form Footer that contains your first and last name
• You may re-positioned and resize the fields in a more user-friendly layout.
NOTE: You will need to first select all fields and Remove the stacked Arrangement by
clicking the Remove icon under the Arrange tab.
• Hide the navigation buttons on the form, and add the following command buttons to the
Form Footer:
– Add Service
– First
– Next
– Previous
– Last
– Close Form
**The above buttons will allow the user to add a new record and move to the first, next,
previous, and last records. The Close button should close the service entry form only, and not
exit the Access application.
Form 2 Description: The form should allow the user to enter data into the CUSTOMERS table.
Name: frmCustomers
Checklist:
• Create the form using the Form Wizard
o Apply the Columnar Layout
o Apply the Apex Style
o Name the form frmCustomers
After creating the form, modify the design as follows:
• Change the Title to be Customer Entry Form in the Form Header.
• Add a label to the Form Footer that contains your first and last name
• You may re-positioned and resize the fields in a more user-friendly layout.
NOTE: You will need to first select all fields and Remove the stacked Arrangement.
• Hide the navigation buttons on the form, and add the following command buttons to the
Form Footer:
– Add Service
– First
– Next
– Previous
– Last
– Close Form
**The above buttons will allow the user to add a new record and move to the first, next,
previous, and last records. The Close button should close the customer entry form only, and not
exit the Access application.
Form 3 Description: The form should allow the user to enter data into the PETS table. Name:
frmPets
Checklist:
• Create the form using the Form Wizard
o Apply the Columnar Layout
o Apply the Apex Style
o Name the form frmPets
After creating the form, modify the design as follows:
• Change the Title to be Pet Entry Form in the Form Header.
• Add a label to the Form Footer that contains your first and last name
• You may re-positioned and resize the fields in a more user-friendly layout. NOTE: You
will need to first select all fields and Remove the stacked Arrangement.
• Hide the navigation buttons on the form, and add the following command buttons to the
Form Footer:
– Add Pet
– First
– Next
– Previous
– Last
– Close Form
**The above buttons will allow the user to add a new record and move to the first, next,
previous, and last records. The Close button should close the pet entry form only, and not exit
the Access application.
Form 4 Description: The form should allow the user to enter data into the PETSERVICES
table. This will be a subform that will be added to the PETS form.
Name: sfrmPetServices
Checklist:
• Create the form using the Form Wizard
o Apply the Tabular Layout
o Apply the Apex Style
o Name the form sfrmPetServices
After creating the form, modify the design as follows:
• Change the Title to be Pet Services in the Form Header.
• Verify the Default View is Continuous Forms
• You may re-positioned and resize the fields in a more user-friendly layout.
NOTE: Do not create customized command buttons on this form. Keep the default navigation
buttons displayed.
• After creating this subform, add it as a subform to the Pets entry form so the user will be
able to schedule services for the pet on the same form.
o Delete the subform label.
o Resize the subform borders so all the fields are visible and at 3 records can be
displayed at once without scrolling down on the subform.
Form 5 Description: Create a Switchboard form named frmSwitchboard, using the Form
Design.
Name: frmSwitchboard
Checklist:
• Add a Title of Pet Care Database to the Form Header.
• Add a label to the Form Footer that contains your first and last name
• Apply the Apex AutoFormat to the form. Remember that professional database forms
are consistent in appearance.
• Hide the form Record Selectors and Navigation Buttons.
• Create the following command buttons that performs the appropriate action with the
following text:
– Enter Services
– Enter Customers
– Enter Pets
– Exit Database
NOTE: The exit button should exit the application and the other button should open the
appropriate form.

Posted in Uncategorized

Responses are currently closed, but you can trackback from your own site.

Comments are closed.