2. Open Access 2016 a) Choose Blank Desktop Database b) Name the database file SylvestersBS and navigate (file folder icon) to the location where you want to save the database and create the database. You have created a database that is empty. 3. Import Excel file into SylvestersBS a) Go to Ribbon and select External Data tab b) In the Import and Link section, choose Import Excel Spreadsheet c) Browse to the location of the Excel file and choose the first option--Import the source data into a new table in the current database and select OK. d) Make sure the Products worksheet is highlighted in the Import Spreadsheet Wizard box, select Next e) Make sure there is a check mark in front of First Row Contains Column Headings, select Next f) Skip the next page about field specification by selecting Next g) Select Choose my own primary key. Select Product Number from the drop-down box, select Next h) Import to Table: box should have Products in it, select Finish. i) Dont check the box on the Save Import Steps page, select Close. j) Repeat the same steps (a through i) to import the Suppliers worksheet into the Access table named Suppliers. The primary key will be the Supplier Number. 4. Modify tables a) Remove the ID column from the Products table and ID No column from the Suppliers table a. Design view > Highlight ID No > right click > delete row. b) Make sure that Product Number is designated as primary key in Product Table and Supplier Number is designated as primary key in Suppliers Table. c) Change the ZIP Code data type from Short Text to Number in both tables. d) Change the Supplier Number data type from Number to Short Text. e) The Supplier Number column in the Products table must display the same supplier number as the Suppliers Table. Change 1 to S1, 2 to S2, 3 to S3, 4 to S4 and 5 to S5 in the Products table in Datasheet View. (Hint: Simple as typing an S in front of all the numbers). f) If you have a Table1 listed in the left column, right click and delete it. It is not needed. Access may ask you to close it. Select the X to the right of where the Products and Suppliers table tabs are located. It should disappear.