Allegany college blackboard

Lab 8 CTEC 226.555 Module 3 – Lab 1 Due – Wednesday, June 19, 2019 (Beginning of Class – minus 50% after 5:15 PM) **** Upload to Dropbox **** Module 3 – Lab 1 Expanding the Garden Naturally Database  You will start with the database (file) that you submitted for Lab 6, which was Module 2 – Lab 1 assignment. Thus, “YOU ALREADY HAVE THE FILE TO START WITH”.  Below, I copied the instructions for this lab, from our book. Once you complete the tasks, upload your file to the Blackboard Dropbox. Maintaining the Garden Naturally Database Problem: Garden Naturally is expanding rapidly and needs to make some database changes to handle the expansion. The company needs to know more about its customers, such as general types of products needed. It also needs to add validation rules and update records in the database. Note: Use the database modified in Lab 1 of Module 2 for this assignment, or see your instructor for information on accessing the files required for this book. Instructions: Perform the following tasks: 1. 1. Open the Lab 1 Garden Naturally database and open the Customer table in Design view. 2. 2. Add a multivalued lookup field, Product Types Needed, to the Customer table. The field should appear after the Postal Code field. Table 3–2. lists the product type abbreviations that management would like in the multivalued field as well as a description. Save the change to the table. Table 3–2 Product Type Abbreviations and Descriptions Product Type Abbreviations Product Type Descriptions Comp Composting Needs Frtl Fertilizers Grdn Garden Supplies Grnh Greenhouse Supplies Lawn Lawn and Landscaping Seed Seeds Soil Soils and Nutrients Watr Watering Equipment 3. 3. Add a calculated field named Total Amount (Amount Paid + Balance Due) to the Customer table. The field should follow the Balance Due field. Save the change to the table. 4. 4. Create the following rules for the Customer table and save the changes: 1. Ensure that any letters entered in the Customer Number field appear as uppercase. 2. Make Customer Name a required field. 3. Ensure that only the values DE, NJ, and PA can be entered in the State field. Include validation text. 4. Assign a default value of NJ to the State field. 5. 5. Use Filter By Form to find all records where the city is Gaston and the balance due is $0.00. Delete the record(s). Do not save the filter. 6. 6. Open the Customer table in Datasheet view and add the data shown in Figure 3–83 to the Product Types Needed field. Resize the field to best fit and save the changes to the layout of the table. Figure 3–83 Customer Table Customer Number Customer Name Product Types Needed AA30 All About Gardens Grdn, Seed, Soil, Watr CT02 Christmas Tree Farm Comp, Frtl, Seed, Soil, Watr GG01 Garden Gnome Frtl, Grdn, Lawn GT34 Green Thumb Growers Frtl, Grnh, Seed LH15 Lawn & Home Store Comp, Frtl, Grdn, Lawn ML25 Mum’s Landscaping Frtl, Soil, Watr OA45 Outside Architects Grdn, Watr PL10 Pat’s Landscaping Frtl, Grdn, Watr PN18 Pyke Nurseries Comp, Frtl, Grnh, Seed, Soil SL25 Summit Lawn Service Grdn, Lawn, Watr TW34 TAL Wholesalers Comp, Frtl, Seed, Soil TY03 TLC Yard Care Lawn, Watr YS04 Yard Shoppe Grdn, Lawn, Watr YW01 Young’s Wholesalers Comp, Frtl, Grdn, Lawn, Seed, Soil 7. 7. Open the Sales Rep table in Design view and change the field size for the Address field to 25. Save the changes and close the table. 8. 8. Open the Sales Rep table in Datasheet view, find the record for sales rep 32, and change the address to 982 Victoria Station Rd. Resize the column to best fit. 9. 9. If requested to do so by your instructor, change the last name for sales rep 35 to your last name. If your last name is longer than 15 characters, simply enter as much as you can. 10. 10. Save the changes to the layout of the table and close the Sales Rep table.