INTRO TO ACCESS COURSE DESCRIPTION

ACCESS BASICS: 
 

Create, edit, save, and print information in a simple one-table database. 
 

CREATE & EDIT TABLES:
 

Use Design View to create and edit tables. Add, format, move, and delete fields. Enter, edit, and delete data in Datasheet View. Adjust width of columns and change font/font size of text. Add Default Values, Lookup fields, and Input Masks to speed up data entry. 
 

CREATE & EDIT FORMS: 
 

Create forms based on tables. Enter and edit data and forms. Change background color of form, as well as move and resize fields. 
 

SORT AND FILTER DATA: 
 

Use Find & Replace to locate and/or change data, use Quick Sort to sort data alphabetically, use Filter by Selection to search for specific data in tables. 
 

CREATE QUERIES: 
 

Sort and filter data using different criteria such as name, amount, and date. Use multiple criteria to narrow a search, use wildcards, sort by range of dates or amounts, etc. 
 

REPORTS: 
 

Use Report Wizard to create professional looking reports based on tables and queries. Edit reports in Design View. 

ADVANCED ACCESS COURSE DESCRIPTION

ADVANCED QUERIES: 
 

Query multiple tables. Create Parameter Queries that do the work of many different queries. Perform multiple sorts using more than one criteria. 
 

RELATIONSHIPS: 
 

Create, edit, and delete relationships (links between different tables.) Learn about one-to-one, one-to-many, and many-to-many relationships. 
 

MACROS: 
 

Create macros that automate basic actions such as running queries and reports, finding data, etc. 
 

FORMS: 
 

Create forms with sub-forms. Add buttons to forms to run macros. 
 

EXPRESSIONS: 
 

Use expressions to perform calculations in queries, forms, and reports. Add, subtract, multiply, and divide numeric data. 
 

SWITCHBOARD (MAIN MENU): 
 

Create a Switchboard (or main menu) with buttons to organize your tables, macros, queries and forms into one central place. 
 

SHARE DATA WITH WORD: 
 

Merge names and addresses from an Access database into a Word form letter. 
 

INTRO TO EXCEL COURSE DESCRIPTION

EXCEL BASICS:  
 

Create, Open, Close, Save, Preview, and Print a spreadsheet. 
 

FORMATTING: 
 

Add borders, patterns (background colors). Center, Bold, Italicize, change font/font size. Apply an AutoFormat that includes borders, patterns, and other formatting. Convert numbers to currency or percentages. Add ClipArt and pictures, rename a spreadsheet, etc. 
 

AUTOSUM: 
 

Use AutoSum to add numbers. 
 

FORMULAS: 
 

Use Formulas to add, subtract, multiply, and divide numbers, calculate percentages. Use Absolute Cell References in Formulas. Learn how to copy Formulas. 
 

FUNCTIONS: 
 

Use Functions to average numbers, determine the highest and lowest numbers, etc. Learn how to copy Functions. 
 

EDIT A SPREADSHEET: 
 

Select (highlight) cells. Copy, Move, Format, and Delete text and numbers. Resize rows and columns. Add Headers and Footers to spreadsheet. Learn about various printing options. 
 

ADVANCED EXCEL COURSE DESCRIPTION

MANAGING SPREADSHEETS & WORKBOOKS:  
 

Insert, copy, move, and delete columns, rows and spreadsheets. Copy data from one spreadsheet to another. Name cell ranges. Split panes to view different parts of spreadsheet simultaneously. Freeze and Unfreeze panes to view titles while scrolling down a page. Add notes to a cell. Sort data.   
 

TEMPLATES: 
 

Create and edit a Workbook Template, complete with formulas, functions, AutoSum, titles, borders, clip art, etc., so you can base new spreadsheets on it. 
 

ADVANCED FORMULAS & FUNCTIONS: 

Use 3-D Formulas to combine data from multiple spreadsheets located within the same workbook (file). Link Workbooks to combine data located in separate workbooks (files). Use Functions such as Count, CountIf, SumIf, and If Statements to calculate text or numeric values. "Nest" one function within another. Use Conditional Formatting.

HLOOKUP & VLOOKUP: 

Use HLookup and VLookup to look up text or numeric values contained in rows or columns.
 

VALIDATION: 

Use Validation to improve speed and accuracy of data entry. Add drop-down lists and pop-up explanation boxes.

PIVOT TABLES: 

Use Pivot Tables to summarize rows of data for reports.

CHARTS & FORMS: 

