View Andrew Comeau's profile on LinkedIn


Microsoft Certified Professional

 

 

 

 

Articles and Reviews

Microsoft Access

Microsoft Access for Beginners  - Revised - February 2008
A series of articles for people new to Microsoft Access. This series explains the differences between Access and Excel and the principles involved in creating a well-designed database application.

Introduction
Part I:  Organizing the Data
Part II:  Building the Tables
Part III:  Writing the Queries
Part IV:  Designing the Forms
Part V:  Generating the Reports

Additional Information

Information Security in Microsoft Access
Securing your data is about more than setting a few options.  Here are some of the best practices to follow when keeping your data in Microsoft Access.

Using Lookup Fields
Ensuring fast and accurate data entry by configuring fields to retrieve data values from the database.

Becoming an Expert
While Access is a great tool, it's only the beginning if you're truly interested in a programming career.  Here are some more areas to study to truly become proficient.

Database Normalization - The Slideshow
This slideshow illustrates the concepts of data normalization from Part I.

Microsoft Access Advanced Form Design
More techniques that you can use to enhance your user interface.

Glossary
A glossary of terms used throughout the series.


Advanced Access

No More Repeats!
How to find and remove duplicate records from your table.

Shut it Down!
How do you get all those remote users out of the system when you want to perform maintenance?

Signs of Digital Life
When is a simple progress meter more than what it seems?

Software Reviews

Microsoft Virtual PC
A review of Microsoft's virtualization software for the PC.


 

 

 

 

 

  

© 2009, Andrew Comeau, except where otherwise noted. Material contained on this website should not be republished without permission from the author. Questions?  Comments?  You can e-mail me at this address.

Microsoft is a registered trademark of Microsoft Corporation in the United States and other countries.