Making a Database - 2 - Importing Data to create tables

STEP 1  -  Create a new blank database

0. Create a new folder in your My Documents folder called 'Database Example'.

1. Start Access by clicking Start -> Programs -> Microsoft Office -> Microsoft Access 2003

2. Click File -> New:

3. Click Blank Database:

4. Save the new database as censusdatabase into your folder called 'Database Example'.

STEP 2  -  Import existing Data

1. Download a sample of 100 results by right clicking and then save target as with UK_phase7_sample100.csv into your Database Example folder.

2. Click File -> Get External Data -> Import

3. Click on the drop down files of type and choose text files.  Select your copy of UK_phase7_sample100.csv and click import.

4. This starts the import text wizard.  Ignore every box and tick OK except for the second one where you must tick the box for 'First Row Contains Field Names':

This should create a new table in the table menu:

5. Double click on the filename to see all the data in there correctly:

Well done.  Now you need to see how to process the data to find out answers...

Go to section 3 - Changing Headers.