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
|
