Building Microsoft Access Applications - Softcover

Viescas, John L.

Softcover

ISBN 10: 0735620393 ISBN 13: 9780735620391

Publisher: Microsoft Press, 2005

Synopsis

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.

About this title

About 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.

From the Back Cover

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 Description: 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!

Edition details

• Publisher: Microsoft Press
• Publication date: 2005
• Language: English
• ISBN 10: 0735620393
• ISBN 13: 9780735620391
• Binding: Paperback
• Edition number: 1
• Number of pages: 720