List Price: $34.99 Our Price: $20.00 You Save: $14.99 (43%)

Product 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.

Customer Reviews:

• Incredible Investment
  I have been studying this book for a little over 2 weeks now and I will say that this book is an invaluable resource for the work I am doing right now. Some of the database concepts it explains are fairly abstract and it helps to have prior experience with them to have a full understanding but this book does do a tremendous job of making it as easy to understand as possible despite the complexity. Absolutely recommend this book, it is a great value for the price paid....more info
• Access 2007 for dummies like me
  I know little about Access 2007 but within a couple three hours I had put together an extremly complex data base that was easy to use and fully functional. I highly recommend this book to all Access 2007 users....more info
• Access 2007 The Missing Manual
  This is one of the best technical manuals I have read. Everything is easy to find and easy to understand. I have several manuals where you spend hours trying to find the answer to a question only to be frustrated in either not finding the answer or the answer being so vague that it makes no sense. This book does not do that; answers are both understandable AND quick to find. I highly recommend this book.
  
  Access 2007: The Missing Manual...more info
• Access 2007
  A great reference. Difficult to find good instruction for Access. This is a good desk reference to have for anyone new to Access....more info
• Wonderful Book, Even Better Humor
  This book was simply amazing...Matthew MacDonald...what can I say about him? Well, for starters, he is amazing, he is actually the single greatest book writer of his generation...I have come to learn so much from him and his method of teaching. It isn't dry or boring, it's a book I could read before going to bed and actually enjoy...You know what, I'm going to tell you what...you buy this book and it does not meet, nay, exceed every one of your wildest expectations, well then you can hold me, Michael GARY Scott, personally and financially responsible. You rock Matt, keep these books coming!
  
  =]...more info
• Easy to Understand
  I had originally purchased the Special Edition of Using Microsoft Office Access 2007 because the updated version of Access was significantly different than 2003. Might just as well being reading a foreign language upside down. Although I am not a novice user of MS Office applications, I found this book to be written for regular people including beginners, not technicians. It was easy to find answers to my questions and guidance for operations I was not sure of. I am constructing a new database and I would definitely recommend this series of manuals....more info
• Learn Access 2007 From Head To Toe!!
  'Access 2007: The Missing Manual' by Matthew MacDonald is another gem in the line of Missing Manual books. Filled with 700+ pages of material, if you are new to Access or even a seasoned pro, there is a little bit of something for everybody in this book. A fantastic layout, wonderful content, and one of the most user-friendly books out there, if you use Access for any length of time and want to become a better user or are a new user and want to discover how to use Access, this is the ONLY book for you.
  
  An absolute marvel which richly deserves the title 'Missing Manual' as this keeps up with the past quality works expected from this line.
  
  ***** HIGHLY RECOMMENDED...more info
• Summary Review of Access 2007 Books
  This is the summary review of four Access 2007 books:
  "Special Edition: Using Access 2007" (Special)
  "Access 2007 Bible" (Bible)
  "The missing Manual of Access 2007" (Manual)
  "Access 2007 for dummies" (Dummies)
  
  In sum, the special edition is the best. Buy the special edition. Even you are a fresh beginner on Access.
  
  (My story? Well, I read the dummies first. Then looked at Manual, doesn't like it. So I got the bible. Still unsatisfied. Finally, I got the special edition.)I know some basics on Access 2003 and only use Access when Excel is not enough to handle my data. I started with "Access 2007 for dummies" and finished it in a couple of hours. Then I turned to "Access 2007 Bible" and "The missing Manual", the manual is the worst one and the bible just provides basics, well, maybe a bit more than, that the dummies book already covers.
  
  The special edition provides more examples and detailed explanation on: Query, Forms, Reports, Pivot table.Not sure about the VBA part.
  
  I also like very much the reader-friendly layout and enjoy its "what is in real world" sections at the end of several chapters.
  
  This book also provides a good summary of basic database concepts like normalized, the importance of index, joints. The summary is very helpful especially you are a beginner.
  
  The cover of the special edition claims that the special edition is the only Access book you need. Well, maybe not the only one, but if you have the special edition, you definitely don't need the Access 2007 Bible, The missing manual and the dummies book.
  
  ...more info
• Very useful book
  This is a very useful book for anybody who wants to learn Access 2007. Access 2007 is a bit different from previous version of Access and I was very happy to have this book. Great layout, simple language, easy explanations. You can use it as a reference book as well as a manual.
  The price is great, too....more info
• Easy to understand
  This book was a huge help in introducing a newbie to Access 2007. I learned a lot from this book. Prior to purchasing this, I tried several Access guide books from the library, and they all confused me. This book is great because it is easy to understand even when he starts going into more complex aspects of Access 2007. Great desk reference....Highly recommended for those new to Access! ...more info
• Very useful
  I read several Access books. I believe this is one of the best. I learned many tricks. ...more info
• Easy to understand and written in an interesting manner.
  I have a number of years of programming and system experience, but had not been exposed to Access. I decided to rewrite my business systems using Access to convert them from the Paradox system that I had used for years. Using this book and Microsoft Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out), I have already rewritten more than half of my systems in a couple of weeks, working on them for a couple of hours each evening. Granted, I am still not an expert, but I have been able to write Virtual Basic macros, designed and completed a number of tables for my data base, forms using multiple subforms, selection boxes, and functional buttons, and a number of professional looking reports. The use of these two books has greatly shortened my learning curve and helped me to be productive in much less time than it would have taken without them.
  ...more info
• Good resource book
  This is a great book, much better than almost all of the other reference books out there. I like the relaxed yet concise and accurate Missing Manual approach though in places it may not be as "funny" as the author's had hoped. That aside, this is a super guide for all of us self taught Access lovers....more info
• Great Information
  After reading this book cover to cover, I was able to put together my first database and understand alot more of Access. I have had a difficult time grasping this software and have read 3 other books before this one. The Missing Manual was filled with great information and was easy to read....more info
• Good project book
  This book has been invaluable in the completion of organizational and personal projects with Access 2007. Explanations are easily located for reference during actual programming. Examples and exercises are good learning tools. Use of "'s" contraction gets a little monotonous. Although usable as is, discussing Forms either right after Tables or right after Queries might have been more efficient for someone starting a project....more info