Welcome to History Online
Actis
HomeFree Resources

Life in Coalbrookdale in the 19th Century

Activity 2: Using the database

Now it is your turn. The aim of this activity is to see whether you really understand how the database works. You can show that you do understand by:

  • choosing two or more individuals from the database (any age, family size, occupation, etc. - your choice)
  • making a set of clues like the ones in activity 1
  • seeing whether other people in your class can find them.

Remember, if they cannot find the right person, it may be because your clues were not precise enough.

Clues about mystery person 1How many people could it be?Clues about mystery person 2How many people could it be?
    
    
    
    
    


Importing the data into Microsoft Access 97

Coalbrookdale data file

  1. Right-click on the above link to the data file and choose 'Save Target As..'

  2. Save the file 'coalbrk.txt' to your hard disk.

  3. Open Microsoft Access and create a new database.

  4. Now click on 'File/Get External Data/Import'.

  5. Locate the data file you just saved to your hard disk, 'coalbrk.txt', and click on the import button.

  6. The text import wizard should start.

  7. Click on the 'Next' button. Make sure the check box labelled 'First Row contains Field Names' is checked.

  8. Click 'Finish' to close the Wizard and the table will be created.

Note: The above process may vary slightly in other database/spreadsheet packages, but the general principles will remain the same.

Please consult your product documentation for further details.

If you have any comments relating to History Online we would welcome your response.
Please email historyonline@actis.co.uk
Click below to find out more:


  • Introduction
  • Teachers' notes
  • Student activity 1: Find your guides
  • Student activity 2: Using the database
  • Student activity 3: Getting to know your guides
  • Student activity 4: Coalbrookdale according to your guides
  • History Online
    Top of pageHistory homepage

    Terms and conditions
    copyright© Actis . All rights reserved