Building Microsoft Access Applications

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.

---

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.

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.