Part Ⅰ Designing Your Application 3
1 Designing Your Tables 3
2 Creating the User Interface 37
3 Designing a Client/Server Application 57
Part Ⅱ Building a Membership Tracking Application4 The Membership Tracking Application 115
5 Verifying Names 121
6 Tracking Member Activities 129
7 Tracking Member Status 137
8 Sending Out Notices 149
Part Ⅲ Creating an Inventory Management Application9 The Inventory Management Application 173
10 Ordering Items from Inventory 183
11 Generating Purchase Orders 215
12 Posting Received Items into Inventory 241
13 Creating Customer Invoices 281
14 Designing Sales and Inventory Reports 297
Part Ⅳ Implementing a Customer Support Application15 The Customer Support Application 319
16 Organizing Customer Information 327
17 Capturing Support Cases 349
18 Tracking Reminders 373
19 Reporting and Analyzing Support Cases 391
Part Ⅴ Creating a Registration Management Application20 The Registration Management Application 413
21 Scheduling Courses 423
22 Scheduling Students 465
23 Printing and E-Mailing Schedules 501
24 Producing Student Invoices 529
Part Ⅵ Appendixes 551
A Recommended Reading 551
B Sample Database Schemas 555
C Function Reference 581
D Understanding SQL 587
E Implementing Generic Features 633