Buy this Book
Print Book $34.99 PDF $23.99 Read it Now!
Print Book £24.99
Add to UK Cart
Reprint Licensing
Access 2007: The Missing Manual

By Matthew MacDonald
First Edition  December 2006 
Pages: 751
Series: The Missing Manuals
ISBN 10: 0-596-52760-8 | ISBN 13: 9780596527600
starstarstarstarstar (Average of 2 Customer Reviews)

Buy 2 Get 1 Free Free ShippingGuarantee

Book description

Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.
Full Description

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.

Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

Browse within this book

Cover | Table of Contents | Colophon



Featured customer reviews

Write a Review


EBook,  March 17 2008
Submitted by Anonymous Reader   [Respond | View]

This book has been so helpful to me. As another rater stated, the grammar can get in the way sometimes, but it's easy enough to get past.

What I would like, though, I can't seem to find on the webpage. I would like the electronic version of the book. The other reference books I've paid for have included the electronic version of the book. I'm not going to pay for the book AND pay for the electronic version on top of that.

This alone makes some of the other books worth the money and they are fine if I use them as a reference, although this book is easier to use.


Champion league author,  January 28 2008
Rating: StarStarStarStarStar
Submitted by Albrik J. Wiederkehr   [Respond | View]

A great applause goes to Matthew MacDonald and the entire team, who helped develop this marvelous book. This is the first time in my forty year business career, that someone presents a manual that explains complicated processes in such an easy-to-follow way. Especially educational are the notes and tips, which provide insights into the not so obvious situations. This is invaluable to people who want to learn how to use ACCESS 2007 in an effective way.

Albrik J. Wiederkehr, Senior Business Consultant, Geneva, Switzerland



Access 2007: The Missing Manual,  March 15 2007
Rating: StarStarStarStarStar
Submitted by Frederick Eccher Jr   [Respond | View]

Title: Access 2007: The Missing Manual
First Edition: December 2006
Series: The Missing Manuals
ISBN 10: 0-596-52760-8
ISBN 13: 9780596527600
Pages: 751

This book is light reading. The style is light and easy to enjoy. The author is definitely a wordsmith and has total control over the tone of the book. Some of the chapters start with non issues to people interested in Access, but this seems to be his writing style: a neutral or buffered start so you do not bolt before you get into that chapter.

This book is heavy reading. After a few paragraphs of light introduction, each sentence is packed with actions to take, issues to ponder, tables to study, and much more. The actions to take could not be done in one night. Look forward to a week, at least.

Annoying things for me:
1. His use of 's.
Code's means "code is" and not "code's use" in the sentence [not the possessive but the contraction].

This happens all the way through the book, so heads up.

2. His use of double negatives.
I found it harder to concentrate on the meaning when there was no evidence that it was not found [see what I mean?]. "no reason you can't get a little fancier" [page 531]. Why not just say:
You could get a little fancier?
You could get a little fancier within reason?

This happens all the way through the book, so heads up.

I liked the following chapters quite a bit:
Chapter 4 blocking bad data
Chapter 15 automating tasks with macros
Chapter 16 automating tasks with visual basic
Chapter 17 writing smarter code

Part Six was the best
Chapter 18 sharing a database with multiple users
Chapter 19 importing and exporting data
Chapter 20 connecting access to sql server
Chapter 21 connecting access to SharePoint
These last two chapters were the very best in the book, depending on whether you were more interested in the sql server database or the collaborative issues surrounding SharePoint.

On page 640, one of the top reasons to switch to Sql Server: Real security

So does Access have Unreal Security? Not enough of a fine grained model? That is real reassuring…

OK, so I did read it, scrutinize it, check the fine points. When I mention that it is worth 5 stars and every penny you might have to spend to get it, that takes everything into account. The book asks questions like: Can you trust Microsoft? [Page 641], so some balanced point of view is being used by the author. Well done.

I really like Access 2007 and find it to be a quantum leap forward. Try it, you'll like it.

Frederick J Eccher Jr
MBA
M.S. Management of Information Systems
A.B. Psychology
B.A. Biology
CIO, Community Partners
President, Board of Directors, Saint Louis Visual Basic Users Group
rick@stlvbug.net

Read all reviews


Media reviews

"The Missing Manual series is simply the most intelligent and usable series of guidebooks..."
-- Kevin Kelly, co-founder of Wired

"One of the beauties of the Missing Manuals is that there is always something new to discover and the research is quite thorough...I kept finding snippets of information, in the way of Tips or Notes, that would give just that bit extra."
-- Graham K. Rogers, Bangkok Post

"There are a lot of good books, but I keep returning to the Missing Manual series because they are inexpensive, easy to read and full of cool tricks and tips."
-- Bob Brooks, The South Bay Apple Mac User Group

Read all reviews


See larger cover


"One of the beauties of the Missing Manuals is that there is always something new to discover and the research is quite thorough...I kept finding snippets of information, in the way of Tips or Notes, that would give just that bit extra."
--Graham K. Rogers, Bangkok Post