Access 2002: The Complete Reference (Book/CD-ROM) (Paperback)

~ Virginia Andersen (Author), Virginia Andersen (Author) "In this, the Information Age, we're all surrounded by mountains of data..." (more)
Key Phrases: unbound text box control, two calculated fields, current workorders, Visual Basic, Home Tech Repair, Design Master (more...)

Editorial Reviews

Product Description

Master all the powerful features of Access 2002. This complete reference explains in full detail how to design and use Access tables, queries, forms, and reports and maximize all the program's capabilities. Chapters on VBA techniques pave your way to Access programming, and a special section on using Access on the Internet is also included. The CD-ROM contains database files from the book's examples so you can recreate the sample projects. You'll also get Test Yourself software to help you prepare for the MOUS Certification Exams for Access 2002.

From the Back Cover

The Most Authoritative Guide to the #1 Database Program

Build a highly responsive Access database, and turn information into a powerful tool. Access 2002: The Complete Reference contains everything you need to gather, organize, and analyze data more effectively than ever. Construct a comprehensive information management solution, then raise productivity and decision efficiency based on analysis of data trends and relationships. Learn to streamline your work with wizards, queries, and sorting and filtering methods. Enable secure online use, multiple party access, and remote data management. Plus--get a hit-the-ground-running introduction to Visual Basic and learn to integrate Access data with outside sources.

• Track and plan for, new trends by using this powerful relational database program
• Work concurrently on databases with multiple users--on site or remotely
• Collaborate over an intranet or the Internet with dynamic or static data
• Integrate Access with other components of the Microsoft Office XP suite
• Create advanced queries to extract and manipulate specific information
• Learn multiple task pathways for accomplishing simple to complex Access functions
• Utilize flexible functionality--including sorting, filtering, writing macros, and more
• Create and customize all manner of data interpretation and presentation grids
• Locate and retrieve stored information quickly from existing databases

See all Editorial Reviews

Product Details

• Paperback: 1220 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (April 19, 2001)
• Language: English
• ISBN-10: 0072132418
• ISBN-13: 978-0072132410
• Product Dimensions: 9 x 7.4 x 2.6 inches
• Shipping Weight: 4.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars  See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #209,955 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

23 of 23 people found the following review helpful:

5.0 out of 5 stars An Excellent Reference, January 2, 2003

By	David Stapleton (California) - See all my reviews (REAL NAME)    (VINE VOICE)

Amazon Verified Purchase

I needed a reference for work, one that was easy enough for a my co-worker, a non-programmer, to use and yet detailed enough to be useful for me. I browsed through most of the current versions of Access references, checking the details, coverage and examples for something that might meet my requirements. While it is impossible for any book to be everything to everyone, this one comes very close to meeting my needs with regard to Access.

Note, this is not a manual for learning SQL, or VBA. Both essential if you want to really step beyond the basic elements of Access usage. However, this book addresses the essential usage elements of working with Access - tables, queries, forms and reports - as well as several less `basic' elements like security, environment customization, and multi-user environments. The material is extensive, the examples are well explained, and the topics are well organized. If I were to teach a class on Access, I'd use this as the text.

I have not been disappointed with this book. P-)

15 of 15 people found the following review helpful:

5.0 out of 5 stars Good entry level book, January 3, 2003

By	"fred_demers" (Ottawa ON) - See all my reviews

This book is a very good reference manual.
It has detailed information on every major aspect of Access.

The VBA programming and the queries are treated fairly lightly, so if you plan on doing advanced queries or use SQL a lot, you should augment your purchase with another book. The same applies for VBA programming.

I found that there are sometimes too many repetitions of very basic UI operations, which make the book unnecessarily big.

Overall, it is a good book to get started, then you should acquire specific books in areas you need further information. It is not a "complete" reference, as the title suggests.

11 of 11 people found the following review helpful:

5.0 out of 5 stars Thorough and Easy to Use, July 24, 2002

By	Z. Becker (Houston, TX United States) - See all my reviews (REAL NAME)

This book is an excellent reference for not only Access 2002 but 2000 as well. The author does a fine job of introducing basic concepts in the early chapters and building on that knowledge toward more complex procedures. The ideal reader for this reference will probably be someone with a mid to advanced beginner understanding of Access all the way through the intermediate to advanced range. The pages are chock full of graphics (screenshots) as well as some step-by-step hands on examples. The text was clear; table of contents and index are well organized.