The following books are my personal recommendations for all levels of Access database users and developers.
This is a great book for beginners. It takes you through from the very beginning without too much jargon ‘computer’ talk and adds a little humour to your learning.
This is one of my favourites and is a starter recommendation for my students.
Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you’ll appreciate the thorough attention to database fundamentals and terminology. If you’re familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.
You’ll want to keep this soup-to-nuts Access reference close at hand!
This book provides you with the tools and techniques you’ll need in order to build more sophisticated solutions. After walking through the features of Access 2007 VBA, you’ll learn all about object–oriented programming and ADO. You’ll then progress to advanced VBA concepts such as working with external DLLs and using automation to control external programs. Plus, two comprehensive case studies presents you with the hands–on experience in building real–world solutions using the concepts covered in the book.
It’s the one I use as a reference for VBA students!
You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access 2010 — and challenge yourself to new levels of mastery!
SQL for Microsoft Access, Second Edition provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code.
This has greatly helped me to handle the more complex and challenging SQL statements that Microsoft’s Access standard QBE grid cannot provide including Union queries, nesting SQL with SQL functions and handling data transfer/definitions. A complete reference tool for your library.
Two Microsoft Access MVPs show how you can become an Access power user Microsoft Access is the world’s leading database system, with millions of users and hundreds of thousands of developers. The best practices, tips, and techniques in this book can turn users into power users. Millions of eager users make Access the most popular database system in the world These Microsoft MVPs exploit key features in Access, providing advice on techniques for capturing, sharing and reporting Access data. Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web site Access 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.
Some really useful Tips & Tricks with excample code that can be downloaded too.