Course
Schedule
AJAX
ASP_NET
Access DB
Acrobat
ActiveDir
C# .NET Prog.
CSS (HTML)
Cisco Week
Crystal Reports
DP Design
DigCameras
Dreamweaver
E-commerce
Excel
Exchange
ExpressionWeb
FileMaker
Fireworks
Flash
HTML
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Networks
ObjectOProg.
Office2007
Oracle
Outlook
PHP
Perl
PhotoElems
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Reporting
SQLServerAdm
Security
SharePoint
SharePtAdmin
SharePtDesign
Support
TCP/IP
UNIX
VB.NET
Visio
Vista Admin
Vista Intro.
Vista Trans.
Visual Basic 6
W2003 Policy
W2003 Server
W2008 Server
Win XP Intro.
Wireless Net.
Word
XML
|
Access |
| ||
 | |||
|
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: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9457 | Tues., Oct. 7 & Wed., Oct. 8 | West County | Sandy Lux |
| G9438 | Thurs., Oct. 16 & Fri., Oct. 17 | UM-St. Louis | Dick Koerper |
| G9577 | Mon., Nov. 10 & Tues., Nov. 11 | West County | Sandy Lux |
| G9644 | Thurs., Dec. 4 & Fri., Dec. 5 | West County | Bill Barry |
| G9733 | Wed., Jan. 7 & Thurs., Jan. 8 | West County | Sandy Lux |
| |||
| Four-Evening Class Meets 6:30-9:30pm (12 hours) | |||
| Code | Dates | Location | Instructor |
| T9130 | Tues., Sept. 30, Oct. 7, 14 & 21 | West County | Dick Koerper |
| |||
| Access 2007 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9469 | Wed., Oct. 22 & Thurs., Oct. 23 | West County | Bill Barry |
| G9710 | Tues., Jan. 13 & Wed., Jan. 14 | West County | Sandy Lux |
| |||
|
Intermediate Applications of Access (Prerequisite: Introduction to Access or equivalent experience.) Increase your knowledge of Access by learning to create effective tables, forms, and reports. Discover how to design effective 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: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9458 | Wed., Oct. 22 & Thurs., Oct. 23 | West County | Sandy Lux |
| G9439 | Thurs., Oct. 30 & Fri., Oct. 31 | UM-St. Louis | Dick Koerper |
| G9578 | Mon., Nov. 24 & Tues., Nov. 25 | West County | Sandy Lux |
| G9645 | Thurs., Dec. 18 & Fri., Dec. 19 | West County | Sandy Lux |
| G9734 | Tues., Jan. 20 & Wed., Jan. 21 | West County | Sandy Lux |
| |||
| Four-Evening Class Meets 6:30-9:30pm (12 hours) | |||
| Code | Dates | Location | Instructor |
| T9168 | Tues., Oct. 28, Nov. 4, 11 & 18 | West County | Dick Koerper |
| |||
| Access 2007 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9570 | Wed., Nov. 5 & Thurs., Nov. 6 | West County | Bill Barry |
| G9711 | Mon., Jan. 26 & Tues., Jan. 27 | West County | Sandy Lux |
| |||
|
Advanced Applications of Access (Prerequisite: Intermediate Applications of Access or equivalent experience.) This course covers a variety of practical 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: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9835 | Mon., Feb. 2 & Tues., Feb. 3 | West County | Sandy Lux |
| |||
| Access 2007 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9572 | Wed., Nov. 19 & Thurs., Nov. 20 | West County | Bill Barry |
| |||
|
Advanced Topics in Access: Database Design (Prerequisite: Intermediate Applications of Access or equivalent experience.) Further your skills in database design by learning to effectively manage a relational database system and work with multiple tables simultaneously. Learn 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: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9459 | Wed., Oct. 29 & Thurs., Oct. 30 | West County | Sandy Lux |
| |||
|
Advanced Topics in Access: Macros (Prerequisite: Intermediate Applications of Access or equivalent experience.) Learn how to use Access macros to automate a database. Create forms with command buttons that guide users through the typical functions of a database, such as entering and modifying data, searching for specific records, and printing a selection of reports. You will design macros that control the startup of a database, filter data, synchronize multiple forms to the same record, and perform record searches based on user input. Fee: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9679 | Tues., Dec. 9 & Wed., Dec. 10 | West County | Bill Barry |
| |||
|
Programming Applications of Access: Level 1 (Prerequisite: Intermediate Applications of Access and Introduction to Programming Concepts or equivalent experience.) Increase the speed and efficiency of your databases and create customized applications through Access Visual Basic for Applications (VBA). You'll learn to use programming control structures to automate your database applications, as well as reduce your database size to save disk space, use less memory, and make your applications run faster. Write code and create variables and control structures using the Visual Basic Editor window. Along with basic commands, techniques, and error trapping, you'll discover the differences among the various programming modules and learn about events, variables, and constants. Other topics include automating the opening and closing forms and other objects; programmatically filtering your forms and reports; and using option groups, list boxes, and combo boxes. Fee: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9683 | Thurs., Dec. 4 & Fri., Dec. 5 | West County | Frank Richey |
| |||
|
Programming Applications of Access: Level 2 (Prerequisite: Programming Applications of Access: Level 1 or equivalent experience.) Build on your knowledge of Access programming using more advanced VBA programming code. Learn how to use ActiveX Data Objects (ADO) coding techniques and Recordset objects to work with your data. Develop error-free applications using formal error-trapping techniques to trap, collect, and respond to errors. Additional topics include using loops to repeat operations and programming your applications using ActiveX controls. Fee: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9684 | Thurs., Dec. 18 & Fri., Dec. 19 | West County | Frank Richey |
| |||
|
Programming Applications of Access: Level 3 (Prerequisites: Programming Applications of Access: Level 2 or equivalent experience.) Learn how to make your code more efficient, expand your knowledge of VBA ADO coding techniques using recordsets, and save time and effort through automation. Learn to use recordsets to modify record data record-by-record, as well as make bulk record changes, create and delete objects using code, and establish relationships between objects using VBA code. Examine useful application optimization techniques, such as variable arrays, connection objects, and constants. Other topics include importing data from an external database, text file, or Excel spreadsheet and automating by creating and controlling Excel and Outlook from an Access database. Fee: $339 | |||
|
Access 2003 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| G9785 | Thurs., Jan. 8 & Fri., Jan. 9 | West County | Frank Richey |
|
| |||
