Microsoft Access for Beginners
Microsoft Access for Beginners eBook now available!
You can read the entire Microsoft Access for Beginners series, completely reviewed
and updated for Access 2010, in the new Kindle edition now available from
Amazon.com!
With an entirely new sample application created specifically for this eBook and additional chapters, this new Kindle edition
is an important update to the series available only on Amazon.com.
Introduction
This series is a mid-level introduction to Microsoft Access intended for people who have never used the program before and might even be wondering what it does. My intention here is to show you the basic concepts of a relational database system as well as some of the things you can do with Access. I've tried to include enough detail so that you will understand the concepts and be able to investigate further. Other sites and books will show you all the fine details of Access. My purpose here is to show you how to use Access well.
The information here covers versions of Access through Access 2007. Check Microsoft Office Online and some of the external links shown below for more information as needed.
If you have any other questions or comments, please contact me. I also offer custom programming services with Microsoft Access and other tools and will be glad to discuss how I can help with your project.
|
|
Demonstration Files
Demo.zip ( Download ) - Access demonstration database and original Excel spreadsheet (Requires Access and Excel 2000 or later)
Chapters
Using the demo database as an example, this section provides a practical guide to building a system of tables within your database that conforms to the rules of data normalization.
After you've organized the data into a system of tables, you need to design those tables for maximum efficiency. Access table design may seem complex but this chapter breaks it down by setting and explains the concepts behind all those choices.
Part III - Writing the Queries
In this chapter, I show how to use queries to retrieve data from tables and provide a brief introduction to Structured Query Language (SQL) which Access uses to manipulate data.
Now that you have tables to store the data and queries to manipulate it, you need forms to help ensure quick and accurate data entry. In Part IV, I talk about the principles of designing a user interface and some of the creative tools you can use to design a great looking application.
Part V - Generating the Reports
A well designed system compiles and summarizes information in a way that can be easily understood. One of the strengths of Microsoft Access is its built-in reporting tool. With Access, you can design a variety of report types, including charts and graphs, as easily as you would design a form.
Read the entire Microsoft Access for Beginners series offline ...
Microsoft Access for Beginners
Expanded, updated for Office Access 2010 and available from Amazon.com.
Additional Information on Drewslair.com ...
After you're comfortable with basic Access design, you can learn how to use Visual Basic for Applications to manipulate data, forms and reports, write your own custom functions and design sophisticated applications to meet any need.
This is a full, professional application designed in Access 2007 and available as a free download here on Drewslair.com. Designed to assist individuals in organizing information related to a job search, it demonstrates how Access can be used to create a robust, easy-to-use application. Screenshots and more details are available on the download page and online manual.
Additional features that you can use to add power to your forms.
Save time and increase accuracy by using lookup fields in your tables and forms.
Keeping your data safe in Access goes far beyond setting a password. It's important to understand the capabilities ... and the limits ... of Access security.
Advice for those who want to become experts with Microsoft Access.
A companion slideshow for Part I. Explains the first three principles of database normalization while showing the practical steps for changing the original Excel file into an Access database.
A few words on Data Access Pages in Microsoft Access.
A glossary of terms used in this series.
I explain the essential elements of Structured Query Language so that you can move beyond the Access interface and have a bit more control over the elements of your database.
Understanding SQL: Modifying Data
Learn the basics of action queries with which you can update, add and delete data.

Available on
Amazon.com
On Other Sites ...
Microsoft's site for everything related to its Office suite. This site features a searchable collection of helpful articles and samples for Office 2000 through Office 2007. Resources include how-to instructions, clip art, templates and access to Microsoft Office Live, the online version of the suite.
Articles for beginners and advanced users of the Microsoft Office Access database. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities to download. All free.
This is a resource site for Access 2007 and the new features it introduces. The site offers a comparison between the newest version and the previous 2003 version.
This FAQ contains essential information for securing your Microsoft Access applications. The FAQ officially covers versions 2.0 through 2000 although the principles remain the same through version 2003.
From Wikipedia. This advanced article explains several rules of normalization, providing examples.
Introduction to Web Enterprise
John Valentino provides an overview of web technologies including databases such as Access and SQL Server. His article provides summaries of various concepts and a host of useful links to additional information.
Access SQL: Basic Concepts, Vocabulary and Syntax
From Microsoft Office Online, a series of articles on using SQL to work with data in Access.

