Book Reviews

The following books are my personal recommendations for all levels of Access database users and developers.

Enjoy!

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.

Access 2013 for Dummies

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!

Access 2010 Bible (UK)

Access 2010 Bible (US)

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!

Beginning Access 2007 VBA (UK)

Beginning Access 2007 VBA (US)

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!

  • Master essential data management and design techniques
  • Import and link to data from spreadsheets, databases, text files, and other sources
  • Use action queries to quickly insert, update, or delete entire sets of data
  • Create custom forms to capture and display data
  • Design reports to calculate, summarize, and highlight critical data–and learn advanced techniques
  • Automate your application with macros and Visual Basic® for Applications (VBA)
  • Use Access Services to extend your database application to the Web

Includes CD

Microsoft Access 2010 Inside Out Book (UK)

Microsoft Access 2010 Inside Out Book (US)

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.

SQL for Microsoft Access, 2nd Edition (UK)

SQL for Microsoft Access, 2nd Edition (US)

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.

Access Solutions MVPS (UK)

Access Solutions MVPS (US)

 

 

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.