Course
Schedule
ACT
ASP
ASP_NET
Access DB
Acrobat
ActiveDir
Apache Server
C# Prog.
C++ Prog.
CSS (HTML)
Cisco Routers
Cisco Week
ColdFusion
Crystal Reports
DHTML
DP Design
DigCameras
Dreamweaver
Excel
Exchange
FileMaker
Fireworks
Flash
FrontPage
HTML
IIS Web Server
Illustrator
InDesign
Introductory
JSP
Java
JavaScript
Linux
Macromedia
Networks
ObjectOProg.
Oracle
Outlook
PHP
PageMaker
Perl
Photoshop
PowerPoint
Premiere
Prog. Concpts
Project
Publisher
QuarkXPress
QuickBooks
SQL
SQL Optimize
SQL Server
Scanners
Security
TCP/IP
UNIX
VB.Net
Visio
Visual Basic
W2003 Policy
W2003 Server
Win XP Admin.
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, among other database applications. 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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6276 | Thurs., Aug. 18 & Fri., Aug. 19 | West County | Dick Koerper |
| F6326 | Tues., Sept. 6 & Wed., Sept. 7 | West County | Bill Barry |
| F6353 | Wed., Sept. 21 & Thurs., Sept. 22 | West County | Lisa Bequette |
| F6424 | Mon., Oct. 10 & Tues., Oct. 11 | West County | Bill Barry |
| F6541 | Tues., Nov. 8 & Wed., Nov. 9 | West County | Bill Barry |
| F6535 | Wed., Nov. 30 & Thurs., Dec. 1 | UM-St. Louis | Dawn Robinson |
| F6675 | Mon., Dec. 19 & Tues., Dec. 20 | West County | Dawn Robinson |
| |||
| Four-Evening Class Meets 6:30-9:30pm (12 hours) | |||
| Code | Dates | Location | Instructor |
| T6109 | Thurs., Sept. 29, Oct. 6, 13 & 20 | West County | Bill Barry |
| |||
|
Intermediate Applications of Access (Prerequisite: Introduction to Access or equivalent experience.) Increase your knowledge of Access by learning to create effective forms and reports. Learn 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. Discover 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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6272 | Mon., Aug. 1 & Tues., Aug. 2 | West County | Bill Barry |
| F6383 | Thurs., Sept. 1 & Fri., Sept. 2 | West County | Bill Barry |
| F6359 | Mon., Sept. 19 & Tues., Sept. 20 | West County | Bill Barry |
| F6465 | Wed., Oct. 5 & Thurs., Oct. 6 | West County | Lisa Bequette |
| F6426 | Mon., Oct. 24 & Tues., Oct. 25 | West County | Bill Barry |
| F6552 | Tues., Nov. 22 & Wed., Nov. 23 | West County | Dawn Robinson |
| F6649 | Wed., Dec. 14 & Thurs., Dec. 15 | UM-St. Louis | Dawn Robinson |
| |||
| Four-Evening Class Meets 6:30-9:30pm (12 hours) | |||
| Code | Dates | Location | Instructor |
| T6052 | Tues., Aug. 9, 16, 23 & 30 | West County | Lisa Bequette |
| T6160 | Thurs., Oct. 27, Nov. 3, 10 & 17 | West County | Bill Barry |
| |||
|
Advanced 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 management 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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6262 | Wed., Aug. 10 & Thurs., Aug. 11 | West County | Lisa Bequette |
| F6493 | Mon., Oct. 3 & Tues., Oct. 4 | West County | Bill Barry |
| F6560 | Tues., Nov. 1 & Wed., Nov. 2 | West County | Lisa Bequette |
| F6659 | Mon., Dec. 5 & Tues., Dec. 6 | West County | Bill Barry |
| |||
| Four-Evening Class Meets 6:30-9:30pm (12 hours) | |||
| Code | Dates | Location | Instructor |
| T6119 | Tues., Sept. 6, 13, 20 & 27 | West County | Lisa Bequette |
| |||
|
Accelerated Topics in Access: Database Security (Prerequisite: Intermediate Applications of Access or equivalent experience.) Learn to use the security features in Access to protect your databases. Practice using passwords to limit access to the entire database. Learn to set up workgroups with user- level security to protect the design of your database objects. Additional topics include granting permissions to allow users varying levels of control and encrypting your database to render the data unreadable to disk utilities. Fee: $89 | |||
|
Half-Day Class Meets 8:30am-11:30am (3 hours) | |||
| Code | Date | Location | Instructor |
| F6393 | Mon., Sept. 12 | West County | Lisa Bequette |
| F6593 | Thurs., Nov. 10 | West County | Lisa Bequette |
| |||
|
Advanced Applications of 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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6273 | Wed., Aug. 24 & Thurs., Aug. 25 | West County | Lisa Bequette |
| F6571 | Mon., Nov. 14 & Tues., Nov. 15 | West County | Lisa Bequette |
| |||
|
Programming Applications of Access: Level 1 (Prerequisite: Intermediate Applications of Access and Introduction to Programming Concepts or equivalent experience. This course was formerly titled Programming Applications of Access.). Increase the speed and efficiency of your databases and create customized applications through Access 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 different 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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6379 | Tues., Sept. 6 & Wed., Sept. 7 | West County | Frank Richey |
| F6523 | Mon., Nov. 28 & Tues., Nov. 29 | 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 Visual Basic for Applications (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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6387 | Mon., Sept. 19 & Tues., Sept. 20 | West County | Frank Richey |
| F6636 | Mon., Dec. 12 & Tues., Dec. 13 | West County | Frank Richey |
| |||
|
Programming Applications of Access: Level 3 (Prerequisites: Programming Applications of Access: Levels 1 and 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: $299 | |||
|
Two-Day Class Meets 8:30am-4:00pm (13 hours) | |||
| Code | Dates | Location | Instructor |
| F6498 | Mon., Oct. 3 & Tues., Oct. 4 | West County | Frank Richey |
| F6700 | Tues., Jan. 3 & Wed., Jan. 4 | West County | Frank Richey |
|
| |||
