EXERCISE DATABASE

You need to create a database to store information about different types of exercise.  This will be used to extract useful information for the Exercise Check-up users.

The data you need is provided in this text file.  You can find out what the data items are by looking at this list.

  1. Design and build a suitable database structure to store the data.  Make sure that each field has:
    1. sensible name
    2. data type
    3. format
    4. length
    5. You must include simple validation rules where appropriate
  2. Now import the data.  If any records are rejected check that your validation rules are working properly.
  3. Add 2 new records to the database
  THE GUIDE GRID
 



Stuck?  Launch SPB Helper!
 
 
Microsoft Access
 

Student login
Teacher login
 DOWNLOAD VLE/SCORM VERSION: 201-2006-DB.ZIP