By – Curtis D. Frye
Published – 2010, Microsoft Press, O’Reilly
ISBN – 0-7356-2730-7
Pages – 288
Another of the Plain & Simple series, the introduction states just what the book is: “You want the information you need—nothing more, nothing less—and you want it now.” That is exactly what this book does is give you the quick step-by-step to complete the needed task.
The book starts with what’s new in this latest version of Access 2010. Particularly with this new office is the Ribbon, introduced in 2007, and the ability to re-use previous work to begin new projects. As they say “why recreate the wheel?”
I do like the brief history of what a database is in Chapter 3 as those who are looking to use Access and know little about computers, this can give a good base for new Access users in understanding why use a database. It then walks the user through opening a database and the user interface.
From here it is time to tighten the seat belt and get to work. Chapters 4-11 cover the aspects from base design to the front operation and data presentation. For those who are familiar with or have several years of experience with Access will find this book taking you to the next level or higher. If you are struggling with how to perform a task you simply look it up in the index, go to the page and you will have the steps to completed in just a couple of pages.
Chapter 12 takes through interacting with other programs. Whether it is through linking, inserting, importing, and/or exporting this chapter covers it for you. And unlike other books I have used, you can get the complete how-to in just a few pages. The only thing lacking in this section is interaction with a SQL Server.
For those who want to share the database but protect the work you have put in and/or who has access to the data Administration of a Database follows. Chapter 13 also covers configuring start-up options so that a Navigation form is the first thing a user will see. There is ever important Database Documenter so that if you need to refresh yourself on what you have done you can create a file(s) with the information.
Chapter 14 could have been included in Chapter 2 when covering the ribbon and new features and breaks the flow of the book.
But the final chapter brings you back and completes the book with the utilization with PivotTable. Dynamic presentation of data means timely information and for some businesses it can be the difference with closing that next deal. I think this book would be a plus for any library where a person works with large amounts of data that must be worked with and queried.