GCE A-Level and AVCE Teaching Resource
McWeeney
Publications
GCE A-Level and AVCE Teaching Resource
Further Details
This photocopyable
book, complete with Teacher's answers and a number of files for
student use. is supplied with a site licence on CD for an inclusive
cost of £60.00. Three versions are included on the CD, one for Access XP/2003, one
for Access2000 and one for Access 97.
The main text consists of a 156 page book that provides students with the necessary knowledge and skills for advanced database work.
The chapters on database theory provide students with the understanding needed for good database design. They include detailed questions covering entity analysis and normalisation and complete answers are provided in a separate teacher's answer booklet.
The practical work provides students with the advanced techniques necessary for project work.
The book is supplied as a photocopy master in Microsoft Word format. It is accompanied by an additional 30 files supporting the text.
| Chapter 1 | Flat file/Relational Database models | Chapter 8 | Implementing Relationships, Cascade Update/Delete |
| Chapter 2 | Entities, attributes and relationships | Chapter 9 | User Interface, Forms and Controls |
| Chapter 3 | Design, Data Modeling, dealing with many-to-many relationships | Chapter 10 | Forms and Visual Basic for Applications. Methods, Events, Error Handling |
| Chapter 4 | Entities and Tables, Atomic Data, First Normal Form | Chapter 11 | Select, Crosstab and Action Queries. Join Types. Linking Action Queries to buttons |
| Chapter 5 | Second Normal Form, Functional and Partial Dependency, Foreign Keys | Chapter 12 | Reports, Aggregate and other functions. Interactive and cross tab reports |
| Chapter 6 | Third Normal Form | Chapter 13 | Modules and Visual Basic. Procedure Arguments, Accessing records from Visual Basic |
| Chapter 7 | Table Design and Implementation, Validation Rules | Chapter 14 | Auto starting, Menu driven interface. Hiding the database from the end user. |
Your licence allows unlimited photocopying/printing within one educational establishment.You are also entitled to edit the materials to produce customised version of the book but you should not distribute the CD to students. You can even sell the printed copies to students if you wish.
I am confident that you will find the materials useful so I am happy to provide them on an inspection copy basis to a school or college address. Please e-mail requests for inspection copies, stating that this is what you require. Even firm orders may be returned within 14 days for a full refund if you decide the materials do not meet your requirements.
Please use the order code to avoid confusion.
The details are:
153 pages plus 30 supporting files. Cost £60.00 inclusive
Order this at the same time as Database Solutions (CD/SL) for a total of £130, a discount of £15 on the total price