KEY SKILLS LEVEL 3 - Database

Data Files

The full range of data files are available directly from the QCA website. To access them, click the link on the right

Database workbook 1

This workbook introduces students to setting up a new database using Access. The following skills are covered:

• Creating a simple database
• Creating & using tables
• Using data fields, records, data types, field sizes, primary key
• Importing data
• Validation
  

The workbook should be printed out as a class set, given to students during the lesson and collected back at the end to use with other students.

To access the data files, right click on the link and choose 'save target as'. Save the file in your area.

Database workbook 2

This workbook continues on from workbook 1. The following skills are covered:

• Creating queries
• Using queries
• Creating forms from a table
• Creating forms from a query

Database workbook 3

This workbook continues on from workbook 1. The following skills are covered:

• Creating reports from tables
• Creating reports from queries
• Reports with grouping
• Formatting
  

Database workbook 4

This workbook covers all of the skills learned during the previous three workbooks and acts as a good way to get students to consolidate their skills.

Database task 5

This task provides students with plenty of opportunities to practice setting up validation

The answers are provided so that students can check whether they have set up their validation rules correctly

Database task 6

This task provides students with plenty of opportunities to practice setting up queries.