FORM DESIGN LAB INSTRUCTIONS

1.
Form Design Lab InstructionsBefore creating the following forms, update the field Caption property within the table design sothe field labels will be descriptive of the data. Captions should have spaces between words andbe descriptive, for instance instead of FName, use First Name.Using the PetCare Database, create the following forms for the PetCare Database. Aftercreating the forms, submit the PetCare database to the Form Design Lab Assignment link inMoodle.All forms, except the switchboard, should be created using the Form Wizard then modified toapply custom formatting.GENERAL CHECKPOINTS TO APPLY TO ALL FORMS:• All controls on the form should be aligned appropriately and the form should lookprofessional 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 shouldturn 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 unnecessarywhite 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: frmServicesChecklist:• Create the form using the Form Wizardo Apply the Columnar Layouto Apply the Apex Styleo Name the form frmServicesAfter 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 byclicking the Remove icon under the Arrange tab.• Hide the navigation buttons on the form, and add the following command buttons to theForm Footer:Add ServiceFirstNextPreviousLastClose 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 notexit the Access application.Form 2 Description: The form should allow the user to enter data into the CUSTOMERS table.Name: frmCustomersChecklist:• Create the form using the Form Wizardo Apply the Columnar Layouto Apply the Apex Styleo Name the form frmCustomersAfter 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 theForm Footer:Add ServiceFirstNextPreviousLastClose 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 notexit the Access application.Form 3 Description: The form should allow the user to enter data into the PETS table. Name:frmPetsChecklist:• Create the form using the Form Wizardo Apply the Columnar Layouto Apply the Apex Styleo Name the form frmPetsAfter 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: Youwill 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 theForm Footer:Add PetFirstNextPreviousLastClose 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 exitthe Access application.Form 4 Description: The form should allow the user to enter data into the PETSERVICEStable. This will be a subform that will be added to the PETS form.Name: sfrmPetServicesChecklist:• Create the form using the Form Wizardo Apply the Tabular Layouto Apply the Apex Styleo Name the form sfrmPetServicesAfter 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 navigationbuttons displayed.• After creating this subform, add it as a subform to the Pets entry form so the user will beable 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 bedisplayed at once without scrolling down on the subform.Form 5 Description: Create a Switchboard form named frmSwitchboard, using the FormDesign.Name: frmSwitchboardChecklist:• 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 formsare consistent in appearance.• Hide the form Record Selectors and Navigation Buttons.• Create the following command buttons that performs the appropriate action with thefollowing text:Enter ServicesEnter CustomersEnter PetsExit DatabaseNOTE: The exit button should exit the application and the other button should open theappropriate form.

“Get 15% discount on your first 3 orders with us” Use the following coupon FIRST15