Advanced Database Projects in Access 2007 is designed to support your learning of the GCE Applied AS and A level ICT database units and the project coursework requirements of AS and A levels in ICT and computing. It also covers the database units of the IT specialised Diploma ensuring you have everything you need to produce a high-quality project. 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 (R) Access TM is necessary. Microsoft (R) Access TM is a popular choice of relational database software, allowing students to develop and customise systems for a real user. This book covers everything a student needs to know to produce a high quality project, including: - Key features of the software to include tables, forms, queries and reports; - The development of a fully customised solution, including features such as subforms, macros, action queries and fully customised reports; - Starting points and scenarios to aid project development; - Guidance on how a project should be documented. The book also includes many valuable tricks and tips, making the use of Access TM easier and fun.