In addition to tracking information about the vendors Chatham Community Health Services works with, Cindi also wants to track information about their products and services. First, Cindi asks you to modify the necessary properties in the existing Supplier table in the Vendor database; then she wants you to create a new table in the Vendor database to contain product data. Complete the following:
1. Open the Vendor database you created in Tutorial 1. 2. Open the Supplier table in Design view, and set the field properties as shown in Figure 2-45.
3. Save the Supplier table. Click the Yes button when a message appears indicating some data might be lost. Switch to Datasheet view and resize columns, as necessary, to their best fit. Then save and close the Supplier table. 4. Create a new table in Design view, using the table design shown in Figure 2-46.
5. Specify ProductID as the primary key, and then save the table as Product. 6. Modify the table structure by adding a new field named Weight (data type: Number; field size: Single; Decimal Places: 2; Caption: Weight in Lbs; Default Value: [no entry]) between the Price and TempControl fields. Then move the Units field so that it is positioned between the Price and Weight fields. 7. Enter the records shown in Figure 2-47 in the Product table. Resize all datasheet columns to their best fit. When finished, save and close the Product table.
8. Use the Import Spreadsheet Wizard to add data to the Product table. The data you need to import is contained in the Supplies workbook, which is an Excel file located in the Access1 c Review folder provided with your Data Files. a. Specify the Supplies workbook as the source of the data. b. Select the option for appending the data. c. Select Product as the table. d. In the Import Spreadsheet Wizard dialog boxes, make sure Access confirms that the first row contains column headings, and import to the Product table. Do not save the import steps.
9. Open the Product table in Datasheet view and resize columns to their best fit, as necessary. Then save and close the Product table.
10. Define a one-to-many relationship between the primary Supplier table and the related Product table. Resize the table field lists so that all field names are visible. Select the referential integrity option and the cascade updates option for the relationship.
11. Save the changes to the Relationships window and close it, compact and repair the Vendor database, and then close the database.
