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: $379

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H5997 Wed., June 10 & Thurs., June 11West CountyBill Barry
G6117 Thurs., Aug. 6 & Fri., Aug. 7West CountyBill Barry
G6374 Mon., Sept. 14 & Tues., Sept. 15West CountyBill Barry
Access 2013  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G6190 Tues., July 7 & Wed., July 8West CountyMark Ratliff
G6228 Wed., Sept. 2 & Thurs., Sept. 3West CountyMark Ratliff

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: $379

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H5999 Wed., June 24 & Thurs., June 25West CountyBill Barry
G6118 Tues., Aug. 18 & Wed., Aug. 19West CountyBill Barry
G6375 Mon., Sept. 28 & Tues., Sept. 29West CountyBill Barry
Access 2013  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H5338 Tues., May 26 & Wed., May 27West CountyMark Ratliff
G6191 Mon., July 20 & Tues., July 21West CountyMark Ratliff
G6229 Wed., Sept. 16 & Thurs., Sept. 17West CountyMark Ratliff

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: $379

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H5269 Mon., May 18 & Tues., May 19West CountyBill Barry
G6119 Wed., Sept. 2 & Thurs., Sept. 3West CountyBill Barry
Access 2013 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G6192 Mon., Aug. 10 & Tues., Aug. 11West CountyMark Ratliff

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: $379

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
H6001 Tues., July 7 & Wed., July 8West CountyBill Barry
G6376 Tues., Oct. 13 & Wed., Oct. 14West 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).