Develop flexible databases that can evolve with changing business requirements.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 TrackingInventory ManagementCustomer SupportReservations ManagementFor 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 structuresBuild forms with an attractive, intuitive, and easy-to-use interfaceCreate queries, forms, and reports specific to each application typeDesign for client/server from the start?and share data more efficientlyApply best practices to help your application run more smoothlyAvoid the 10 most common design problems and deliver more robust solutions!Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000CD 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.
Kitap Yorumları - (0 Yorum)