Advanced database projects in Access 2007 [printed text] / Ian Rendell, Author ; Julian Mott, Author  . -  1st Edition Reprint . - [S.l.] : Hodder Education, 2010 . - 308 p. : ill (col) ; 25 cm.
ISBN : 978-1-4441-1737-0

Class number:	005.74
Abstract:	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. Microsoft 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.
Contents note:	Part One The Development of a system 1. The Pass IT Driving School; 2. Getting started; 3. Setting up the 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; 10. Working in Form Design View; 11. Taking form design further; 12. Setting up reports; 13. Further reports; 14. Macros; 15. Adding a switchboard; 16. Giving forms a new look with Access 2007; 17. Using SubForms; 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 1. Bouncy Castle Hire; 2. Cricket Bat Orders; 3. The Stationery Store Part Four Project Ideas 1. Abbey Window Cleaning Services; 2. Albion Away Travel; 3. Bouncy Castle Hire; 4. Cake Making; 5. Charity Xmas Cards; 6. Conferences @ The Bird in the Hand Hotel; 7. Cricket Bat Orders; 8. The Derwentdale Fun Run; 9. Hair on the Move; 10. Hotel Room Booking @ The Broadway Hotel; 11. Peak Cycle Hire; 12. School Stationery Orders; 13. Village Hall Auctions; 14. Westford Community Bus; 15. Westford Toy Library Online REsources: Part Five Project Documentation; Part Six Finding Project Ideas.