| Course ID
|
Course Name
|
Hours
|
Price
|
Outline |
Schedule |
|
|
0300-400-07-W
Course Number: 0300-400-07-W
Course Name: Access 2007 Application and Development
# of class dates: 31
Description: This course is for those who want to go beyond using the built-in features offered by Access and develop their own applications. The course starts with how to plan an application from the ground up, and how to make use of advanced form design, macros, and ...
|
Access 2007 Application and Development
Course Number: 0300-400-07-W
Course Name: Access 2007 Application and Development
# of class dates: 31
Description: This course is for those who want to go beyond using the built-in features offered by Access and develop their own applications. The course starts with how to plan an application from the ground up, and how to make use of advanced form design, macros, and ...
|
7 |
$350.00 |
|
|
|
|
0300-100-07-W
Course Number: 0300-100-07-W
Course Name: Access 2007 Level 1 for Windows
# of class dates: 30
Description: In this course you will cover: an introduction to various components of the Access 2007, creating and manipulating database and table, perform a simple data entry, display and filter the data, perform multiple data import and/or export procedures to many d...
|
Access 2007 Level 1 for Windows
Course Number: 0300-100-07-W
Course Name: Access 2007 Level 1 for Windows
# of class dates: 30
Description: In this course you will cover: an introduction to various components of the Access 2007, creating and manipulating database and table, perform a simple data entry, display and filter the data, perform multiple data import and/or export procedures to many d...
|
7 |
$249.00 |
|
|
|
|
0300-200-07-W
Course Number: 0300-200-07-W
Course Name: Access 2007 Level 2 for Windows
# of class dates: 30
Description: In this course you will cover: data integrity through data restricting, specifying, validation rules, and/or creating a list. Also the students will be creating a custom form, explore the queries, making reports by using wizard, manage the database and cr...
|
Access 2007 Level 2 for Windows
Course Number: 0300-200-07-W
Course Name: Access 2007 Level 2 for Windows
# of class dates: 30
Description: In this course you will cover: data integrity through data restricting, specifying, validation rules, and/or creating a list. Also the students will be creating a custom form, explore the queries, making reports by using wizard, manage the database and cr...
|
7 |
$249.00 |
|
|
|
|
0300-300-07-W
Course Number: 0300-300-07-W
Course Name: Access 2007 Level 3 for Windows
# of class dates: 30
Description: In this course you will cover: structuring of existing data, writing advanced queries, simplifying tasks with macros, making effective use of forms, making reports more effective & maintaining an access database.
|
Access 2007 Level 3 for Windows
Course Number: 0300-300-07-W
Course Name: Access 2007 Level 3 for Windows
# of class dates: 30
Description: In this course you will cover: structuring of existing data, writing advanced queries, simplifying tasks with macros, making effective use of forms, making reports more effective & maintaining an access database.
|
7 |
$285.00 |
|
|
|
|
0300-050-07-W
Course Number: 0300-050-07-W
Course Name: Access 2007 VBA Programming
# of class dates: 31
Description: This course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. Specific topics include: Visual Basic Editor, objects, object browser and collections, programming bas...
|
Access 2007 VBA Programming
Course Number: 0300-050-07-W
Course Name: Access 2007 VBA Programming
# of class dates: 31
Description: This course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. Specific topics include: Visual Basic Editor, objects, object browser and collections, programming bas...
|
7 |
$350.00 |
|
|
|
|
0300-100-10-W
Course Number: 0300-100-10-W
Course Name: Access 2010 Level 1 for Windows
# of class dates: 31
Description: In this course you will cover: basic database concepts and an exploration of the Access 2010 environment, designing a database, building a database with related tables, managing data in a table, querying a database using different methods, designing forms...
|
Access 2010 Level 1 for Windows
Course Number: 0300-100-10-W
Course Name: Access 2010 Level 1 for Windows
# of class dates: 31
Description: In this course you will cover: basic database concepts and an exploration of the Access 2010 environment, designing a database, building a database with related tables, managing data in a table, querying a database using different methods, designing forms...
|
7 |
$249.00 |
|
|
|
|
0300-200-10-W
Course Number: 0300-200-10-W
Course Name: Access 2010 Level 2 for Windows
# of class dates: 30
Description: In this class you will cover: modifying the design and field properties of a table to streamline data entry, retrieving data from tables using joins, creating flexible queries, enhancing the capabilities of a form, customizing reports to organize the displ...
|
Access 2010 Level 2 for Windows
Course Number: 0300-200-10-W
Course Name: Access 2010 Level 2 for Windows
# of class dates: 30
Description: In this class you will cover: modifying the design and field properties of a table to streamline data entry, retrieving data from tables using joins, creating flexible queries, enhancing the capabilities of a form, customizing reports to organize the displ...
|
7 |
$249.00 |
|
|
|
|
0300-300-10-W
Course Number: 0300-300-10-W
Course Name: Access 2010 Level 3 for Windows
# of class dates: 30
Description: In this course, you will cover how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; pa...
|
Access 2010 Level 3 for Windows
Course Number: 0300-300-10-W
Course Name: Access 2010 Level 3 for Windows
# of class dates: 30
Description: In this course, you will cover how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; pa...
|
7 |
$289.00 |
|
|
|
|
0300-400-10-W
Course Number: 0300-400-10-W
Course Name: Access 2010 Level 4 for Windows
# of class dates: 31
Description: In this course you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases. This course is designed for students who have a thorough understanding of the basic and advanced user features of...
|
Access 2010 Level 4 for Windows
Course Number: 0300-400-10-W
Course Name: Access 2010 Level 4 for Windows
# of class dates: 31
Description: In this course you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases. This course is designed for students who have a thorough understanding of the basic and advanced user features of...
|
7 |
$350.00 |
|
|
|
|
1391-100-07-W
Course Number: 1391-100-07-W
Course Name: Creating InfoPath 2007 Forms
# of class dates: 6
Description: This course will cover how to use InfoPath 2007 to gather and share information by creating and implementing XML-based forms. Specific topics include: creating InfoPath forms, importing and exporting form data, customizing form layout, managing views, secu...
|
Creating InfoPath 2007 Forms
Course Number: 1391-100-07-W
Course Name: Creating InfoPath 2007 Forms
# of class dates: 6
Description: This course will cover how to use InfoPath 2007 to gather and share information by creating and implementing XML-based forms. Specific topics include: creating InfoPath forms, importing and exporting form data, customizing form layout, managing views, secu...
|
7 |
$270.00 |
|
|
|
|
0200-230-07-W
Course Number: 0200-230-07-W
Course Name: Excel 2007 Charts
# of class dates: 15
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data & create a user-defined chart type.
|
Excel 2007 Charts
Course Number: 0200-230-07-W
Course Name: Excel 2007 Charts
# of class dates: 15
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data & create a user-defined chart type.
|
4 |
$210.00 |
|
|
|
|
0200-400-07-W
Course Number: 0200-400-07-W
Course Name: Excel 2007 Database Features for Windows
# of class dates: 16
Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; work with PivotTables and PivotCharts; export and i...
|
Excel 2007 Database Features for Windows
Course Number: 0200-400-07-W
Course Name: Excel 2007 Database Features for Windows
# of class dates: 16
Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; work with PivotTables and PivotCharts; export and i...
|
7 |
$235.00 |
|
|
|
|
0200-240-07-W
Course Number: 0200-240-07-W
Course Name: Excel 2007 Formulas
# of class dates: 15
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, ...
|
Excel 2007 Formulas
Course Number: 0200-240-07-W
Course Name: Excel 2007 Formulas
# of class dates: 15
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, ...
|
4 |
$210.00 |
|
|
|
|
0200-100-07-W
Course Number: 0200-100-07-W
Course Name: Excel 2007 Level 1 for Windows
# of class dates: 30
Description: In this course you will cover: an introduction to various components of the Excel 2007, entering, modifying, and/or moving data within a Workbook, formatting cells, creating charts and/or data tables, conducting calculations, and preparing to print the wor...
|
Excel 2007 Level 1 for Windows
Course Number: 0200-100-07-W
Course Name: Excel 2007 Level 1 for Windows
# of class dates: 30
Description: In this course you will cover: an introduction to various components of the Excel 2007, entering, modifying, and/or moving data within a Workbook, formatting cells, creating charts and/or data tables, conducting calculations, and preparing to print the wor...
|
7 |
$235.00 |
|
|
|
|
0200-200-07-W
Course Number: 0200-200-07-W
Course Name: Excel 2007 Level 2 for Windows
# of class dates: 29
Description: In this course you will cover: more calculations and formatting by summarizing data and finding its error and making corrections. Also, this course will cover in customizing the charts and graphics, data lists, and acquiring data from multiple sources suc...
|
Excel 2007 Level 2 for Windows
Course Number: 0200-200-07-W
Course Name: Excel 2007 Level 2 for Windows
# of class dates: 29
Description: In this course you will cover: more calculations and formatting by summarizing data and finding its error and making corrections. Also, this course will cover in customizing the charts and graphics, data lists, and acquiring data from multiple sources suc...
|
7 |
$235.00 |
|
|
|
|
0200-301-07-W
Course Number: 0200-301-07-W
Course Name: Excel 2007 Level 3
# of class dates: 31
Description: In this course you will cover: data analysis by either defining alternative data set or multiple data sets. Also analyzing data by using PivotTables and/or PivotCharts. In-depth introduction of Macros and its application to Excel 2007, recycling office d...
|
Excel 2007 Level 3
Course Number: 0200-301-07-W
Course Name: Excel 2007 Level 3
# of class dates: 31
Description: In this course you will cover: data analysis by either defining alternative data set or multiple data sets. Also analyzing data by using PivotTables and/or PivotCharts. In-depth introduction of Macros and its application to Excel 2007, recycling office d...
|
7 |
$235.00 |
|
|
|
|
0200-220-07-W
Course Number: 0200-220-07-W
Course Name: Excel 2007 VBA Programming
# of class dates: 16
Description: In this course, you will cover how to: use Visual Basic Editor for applications terminology, manipulate data by declaring variables and procedures of correct scope, control program flow by using decision structures to perform decision tasks and loop struct...
|
Excel 2007 VBA Programming
Course Number: 0200-220-07-W
Course Name: Excel 2007 VBA Programming
# of class dates: 16
Description: In this course, you will cover how to: use Visual Basic Editor for applications terminology, manipulate data by declaring variables and procedures of correct scope, control program flow by using decision structures to perform decision tasks and loop struct...
|
7 |
$295.00 |
|
|
|
|
0200-230-10-W
Course Number: 0200-230-10-W
Course Name: Excel 2010 Charts
# of class dates: 16
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data & create a user-defined chart type.
|
Excel 2010 Charts
Course Number: 0200-230-10-W
Course Name: Excel 2010 Charts
# of class dates: 16
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data & create a user-defined chart type.
|
4 |
$210.00 |
|
|
|
|
0200-400-10-W
Course Number: 0200-400-10-W
Course Name: Excel 2010 Database Features
# of class dates: 16
Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; work with PivotTables and PivotCharts; export and i...
|
Excel 2010 Database Features
Course Number: 0200-400-10-W
Course Name: Excel 2010 Database Features
# of class dates: 16
Description: In this course, you will cover how to: find features using the Ribbon; freeze panes; manage multiple windows; compare workbooks side by side; work with tables and lists; validate data; work with outlines; work with PivotTables and PivotCharts; export and i...
|
7 |
$235.00 |
|
|
|
|
0200-240-10-W
Course Number: 0200-240-10-W
Course Name: Excel 2010 Formulas
# of class dates: 16
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, ...
|
Excel 2010 Formulas
Course Number: 0200-240-10-W
Course Name: Excel 2010 Formulas
# of class dates: 16
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, ...
|
4 |
$210.00 |
|
|
|
|
0200-100-10-W
Course Number: 0200-100-10-W
Course Name: Excel 2010 Level 1 for Windows
# of class dates: 32
Description: In this class you will cover: the Excel 2010 environment, working with an Excel spreadsheet by entering and selecting the data in it, modifying a worksheet, performing calculations, formatting a worksheet, developing a workbook, printing workbook contents ...
|
Excel 2010 Level 1 for Windows
Course Number: 0200-100-10-W
Course Name: Excel 2010 Level 1 for Windows
# of class dates: 32
Description: In this class you will cover: the Excel 2010 environment, working with an Excel spreadsheet by entering and selecting the data in it, modifying a worksheet, performing calculations, formatting a worksheet, developing a workbook, printing workbook contents ...
|
7 |
$235.00 |
|
|
|
|
0200-200-10-W
Course Number: 0200-200-10-W
Course Name: Excel 2010 Level 2 for Windows
# of class dates: 31
Description: In this class you will cover: enhancing Excel workbooks, creating workbooks using templates, organizing data using tables, presenting data using charts, analyzing data using PivotTables and PivotCharts, enhancing visual appeal using graphic objects, calcul...
|
Excel 2010 Level 2 for Windows
Course Number: 0200-200-10-W
Course Name: Excel 2010 Level 2 for Windows
# of class dates: 31
Description: In this class you will cover: enhancing Excel workbooks, creating workbooks using templates, organizing data using tables, presenting data using charts, analyzing data using PivotTables and PivotCharts, enhancing visual appeal using graphic objects, calcul...
|
7 |
$235.00 |
|
|
|
|
0200-300-10-W
Course Number: 0200-300-10-W
Course Name: Excel 2010 Level 3 for Windows
# of class dates: 31
Description: In this course you will cover some of the more advanced features of Excel including the following topics: streamlining workflow and creating macros, collaborating with others, auditing worksheets, analyzing data, Pivot Tables, working with multiple workshe...
|
Excel 2010 Level 3 for Windows
Course Number: 0200-300-10-W
Course Name: Excel 2010 Level 3 for Windows
# of class dates: 31
Description: In this course you will cover some of the more advanced features of Excel including the following topics: streamlining workflow and creating macros, collaborating with others, auditing worksheets, analyzing data, Pivot Tables, working with multiple workshe...
|
7 |
$235.00 |
|
|
|
|
0200-500-10-W
Course Number: 0200-500-10-W
Course Name: Excel 2010 PivotTables for Windows
# of class dates: 2
Description: In this course, you will cover when to use PivotTables vs other analytical tools in Excel, how to create, modify and use PivotTables. You will also learn several ways to display your information in PivotTable reports using the ‘Classical’ layout and the st...
|
Excel 2010 PivotTables for Windows
Course Number: 0200-500-10-W
Course Name: Excel 2010 PivotTables for Windows
# of class dates: 2
Description: In this course, you will cover when to use PivotTables vs other analytical tools in Excel, how to create, modify and use PivotTables. You will also learn several ways to display your information in PivotTable reports using the ‘Classical’ layout and the st...
|
4 |
$210.00 |
|
|
|
|
0200-220-10-W
Course Number: 0200-220-10-W
Course Name: Excel 2010 VBA Programming
# of class dates: 16
Description: This course is designed to give experienced Excel 2010 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user for...
|
Excel 2010 VBA Programming
Course Number: 0200-220-10-W
Course Name: Excel 2010 VBA Programming
# of class dates: 16
Description: This course is designed to give experienced Excel 2010 users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user for...
|
7 |
$295.00 |
|
|