Access Beginning Objectives

Upon the completion of the Beginning Access class participants, will be able to:

• Start Microsoft Access and create a new blank database or open previously prepared database.
• Identify the menu, task panes, toolbars and objects of the MS Access window.
• Create a Table using both the wizard and the design view.
• Given a Table be able to add and change the primary key.
• Add a field to a Table and change the properties of a previously created field.
• Modify the column widths and row heights of a given Table.
• Add new records and modify old records in a given Table.
• Add an input mask to a field.
• Insert an OLE object into a table.
• Given a prepared Table sort the data.
• Use a wizard to create a form to enter data in a given Table.
• Filter data by Selection and Form in a given Table.
• Filter data by Form with more than one variable in a given Table.
• Create a Query using a wizard for a given Table.
• Create a Query in the design view for a given Table.
• Add a calculation field to a Query in the design view.
• Given a prepared database establish a relationship between two Tables.
• Given a prepared database create a Query between multiple Tables for a Report.
• Given a prepared database create a report using the wizard from both a Query and a Table.
• Create a form with a Combo Box.
• Format a form in the design view by adding a title and moving various controls.
• Modify labels in a form using the properties window.

Access Intermediate Objectives

Upon the completion of the Intermediate Access class participants will be able to:

• Create and Run a Macro to that will run a report.
• Create a Macro with a filter.
• Create and apply an input mask to a field in a given table.
• Add a switchboard, to a given database, with buttons to various switchboard pages.
• Given a database with more than two tables create a form with a sub-form using the wizard.
• Given a database create a pivot table for a table.
• Given a database create a pivot chart for a table.
• Prepare data in an Excel worksheet to be imported into an Access database.
• Export contacts from MS Outlook into an access database file.
• Import from a MS Access table to MS Outlook contacts.
• Create an Access Page from a given table.

Access Advanced Objectives

Upon the completion of the Advanced Access class participants will be able to:

• Define the components of a MS Access expression.
• Use the Expression Builder to create an expression.
• Build an expression in a table of a given Access database.
• Build an expression in a control box of a Report of a given Access database.
• Build and use an expression in the criteria box of a Query.
• Add an expression to a field portion of a Query.
• Use an expression in the validation rule of a Table in a given Access database.
• Use an expression in the validation rule in the property of a control of a Form of a given Access database.
• Define bound, unbound and calculated controls in Forms and Reports of a given Access database.
• Given a scenario and some data in an excel workbook design a simple Access database that will solve the problems put forth in the scenario.

Excel Beginning Objectives

Upon the completion of the Beginning Excel class participants will be able to:

• Demonstrate how to open a workbook and know difference between workbook and worksheet.
• Identify the parts of a worksheet window.
• Open a given workbook and be able to change views.
• Create a blank workbook then name and save it to a specific location.
• Recall algebraic rules that govern order of operation.
• Format cells using text, number, percentages and currency.
• Rotate text in a cell.
• Enter and edit data, modify column and rows with respect to height and width, and sort data.
• Add a worksheet to a given workbook and modify the color, name and location of its tab.
• Use simple formulas and functions (such as min, max, count, sum, and average),
• Use a spreadsheet to compute “loan payments” by using financial functions.
• Understand and use absolute and relative cell references in formulas.
• Copy values and formulas down and over in a worksheet.
• Use the AutoSum tool on rows and columns in a worksheet.
• Enter data into a cell and use the “merge and center" tool to combine a number of cells into one cell.
• Set print areas, change print options and print documents.
• Use the “Date” and “Now” functions in a worksheet.
• Calculate the difference between two given dates in a worksheet.
• Use various means for sorting data in a worksheet.
• View and print the formulas version of a worksheet.

Excel Intermediate Objectives

Upon the completion of the Intermediate Excel class participants will be able to:

• Demonstrate how to add a header and footer, change margins and insert a page break.
• Add comments to a cell on a given worksheet.
• Create a variety of charts from data in a given worksheet.
• Use the Format Painter button to copy the formatting from one group of cells to another.
• Enter data and then use border thickness and color to highlight and enhance.
• Use conditional formatting for a specific set of data in a given worksheet to highlight specific data.
• Name Cells in a given worksheet and use those names in a formula.
• Use the COUNTIF, IF and VLOOKUP functions in a given worksheet.
• Explore advanced format painting, styles, and additional formulas and functions.
• Assign a name to a cell and refer to the cell in a formula by using the assigned name.
• Demonstrate how to create and use a template.
• Given a worksheet be able to display subtotals.
• Add a hyperlink to a worksheet element.
• Show how to use the find and replace command in a given worksheet.
• Protect and unprotect cells in a worksheet.
• Split worksheet windows.
• Freeze rows and columns in a given worksheet.

