McWeeney Publications

Advanced Coursework Resource

Database Solutions

Further Details

This resource designed for use on a school or college intranet. It provides a practical solution to many of the typical problems encountered by students when completing advanced coursework using Access. Two complete and separate versions are supplied. One for Access XP/2003 and the other for Access 2000.

Over 30 linked pdf files provide solutions to 25 coursework problems. Each file is accompanied by a a sample database files, each of which provides a working demonstration of the solution. A further 25 practice database files provide a starting point for students to follow the detailed step-by-step solution provided in the text.

The text itself consists of three sections for each solution. An outline description of the solution and its context, a description of the method to be used and a detailed step-by-step guide to implementing the solution - which can be followed by the student using the practice database.

Apart from the obvious use of allowing students to find solutions to particular coursework problems - thereby helping to relieve some of the pressure on teachers during practical lessons, the materials have a number of other uses.

Research: the sample databases together with a summary document of all 25 solutions allow students to investigate the potential of Access, discovering techniques and methods that they otherwise may not have come across and which will be of direct relevance to their coursework.

Learning Access: the complete set of solutions can be used as the basis of a teaching course, delivering advanced practical skills in the use of Access.

Projects: the final section of the materials provide a starting point for a number of standard project titles.

The list below gives a summary of the solution topics.

Solution 01
Opening a form at a particular record
Solution 16
Automatically exporting data to Excel
Solution 02
Opening a form to display a particular list of records
Solution 17
Finding the user and computer name
Solution 03
Opening a form by clicking the related item in a list
Solution 18
Transaction logs and back up
Solution 04
A simple find button on a form
Solution 19
Handling address data
Solution 05
Calculating ages from dates of birth
Solution 20
Invoicing and customer billing systems
Solution 06
Converting marks (numbers) to grades (letters)
Solution 21
Appointments systems
Solution 07
Calculating amounts and quantities remaining
   Solution 22
Interactive booking systems
Solution 08
Generating sequence numbers
  Solution 23
Calculation dependent systems
Solution 09
Confirming data entry (on screen validation)
  Solution 24
Stock control systems
Solution 10
Validating post codes
  Solution 25
Library/loans systems
Solution 11
Implementing check digit validation
User Guide
Notes on using the materials effectively
Solution 12
Displaying text values in option groups
Summary
Brief details of each solution
Solution 13
Hierarchical password protection
Functions
Explanation of functions used with links to text
Solution 14
Adding a many-side record without a corresponding one side record
TOC
Links to all text files and related database files
Solution 15
Linking to a Word Document
Appendices
AO/ADO data libraries, Importing module code and accessing data using Visual Basic

Order details are:

Database Solutions

Order Code CD/SL

Site licence for installation on your Intranet: £85

Order this at the same time as Relational Database Design and Implementation (CD/DB) for a total of £130, a discount of £15 on the total price

Main Page