Database Task One

First: Download/Open the Database Task Sheet and the Database Processes Sheet

Second: Watch the video tutorials

Third: Download the Database data file

Fourth: Complete the database task and email the Access database file to your ICT FS tutor

 

1 Reading the Task

 

 

 

 

 

 

 

 

2 Getting External Data

 

 

 

 

 

 

3 Setting Field Types

 

 

 

 

 

 

 

4 Screen Print of Design View

 

 

 

 

 

 

 

 

5 Saving and Printing the Table

 

 

 

 

 

 

6 Create Query for Ascending Order

 

 

 

 

 

 

 

7 OR query

 

 

 

 

 

8 Saving and Renaming the Query

 

 

 

 

 

 

 

 

9 Creating the Report

 

 

 

 

 

 

10 Printing the Report