Excel Advanced Objectives

Upon the completion of the Advanced Excel class participants will be able to:

• Create a List from a set of data entered in a spreadsheet.
• Add records to a List.
• Do a simple sort of a List.
• Add computational fields to a List.
• Sort a List by one or multiple fields.
• Compose and use a query for a List.
• Use the Totals button to open and close the Totals row and use various options in the Total row.
• Use the Criteria create a query from a list and print results.
• Apply database functions, the SUMIF function and the COUNTIF function to generate information from a list
• Create a Pivot Table from a given set of data on a worksheet.
• Create a Pivot Chart from a given set of data on a worksheet.
• Create an amortization schedule on a blank spreadsheet.
• Use the Excel Speaks function to listen as you enter and review data on worksheet.
• Use the Concatenate function in a worksheet.
• Create a document in Excel.

Outlook Basic Objectives

Upon the completion of the Outlook class participants will be able to:

• Navigate and modify the various views of MS Outlook.
• Open and read emails and any attachments.
• Turn the Desktop Alert off and on as desired.
• Send a new email to a contact or someone listed in an address book.
• Add an attachment, with varying options, to an email.
• Send an email of high importance.
• Sort emails by varying options.
• Create a new folder and save specific messages in that folder.
• Set up Rules to manage incoming or outgoing messages.
• Set up a list of Safe Senders for filtering emails.
• Set up a list of Blocked Senders for filtering emails.
• Set up Signatures for your emails.
• Select a Signature for a specific email.
• Change from one view to another in the MS Outlook Calendar.
• Set up a one time appointment in the Calendar.
• Set up a recurring appointment in the Calendar.
• Use the Calendar option to set up a meeting and invite specified attendees.
• Set up a recurring meeting using the Calendar option of MS Outlook.
• Create a new Contact.
• Using the various Tabs modify information about a current Contact.
• Create an email Distribution List.
• Set up a “to do” list using the Tasks option in Outlook.
• Assign a Task to another person and track the progress.
• Understand the function of Notes, Folder List, Journal and Shortcuts in Outlook.

PowerPoint Level 1 Objectives

Upon the completion of the Level 1 PowerPoint class participants will be able to:

• Start Microsoft PowerPoint and open a new blank presentation or a previously prepared presentation.
• Identify and name the various components of the PowerPoint window.
• Understand and change between various views.
• Create a new presentation from a template.
• Add a new slide to a presentation and change its layout.
• Resize, change the position and shape of a text box in a slide.
• Add a new slide into which the participant will add both text and clip art.
• Use the drawing toolbar to add some basic shapes and lines to a slide.
• Open a previously prepared presentation and apply a new design template.
• Add a slide transition to a specific slide and then to all slides of a presentation.
• Apply an animation scheme to the text of a slide.
• Apply custom animation to selected text and graphics of a slide.
• Insert a sound clip into a slide.
• Use the Outline Pane to change text on slides and to promote and demote text in bulleted lists.
• Identify the various print options for a presentation.
• Create a presentation starting with a prepared Word document.

PowerPoint Level 2 Objectives

Upon the completion of the Level 2 PowerPoint class participants will be able to:

• Insert and manipulate an AutoShape into a presentation.
• Insert and format text inside an AutoShape.
• Rotate, resize and move an AutoShape in a slide.
• Add a floating toolbar to a workspace.
• Use the drawing toolbar to add shapes and lines to a slide.
• Add and format WordArt on a slide.
• Use the flowchart option on the AutoShape menu to create a flowchart.
• Add an Organizational chart to a slide using the Diagram or Organization Chart tool on the drawing toolbar.
• Create and format a Table on a blank slide.
• Create a chart on a blank slide from given data.
• Download design templates from an online source.
• Change the color scheme of a selected design template for a presentation.
• Edit individual colors in a color scheme.
• Format text to given specifications.
• Import an outline from Word into a presentation.
• Modify the text and background on the Slide Master for a given presentation.
• Change the design template and modify the Title Master and Slide Master of a given presentation.
• Add date, name and slide number to the Header and Footer of a given presentation.
• Create a photo album presentation given a group of digital images.
• Print a given presentation as a Word document.
• Remove hidden data from a presentation and then save it.
• Save presentation as a web page.
• Use the Package for CD option for a given presentation.

