Form Design Lab Instructions

1. 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.