In this course you will learn to work with the properties of the table object to control how data is entered into your tables. You will create a customized form view by moving and resizing control objects and modifying properties. You will use advanced query features to calculate statistical information. Advanced report features will be used to embed a sub-report in a main report and perform arithmetic calculations. You will utilize Macros to perform automated commands and create a simplified user interface, and also learn how to turn the Navigation Pane into a user interface.
Prerequisite: Access I & II or equivalent knowledge.

In this course you will learn to work with the properties of the table object to control how data is entered into your tables. You will create a customized form view by moving and resizing control objects and modifying properties. You will use advanced query features to calculate statistical information. Advanced report features will be used to embed a sub-report in a main report and perform arithmetic calculations. You will utilize Macros to perform automated commands and create a simplified user interface, and also learn how to turn the Navigation Pane into a user interface.
Prerequisite: Access I & II or equivalent knowledge.

In earlier Access classes, students learned to create a broad range of queries using Access’s graphical user interface, the Query Design View. This course will extend the student’s knowledge of query creation through the use of SQL, also known as Structured Query Language.
SQL is a computer language that uses ordinary English words such as SELECT, FROM, WHERE, and HAVING as keywords in its syntax. This course will utilize the specific syntax for querying within Microsoft Access. This syntax may differ in many instances from that used in Microsoft SQL Server, as well as that used in other vendor’s databases.
The ability to retrieve data in SQL is accomplished through the SELECT statement. The fundamentals of creating SELECT statements will be covered in detail, familiarizing the student with statement clauses, keywords, and special terms required to build a specific query. Each clause will be reviewed to understand its syntax and its order of placement within the overall statement. A variety of queries will be created to gain an understanding of options such as: sorting; grouping; combining query results; joining related data, creating calculated fields; using functions; and specifying criteria.
The student will learn how to create Subqueries and Data-Definition Queries, both of which can only be created by using SQL.
This course is a great lead-in to Visual Basic Application.

For many novices, getting started in any database can be a challenge. In this course you will learn how to create and maintain a database using the database management system Access. Using Access wizards and design tools, you will create tables, forms, queries, and reports. You will learn how each of these objects can be utilized to efficiently manage your valuable information. Access is a great program for maintaining inventory records.
Prerequisite: Basic computer knowledge

For many novices, getting started in any database can be a challenge. In this course you will learn how to create and maintain a database using the database management system Access. Using Access wizards and design tools, you will create tables, forms, queries, and reports. You will learn how each of these objects can be utilized to efficiently manage your valuable information. Access is a great program for maintaining inventory records.
Prerequisite: Basic computer knowledge

For many novices, getting started in any database can be a challenge. In this course you will learn how to create and maintain a database using the database management system Access. Using Access wizards and design tools, you will create tables, forms, queries, and reports. You will learn how each of these objects can be utilized to efficiently manage your valuable information. Access is a great program for maintaining inventory records.
Prerequisite: Basic computer knowledg

You'll learn the concepts of a rational database and use those concepts to build relationships between multiple tables in a single database. Creating relationships between the tables in your database will give you enormous functionality. You will also learn the advanced features of forms, queries, and reports which will provide you with additional ways to manage and analyze the data in your relational database. And you will learn to compact your database to insure that a minimal file size is maintained.
Prerequisite: Access I or equivalent knowledge.

