A Customer Database Application: Access Refer to Production Challenge 10-A on page 190 of the textbook, and
Question:
A Customer Database Application: Access Refer to Production Challenge 10-A on page 190 of the textbook, and use the 35 names listed in this challenge to create a customer database for Millennium Appliances, Inc. Using MS Access techniques you have learned, complete the following A. Name the database Millennium Customers. Create a TABLE in MS Access that includes the following fields: Customer ID Customer Name Product Purchased Quantity B. The Customer ID will be the primary key and will be formatted as CST01, CST02, CST03, etc. to CST35. C. Enter the 35 names into the Customer Name column in the order they appear in Production Challenge 10-A. D. Randomly select products from the following list to enter data into the Product Purchased column: Refrigerator Microwave oven Conventional oven Convection oven Garbage compactor Freezer Dishwasher Washer Dryer Pure water dispenser E. Randomly assign a quantity purchased figure for each record in the Quantity column. F. Randomly assign a date within the last two years (including month, day, and year) for each purchase in the Date Purchased column. G. Save the table design as a customer database. Exercise 10-2: A Customer Database Report Application: Access Complete Exercise 10-1 then create a REPORT using the customer database table. A. Select CREATE/REPORT WIZARD to create the report. B. Include all fields in the report. C. Group the report by the Product Purchased field and order the data by the Customer ID field. D. Select SUM in the SUMMARY OPTIONS for the Quantity field. E. Select the ALIGN LEFT 1 LAYOUT, the PORTRAIT ORIENTATION, and the CORPORATE style for the report. F. Insert the title, Customer Purchase Information, then preview and print the report. Exercise 10-3: A Customer Database Form Application: Access Complete Exercise 10-1 then create a FORM using the customer database table. A. Select CREATE/FORM WIZARD to create your form. B. Include all fields in the form. C. Select the JUSTIFIED LAYOUT, the PORTRAIT ORIENTATION and the STANDARD STYLE for the form. D. Insert the title, Customer Purchase Information, then preview and print one the form record.
Systems Analysis and Design
ISBN: 978-1133274636
9th Edition
Authors: Shelly Cashman, Gary B. Shelly and Harry J. Rosenblatt