Microsoft ACCESS应用大全 英文PDF电子书下载

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