Software Training
Prerequisites: You should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Before taking Level 2 courses, it is recommended that you first take an introductory (Level 1) course, or have equivalent knowledge and skills.
Microsoft® Office Access® 2010: Level 1
Course Objectives: You will create and modify new databases and their various objects.
Target Student: This course is designed for students who wish to learn the basic operations of the Microsoft Access
database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.
Upon successful completion of this course, students will be able to:
- identify the basic components of an Access database.
- manage data in tables.
- design forms.
- build the structure of a database.
- query a database.
- generate reports.
Microsoft® Office Access® 2010: Level 2
Course Objectives: You will improve and customize tables, queries, forms and reports, and share data with other applications.
Target Student: This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.
Upon successful completion of this course, students will be able to:
- streamline data entry and maintain data integrity.
- join tables to retrieve data from unrelated tables.
- create flexible queries to display specified records, allow for user’s query criteria, and modify data using queries.
- improve forms.
- customize reports to organize the displayed information and produce specific print layouts.
- share data between Access and other applications.
Microsoft® Office Excel® 2010: Level 1
Course Objectives: You will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks.
Target Student: This course is designed for students who desire to gain the necessary skills to create, edit, format, and
print basic Microsoft Office Excel 2010 worksheets.
Upon successful completion of this course, students will be able to:
- create a basic worksheet by using Microsoft Excel 2010.
- modify an Excel worksheet.
- manage Excel workbooks.
- perform calculations in an Excel worksheet.
- modify the appearance of data within a worksheet.
- print the content of an Excel worksheet.
Microsoft® Office Excel® 2010: Level 2
Course Objectives: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Target Student: This course is meant for those desiring to gain advanced skill sets necessary for calculating data using
functions and formulas, sorting and filtering data, using Pivot Tables and Pivot Charts for analyzing data, and customizing
workbooks.
Upon successful completion of this course, students will be able to:
- use advanced formulas.
- organize worksheet and table data using various techniques.
- create and modify charts.
- analyze data using Pivot Tables, Slicers, and Pivot Charts.
- insert and modify graphic objects in a worksheet.
- customize and enhance workbooks and the Microsoft Office Excel environment.
Microsoft® Office Word® 2010: Level 2
Course Objectives: You will create complex documents and build personalized efficiency tools using Office Word 2010.
Target Student: This course is designed for persons who are able to create and modify standard business documents in
Word 2010, but need to know how to create or modify complex business documents & customized Word efficiency tools.
Upon successful completion of this course, students will be able to:
- manage lists.
- customize the formatting of a document using styles & themes.
- create customized graphic elements.
- control text flow.
- use the mail merge function.
- customize tables and charts.
- modify pictures in a document.
- insert content using Quick Parts.
- use templates to automate document creation.
- use macros to automate common tasks.
Updated December 2011