One supplier can supply many inventory items.Ĭreate a relationship report. Enforce Referential Integrity and select both Cascade options. On the Navigation Pane, group the objects by Tables and Related Views.Ĭreate a relationship between the two tables in the database using Supplier ID as the common field. Switch to Datasheet view and apply Best Fit to all of the fields. Delete the Fax Number field and save the table. Open the Cap1 Suppliers table in Design view. In the wizard, click the First Row Contains Column Headings option and set the primary key to Supplier ID. Import the source data from the downloaded Cap1_Suppliers workbook into a new table in the current database. Open the table, verify there are 25 records, and apply Best Fit to all fields. Accept all defaults in the wizard and do not save the Import steps. Append a copy of the records from the downloaded Cap1_Inventory workbook to the Cap1 Inventory table. Enter the following two records into Cap1 Inventory:Ĭlose the table. Continue adding the following fields as Short Text except for Cost, which should have a Currency Data Type: Rename the ID field to Item ID and change the Data Type to Short Text. Open the Cap1 Inventory table in Design View. Open the file Student_Access_Cap1_Rugged_Sportswear.accdb downloaded with this project.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |