By Matthew MacDonald
First Edition
December 2006
Pages: 751
Series: The Missing Manuals
ISBN 10: 0-596-52760-8 |
ISBN 13: 9780596527600
(Average of 2 Customer Reviews)
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
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.
Register your book | Submit Errata | Missing CD-ROM
Browse within this book
Cover | Table of Contents | Colophon
No time right now?
Email these links
Customers interested in this book may also be interested in:
Book:Word 2007: The Missing Manual Read more |
Book:PowerPoint 2007 for Starters: The Missing Manual Read more |
Book:Access 2007 for Starters: The Missing Manual Read more |
Book details
First Edition: December 2006
Series:
The Missing Manuals
ISBN: 0-596-52760-8
Pages: 751
Average Customer Reviews: (Based on 2 Reviews)
Featured customer reviews
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
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
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
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
"I found this manual to be head and shoulders above all of the cheap "shovelware" books on such subjects that often have all the information you need, but are disorganized. I haven't seen any of the new versions of the "Que" books that always come out on Access, but I haven't been that satisfied with them in the past. I recommend this book for anybody planning on using Access 2007. "
-- Amazon reviewer, Amazon
"The ideal audience for this book seems to be those in small to mid-range businesses who will use Access for database services (the enterprise is more likely to use SQL). In that event, MacDonald has written an excellent manual for these people and organizations. He takes the reader from the creation of simple forms through automating tasks with macros and Visual Basic. He also covers connecting Access to SQL and SharePoint."
-- James Pyles, MCSE World
"...since the Office 2007 applications will not come with a handy user guide, which is the norm these days, and because of the major overhaul of the applications, users may find themselves reaching out to third-party guides to Office 2007. To the rescue comes these superb O'Reilly Missing Manual guides to Office 2007, that may be used even more than usual because of the drastic changes in Office 2007. These latest titles in this marvelous series of "Missing Manual" guides will surely get the attention of potential buyers who have taken the plunge into the new Office 2007 and find themselves a bit bewildered by its completely new look and organization."
-- Dale Farris, Reviews Coordinator, Golden Triangle PC Club
"Mixing a great combination of humor and good, common sense, they ease you into using these programs and placate the fear we all experience when faced with a new interface or operating system we don't understand.
"
-- Mike Berman, Scripps Howard News Service, SacBee.com
"With so many various guidebooks on the market promising to help you find your way around Access 2007, coupled with the fact that the last thing you have is time to be wasting, Matthew MacDonald makes the decision easy with this surprisingly logical yet entertaining book. Similar to the other Missing Manual books in the way that they are aimed towards a variety of audiences, rest assured that both the student and professional will be able to gain further insight into Access. As Microsoft Office 2007 programs are designed to run on both Microsoft Windows (XP Service Pack 2 or later) and Windows Vista, these new resources are there to answer your every question."
-- Alain B. Renaud, TCM Reviews
"I have never seen a manual for any program, hardware or OS which is anywhere close to this series in its helpfulness to the reader. Anyone other than the well trained techs can find this book valuable."
-- Ray Bowler, Vice President, Des Moines Macintosh User's Group
"Four new "Missing Manual" books honed for 2007 are picks any program owner should have...These books should not only have been "in the box" with the software--they shouldn't be omitted from any library strong in computer references."
-- James A. Cox, The Computer Shelf
"At the onset I must tell one and all that Access 2007: The Missing Manual, is the latest and greatest incarnation of Microsoft’s bestselling database software. It has a new and improved database engine which allowed the creators of the application to add new features and fine tune the performance. It is simply more intuitive, albeit more complex...As with all other Microsoft Office products, Access 2007: The Missing Manual should have been in the box with the application. Help is always on the ribbon. However, you can find your answers to questions easier if you use the Mr. MacDonald’s book Access 2007: The Missing Manual."
-- Esther Schare, Director, Broward Personal Computer Association, Inc.
"I have reviewed quite a number of Missing Manual books and I am always impressed with them. David Pogue is a Mac master and the depth of his knowledge shines through."
-- Roger Bernau, ACT Apple User Group Incorporated
