Microsoft Access 2010 Chapter 1 Lab 2: Creating the Walburg Energy Alternatives Database
Problem: Walburg Energy Alternatives is a nonprofit organization that promotes the use of energy alternatives such as solar power and wind power. The organization provides a variety of services and funds itself through donations. Recently, the organization decided to sell a small number of items in its education center to help fund programs. The store purchases the items from vendors that deal in energy-saving products. Currently, the information about the items and vendors is stored in the Excel workbook shown in Figure 1–95. Each item is assigned to a single vendor, but each vendor may be assigned many items. You volunteer part-time at the store, and the store manager has asked you to create a database that will store the item and vendor information. You have already determined that you need two tables in which to store the information: an Item table and a Vendor table.
Instructions: Perform the following tasks:
1. Design a new database in which to store all the objects related to the items for sale. Call the database Walburg Energy Alternatives.
2. Use the information shown in the Excel workbook in Figure 1–95 to determine the primary keys and determine additional fields. Then, determine the relationships between tables, the data types, and the field sizes.
3. Create the Item table using the information shown in Figure 1–95.
4. Create the Vendor table using the information shown in Figure 1–95. Be sure that the field size for the Vendor Code in the Item table is identical to the field size for the Vendor Code in the Vendor table. Add the caption, Phone, for the Telephone Number field.
5. Add the appropriate data to the Item table. Resize the columns to best fit the data and save the changes to the layout.
6. Add the appropriate data to the Vendor table. Resize the columns to best fit the data and save the changes to the layout.
7. Create a query for the Item table. Include the Item Number, Description, Cost, Selling Price, and Vendor Code in the query. Save the query as Item Query.
8. Open the Item Query and add a criterion to limit retrieval to those items supplied by Scryps Distributors. Save the query as Item-Scryps Query.
9. Create a simple form for the Item table. Use the name, Item, for the form.
10. Create the report shown in Figure 1–96 for the Item table. Do not add any totals.
11. Change the database properties, as specified by your instructor. Submit the database in the format specified by your instructor.