print
Course Name
Microsoft Office 2007 Essentials

Contact Hours: 60
Course Description

This Microsoft Office course teaches you how to effectively use the Office 2007 Suite through comprehensive lessons and engaging quizzes, allowing the user to choose which lesson to learn. New users will be guided through the fundamentals of the new office interface, while experienced users will be brought up to speed on the new navigation and functionality of this 2007 edition. These courses will train you how to best meet your needs through the use of Word, Outlook, Excel, Powerpoint, and/or Access.
  • Overview: This training includes a complete overview of the instructor, product, and what to expect from the training.
  • Controls: Users can move throughout the training with their own controls. Play, Pause, Stop, or check their time while the product bar illuminates as they advance through a topic.
  • Course Map: Choosing which topic the user wants to learn is easy with the convenient course map. Advanced users may skip ahead or repeat users have the ability to pick up where they left off.
  • Bookmarks: This training tracks which topics the user has completed - displaying their progress through the course outline.
Outcome

  • Navigate through the new easy-to-use interface, ribbon, office button, contextual tabs, and galleries.
  • Create and share documents through the new, easy-to-use interface.
  • Create presentations with pictures, shapes, animation, and advanced delivery options.
  • Prepare professional charts and share data with coworkers, customers, and business partners.
  • Follow basic and advanced functions of e-mail, planning/scheduling features, and customizing the interface.
  • Track and report information with ease, modify pre-built applications, and share database information.
Assessment

Multiple-choice quizzes for each section covered allow the user to track their progress as they learn. Proficiency can be assessed at any time throughout the training.
Outline

Microsoft Access 2007: Beginner

  • 1.0 Getting Started
  • 1.1 About Relational Databases and Access 2007
  • 1.2 Launching Access 2007
  • 1.3 Touring the Access Environment
  • 1.4 Using the Office Menu
  • 1.5 Database Components
  • 1.6 Using the Navigation Pane
  • 1.7 Getting Help
  • 1.8 Opening and Closing Access Databases
  • 1.9 Creating an Access Database Using a Preloaded Template
  • 2.0 Working with an Existing Table
  • 2.1 Exploring Datasheet View
  • 2.2 Editing and Selecting Table Data
  • 2.3 Adding and Deleting Records
  • 2.4 Find and Replace
  • 2.5 Undo and Redo
  • 3.0 Working with an Existing Form
  • 3.1 Exploring Form View
  • 3.2 Editing and Selecting Form Data
  • 3.3 Adding and Deleting Records
  • 3.4 Find and Replace
  • 4.0 Sorting and Filtering
  • 4.1 Sorting a Table and a Form
  • 4.2 About Filters
  • 4.3 Common Filters
  • 4.4 Filter by Selection
  • 4.5 Filter by Form
  • 4.6 Advanced Filter
  • 5.0 Designing Select Queries
  • 5.1 Using the Query Wizard
  • 5.2 Using Query Design View
  • 5.3 Using Criteria
  • 5.4 Sorting and Showing Query Fields
  • 5.5 Adding Tables to a Query
  • 6.0 Form Basics
  • 6.1 Using the Forms Wizard
  • 6.2 Using the Form Tool
  • 6.3 Working with Form Design View
  • 6.4 Working with Form Layout View
  • 6.5 Working with Form Controls
  • 7.0 Report Basics
  • 7.1 Using the Reports Wizard
  • 7.2 Using the Report Tool
  • 7.3 Working with Report Design View
  • 7.4 Working with Report Layout View
  • 7.5 Working with Report Controls
  • 8.0 Printing Database Objects
  • 8.1 Printing Tables or Queries
  • 8.2 Printing Forms
  • 8.3 Printing Reports

Microsoft Access 2007: Intermediate

  • 1.0 Planning and Designing a Database
  • 1.1 Database Design Process
  • 1.2 Creating a Database Using a Wizard
  • 1.3 Creating a Database from Scratch
  • 2.0 Building and Modifying Tables
  • 2.1 Creating a Table Using a Table Template
  • 2.2 About Data Types
  • 2.3 Creating a Table in Datasheet View
  • 2.4 Creating a Table in Design View
  • 2.5 Using Field Templates
  • 2.6 Setting Primary Keys
  • 3.0 Working with Relationships
  • 3.1 Types of Relationships
  • 3.2 Referential Integrity
  • 3.3 Cascading Updates and Deletes
  • 3.4 Multi-Valued Fields
  • 3.5 Printing Relationships
  • 4.0 Sharing Your Data
  • 4.1 Export Your Access Report to Word
  • 4.2 Export Your Access Table to Excel
  • 4.3 Import Your Excel Spreadsheet into Access
  • 4.4 Copying the Table Structure and Data
  • 5.0 Enhancing Your Forms
  • 5.1 Using the Field List Task Pane
  • 5.2 Using the Forms Controls Group
  • 5.3 Adding and Formatting Labels
  • 5.4 Adding Graphics
  • 5.5 Adding Command Buttons
  • 6.0 Enhancing Your Reports
  • 6.1 Using the Reports Control Group
  • 6.2 Adding Graphic Details
  • 6.3 Working with White Space and Report Width

Microsoft Access 2007: Advanced

  • 1.0 Preventing Data Entry Errors
  • 1.1 Using the Lookup Wizard
  • 1.2 Data Validation
  • 1.3 Working with Combo Boxes
  • 1.4 Working with List Boxes
  • 2.0 Advanced Table Design
  • 2.1 Field Properties
  • 2.2 Using Input Masks
  • 2.3 Using the Datasheet Total Row
  • 2.4 Using Rich Text in the Memo Field
  • 3.0 Advanced Query Design
  • 3.1 Creating a Calculated Field
  • 3.2 Creating a Crosstab Query
  • 4.0 Advanced Form Design
  • 4.1 Split Forms
  • 4.2 Working with the Property Sheet
  • 4.3 Changing Control Tab Order
  • 4.4 Conditional Formatting
  • 4.5 Adding Tab Pages
  • 5.0 Advanced Report Design
  • 5.1 Creating Groups and Total Reports
  • 5.2 Working with Total Fields
  • 5.3 Adding Calculated Controls to a Report
  • 6.0 Managing Databases
  • 6.1 Identify Object Dependencies
  • 6.2 Database Documenter

Microsoft Access 2007: Expert

  • 1.0 Expertly Designed Select Queries
  • 1.1 Single Parameter Queries
  • 1.2 Multiple Parameter Queries