×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Building Microsoft Access Applications
     

Building Microsoft Access Applications

4.0 1
by John Viescas
 

Get fully functional database samples and table designs for four of the most common Microsoft Access database types—and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types:

  • Membership

Overview

Get fully functional database samples and table designs for four of the most common Microsoft Access database types—and use them as templates to create your own Access solutions. Database expert and Microsoft MVP John L. Viescas provides the detailed guidance you need to customize your own solutions from these application types:

  • Membership Tracking
  • Inventory Management
  • Customer Support
  • Reservations Management

For each type, you’ll walk through typical usage scenarios, design considerations, and common pitfalls. You’ll examine the logic behind each application’s table design, and learn how to adapt it for your own Access solution.

Get expert insights and examples to help you:

  • Learn specific design techniques to improve your table structures
  • Build forms with an attractive, intuitive, and easy-to-use interface
  • Create queries, forms, and reports specific to each application type
  • Design for client/server from the start-and share data more efficiently

  • Apply best practices to help your application run more smoothly
  • Avoid the 10 most common design problems—and deliver more robust solutions!

Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000

CD includes database samples and a fully searchable eBook.

Use the sample databases on CD to model your own solutions for:

  • Membership Tracking: Enter, track, and manage member information and communications.
  • Inventory Management: Track and manage stock and create purchase orders, invoices, and packing lists.
  • Customer Support: Track contacts, enter customer details, identify follow-up items, and create reminders.
  • Reservations Management: Manage course registrations, car rentals, room reservations, and more.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Product Details

ISBN-13:
9780735620391
Publisher:
Microsoft Press
Publication date:
02/16/2005
Edition description:
REV
Pages:
720
Product dimensions:
7.34(w) x 9.14(h) x 1.87(d)

Meet the Author

John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications, and Microsoft Office Access 2007 Inside Out. John has been recognized as a Microsoft MVP since 1993.

Home Page: Viescas Consulting, Inc.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

Building Microsoft Access Applications 4 out of 5 based on 0 ratings. 1 reviews.
Anonymous More than 1 year ago
I don't have knowledge of all the categories in the rankings since I just got this book and have not delved into a lot. Excellent resource for advanced ACCESS users. It does not have basics in it, so if that's what you need you need his earlier book.