Access应用大全Applications

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

　　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