Insert, Move, Edit, and Resize a variety of different charts. Create Forms to speed up data entry, editing, and searching.

MISC.:

Create simple Macros to automate basic tasks, add Hyperlinks to connect spreadsheets to Word documents and other files, add Comments to provide documentation for user, Protect a Worksheet or Workbook so it cannot be changed, etc. 

INTRO TO FRONTPAGE COURSE DESCRIPTION

FRONTPAGE BASICS:  
 

Create, edit, save, and upload a website. 
 

HYPER-LINKS: 
 

Use hyper-links to connect different pages within your website, connect to other websites, or add an e-mail link so people can contact you. 
 

TABLES: 
 

Create and format a variety of tables to organize and provide a framework for design elements on web page. Change the border size, padding, spacing, alignment, and color scheme. Format the text inside the table. 
 

GRAPHICS: 
 

Add graphics to a web page, change the size and position of the graphic, adjust brightness and contrast, crop picture, create a thumbnail, etc. 
 

SOUNDS & VIDEO: 
 

Add sound and video your web site.  
 

MISC.:
 

Add hover buttons, search form, marquee, table of contents, etc.
 

RENTING WEB SPACE: 
 

Learn what to look for when renting web space, where the best deals are, and what to expect from a web hosting company. 
 

UPLOADING FILES: 
 

Learn to use FrontPage to publish (upload) your web site files to your web hosting company’s server. 

INTRO TO HTML COURSE DESCRIPTION

HTML BASICS: 
 

Learn about HTML tags, elements, and attributes. Format text and paragraphs, change color of text and background. 
 

HYPER-LINKS: 
 

Create hyper-links to different pages in your web site, an external website, or to an e-mail address. 
 

GRAPHICS: 
 

Add graphics to a web page and change the size, position of the graphic. 
 

SOUNDS & VIDEO: 
 

Add sound and video your web site. 
 

TABLES 
 

Add a table to your web site. Change the border size and color scheme. Format the text inside the table. 
 

FINDING A WEB HOST: 
 

Learn what to look out for when renting web space, where the best deals are, and what to expect from a web hosting company. 
 

UPLOADING FILES: 
 

Learn to use WS_FTP to upload your web site files to your web hosting company’s server. 

INTRO TO PHOTOSHOP COURSE DESCRIPTION

TOOLS: 
 

Learn how to use the tools, menus, and palettes in Photoshop. Learn how to change foreground and background color. Use the Paintbrush, Pencil, Eraser, Fill Tool, Gradient, Zoom, Move, and other tools. 
 

EDIT PHOTOGRAPHS 
 

Learn how to lighten, darken, blur, and sharpen portions of a photograph. Adjust color balance, change color schemes, apply filters for artistic effects, etc. Erase, crop, and combine images. Select different parts of an image. Copy & paste.  
 

FILE FORMATS & MODES
 

Learn about and work with different file formats and modes. 
 

TEXT AND SHAPES 
 

Add and format text. Add shapes and learn how edit, format, and rotate them.  
 

LAYERS:
 

Learn how to add, move, and delete layers. Include layers with solid color backgrounds, gradients, and patterns. Select portions of different photos and combine them into one.
 

INTRO TO POWERPOINT COURSE DESCRIPTION

POWERPOINT BASICS:  

Create, edit, close, open, view, save, and run presentations. 
 

PRESENTATION ELEMENTS: 

Create, edit, view, move, and delete slides. Move and resize placeholders. Change slide layout. 
 

WORK WITH SLIDES: 

Add slides containing Clipart, Tables, Graphs, and Organization Charts. 
 

WORK IN DIFFERENT VIEWS: 

Use Slide View to create and edit slides. Use Outline View to quickly enter text. Use Slide Sorter View to copy, move, and delete slides. Use Notes Pages View to add speaker’s notes. 
 

SPECIAL EFFECTS: 

Add "Transitions" between slides, and "Builds" to bulleted lists. Add Slide Timings to run a presentation automatically. Add sound effects. Adjust the speed of different special effects. 
 

DRAWING TOOLS: 

Draw squares, circles, arcs, freehand objects, etc. Use AutoShape feature. Rotate drawing elements. 
 

QUICKBOOKS BASICS: 
 

Navigating in QuickBooks, setting-up a company, working with Chart of Accounts.  

LISTS:  
 

Create & Edit Customer, Vendor, and Item lists (products, services, taxes, and shipping) 
 

INVOICES AND PAYMENTS
 

