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 Tracking Inventory Management Customer Support Registration 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.
作者简介
John got started in computing long before many of the current employ-ees at Microsoft were starting grade school. It amazes him to think that the iaptop he carries with him when he travels has more than 30,000 times the memory, has 1,000 times the disk space, and is many times faster than the first so-called mainframe computer he used to teach him-self an obscure language called Autocoder.
目录
Part I Designing Your Application 1 Designing Your Tables 2 Creating the User Interface 3 Designing a Client/Server Application Part II Building a Membership Tracking Application 4 The Membership Tracking Application 5 Verifying Names 6 Tracking Member Activities 7 Tracking Member Status 8 Sending Out Notices Partlll Creating an lnventory Management Application 9 The Inventory Management Application 10 Ordering Items from Inventory 11 Generating Purchase Orders 12 Posting Received Items into Inventory 13 Creating Customer Invoices 14 Designing Sales and Inventory Reports Part IV Implementing a Customer SUpport Application 15 The Customer Support Application 16 Organizing Customer Information 17 Capturing Support Cases 18 Tracking Reminders 19 Reporting and Analyzing Support Cases Part V Creating a Registration Management Application 20 The Registration Management Application 21 Scheduling Courses 22 Scheduling Students 23 Printing and E-Mailing Schedules 24 Producting Student Invoices Part VI Appendixes A Recommended Reading B Sample Database Schemas C Function Reference D Uuderstanding SQL E Implementing Generic Features
