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.

Introduction to Access

(Prerequisite: Introduction to Windows or equivalent experience.) 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: $349

Access 2007  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4101 Mon., Mar. 3 & Tues., Mar. 4West CountyDick Koerper
H4183 Wed., June 18 & Thurs., June 19West CountyDick Koerper
Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4261 Wed., Mar. 26 & Thurs., Mar. 27West CountyBill Barry
H4346 Tues., May 27 & Wed., May 28West CountyBill Barry
Access 2013 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4254 Wed., May 7 & Thurs., May 8West 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: $349

Access 2007  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4102 Mon., Mar. 17 & Tues., Mar. 18West CountyDick Koerper
H4184 Mon., June 30 & Tues., July 1West CountyDick Koerper
Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4262 Wed., Apr. 9 & Thurs., Apr. 10West CountyBill Barry
H4347 Mon., June 9 & Tues., June 10West CountyBill Barry
Access 2013 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4255 Tues., May 20 & Wed., May 21West 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: $349

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G4870 Mon., Mar. 3 & Tues., Mar. 4West CountyBill Barry
H4348 Tues., June 17 & Wed., June 18West CountyBill Barry

Advanced Topics in Access: Database Design

(Prerequisite: Intermediate Applications of Access or equivalent experience.) Learn to effectively manage a relational database system and work with multiple tables simultaneously. Discover how to identify items to be stored in a database, establish relationships between the items, and group the items in the appropriate tables. Topics include linking database tables, generating reports from multiple tables, querying multiple tables, and updating tables. Strong emphasis will be placed on effective database design and deciding how to structure tables within the database.
Fee: $349

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H4263 Thurs., Apr. 24 & Fri., Apr. 25West 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.