Ships from: Philadelphia, PA
Usually ships in 1-2 business days
Ships from: Bensalem, PA
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
Ships from: Philadelphia, PA
Usually ships in 1-2 business days
Ships from: Philadelphia, PA
Usually ships in 1-2 business days
Ships from: Southampton, PA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
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:
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.
Get expert insights and examples to help you:
Note: This book covers Microsoft Office Access 2003, Access 2002, and Access 2000
CD includes database samples and a fully searchable eBook.
Use the sample databases on CD to model your own solutions for:
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
| Pt. I | Designing your application | |
| 1 | Designing your tables | 3 |
| 2 | Creating the user interface | 37 |
| 3 | Designing a client/server application | 57 |
| Pt. II | Building a membership tracking application | |
| 4 | The membership tracking application | 115 |
| 5 | Verifying names | 121 |
| 6 | Tracking member activities | 129 |
| 7 | Tracking member status | 137 |
| 8 | Sending out notices | 149 |
| Pt. III | Creating an inventory management application | |
| 9 | 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 |
| Pt. IV | Implementing a customer support application | |
| 15 | 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 |
| Pt. V | Creating a registration management application | |
| 20 | 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 |
| App. A | Recommended reading | 551 |
| App. B | Sample database schemas | 555 |
| App. C | Function reference | 581 |
| App. D | Understanding SQL | 587 |
| App. E | Implementing generic features | 633 |
Anonymous
Posted Sat Feb 20 00:00:00 EST 2010
I don't have knowledge of all the categories in the rankings since I just got this book and have not delved into a lot. Excellent resource for advanced ACCESS users. It does not have basics in it, so if that's what you need you need his earlier book.
1 out of 1 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
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: