ReviseICT.co.uk homepage
Microsoft Access
Database software

Tasks

 
You have three tasks to complete.  These will help you develop your Access skills and guide you through the process of building a database.  Click on each link below to work through each of the stages.  When you reach the extension tasks you will have the opportunity to develop your own ideas.
 
 Task  Requirements
   
1. Planning  Understanding the purpose of a database
 Planning what is needed
 Completing research
   
2. Developing  Data types
 Naming conventions
 Starting the database
 Create a database table and a primary key
   
3. Creating  Entering data
 Editing and manipulating fields
 Data validation and rules
 Making queries
 Using simple and multiple criteria
   

Only when you have completed all the tasks about should you continue on.


Assessment

 

Index page