Microsoft ACCESS Database Basics
John Andrew, P.E.
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.
At the conclusion of this course the student will:
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.
This course adheres to recommendations Microsoft in the use of Access databases.
The course content is in a PDF file (700 KB):
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.
A brief and to the point well illustrated summary is provided in these “Access” database lesson notes.
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.