Building Microsoft Access Applications (Bpg Other) (Paperback)

~ (Author) "Even experienced Access developers occasionally commit design errors..." (more)
Key Phrases: subform window, student invoices, packing list report, True Exit, True End, Membership Tracking (more...)

Editorial Reviews

Product Description

Get expert design guidance and fully functional sample databases from John L. Viescaspopular author, consultant, and Microsoft Most Valuable Professional (MVP) for Access. Designed for everyone from Access power users to application developers to beginners, this book focuses on four of the most common database types: Inventory Management, Membership Tracking, Customer Support, and Registration Management. For each, youll walk through usage scenarios, design considerations, typical problems, and multiple solutions, along with complete sample databases. Youll examine the logic behind the table design for the application type and see how to use it as a template for quickly creating your own Access solutions. You get everything you need to design with confidence, avoid common pitfalls, and hit the ground running! For each of four common database types, explore a range of solution options from the simple to the complex. Review query, form, report, and code examples specific to each application type. Use the table designs in the sample databases to model your own solutions. The book is geared for power users who work with everything from Access 2000 to Access 2003. The CD includes eBook and complete database solutions for Microsoft Office Access 2002 and Access 2003 The author has been recognized as a Microsoft MVP for Access every year since 1993.

About the Author

John L. Viescas is the author of Microsoft Office Access 2003 Inside Out and the top-selling Running Microsoft Access books from Microsoft Press. He is president of Viescas Consulting, Inc., a respected provider of database application design and editorial consulting services. He has been recognized by Microsoft Product Support Services as a Most Valuable Professional (MVP) every year since 1993 for his contributions to the community of Access users.

Product Details

• Paperback: 720 pages
• Publisher: Microsoft Press (January 26, 2005)
• Language: English
• ISBN-10: 0735620393
• ISBN-13: 978-0735620391
• Product Dimensions: 9 x 7.2 x 1.9 inches
• Shipping Weight: 3.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.8 out of 5 stars  See all reviews (13 customer reviews)
• Amazon.com Sales Rank: #282,682 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #39 in

  Books > Computers & Internet > Microsoft > Databases

Customer Reviews

Most Helpful Customer Reviews

45 of 45 people found the following review helpful:

5.0 out of 5 stars I've learned much in the first 3 chapters, March 26, 2005

By	Allan Bach (Hellertown, PA) - See all my reviews (REAL NAME)

As a self-taught Access developer for the past eight years, I have an extensive library of books dealing with beginneing to advanced areas of Access. I bought this book to add to my library, figuring it to be another reference item. However, in a casual browsing of the content, I discovered this book has much more to offer. I was pleasantly surprised to see information on levels of magnitude for linked tables, never having known that the number of sub folders for linked tables can affect the speed of reading from them.

Each of the sample databases has more than enough explanation and code to fully understand the how and why of the application.

After reading only the first three chapters, I have learned much that I was never aware of. I thought I understood Single and Double number types, but was re-educated by the information on page 18. Pages 32 and 33 taught me some new things about the difference between format and input mask.

I am now much better at my development, and I haven't yet finished the book. Excellent work, Mr. Viescas!

20 of 20 people found the following review helpful:

5.0 out of 5 stars Very Solid, useful book for development of Access Applications., June 28, 2005

By	Clyde Hyde (NYC) - See all my reviews

Easy to read first few chapters with basic design info, remainder of the book focuses on complete applications that can serve as a template/best practice for almost any other MS Access application.

Viescas clearly understands/communicates an in depth knowledge of Access Applications that I have not seen anywhere else.

23 of 24 people found the following review helpful:

5.0 out of 5 stars Excellent Books Showing Application Development, February 8, 2005

By	John Matlock "Gunny" (Winnemucca, NV) - See all my reviews (REAL NAME)

Microsoft Access is of course a database. But it's really much more than that. With its front end forms design capability and the integral report generating system, it is well suited for quite a number of small applications. I say small, because you aren't going to use Access to handle the operations of a Fortune 500 company.

There are a lot of books that teach about the basics of Access. They however tend to talk strictly about how to do the programming portion only. They do not go into the practical aspects of database, forms, or report design.

This book takes you deeply into the design of four small and rather simple applications. This way you can see what is needed to actually make an application that is really useful. It is unlikely that you'd actually run one of these applications as is, even if they were applicable to your business, you or your boss would want something changed. But with the knowledge you would get from the rest of the book, this should be a doable task.

There is one combined plus and minus about this book. The plus, it has an excellent introduction to SQL programming, one of the best I've ever seen. The minus is that the SQL is based on the JET engine database. Access now ships with both JET and MSDE which is a much better engine. I suspect that Microsoft will make MSDE the standard engine in the future. Even with this negative, this is an excellent book.