Create, Edit, Customize, and Print invoices. Apply full or partial payments to open invoices. Handle discounts, credits, refunds for customers, and make deposits. 
 

INVENTORY: 
 

Set-up inventory, create purchase orders, receive items and bill.  

 

WRITE CHECKS: 
 

Handle QuickBooks checks or handwritten checks. Edit, Void, Split, Delete & Memorize checks. Handle ATM withdrawals, EFTs, etc.
 

RECONCILE STATEMENTS:  
 

Reconcile checking, savings, and credit card accounts. 
 

REPORTS AND GRAPHS: 
 

Create, customize, and memorize a wide variety of reports & graphs. 
 

ACCOUNTS PAYABLE: 
 

Use Accounts Payable to enter and pay bills. Handle discounts and credits with vendors.
 

MISC.: 
 

Use FIND feature to locate information. Use TO DO and REMINDERS lists to keep track of information. Memorize groups of invoices or payments to save time. Set-up budgets.
 

ESTIMATES & INVOICES : 
 

Create estimates. Base invoices on information in an estimate. Add Reimbursable Expenses to invoices and mark-up the amounts to make a profit.
 

TIME TRACKING 
 

Use Timesheets or Timer to track time for different projects and use Timesheet data for invoicing, in payroll, and P&L reports. 
 

EXCEL & WORD 
 

Export QuickBooks reports to Excel so you can customize them. Create letters in Word using QuickBooks data. 
 

BAD CHECKS 
 

Handle bad checks and NSF fees. 
 

PAYROLL & SALES COMMISSIONS 
 

Set up payroll, track commissions for employees, run commission reports. 
 

MISC. 
 

Do Journal Entries, work with Classes, use Year-end Close feature, make Inventory Adjustments, set-up Fixed Assets, etc. 
 

INTRO TO WINDOWS COURSE DESCRIPTION

SCREEN ELEMENTS: 
 

Learn about the Desktop, Title bar, Menu bar, Toolbar, Minimize, Maximize, Restore, and Close buttons 
 

NAVIGATING IN WINDOWS: 
 

Four basic mouse techniques used in Windows. Minimize, Maximize, Restore, Move, and Resize windows. Multitasking (running more than one program at a time). Viewing multiple programs simultaneously 
 

FILE MANAGEMENT:
 

Save, Close, Open and Print files. Rename, Copy, and Delete files. Installing and un-installing software. Copying a file to or from a floppy disk. 
 

SHORTCUTS: 
 

Create, rename, and delete shortcuts to files and programs. 
 

SEARCH/FIND: 
 

Locate and open files and programs. 
 

RECYCLE BIN: 
 

Delete and Restore files and shortcuts. 
 

CUSTOMIZE WINDOWS:  
 

Change mouse, keyboard, Desktop, and screen saver settings. Move, Re-Size, and Hide the Taskbar, etc. 
 

INTRO TO WORD COURSE DESCRIPTION

WORD BASICS: 
 

Create, Close, Save, Preview, and Print documents. Learn keyboard shortcuts to move around in a document. Learn shortcuts for selecting (highlighting) text with mouse. 
 

FORMAT DOCUMENT: 
 

Change margins, justification, and line spacing. Add borders and shading, page numbers, headers & footers, special symbols and characters, clip art. Indent paragraphs, add footnotes and endnotes. 
 

FORMAT TEXT: 
 

Bold, italicize, and underline text, change font, change font size. Add bullets and numbers. 
 

EDIT TEXT: 
 

Cut and Paste, Copy and Paste, Drag and Drop text. Delete text, Undo and Redo actions. 
 

MISC: 
 

Run Spell Checker, Grammar Checker,  and Thesaurus. Add new words to AutoCorrect dictionary. 
 

ADVANCED WORD COURSE DESCRIPTION

MAIL MERGE: 
 

Combine a list of names and addresses with a Word form letter. Combine an Access database with a Word form letter 
 

COLUMNS: 
 

Insert columns, change number and width of columns. Format text in columns (center, bold, etc.) 
 

TABLES: 
 

Add and delete columns and rows. Adjust width of columns and rows. Split and merge cells. Format text in tables (center, bold, etc.). Calculate numbers and sort data. 
 

CREATE MAILING LABELS AND ENVELOPES: 
 

MACROS: 
 

Use macros to automate basic actions (format a document, add name and address). 
 

MISC.: 
 

Work with multiple documents (open and switch between files). Insert page breaks, section breaks, and column breaks into a document. Use AutoText to automate data entry.