Creating Tables   «Prev  Next»

Importing Data from Another Database - Exercise

Import the Hours table

Objective: Import the Hours table from another database.

Exercise Scoring

You will receive 5 points for this exercise. The exercise is auto-scored, which means all you need to do to receive full credit for the exercise is click the Submit button.


You need one more table in the Consulting database: the table that contains data about the hours you worked on each project. Rather than creating this table from scratch and entering the data, you can import the table from the Access database called Hours.mdb. You can download this file from the Resources page.


  1. Start by opening the Consulting database and choosing File>>Get External Data>>Import.
  2. Choose the Hours database and then the Hours table within the database.
  3. Check your database window to see if the Hours table is there.