You’ll learn the concepts of a relational database and use those concepts to build relationships between multiple tables in one database. Creating relationships between the tables in your database will give you enormous functionality. You will also learn the advanced features of forms, queries, and reports which will provide you with additional ways to manage and analyze the data in your relational database. And you will learn to compact your database to insure that a minimal file size is maintained. (Prerequisite: Access I or equivalent knowledge

You’ll learn the concepts of a relational database and use those concepts to build relationships between multiple tables in one database. Creating relationships between the tables in your database will give you enormous functionality. You will also learn the advanced features of forms, queries, and reports which will provide you with additional ways to manage and analyze the data in your relational database. And you will learn to compact your database to insure that a minimal file size is maintained. (Prerequisite: Access I or equivalent knowledge

Take your knowledge of Microsoft Access to a higher level. Learn how Visual Basic Application (VBA) can be used to enhance the objects you already know how to build in Access; i.e., tables, forms, queries, reports, etc. VBA is a sub-set of the Visual Basic programming language that comes with Access. It lets you customize your objects to perform additional tasks other than those already built into Access. This course will introduce the student to the basic fundamentals of VBA programming and cover the use of the VBA toolkit—the Visual Basic Editor, the Object Browser, and the Object Library.

In this course, the participants will learn how to use VBA programming to customize an Access form, create customized dialog boxes, drop-down menus, and list and combo boxes; create event procedures to add additional information to a form; and open and filter a report from a customized form using VBA. How to test and debug VBA code will also be covered.

In this course, the participants will learn how to use VBA programming to customize an Access form, create customized dialog boxes, drop-down menus, and list and combo boxes; create event procedures to add additional information to a form; and open and filter a report from a customized form using VBA. How to test and debug VBA code will also be covered.

This course will cover the fundamentals of creating clear, concise and informative documents. The student will learn how to put thoughts on paper in an organized manner; how to create different types of correspondence and reports; and how to handle various methods of document distribution. Using Microsoft Word, the student will learn how to create:
Internal company memos
Formal business letters
E-mails with attachments or with data imbedded
Reports of various types: instructional, technical, status, summary
The student will also learn about the tools Microsoft Word offers for professionalizing your reports, such as: Bullets and Numbering, Tables, Styles and Headings and Tables of Contents.

This course continues to explore Excel functionality and introduces the student to the extensive variety of Excel templates that are available. The student will learn how to use macros to handle repetitive activities and how to attach them to buttons using the Developer Tab. Enhancing a spreadsheet with conditional formatting and graphics will be covered, as well as features such as formula auditing: calculation options, comments; and how to protect a worksheet. A few more functions will also be covered, including the VLOOKUP function and ARRAY functions.

You want to record numeric data faster? Now you can. In this course you will learn to create well-designed spreadsheets to store your important numeric data. You will learn to automate repetitive data entry using Autofill and customized lists. Don't like math? That's OK. Excel will help you simplify your "number crunching" tasks. Using time saving functions and formulas, you'll be able to calculate those budget and forecast totals quickly. This course covers the fundamental rules of relative cell addressing and Order of Precedence-essential knowledge necessary for efficient use of formulas and functions. Formulas and functions will be introduced.
Prerequisite: General ability to use a computer.

You want to record numeric data faster? Now you can. In this course you will learn to create well-designed spreadsheets to store your important numeric data. You will learn to automate repetitive data entry using Autofill and customized lists. Don't like math? That's OK. Excel will help you simplify your "number crunching" tasks. Using time saving functions and formulas, you'll be able to calculate those budget and forecast totals quickly. This course covers the fundamental rules of relative cell addressing and Order of Precedence-essential knowledge necessary for efficient use of formulas and functions. Formulas and functions will be introduced.
Prerequisite: General ability to use a computer.

You want to record numeric data faster? Now you can. In this course you will learn to create well-designed spreadsheets to store your important numeric data. You will learn to automate repetitive data entry using Autofill and customized lists. Don't like math? That's OK. Excel will help you simplify your "number crunching" tasks. Using time saving functions and formulas, you'll be able to calculate those budget and forecast totals quickly. This course covers the fundamental rules of relative cell addressing and Order of Precedence-essential knowledge necessary for efficient use of formulas and functions. Formulas and functions will be introduced.
Prerequisite: General ability to use a computer.

This course introduces Excel functionality for enhancing your worksheets for presentation purposes or for printing. Students will learn how to use the Page Setup tools to adjust their worksheets with custom margins, page orientation, page breaks, and headers and footers. They will learn how to sort large spreadsheets; how to filter data and create advanced filters; how to group and summarize data; and how to insert subtotals. How to manage data within multiple worksheets and workbooks and how to link that data with formulas and named cells will also be covered, as well as a few more functions, including the IF function and the DATE and PMT functions.
Prerequisite: Excel I or equivalent knowledge

This course introduces Excel functionality for enhancing your worksheets for presentation purposes or for printing. Students will learn how to use the Page Setup tools to adjust their worksheets with custom margins, page orientation, page breaks, and headers and footers. They will learn how to sort large spreadsheets; how to filter data and create advanced filters; how to group and summarize data; and how to insert subtotals. How to manage data within multiple worksheets and workbooks and how to link that data with formulas and named cells will also be covered, as well as a few more functions, including the IF function and the DATE and PMT functions.
Prerequisite: Excel I or equivalent knowledge

This course introduces Excel functionality for enhancing your worksheets for presentation purposes or for printing. Students will learn how to use the Page Setup tools to adjust their worksheets with custom margins, page orientation, page breaks, and headers and footers. They will learn how to sort large spreadsheets; how to filter data and create advanced filters; how to group and summarize data; and how to insert subtotals. How to manage data within multiple worksheets and workbooks and how to link that data with formulas and named cells will also be covered, as well as a few more functions, including the IF function and the DATE and PMT functions.
Prerequisite: Excel I or equivalent knowledge

You want to record numeric data faster? Now you can. In this course you will learn to create well-designed spreadsheets to store your important numeric data. You will learn to automate repetitive data entry using Autofill and customized lists. Don't like math? That's OK. Excel will help you simplify your "number crunching" tasks. Using time saving functions and formulas, you'll be able to calculate those budget and forecast totals quickly. This course covers the fundamental rules of relative cell addressing and Order of Precedence-essential knowledge necessary for efficient use of formulas and functions. Formulas and functions will be introduced.
Prerequisite: General ability to use a computer.

This course continues to explore Excel functionality and introduces the student to the extensive variety of Excel templates that are available. The student will learn how to use macros to handle repetitive activities and how to attach them to buttons using the Developer Tab. Enhancing a spreadsheet with conditional formatting and graphics will be covered, as well as features such as formula auditing: calculation options, comments; and how to protect a worksheet. A few more functions will also be covered, including the VLOOKUP function and ARRAY functions.

This course continues to explore Excel functionality and introduces the student to the extensive variety of Excel templates that are available. The student will learn how to use macros to handle repetitive activities and how to attach them to buttons using the Developer Tab. Enhancing a spreadsheet with conditional formatting and graphics will be covered, as well as features such as formula auditing: calculation options, comments; and how to protect a worksheet. A few more functions will also be covered, including the VLOOKUP function and ARRAY functions.

Excel supports many types of charts to help you display data in ways that are meaningful to your audience. This course is designed to introduce the student to all of
Excel's chart types and explore their specific usage. The student will learn how to create, modify, and enhance the appearance of charts with color, patterns, and custom graphics, and how to embed and link charts into Word and PowerPoint files.
Prerequisite: Excel I & II or equivalent knowledge.

Excel supports many types of charts to help you display data in ways that are meaningful to your audience. This course is designed to introduce the student to all of
Excel's chart types and explore their specific usage. The student will learn how to create, modify, and enhance the appearance of charts with color, patterns, and custom graphics, and how to embed and link charts into Word and PowerPoint files.
Prerequisite: Excel I & II or equivalent knowledge.

Excel supports many types of charts to help you display data in ways that are meaningful to your audience. This course is designed to introduce the student to all of
Excel's chart types and explore their specific usage. The student will learn how to create, modify, and enhance the appearance of charts with color, patterns, and custom graphics, and how to embed and link charts into Word and PowerPoint files.
Prerequisite: Excel I & II or equivalent knowledge.

Excel supports many types of charts to help you display data in ways that are meaningful to your audience. This course is designed to introduce the student to all of
Excel's chart types and explore their specific range. The student will learn how to create, modify, and enhance the appearance of charts with color, patterns, and custom graphics, and how to embed and link charts into Word and PowerPoint files.
Prerequisite: Excel I & II or equivalent knowledge.

This course teaches experienced Excel users how to use Excel's What-If tools: Goal Seeker, Solver, Scenario Manager, and Data Tables. The student will learn how to install Excel's add-in tool AnalysisPak that comes with Excel but is not loaded, and will explore using it to create complex analyses such as Histograms, Rank and Percentile Analysis, and Descriptive Statistics. The student will also learn how to use the Data Tools group to separate text into multiple columns, remove duplicates, set up data validation in cells, and consolidate data from multiple ranges. Great course for managers who need to analyze data to make management decisions!

This course teaches experienced Excel users how to use Excel's What-If tools: Goal Seeker, Solver, Scenario Manager, and Data Tables. The student will learn how to install Excel's add-in tool AnalysisPak that comes with Excel but is not loaded, and will explore using it to create complex analyses such as Histograms, Rank and Percentile Analysis, and Descriptive Statistics. The student will also learn how to use the Data Tools group to separate text into multiple columns, remove duplicates, set up data validation in cells, and consolidate data from multiple ranges. Great course for managers who need to analyze data to make management decisions!

This course teaches experienced Excel users how to use Excel's What-If tools: Goal Seeker, Solver, Scenario Manager, and Data Tables. The student will learn how to install Excel's add-in tool AnalysisPak that comes with Excel but is not loaded, and will explore using it to create complex analyses such as Histograms, Rank and Percentile Analysis, and Descriptive Statistics. The student will also learn how to use the Data Tools group to separate text into multiple columns, remove duplicates, set up data validation in cells, and consolidate data from multiple ranges. Great course for managers who need to analyze data to make management decisions!

This course teaches experienced Excel users how to use Excel's What-If tools: Goal Seeker, Solver, Scenario Manager, and Data Tables. The student will learn how to install Excel's add-in tool AnalysisPak that comes with Excel but is not loaded, and will explore using it to create complex analyses such as Histograms, Rank and Percentile Analysis, and Descriptive Statistics. The student will also learn how to use the Data Tools group to separate text into multiple columns, remove duplicates, set up data validation in cells, and consolidate data from multiple ranges. Great course for managers who need to analyze data to make management decisions!

In this course the student will learn how to convert rows and columns of data into a table, and then use an Excel table to manage that data independently from the data in other rows and columns on the worksheet. Table features include: sorting and filtering; formatting table data; inserting and deleting table rows and columns; using a calculated column; and displaying and calculating table data totals.
Pivot tables are another powerful tool that can be used to summarize thousands of rows of data in a matter of seconds. You can then change your analysis on the fly by simply moving data from one area of the pivot table to another area. You can group, sort, and filter pivot table data, perform calculations within the pivot table, and add and remove subtotals and grand totals with ease. And finally, you can create charts that can be filtered on the fly just like the pivot table.

In this course the student will learn how to convert rows and columns of data into a table, and then use an Excel table to manage that data independently from the data in other rows and columns on the worksheet. Table features include: sorting and filtering; formatting table data; inserting and deleting table rows and columns; using a calculated column; and displaying and calculating table data totals.
Pivot tables are another powerful tool that can be used to summarize thousands of rows of data in a matter of seconds. You can then change your analysis on the fly by simply moving data from one area of the pivot table to another area. You can group, sort, and filter pivot table data, perform calculations within the pivot table, and add and remove subtotals and grand totals with ease. And finally, you can create charts that can be filtered on the fly just like the pivot table.

In this course the student will learn how to convert rows and columns of data into a table, and then use an Excel table to manage that data independently from the data in other rows and columns on the worksheet. Table features include: sorting and filtering; formatting table data; inserting and deleting table rows and columns; using a calculated column; and displaying and calculating table data totals.
Pivot tables are another powerful tool that can be used to summarize thousands of rows of data in a matter of seconds. You can then change your analysis on the fly by simply moving data from one area of the pivot table to another area. You can group, sort, and filter pivot table data, perform calculations within the pivot table, and add and remove subtotals and grand totals with ease. And finally, you can create charts that can be filtered on the fly just like the pivot table.

In this course the student will learn how to convert rows and columns of data into a table, and then use an Excel table to manage that data independently from the data in other rows and columns on the worksheet. Table features include: sorting and filtering; formatting table data; inserting and deleting table rows and columns; using a calculated column; and displaying and calculating table data totals.
Pivot tables are another powerful tool that can be used to summarize thousands of rows of data in a matter of seconds. You can then change your analysis on the fly by simply moving data from one area of the pivot table to another area. You can group, sort, and filter pivot table data, perform calculations within the pivot table, and add and remove subtotals and grand totals with ease. And finally, you can create charts that can be filtered on the fly just like the pivot table.

This course is designed to introduce the use of VBA programming within the Microsoft Excel environment. Programming basics, including logical concepts and the language of syntax, will be discussed, as well as the basics of Excel’s Visual Basic Editor and the VBE window. Topics will include module design, function procedures, and decision loop statements. Students will create custom messages and input boxes, and create custom Macros that make decisions and take action based on those decisions.
Prerequisite: Excel I & II or equivalent knowledge.

Excel Visual Basic Application II
This course takes the student’s knowledge of VBA within Excel to the next level. You will learn more about the VBA toolkit—the Visual Basic Editor, the Object Browser, and the Object Library, as well as how to debug and troubleshoot the programs you have designed through error handling and error trapping protocol. Topics will include working with object properties, methods, and events to modify the appearance, behavior, and actions performed by Excel objects. Students will also learn how to create custom function procedures.
Prerequisite: Excel Visual Basic Application I

Built-in Functions are formulas that Excel has predefined. These functions are designed to quickly perform calculations with a minimum of effort on the part of the user. Excel has already determined the necessary mathematical steps required and only needs to be given the arguments in order to complete the calculation—that is, the cell addresses or ranges where pertinent information is stored. There are over 200 built-in functions in Excel 2007 and over 300 in Excel 2010.
While a few commonly used functions were covered in Excel I, II, and III, this course covers a broader spectrum and introduces the student to a wide range of useful and versatile functions that most users haven’t discovered yet. It will also cover tips and tricks on how to combine several functions to add even more outcome possibilities.

Built-in Functions are formulas that Excel has predefined. These functions are designed to quickly perform calculations with a minimum of effort on the part of the user. Excel has already determined the necessary mathematical steps required and only needs to be given the arguments in order to complete the calculation—that is, the cell addresses or ranges where pertinent information is stored. There are over 200 built-in functions in Excel 2007 and over 300 in Excel 2010.
While a few commonly used functions were covered in Excel I, II, and III, this course covers a broader spectrum and introduces the student to a wide range of useful and versatile functions that most users haven’t discovered yet. It will also cover tips and tricks on how to combine several functions to add even more outcome possibilities.

Built-in Functions are formulas that Excel has predefined. These functions are designed to quickly perform calculations with a minimum of effort on the part of the user. Excel has already determined the necessary mathematical steps required and only needs to be given the arguments in order to complete the calculation—that is, the cell addresses or ranges where pertinent information is stored. There are over 200 built-in functions in Excel 2007 and over 300 in Excel 2010.
While a few commonly used functions were covered in Excel I, II, and III, this course covers a broader spectrum and introduces the student to a wide range of useful and versatile functions that most users haven’t discovered yet. It will also cover tips and tricks on how to combine several functions to add even more outcome possibilities.

This class will explain the various parts of your computer and how to enjoy using it. The class will begin with a discussion of what a computer actually does and how it does it.
Computer terminology such as RAM,ROM and CPU will be explained. You will not only learn how to interact with the Windows Operating System; but, also how to use the Windows OS filing system to efficiently store data that you create and wish to retain.

A computer requires an operating system to provide necessary instructions on a variety of processes including loading programs, managing data, displaying information, and directing the flow of information to peripheral equipment. Windows is an operating system that provides these functions along with a graphical user interface that features easy-to-use icons and buttons. In this course, you will earn the basic features of Windows and learn how to:
• Use desktop icons and the Taskbar to launch programs and open files and folders
• Organize and manage data, including copying, moving, creating, and deleting files and folders
• Customize the desktop by changing the theme, background, colors, settings, and adding a screen saver
• Perform regularly scheduled maintenance that keeps your computer running at optimum performance
• Use the Help and Support Center features
Knowing how to save, locate, and organize computer files will make you more productive when you are working with a computer. Knowing how to regularly perform maintenance on your computer will save you time and money. Prerequisites: General access to a computer or equivalent knowledge

This class will explain the various parts of your computer and how to enjoy using it. The class will begin with a discussion of what a computer actually does and how it does it. Computer terminology such as RAM, ROM, and CPU will be explained. You will not only learn how to interact with the Windows Operating System, but also how to use the Windows OS filing system to efficiently store data that you create and wish to retain

Introduction to Computers II
This class will cover the System Properties that provide pertinent information about your computer and Operating System, and the System Tools that are available to help you maintain your computer. You will also learn how to use the extensive Help System that is an essential resource for novice user. How to use the Internet and E-Mail will be covered, along with information on the use of Scanners and Digital Cameras with a computer. Last but not least, the operating system’s security features will be reviewed, as well as commercially available virus protection software.

The first thing you'll see when you open Microsoft Office 2013 is a clean, new look. But the features you know and use are still there-along with some new ones that are huge time savers. The new Office 2013 also works with smartphones, tablets, and in the cloud, even on PC's that don't have Office installed. So now you can always get to your important files, no matter where you are or what you're using.
This course will cover the changes from Microsoft Office 2007/10, introducing the student to revised Ribbon and Backstage features as well as new functionality within Word, Excel, PowerPoint and Outlook.

Prerequisite: Working knowledge of Word, Excel, PowerPoint and Outlook.

You'll learn the most efficient way to send and receive e-mail; forward your messages; set up mailing lists; automatically archive old mail; sort and search for messages; track contacts; and print an address/phone list to take with you when you travel. You'll also learn how to use the Calendar applet to schedule appointments and events. You'll learn how to set reminders for appointments so that you are never late and how to track task and due dates.

Microsoft Publisher is a desktop publishing program designed for business users who are serious about creating professional-looking marketing and business materials without the assistance of a professional designer. This course will cover creating flyers, brochures, newsletters, and business cards.

This course will introduce the student to the extensive range of templates that Microsoft offers, reviewing how to modify them to suit specific needs. The student will complete hands-on projects designed to increase knowledge in customizing brochures and newsletters.

The perfect document is easy to create in Microsoft Word. In this hands-on class, you'll work live in the application as you learn to create, open and save documents. You will also learn to format words, sentences, and paragraphs to appear just how you want. Dress up your documents with fancy borders and bullets and learn to print. Catch your spelling and grammar mistakes before somebody else does with Word's powerful spelling and grammar checker.

The perfect document is easy to create in Microsoft Word. In this hands-on class, you'll work live in the application as you learn to create, open and save documents. You will also learn to format words, sentences, and paragraphs to appear just how you want. Dress up your documents with fancy borders and bullets and learn to print. Catch your spelling and grammar mistakes before somebody else does with Word's powerful spelling and grammar checker.

The perfect document is easy to create in Microsoft Word. In this hands-on class, you'll work live in the application as you learn to create, open and save documents. You will also learn to format words, sentences, and paragraphs to appear just how you want. Dress up your documents with fancy borders and bullets and learn to print. Catch your spelling and grammar mistakes before somebody else does with Word's powerful spelling and grammar checker.

Want to become the office productivity guru? This course is full of time-saving tools that you'll use every day. In fact, you'll wonder how you ever go anything done without Word's customized styles and templates. Learn to use columns and tables to produce reader friendly documents and dress them up with advanced graphics. Master Word's mail merge tools to automate everything from letters to envelopes and labels.

Want to become the office productivity guru? This course is full of time-saving tools that you'll use every day. In fact, you'll wonder how you ever go anything done without Word's customized styles and templates. Learn to use columns and tables to produce reader friendly documents and dress them up with advanced graphics. Master Word's mail merge tools to automate everything from letters to envelopes and labels.