Advanced database projects in Access
By: by Ian Rendell, Julian Mott
Contributors: Mott, Julian
Edition: 3rd ed.
Publisher: Hodder Murray
Published: 2008
Place of publication: London
Language: eng
Number of pages: 276
ISBN-13: 9780340929254
Subjects: Problems, exercises; Database management; Microsoft Access
Description: "This book is aimed at a number of Advanced courses of study within the National Qualifications Framework currently available in schools and colleges, supported by AQA, OCR, Edexcel and WJEC. Advanced Database Projects in Access TM has been comprehensively revised and extended to cover the requirements of all GCE Applied A and AS Level ICT database units, in addition to the coursework requirements of A and AS Levels in both ICT and Computing, and the database requirements of the IT Specialised Diploma. The materials and approach used in the book should also be applicable to students on many courses in further and higher education where a study of databases through Microsoft Access TM is necessary."--Book cover.
Notes: Previous edition: published as Database projects in Access. London: Hodder & Stoughton, 2003.
Table of contents: title: Part One. The development of a system; title: 1. the pass-it driving school; title: 2. Getting started; title: 3. Setting up tables; title: 4. Entering the data; title: 5. Defining the relationships; title: 6. Select queries; title: 7. Further queries; title: 8. Setting up multi-table queries; title: 9. Setting up forms using the Form Wizard; title: 10. Working in form design view; title: 11. Taking form design further; title: 12. Setting up forms; title: 13. Further reports; title: 14. Macros; title: 15. Adding a switchboard; title: 16. Ising subforms; title: 17. Setting up search and sort options; title: 18. Calculations in reports; title: 19. Using action queries; title: 20. Finishing touches; title: - Part Two. Access tricks and tips; title: 1. Tables; title: 2. Queries; title: 3. Forms; title: 4. Reports; title: 5. Macros; title: 6. Others; title: - Part Three. Starting points; title: - Part Four. Project ideas; title: - Part Five. Project documentation; title: - Part Six. Finding project ideas.