UMSL logo

Computer Education & Training Center

Access Database

Access Classes

Explore the Access database and develop your skills for managing information by taking a hands-on course at the Computer Education & Training Center at UMSL.

Our Access classes are now available online with an instructor present for the entire course. You will see the instructor's screen throughout the class and you can share your screen if you need individual help from the instructor. You will have time to practice, ask questions, and receive hands-on training. If you don't have Access installed on your machine, you can remote into one of our computers. For more information, email info@cetc.umsl.edu.

Introduction to Access

(Prerequisite: Experience with Windows.) Learn to use the Microsoft Access database system to keep track of inventory, update mailing lists, and manage information files. Master the skills necessary to plan and design a table, as well as add, change, and delete data. Learn how to perform queries on single and multiple tables to find and display data. Discover how to generate simple forms and reports to access or print out the information that you need. Additional topics include global changes, sorting data, date arithmetic, modifying the table structure, and database management.
Fee: $399

Access 2016  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E0892 Mon., June 1 & Tues., June 2West CountyBill Barry
E1121 Wed., Aug. 5 & Thurs., Aug. 6West CountyBill Barry

Intermediate Applications of Access

(Prerequisite: Introduction to Access or equivalent experience.) This course covers creating effective tables, forms, and reports. Discover how to design forms so you can easily enter, edit, and delete information. Learn the principles of data validation and how to error-trap your inputs. This course covers special techniques for creating sophisticated reports, grouping data for subtotals, and generating mailing labels. Additional topics include understanding field properties, working with indexes and primary keys, using functions in queries and reports, and creating summary reports.
Fee: $399

Access 2016  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E0893 Mon., June 15 & Tues., June 16West CountyMark Ratliff
E1122 Wed., Aug. 19 & Thurs., Aug. 20West CountyBill Barry

Advanced Applications of Access

(Prerequisite: Intermediate Applications of Access or equivalent experience.) This course covers a variety of advanced tips and techniques for designing and using Access databases. Learn to write special purpose queries, including crosstab and union queries, and design reports that include running sums and conditional formatting. Practice using text, date, and conditional functions to manipulate data. Create complex parameter queries and custom forms to supply parameter values. Additional topics include inserting subreports and using PivotTables and PivotCharts to summarize your data.
Fee: $399

Access 2016 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
E0984 Mon., June 29 & Tues., June 30West CountyMark Ratliff
E1123 Wed., Sept. 2 & Thurs., Sept. 3West CountyBill Barry

If you would like to register for a course, call (314) 984-9000 or register online.

Classes are available in Access Programming that teach you how to use Access Visual Basic for Applications (VBA).