TY - BOOK AU - Rendell,Ian AU - Mott,Julian AU - Rendell,Ian TI - Advanced database projects in Access SN - 9780340929254 (pbk.) U1 - 005.74 REN PY - 2008/// CY - London PB - Hodder Murray KW - Microsoft Access KW - Problems, exercises, etc KW - Database management N1 - Previous ed.: published as Database projects in Access. London: Hodder & Stoughton, 2003; Part One. The development of a system -- 1. the pass-it driving school -- 2. Getting started -- 3. Setting up tables -- 4. Entering the data -- 5. Defining the relationships -- 6. Select queries -- 7. Further queries -- 8. Setting up multi-table queries -- 9. Setting up forms using the Form Wizard -- 10. Working in form design view -- 11. Taking form design further -- 12. Setting up forms -- 13. Further reports -- 14. Macros -- 15. Adding a switchboard -- 16. Ising subforms -- 17. Setting up search and sort options -- 18. Calculations in reports -- 19. Using action queries -- 20. Finishing touches --- Part Two. Access tricks and tips -- 1. Tables -- 2. Queries -- 3. Forms -- 4. Reports -- 5. Macros -- 6. Others --- Part Three. Starting points --- Part Four. Project ideas --- Part Five. Project documentation --- Part Six. Finding project ideas N2 - "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 ER -