Class

1

• Class
• Instructor Name
• Date

2
Classroom Tips

• Class Roster Please Sign In
• Internet Usage
• Breaks and Lunch Break only
• Breaks
• 15 minutes break during both morning and
  afternoon
• Lunch will be a one hour break
• Bathroom Locations
• Books are yours to keep
• Media in book contains all of todays practice
  exercise files
• If you dont see a class you need, ask us to add
  it!

3
Introductions

• About Computer Concepts
• About the instructor
• Where do you work at the University?
• Experience with the software
• Goal for today?
• Are you a Sponge ? On Vacation ? Prisoner

4
Access 2007 Introduction Level 1

• Lesson 1 Exploring the Microsoft Access
  Environment
• Lesson 2 Designing a Database
• Lesson 3 Building a Database
• Lesson 4 Managing Data in a Table
• Lesson 5 Querying a Database
• Lesson 6 Designing Forms
• Lesson 7 Generating Reports

5
Access 2007 Intermediate Level 2

• Lesson 1 Controlling Data Entry
• Lesson 2 Joining Tables
• Lesson 3 Creating Flexible Queries
• Lesson 4 Improving Forms
• Lesson 5 Customizing Reports
• Lesson 6 Sharing Data Across Applications

6
Access 2007 Advanced Level 3

• Lesson 1 Structuring Existing Data
• Lesson 2 Writing Advanced Queries
• Lesson 3 Simplifying Tasks with Macros
• Lesson 4 Making Effective Use of Forms
• Lesson 5 Making Reports More Effective
• Lesson 6 Maintaining an Access Database

7
Access 2007 Level 4

• Lesson 1 Integrating Access into Your Business
• Lesson 2 Automating a Business Process with VBA
• Lesson 3 Managing Switchboards
• Lesson 4 Distributing and Securing Databases
• Lesson 5 Sharing Databases Using a SharePoint
  Site

8
Excel 2007 Introduction - Level 1

• Lesson 1 Creating a Basic Worksheet
• Lesson 2 Performing Calculations
• Lesson 3 Modifying a Worksheet
• Lesson 4 Formatting a Worksheet
• Lesson 5 Printing Workbook Contents
• Lesson 6 Managing Large Workbooks

9
Excel 2007 Intermediate - Level 2

• Lesson 1 Calculating Data with Advanced Formulas
• Lesson 2 Organizing Worksheet and Table Data
• Lesson 3 Presenting Data Using Charts
• Lesson 4 Analyzing Data Using PivotTables and
  PivotCharts
• Lesson 5 Inserting Graphic Objects
• Lesson 6 Customizing and Enhancing Workbooks and
  the Excel Environment

10
Excel 2007 Advanced - Level 3

• Lesson 1 Streamlining Workflow
• Lesson 2 Collaborating with Others
• Lesson 3 Auditing Worksheets
• Lesson 4 Analyzing Data
• Lesson 5 Working with Multiple Workbooks
• Lesson 6 Importing and Exporting Data
• Lesson 7 Using Excel with the Web
• Lesson 8 Structuring Workbooks with XML

11
PowerPoint 2007 Introduction Level 1

• Lesson 1 Getting Started with PowerPoint
• Lesson 2 Creating a Presentation
• Lesson 3 Formatting Text on Slides
• Lesson 4 Adding Graphical Objects to a
  Presentation
• Lesson 5 Modifying Objects
• Lesson 6 Adding Tables to a Presentation
• Lesson 7 Inserting Charts in a Presentation
• Lesson 8 Preparing to Deliver a Presentation

12
PowerPoint 2007 Advanced Level 2

• Lesson 1 Customizing the PowerPoint Environment
• Lesson 2 Customizing a Design Template
• Lesson 3 Adding Diagrams to a Presentation
• Lesson 4 Adding Special Effects to Presentations
• Lesson 5 Customizing a Slide Show Presentation
• Lesson 6 Collaborating on a Presentation
• Lesson 7 Securing and Distributing a Presentation

13
Word 2007 Introduction Level 1

