Database Methods
Important Note:
Any Database Methods exam solution files in .mdb format will not download. Clicking on their links will cause an "Error 500: Internal Server Error" or variation on that theme, depending on which web server the file resides.
This is as a result of increased server security that prohibits downloads of this file type. The solutions should now be downloadable as they are now stored in .zip (ZIP compressed file format). When you download the files, unzip them to your Linux or Windows system and use as required. Please note that as this format conversion is ongoing errors are likely...
Tutorials
The PowerPoint presentation used to teach Access is here. (The bullets are messed up and the explanatory notes are normally delivered verbally, but this should make sense). This set of notes makes use of the 1996 exam, which you can print from below.
If the above presentation is unusable on your system you may download it in:
- OpenOffice.org format (342K)
- Microsoft Powerpoint format (407K)
- The completed database is available in:
- Microsoft Access 1997 format (140K)
- Microsoft Access 2000 format (164K)
NB:Use this diagram to better understand the components of a modern database such as Microsoft Access or OpenOffice base and see how they fit together and relate to one another.
Assessment 2008/9
- Project (50%)
- TBA
- Exam (50%)
- TBA
Assessment 2007/8
- Project (50%)
- Read the instructions in the PDF documents below on electronic as well as paper submission.
- Apart from an Access database file, you should email one other document containing all the other elements of your paper submission - even the cover sheet.
- Service Charges Exemption Database (Rev:52) (PDF)
- General project guidelines (HTML)
- More detailed guidelines (Rev:31) (PDF)
- External tutorial on Access Queries (HTML)
- Exam (50%)
- Practical Exam Paper
- Solution file in Microsoft Access 2000 format (The file is zipped to enable downloading. The .zip compression format is supported under Linux as well as Microsoft Windows)
Assessment 2006/7
- Project (50%)
- Allocated topic:
- Parking Permit Registrations Database (More Mods: now has FAQ)
- General project guidelines (HTML)
- More detailed guidelines (PDF)
- OO Big Beautiful Queries - HOWTO!
- Exam (50%)
Exams - Previous Years
Project:
Exams:
There are past papers available. When you click on the links below, if asked, choose "Open It".
- 2007
- 2006
- Marking Scheme (1.95MB)
- 2005
- Part solutions available available in:
- Microsoft Access 1997 format (82K)
- Microsoft Access 2000 format (200K)
- 2004
- 2003
- Solutions available in:
- Microsoft Access 1997 format (82K)
- Microsoft Access 2000 format (208K)
- 2002
- 2001 which also has printed answers.
- 1997
- 1996
- Solutions available in:
- Microsoft Access 1997 format (140K)
- Microsoft Access 2000 format (164K)
- 1995
- Solutions available in:
- Microsoft Access 1997 format (74K)
- Microsoft Access 2000 format (200K)
- 1994
- Microsoft Access 1997 format (140K)
- Microsoft Access 2000 format (164K)
- TBA
- TBA
- Read the instructions in the PDF documents below on electronic as well as paper submission.
- Apart from an Access database file, you should email one other document containing all the other elements of your paper submission - even the cover sheet.
- Service Charges Exemption Database (Rev:52) (PDF)
- General project guidelines (HTML)
- More detailed guidelines (Rev:31) (PDF)
- External tutorial on Access Queries (HTML)
- Practical Exam Paper
- Solution file in Microsoft Access 2000 format (The file is zipped to enable downloading. The .zip compression format is supported under Linux as well as Microsoft Windows)
- Parking Permit Registrations Database (More Mods: now has FAQ)
- General project guidelines (HTML)
- More detailed guidelines (PDF)
- OO Big Beautiful Queries - HOWTO!
- Marking Scheme (1.95MB)
- Microsoft Access 1997 format (82K)
- Microsoft Access 2000 format (200K)
- Microsoft Access 1997 format (82K)
- Microsoft Access 2000 format (208K)
- Microsoft Access 1997 format (140K)
- Microsoft Access 2000 format (164K)
- Microsoft Access 1997 format (74K)
- Microsoft Access 2000 format (200K)
Click here for some information on the project. Click here for the 'my own work' form.