Get expert design guidance and fully functional sample databases from John L. Viescas— popular 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 five of the most common database types: Inventory Management, Membership, Customer Support/Event Tracking, Reservation Management, and Questionnaire/Statistical Analysis. For each, you’ll walk through usage scenarios, design considerations, typical problems, and multiple solutions, along with complete sample databases. You’ll 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!
Key Book Benefits:

For each of six 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 97 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.