14 May FORM DESIGN LAB INSTRUCTIONS
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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.