Building Microsoft Access applications

John L. Viescas

680 pages, parution le 29/12/2004

Ajouter à une liste

Indisponible

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

Voir tout

Replier

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