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
G7281 Mon., Aug. 8 & Tues., Aug. 9West CountyBill Barry
G7359 Wed., Nov. 16 & Thurs., Nov. 17West CountyMark Ratliff
Access 2013  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G7295 Thurs., Sept. 8 & Fri., Sept. 9West CountyMark Ratliff
G7422 Mon., Oct. 24 & Tues., Oct. 25West 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: $379

Access 2010  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G7282 Tues., Aug. 23 & Wed., Aug. 24West CountyBill Barry
G7360 Thurs., Dec. 1 & Fri., Dec. 2West CountyMark Ratliff
Access 2013  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G7296 Thurs., Sept. 22 & Fri., Sept. 23West CountyMark Ratliff
G7423 Tues., Nov. 8 & Wed., Nov. 9West 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
G7283 Tues., Sept. 6 & Wed., Sept. 7West CountyBill Barry
Access 2013  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G7297 Wed., Oct. 5 & Thurs., Oct. 6West 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
G7361 Thurs., Dec. 15 & Fri., Dec. 16West CountyMark Ratliff
Access 2013  [Course Outline]
Two-Day Class Meets 8:30am-4:00pm (13 hours)
Code Dates Location Instructor
G7176 Wed., Aug. 10 & Thurs., Aug. 11West CountyMark Ratliff
G7424 Mon., Nov. 21 & Tues., Nov. 22West CountyMark Ratliff

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).