Access 2007: 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

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com