FORM DESIGN LAB INSTRUCTIONS

Form Design Lab Guidelines

Update the field Caption property inside the table design before generating the subsequent forms so the field labels will accurately describe the data. Spaces should be used between words in captions, and they should be descriptive. For example, use First Name rather than FName.
Create the following forms for the PetCare Database using the PetCare Database. Submit the PetCare database to the Form Design Lab Assignment link in Moodle after creating the forms.
The Form Wizard should be used to build all forms, with the exception of the switchboard, and then updated to add specific formatting.
COMMON CHECKPOINTS FOR ALL FORMS:
• The form should seem professional, with all controls adequately positioned so that all data in the fields and field captions are visible.
(As shown in the video for Form Design Part 1)
• The mouse pointer should change into a Hyperlink Hand when it is over a command button, and the button itself should have a transparent back style.
(As shown in the video for Form Design Part 2)
• The size of the form’s header, detail, and footer sections should be chosen to reduce extraneous white space.
(As shown in the video for Form Design Part 1)
Form 1’s description states that the user may enter information into the SERVICES table using the form.
Identity: frmServices
Checklist:
• Use the Form Wizard to create the form.
Apply the Columnar Layout, the Apex Style, and the frmServices form name.
Create the form, then alter the design as follows:
• In the form header, change the Title to Service Entry Form.
• Include a label with your first and last names in the form’s footer.
• The fields can be moved around and resized to create a layout that is more user-friendly.
NOTE: Prior to removing the stacked arrangement, you must first select all fields and click the Remove icon under the Arrange tab.
• Conceal the form’s navigation buttons and include the following command buttons in the form footer:
Add Service First, followed by Previous, Last, and Close FormThe user can add a new record and navigate to the first, next, previous, and last records using the aforementioned buttons. The Access application should not be closed; instead, the Close button should close the service entry form.
Form 2 Description: The user should be able to input data into the CUSTOMERS database using the form.
Identifier: from customers
• Produce the form utilizing the Form Wizard
Apply the Columnar Layout, Apex Style, and Form Name. frmCustomers
Create the form, then alter the design as follows:
• In the form header, change the Title to Customer Entry Form.
• Include a label with your first and last names in the form’s footer.
• The fields can be moved around and resized to create a layout that is more user-friendly.
NOTE: Prior to removing the layered Arrangement, you must first select all fields.
• Conceal the form’s navigation buttons, and include the following command buttons in the form footer:
The user can add a new record and go to the first, next, previous, and last records using the aforementioned buttons: Add Service First Next Previous Last Close Form. Only the client entry form should be closed by using the Close button; Access should not be closed.
The user should be able to input data into the PETS table using Form 3. Checklist: frmPets: • Produce the form via the Form Wizard
Apply the Columnar Layout and the Apex Style, respectively.
The form is called frmPets.
Create the form, then alter the design as follows:
• In the form header, change the Title to Pet Entry Form.
• Include a label with your first and last names in the form’s footer.
• The fields can be moved around and resized to create a layout that is more user-friendly. NOTE: Prior to removing the layered Arrangement, you must first select all fields.
• Conceal the form’s navigation buttons, and include the following command buttons in the form footer:
Add Pet First, followed by Previous, Last, then Close FormThe user can add a new record and navigate to the first, next, previous, and last records using the aforementioned buttons. The Access application should not be closed; instead, the Close button should just close the pet entry form.
Form 4 Description: The user should be able to input data into the PETSERVICES table using the form. The PETS form will be supplemented by this subform.
sfrmPetServices is its name.
Checklist:
• Use the Form Wizard to create the form.
Apply the Tabular Layout, the Apex Style, and the sfrmPetServices form name.
Create the form, then alter the design as follows:
• In the form header, change the title to Pet Services.
• Confirm that Continuous Forms is the default view.
• The fields can be moved around and resized to create a layout that is more user-friendly.
NOTE: On this form, do not add custom command buttons. Keep the standard navigational buttons visible.
• Once this subform has been created, add it as a subform to the Pets entry form so that the user may schedule services for the pet on the same form.
o Remove the label from the subform.
o Resize the subform borders so that at least three records can be shown at once without having to scroll down the subform and that all of the fields are visible.
Description for Form 5: Using the Form Design, create a Switchboard form with the name frmSwitchboard.
Identifier: frmSwitchboard
Checklist:
• Change the form header to include a Title of Pet Care Database.
• Include a label with your first and last names in the form’s footer.
• Format the form using Apex AutoFormat. Keep in mind that professional database forms always have the same design.
• Cover the Navigation Buttons and Record Selectors on the form.
• Make the following command buttons with the text below that executes the proper action:
Go to Services
Enter clients
Adopt a Pet
Out of Database
NOTE: The other button should open the proper form, while the exit button should close the application.

 

 

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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

Order Now