PowerPoint Level 3 Objectives

Upon the completion of the Level 3 PowerPoint class participants will be able to:

• Use custom animation to create animation of text, clip art and pictures on a given slide.
• Apply various animation effects to a given slide.
• Add an action button the will play an audio sound clip to a given slide.
• Using an audio CD, have a track play on a specific slide on a given presentation.
• Rehearse timings for a presentation.
• Record narration for a presentation.
• Use the on-screen ink feature to highlight and emphasis points on a slide.
• Set up a show for various situations.
• Build a custom show using selected slides.
• Address security issues.
• Change the linked sound size limit.
• Communicate effectively as described by Dale Carnegie.

Word Beginning Objectives

Upon the completion of the Beginning Word class participants will be able to:

• Start Microsoft Word and open a new blank document or a previously prepared document.
• Identify the menu, task panes, toolbars and various views of the MS Word window.
• Use the commands “save” and “save as” to name and save their document to specific locations on the computer.
• Enter text and to use spell check, the thesaurus and dictionary.
• Use the File | Page Setup menu to set the margins and page orientation
• Format text to given specifications and to use the “Cut”, “Copy”, “Paste” and “Move” functions on text within a given document or between documents.
• Use the “Back Up” and “Redo” functions from the standard toolbar and menu.
• Open the Office Clipboard and use the “insert”, “clear all” and “paste all” functions.
• Use the “format painter” to transfer formatting from one portion of a document to another.
• Apply indentation, shading and borders to a paragraph.
• Set tabs from the Format | Tabs menu or insert and modify tabs manually on the ruler.
• Change the Style of a selected portion of a document.
• Investigate the various settings in the Tools | Option menu that can be modified for personnel preferences of the user.

Word Intermediate Objectives

Upon the completion of the Intermediate Word class participants will be able to:

• Use the “Insert Table” option under the Table menu to create a table in a MS Word document.
• Use the “Tables and Borders” toolbar to format a table with borders and shading to given specifications.
• Recreate a table from a given image using “Tables and Borders” toolbar options.
• Use the “Find”, ”Replace” and “Go To” functions under the Edit toolbar to find and/or replace given text in a document.
• Use various wildcard options in their Find/Replace search for text within a document.
• Set the options in the “Autocorrect” feature for MS Word.
• Set the “Options” for MS Word to control whether a “Drawing Canvas” will be created when an “AutoShape” is inserted into a document.
• Be able to insert an “AutoShape” into a blank document and add text and formatting.
• Use the “Header and Footer” toolbar to enter prearranged or custom information into the header and footer of a document.
• Use the “Page Set-up” window to change the header and footer options.
• Insert the current date within the document and have it set to update automatically.
• Use the “Word Count” feature located in the Tools menu to find the number of words in the document.
• Perform various sorting activities.
• Insert a “Hyperlink” into document and understand the various targets that may be linked to.
• Use the “Drop Caps” formatting option within a document.
• Use the “Section Break” and Format | Columns options to change the number of columns at a specific location within a document.
• (As an exercise) Create a newsletter from given specific information utilizing the lessons in this class.

Word Advanced Objectives

Upon the completion of the Advanced Word class participants will be able to:

• Create a new “Mail Merge” document using a template from the participant’s computer
• Merge data from a new list that the participant will create.
• Modify the fields on a “Data List” of information to be used in the “Mail Merge” document.
• Enter information into the “Data List” that has been created.
• Enter static information into the “Mail Merge” document and format the letter to given specifications.
• Enter specific “Blocks” and “Fields” into predetermined locations in the “Mail Merge” document.
• Sort data on the Data List, view specific data as it will appear in the document and then merge the data into a new document.
• Use the Mail Merge to create Labels, E-mails, Directories, and Envelopes.
• Use Access to update the List that was created by the participant.
• Create a form in Access that can be used to update a list used by the Mail Merge function.
• Given a MS Word document create macros to carry out specific formatting functions.
• Use the Paste Special command to copy from a web page to a MS Word document.
• Use the Track Changes function to make and review changes to a document.
• Add document protection at various levels limiting access to a document.