Résumé
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
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.
- Learn specific design techniques to improve your table structures
- Build forms with an attractive, intuitive, and easy-to-use interface
- Create queries, forms, and reports specific to each application type
- Design for client/server from the start-and share data more efficiently
- Apply best practices to help your application run more smoothly
- Avoid the 10 most common design problems-and deliver more robust solutions!
Covers Microsoft Office Access 2003, Access 2002, and Access 2000
Use the sample databases on CD to model your own solutions:
- Membership Tracking
Enter, track, and manage member information and communications. - Inventory Management
Track and manage stock, and create purchase orders, invoices, and packing lists. - Customer Support
Track contacts, enter customer details, identify follow-up items, and create reminders. - Registration Management
Manage course registrations, car rentals, room reservations, and more.
The CD also includes a fully searchable eBook.
For system requirements, please see "About the CD" section.
L'auteur - John L. Viescas
John L. Viescas is President of Viescas Consulting,
Inc., a respected provider of database consulting services.
He is also the author of the best-selling Running Microsoft
Access 2000 and Programmer's Quick Reference Guide to
SQL.
Sommaire
- Designing Your Application
- Designing Your Tables
- Creating the User Interface
- Designing a Client/Server Application
- Building a Membership Tracking Application
- The Membership Tracking Application
- Verifying Names
- Tracking Member Activities
- Tracking Member Status
- Sending Out Notices
- Creating an Inventory Management Application
- The Inventory Management Application
- Ordering Items from Inventory
- Generating Purchase Orders
- Posting Received Items into Inventory
- Creating Customer Invoices
- Designing Sales and Inventory Reports
- Implementing a Customer Support Application
- The Customer Support Application
- Organizing Customer Information
- Capturing Support Cases
- Tracking Reminders
- Reporting and Analyzing Support Cases
- Creating a Registration Management Application
- The Registration Management Application
- Scheduling Courses
- Scheduling Students
- Printing and E-Mailing Schedules
- Producing Student Invoices
- Appendixes
- Recommended Reading
- Sample Database Schemas
- Function Reference
- Understanding SQL
- Implementing Generic Features
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Microsoft Press |
Auteur(s) | John L. Viescas |
Parution | 29/12/2004 |
Nb. de pages | 680 |
Format | 18,5 x 22,5 |
Couverture | Broché |
Poids | 1390g |
Intérieur | Noir et Blanc |
EAN13 | 9780735620391 |
ISBN13 | 978-0-7356-2039-1 |
Avantages Eyrolles.com
Nos clients ont également acheté
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse