Computer Training

Students will learn basic Access skills including:

• Identify the basic components of an Access database
• Build the structure of a database
• Manage data in tables
• Query a database
• Design forms
• Generate reports

Students will learn intermediate Access skills including:

• Learn to normalize data
• Work with Lookup fields and sub datasheets
• Create join queries
• Add objects to forms
• Print reports and labels
• Create charts
• Use PivotTables and Pivot Charts

Students will learn advanced Access skills including:

• How to query with SQL
• Create crosstab
• Parameter and action queries
• Create macros
• Import, export, and link database objects
• Work with XML documents
• Work with Windows SharePoint Services
• Optimize databases
• Password protect and encrypt databases
• Set Access options and properties
• Create 2007 to update data

Students will be given an introduction to spreadsheet terminology and Excel’s window components. Students will learn basic Excel skills including:

• Create a basic worksheet
• Perform calculations in an Excel worksheet
• Modify an Excel worksheet.
• Modify the appearance of data within a worksheet
• Manage Excel workbooks
• Print the content of an Excel worksheet

Students will learn how to use multiple worksheets and workbooks efficiently. Skill learned will include:

• Use advanced formulas
• Organize worksheet and table data using various techniques
• Create and modify charts
• Insert and modify graphic objects in a worksheet
• Customize and enhance workbooks and the Microsoft Office Excel environment

Students will learn advanced Excel skills including:

• Learn how to work with Pivot Tables and Pivot Charts
• Work with advanced formulas and functions
• Import and export data
• How to query external databases
• Running and recording macros
• Integrate Excel data with the web.
• Learn analytical features such as Goal Seek and Solver

This course covers new features of each Microsoft Office application.

Students will create new presentations and learn the following skills:

• Format text on slides
• Add graphical objects to a presentation
• Modify graphical objects in a presentation
• Work with tables in a presentation
• Add charts to a presentation
• Prepare to deliver a presentation
• Apply transition effects

Students will customize PowerPoint by modifying the Quick Access Toolbar and creating macros. Other skills learned in this class include:

• Customize a design template
• Add SmartArt graphics to a presentation
• Add special effects to a presentation
• Add multimedia content and interactive elements to slides
• Presentation distribution
• Integrating PowerPoint with Word and Excel

Performance-Based Objectives

• Set up a company
• Work with lists
• Set up inventory
• Prepare business forms

Performance-Based Objectives

• Write and print checks
• Process payments
• Work with bank accounts
• Enter and pay bills
• Create modify, memorize and print reports
• Apply password protection

Students will work with styles, sections, and columns. Skills learned in this workshop include:

• • Identify and work with basic Word tools and features
• Edit text in a Word document
• Insert special characters and graphical objects
• Organize data in tables
• Proof a Word document
• Control the appearance of pages in a Word document
• Print a Word document

Students will work with styles, sections and columns. Other skills learned will include:

• Manage lists
• Customize tables and charts
• Customize the formatting of a document using styles and themes
• Modify pictures in a document
• Create customized graphic elements
• Insert content using Quick Parts
• Control text flow
• Use templates to automate document creation
• Use the mail merge function
• Use macros to automate common tasks

Students will perform mail merges, create and use forms and create master documents. Other skills learned will include:

• Create macros
• Customize Quick Access toolbar and Keyboard shortcuts
• Manage document versions
• Work with XML documents
• Simplify the use of long documents
• Secure a document