Catalog/Programs
| Access 2007, Advanced | Clock Hours: 12.00 | CEUS: 1.20 |
Learn querying with SQL statements and attaching SQL queries to Access controls. Create crosstab, parameter and action queries. Create, run and attach macros to the events of database objects. Import, export and link objects and interact with XML documents. Optimize database resources; set options and properties to protect the database. Examine internet integration with hyperlink fields and data collection capabilities with Outlook.Course ID
and Fee | Meeting Information | Instructor |
|
| Access 2007, Intermediate | Clock Hours: 12.00 | CEUS: 1.20 |
Learn about database normalization, relationships, referential integrity and how to analyze tables. Explore more complex queries with joins, calculated fields and summarizing and grouping values. Enhance forms with unbound controls, graphics, calculated values, combo boxes. Create more customized reports, labels, charts in forms and reports, as well as PivotTables and PivotCharts.Course ID
and Fee | Meeting Information | Instructor |
|
| Access 2007, Introduction | Clock Hours: 12.00 | CEUS: 1.20 |
Learn the basic building blocks of Access by creating, designing, and editing tables. Insert, update and delete data in these tables. Find the data you want by creating simple queries and filters. Design simple forms and reports.Course ID
and Fee | Meeting Information | Instructor |
|
| Access VBA Programming | Clock Hours: 6.00 | CEUS: 0.60 |
Experienced Access users will learn to work with ActiveX Data Objects, control structures, and the basics of VBA programming.Course ID
and Fee | Meeting Information | Instructor |
|
| Crystal Reports, Advanced | Clock Hours: 12.00 | CEUS: 1.20 |
Enhance your Crystal reporting with advanced formulas, formatting, cross-tabs, sub-reports and SQL tools. Prerequisites: Crystal Reports Introduction or equivalent knowledge.Course ID
and Fee | Meeting Information | Instructor |
|
| Crystal Reports, Introduction | Clock Hours: 12.00 | CEUS: 1.20 |
Crystal Reports is a database report writer and is used for analyzing and presenting database information. You will learn to create and modify reports, apply formatting and formulas. Prerequisites: Database concepts and Windows experience.Course ID
and Fee | Meeting Information | Instructor |
|
| Database Design | Clock Hours: 6.00 | CEUS: 0.60 |
Is your database easy to work with and efficient? Learn the theory behind relational databases, entity relationship diagrams and normalization of data. Students will plan the design of a database. Recommended prerequisites: Intro to Access or basic database skills.Course ID
and Fee | Meeting Information | Instructor |
|
| Database Productivity Lab | Clock Hours: 6.00 | CEUS: 0.60 |
At the end of the Database Design and Management Certificate Program, students design a working database, queries, forms and reports. This lab, hands-on session provides the review and practical application needed to pull it all together and fine-tune your new database management skills.Course ID
and Fee | Meeting Information | Instructor |
|
| SQL, Introduction | Clock Hours: 12.00 | CEUS: 1.20 |
Prepare yourself to use generic SQL (Structured Query Language) to retrieve, store and manipulate data from any relational database. Querying and SQL statements fundamentals will be covered. Prerequisite: Windows experience and knowledge of database concepts are recommended.Course ID
and Fee | Meeting Information | Instructor |
|
