Print this page Print this page

Microsoft ACCESS Database Basics

John Andrew, P.E.

Course Outline

This one (1.0 PDH) Professional Development Hour course describes basic elements in Microsoft’s, “Access” database creating software with many illustrations.

Engineering records of many types are kept for decades and should be readily retrievable for: engineering, legal, and tax purposes. Engineering organizations keep a list of drawings and revisions of drawings for all projects. The purchasing department keeps records of all equipment to be purchased for each client and track the delivery dates. All stages of manufacturing operations are planned and controlled to meet delivery requirements including records of all products: serial numbers, bills of materials, quality control data, and delivery dates.

A database is a computerized system for collecting, modifying, and accessing small and large lists of similar data. A list of factory equipment: generic names, descriptions, manufacturers, addresses, phone numbers, and prices are another example of a database.

1. Creating a Database
2. Editing a Database
3. Importing Data From Excel
4. Query a Database
5. Database Forms
6. Summary Reports
7. Backing Up a Database

The course includes a multiple-choice quiz at the end, which is designed to enhance the understanding of the course materials.

Learning Objective

At the conclusion of this course the student will:

Intended Audience

The information will be especially useful to: students, entrepreneurs, engineers, architects, and innovators who want to create and use the power of a database.

Benefit to Attendees

Attendee of this course will know how to create and search Access database records.

Course Introduction

This course adheres to recommendations Microsoft in the use of Access databases.

Course Content

The course content is in a PDF file (700 KB):

Microsoft ACCESS Database Basics

Please click on the above underlined hypertext to view, download or print the document for your study. Because of the large file size, we recommend that you first save the file to your computer by right clicking the mouse and choosing "Save Target As ...", and then open the file in Adobe Acrobat Reader. If you still experience any difficulty in downloading or opening this file, you may need to close some applications or reboot your computer to free up some memory.

Course Summary

A brief and to the point well illustrated summary is provided in these “Access” database lesson notes.

Related Links

Microsoft home page information about, “Access”:

The United States Patent and Trademark Office patent database at Provides links to information about all aspects pertaining to invention patents.


Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.

Take a Quiz

DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.