Access 2003: Setting up a database from scratch

The ticks indicate the suitability of resources for each Key Stage.

Resource

KS3

KS4

KS5

Click Here

Setting up a basic Access Database (walkthrough 1)

Skills covered:

  • Creating a new database
  • Setting up fields
  • Changing the field size
  • Selecting appropriate data types
  • Setting up formatting e.g. date
  • Primary key
  • Required field
  • Validation rule
  • Lookup table
  • Creating a form
  • Entering records

 

tick
tick
tick

download filedownload file

Task

 

Database walkthrough 2

A different database walkthrough.

Again it will take students through setting up a simple one table database step-by-step.

Database terms explained as they are used e..g primary key

 

tick
tick
tick

download filedownload file

Task

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com