Expert one-on-one Microsoft Access application development

Helen Feddema - Collection Programmer to Programmer

594 pages, parution le 03/06/2004

Ajouter à une liste

Indisponible

Résumé

If you are developing databases for your own use, the process need not be complicated. But when you build databases for clients, many of whom may not be familiar with Access or comfortable with databases in general, you have a lot more work to do. I hope this book will make that process easier.

In these pages, I will teach you how to set up tables and relationships to ensure that the database is properly normalized. Then I'll help you write VBA code to create the connective tissue that turns a bunch of tables, queries, forms, and reports into a complete and coherent application. We'll pay special attention to the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications.

Over years of working with Access, I've created some add-ins to save time when developing applications. I'll show you how to use them to create a main menu for an application, automatically apply a naming convention to database objects, and ensure a consistent and professional appearance of the application's forms.

This book helps you write VBA code that unites database components into an application that works.

Sommaire

Creating an Access Application
- Creating a Database for an Application
- Using Forms to Work with Data
- Selecting the Right Controls for Forms
- Sorting and Filtering Data with Queries
- Using PivotTables and PivotCharts to Interact with Data
- Printing Data with Reports
- Writing VBA Code in Modules
Modifying, Updating, and Maintaining Access Applications
- Managing the Application Life Cycle
- Reworking an Existing Application
- Moving Old Data into a New Database
Working with Other Office Components (and More)
- Working with Word
- Working with Outlook
- Working with Excel
- Working Outside of Office

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Helen Feddema
Collection	Programmer to Programmer
Parution	03/06/2004
Nb. de pages	594
Format	19 x 23
Couverture	Broché
Poids	900g
Intérieur	Noir et Blanc
EAN13	9780764559044