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

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