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:
- create with an easy to use, Wizard” a Microsoft, “Access” database with fields and records;
- edit a database table inserting new fields;
- import an Excel table into an Access database;
- ask questions about a database with an Access, “Query”;
- create easy to read Access, “Forms” that describe each item in a database;
- create database summary, “Reports”; and
- back-up a database to prevent loss of data.
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”: www.microsoft.com.
The United States Patent and Trademark Office patent database at www.uspto.gov Provides links to information about all aspects pertaining to invention patents.
Quiz
Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.
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.
