Aida Database Task

 

Step

Description

Help Video

1

Downloading the data files from the Edexcel website

Click here

2

Setting up the database and importing the data file

Click here

3

Changing the field names and setting up the table structure

Click here

4

Adding the validation rules – completing the table structure

Click here

5

Importing the data into the table

Click here

6

Identifying the rejected records

Click here

7

Recording the rejected records

Click here

8

Setting up a data entry form

Click here

9

Creating search queries

Click here