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.
