Open a new Access database and save the new Module 14 assignment file to the Rowan folder on your desktop as BA132_LastName_QueryDB.accdb, replacing “LastName” with your own last name. (Example: BA132_Hywater_QueryDB) It is a good idea to save your work periodically.
Import External Data: With the Access new database open import the Excel data file into Access.
Import Wizard: Set up the imported data into a new table, make sure the box with first row with column heading is checked and let Access add the primary key, and name the table.
