Course Descriptions

MS Publisher

MS Publisher is an industry-strength Desktop Publishing application. Students will learn to create customized documents from scratch. Students will create a multi-page document, import and format text and graphics, and create the document's layout.

ACCESS

Access provides a powerful set of tools that are sophisticated enough for professional developers, yet easy to learn for new users. Create or use powerful database solutions that make organizing, accessing, and sharing information easier than ever.

Access 2000: Level 1 is the first course in this series. Students will learn how to create and use database objects, including tables, queries, forms, and reports.

Access 2000: Level 2, the next course in this series, teaches students how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports.

Students who want to learn advanced features can take the third course in this series, Access 2000: Advanced. In that course, students learn to create advanced queries, create more efficient forms and reports, and work with macros.

MICROSOFT OFFICE CERTIFICATION

Access 2000: Level 1-3 is a series of classes that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. To successfully pass the Certification exam, you must take all three levels of Access.

Create brochures, flyers, and more using Word

Students will use a variety of desktop publishing techniques to create publications with Word. Here are the activities covered:

• Desktop publishing fundamentals; create a newsletter using Word
• Create an eye-catching coupon flyer
• Save money with a folded flyer
• Design a tri-fold brochure

Track and analyze your business data using Excel

Prerequisite: Excel 2000 Beginning or equivalent knowledge

Students will use a variety of functions and formulas to analyze and track data for a business. Here are the activities covered:

• Excel formulas "101"
• Build formulas to project sales
• Use lookup tables to find delivery charges
• Calculate loan payments

Upon successful completion of this lab, students will be able to:

• create simple formulas with cell references and functions
• use absolute and mixed cell references in formulas and use the Round function
• build formulas using the If and Vlookup functions
• create formulas with the PMT function to calculate loan payments

Manage Your Contacts Using Outlook and Other Office Applications

• Import contact information from an Excel spreadsheet into your Contacts folder
• Export the contacts in your contacts folder into an Excel spreadsheet.
• Import Access database information into your Outlook Contacts folder
• Export your contact information into an Access database
• Create a form letter in Word and use the Mail Merge to send them to your Outlook contacts
• Create mailing labels from your Outlook contacts using Mail Merge
• Forward a single contact to your partner
• Share contact information through folders
• Share your contacts by assigning permissions