• Lesson 1 Creating a Basic Document
• Lesson 2 Editing a Document
• Lesson 3 Formatting Text
• Lesson 4 Formatting Paragraphs
• Lesson 5 Adding Tables
• Lesson 6 Inserting Graphic Objects
• Lesson 7 Controlling Page Appearance
• Lesson 8 Proofing a Document

14
Word 2007 Intermediate Level 2

• Lesson 1 Managing Lists
• Lesson 2 Customizing Tables and Charts
• Lesson 3 Customizing Formatting with Styles and
  Themes
• Lesson 4 Modifying Pictures
• Lesson 5 Creating Customized Graphic Elements
• Lesson 6 Inserting Content Using Quick Parts
• Lesson 7 Controlling Text Flow
• Lesson 8 Using Templates to Automate Document
  Creation
• Lesson 9 Automating Mail Merges
• Lesson 10 Using Macros to Automate Tasks

15
Word 2007 Advanced Level 3

• Lesson 1 Using Microsoft Word with Other
  Programs
• Lesson 2 Collaborating on Documents
• Lesson 3 Managing Document Versions
• Lesson 4 Adding Reference Marks and Notes
• Lesson 5 Making Long Documents Easier to Use
• Lesson 6 Securing a Document

16
Project 2007 Introduction Level 1

• Lesson 1 Getting Started with Microsoft Project
• Lesson 2 Creating a Project Plan
• Lesson 3 Managing Tasks in a Project Plan
• Lesson 4 Managing Resources in a Project Plan
• Lesson 5 Finalizing the Project Plan

17
Project 2007 Advanced Level 2

• Lesson 1 Exchanging Project Plan Data with Other
  Applications
• Lesson 2 Updating a Project Plan
• Lesson 3 Managing Project Costs
• Lesson 4 Reporting Project Data Visually
• Lesson 5 Reusing Project Plan Information

18
Visio 2007 Level 1

• Lesson 1 Getting Started with Visio 2007
• Lesson 2 Creating a Route Map
• Lesson 3 Enhancing a Basic Diagram
• Lesson 4 Creating Process Diagrams
• Lesson 5 Representing an Organization Hierarchy

19
Visio 2007 Level 2

• Lesson 1 Creating a Custom Shape
• Lesson 2 Designing a Custom Stencil
• Lesson 3 Designing Styles and Templates
• Lesson 4 Designing a Floor Plan
• Lesson 5 Representing External Data in Visio
• Lesson 6 Sharing Your Work

20
Acrobat 9 Level 1

• Lesson 1 Accessing a PDF Document
• Lesson 2 Creating PDF Documents
• Lesson 3 Navigating to Specific Content in a PDF
  Document
• Lesson 4 Modifying PDF Documents
• Lesson 5 Working with Multiple PDF Documents
• Lesson 6 Reviewing a PDF Document
• Lesson 7 Validating a PDF Document

21
Adobe Acrobat 9 Level 2

• Lesson 1 Creating PDFs from Technical Documents
• Lesson 2 Enhancing PDF Documents  
• Lesson 3 Creating Interactive PDF Forms in Adobe
  LiveCycle Designer
• Lesson 4 Preparing PDF Files for Commercial
  Printing
• Lesson 5 Finalizing PDF Files for Commercial
  Printing

22
Adobe Photoshop CS4 Level 1

• Lesson 1 Exploring the Adobe Photoshop CS4
  Environment
•  Lesson 2 Determining Resolution and Graphic
  Type
• Lesson 3 Working with Selections
• Lesson 4 Working with Layers
• Lesson 5 Enhancing Images with Paint and Filters
• Lesson 6 Exploring Image Modes and Color
  Adjustments
• Lesson 7 Saving Images for Web and Print

23
Adobe Photoshop CS4 Level 2

• Lesson 1 Enhancing Images 
• Lesson 2 Working with Vector Paths
• Lesson 3 Applying Custom Fills
• Lesson 4 Working with Layers
• Lesson 5 Automating Tasks
• Lesson 6 Working with Video Files
• Lesson 7 Integrating with Other Adobe
  Applications

