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

Task