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 2007  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5518 Thurs., Nov. 13 & Fri., Nov. 14West CountyDick Koerper
Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5361 Mon., Sept. 8 & Tues., Sept. 9West CountyBill Barry
G5554 Tues., Nov. 4 & Wed., Nov. 5West CountyBill Barry
Access 2013 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5301 Thurs., Sept. 4 & Fri., Sept. 5West CountyBill Barry
G5601 Mon., Dec. 1 & Tues., Dec. 2West 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 2007  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5519 Mon., Nov. 24 & Tues., Nov. 25West CountyDick Koerper
Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5362 Mon., Sept. 22 & Tues., Sept. 23West CountyBill Barry
G5555 Mon., Nov. 17 & Tues., Nov. 18West CountyBill Barry
Access 2013 
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G5302 Thurs., Sept. 18 & Fri., Sept. 19West CountyBill Barry
G5602 Mon., Dec. 15 & Tues., Dec. 16West 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
G5363 Mon., Oct. 6 & Tues., Oct. 7West 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: $379

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