24
Adobe Indesign CS4 Level 1

• Lesson 1 Exploring the InDesign Environment
• Lesson 2 Designing Document
• Lesson 3 Enhancing Document
• Lesson 4 Working with Page Elements
• Lesson 5 Managing Objects
• Lesson 6 Working with Tables
• Lesson 7 Finalizing Documents

25
Adobe Indesign CS4 Level 2

• Lesson 1 Handling Page Elements
• Lesson 2 Managing Styles
• Sequence
• Lesson 3 Developing Complex Paths
• Lesson 4 Administering External Files
• Lesson 5 Working with an XML File
• Lesson 6 Managing Long Documents
• Lesson 7 Exporting InDesign Files in Other
  Formats
• Lesson 8 Adjusting Print Settings

26
Adobe Dreamweaver CS4 Level 1

• Lesson 1 Getting Started with Dreamweaver
• Topic 1C Customize the Interface
• Lesson 2 Building a Website
• Lesson 3 Working with Web Pages
• Lesson 4 Working with Reusable Site Assets
• Lesson 5 Working with Links
• Lesson 6 Uploading a Website

27
Adobe Dreamweaver CS4 Level 2

• Lesson 1 Working in Code View
• Lesson 2 Formatting with Advanced CSS Techniques
  
• Lesson 3 Working with AP Elements
• Lesson 4 Working with Spry Elements
• Lesson 5 Creating a Form
• Lesson 6 Integrating External Files with
  Dreamweaver

28
Adobe Illustrator CS4 Level 1

• Lesson 1 Getting Acquainted with Adobe
  Illustrator CS4
• Lesson 2 Creating Shapes in a Document
• Lesson 3 Creating Custom Paths
• Lesson 4 Working with Text
• Lesson 5 Enhancing Documents
• Lesson 6 Proofing a Document
• Lesson 7 Saving Images for Web and Print

29
Outlook 2007 Level 1

• Lesson 1 Getting Started with Outlook
• Lesson 2 Composing Messages
• Lesson 3 Organizing Messages
• Lesson 4 Managing Contacts
• Lesson 5 Scheduling Appointments
• Lesson 6 Scheduling Meetings
• Lesson 7 Managing Tasks and Notes

30
Outlook 2007 Level 2

• Lesson 1 Setting Calendar Options
• Lesson 2 Customizing Message Options
• Lesson 3 Tracking Work Activities Using the
  Journal
• Lesson 4 Managing Tasks
• Lesson 5 Sharing Folder Information
• Lesson 6 Customizing the Outlook Environment
• Lesson 7 Locating Outlook Items
• Lesson 8 Working with Public Folders

31
Access 2007 Classes

• Access 2007 Introduction Level 1
• Access 2007 Intermediate Level 2
• Access 2007 Advanced Level 3
• Access 2007 Level 4

32
Excel 2007 Classes

• Excel 2007 Introduction Level 1
• Excel 2007 Intermediate Level 2
• Excel 2007 Advanced Level 3
• Excel 2007 Macros Level 4
• Excel 2007 Tips and Tricks

33
Word 2007 Classes

• Word 2007 Introduction Level 1
• Word 2007 Intermediate Level 2
• Word 2007 Advanced Level 3

34
PowerPoint 2007 Classes

• PowerPoint 2007 Introduction Level 1
• PowerPoint 2007 Advanced Level 2

35
Project 2007 Classes

• Project 2007 Introduction Level 1
• Project 2007 Advanced Level 2

36
Outlook 2007 Classes

• Outlook 2007 Introduction Level 1
• Outlook 2007 Advanced Level 2

37
Thank You

• UHRM Computer Concepts would like to thank you
  for attending our class.
• Please complete the Feedback Survey and share
  with us how we can serve you better.
• Remember we offer other services
• One on One Training
• Consulting Services
• Database Development
• Graphic Design Consulting
• Website Design Consulting
• Contact 847.604.8421 or train_at_goccusa.com

38
(No Transcript)