Microsoft Corp. Microsoft Office System 2007

Microsoft Official Academic Course. Updated First Edition. – John Wiley & Sons, Inc., 2009. – 1226 p.
(Коллективное издание).Wiley’s publishing vision for the Microsoft Official Academic Course series is to provide students and instructors with the skills and knowledge they need to use Microsoft technology effectively in all aspects of their personal and professional lives. Quality instruction is required to help both educators and students get the most from Microsoft’s software tools and to become more productive. Thus our mission is to make our instructional programs trusted educational companions for life.
To accomplish this mission, Wiley and Microsoft have partnered to develop the highest quality educational programs for Information Workers, IT Professionals, and Developers. Materials created by this partnership carry the brand name "Microsoft Official Academic Course," assuring instructors and students alike that the content of these textbooks is fully endorsed by Microsoft, and that they provide the highest quality information and instruction on Microsoft products.
The Microsoft Official Academic Course textbooks are Official in still one more way—they are the officially sanctioned courseware for Microsoft IT Academy members.
The Microsoft Official Academic Course series focuses on workforce development. These programs are aimed at those students seeking to enter the workforce, change jobs, or embark on new careers as information workers, IT professionals, and developers. Microsoft Official Academic Course programs address their needs by emphasizing authentic workplace scenarios with an abundance of projects, exercises, cases, and assessments.
The Microsoft Official Academic Courses are mapped to Microsoft’s extensive research and job-task analysis, the same research and analysis used to create the Microsoft Certified Application Specialist (MCAS) and Microsoft Certified Application Professional (MCAP) exams. The textbooks focus on real skills for real jobs. As students work through the projects and exercises in the textbooks they enhance their level of knowledge and their ability to apply the latest Microsoft technology to everyday tasks. These students also gain resume-building credentials that can assist them in finding a job, keeping their current job, or in furthering their education.
The concept of life-long learning is today an utmost necessity. Job roles, and even whole job categories, are changing so quickly that none of us can stay competitive and productive without continuously updating our skills and capabilities. The Microsoft Official Academic Course offerings, and their focus on Microsoft certification exam preparation, provide a means for people to acquire and effectively update their skills and knowledge. Wiley supports students in this endeavor through the development and distribution of these courses as Microsoft’s official academic publisher.
Today educational publishing requires attention to providing quality print and robust electronic content. By integrating Microsoft Official Academic Course products, WileyPLUS, and Microsoft certifications, we are better able to deliver efficient learning solutions for students and teachers alike.Introduction Unit
Introduction to Office 2007
Lesson Skill Matrix
Key Terms
Software Orientation
Opening and Closing Office Applications
Starting an Office Application
Closing a Document
Closing an Office Application
Working in the Office Window
Using the Onscreen Tools
Use the Ribbon
Use the Mini Toolbar
Use the Quick Access Toolbar
Use KeyTips
Working with the Microsoft Office Button
Using the Microsoft Office Button
Opening an Existing Document
Saving a Document
Choosing a Printer
Setting Standard Properties
Assigning Keywords to a Document
Working with Microsoft Office Help
Using the Microsoft Office Help button
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWindows Basics
Lesson Skill Matrix
Key Terms
Getting Started with Windows Vista
Logging On to Windows Vista
Using the Mouse to Identify Desktop Items
Use the Start Menu
Opening and Closing the Start Menu
Identifying Items on the Start Menu
Selecting Start Menu Settings
Searching from the Start Menu
Resizing a Folder Window
Minimizing, Maximizing, and Restoring a Window
Accessing Help and Support
Accessing Help and Support
Shutting Down Windows Vista
Shutting Down Windows Vista
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWorking with Files and Folders
Lesson Skill Matrix
Key Terms
Using a Folder Window
Opening and Closing a Folder Window
Selecting Items in a Folder
Creating and Renaming a Folder
Creating and Renaming a Folder
Deleting Files and Folders
Using the Recycling Bin
Navigating Through Windows
Browsing Through Recently Opened Windows
Using the Navigation Pane
Using Multiple Windows
Opening and Arranging Multiple Windows
Changing the Active Window
Moving Files and Folders
Moving Files and Folders
Managing Files and Folders
Copying to a Different Folder
Copying to a Storage Device
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWindows Vista Speech Recognition
Lesson Skill Matrix
Key Terms
Setting Up Speech Recognition
Setting Up the Microphone
Learning How to Talk to Your Computer
Training your Computer to Understand Your Speech
Speech Recognition Basics
Turning Speech Recognition On and Off
Using Voice Commands
Navigating Speech Recognition
Working with Text in Speech Recognition
Dictating Text
Editing Text
Formatting Text
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWord Unit
Word Essentials
Lesson Skill Matrix
Key Terms
Software Orientation
Working in Word
Changing Word's View
Change Document Views
Use Show/Hide Commands
Use Zoom
Change Window Views
Navigate a Document
Scroll Through a Document Using the Mouse
Use Keystrokes to Navigate a Document
Entering Text in a Document
Selecting, Replacing, and Deleting Text
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyDocument Basics
Lesson Skill Matrix
Key Terms
Creating a Document
Starting a Business Letter
Choosing a Different File Format
Changing a Document's Appearance
Formatting a Document with Quick Styles
Formatting a Document with a Theme
Printing a Document
Using Print Preview
Setting Other Print Options
Creating Envelopes and Labels
Creating and Printing an Envelope
Creating and Printing a Label
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet Ready
Workplace ReadyCharacter Formatting
Lesson Skill Matrix
Key Terms
Software Orientation
Manually Formatting Characters
Choosing Fonts and Font Sizes
Applying Special Character Attributes
Changing Case
Highlighting Text
Copying and Removing Formatting
Using the Format Painter
Removing Formatting
Formatting Text with Styles
Applying Styles
Modifying Styles
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyParagraph Formatting
Lesson Skill Matrix
Key Terms
Software Orientation
Manually Formatting Paragraphs
Setting Indents
Changing Alignment
Setting the Line Spacing Within a Paragraph
Setting the Spacing Around a Paragraph
Creating a Numbered List
Creating a Bulleted List
Shading a Paragraph
Placing a Border Around a Paragraph
Software Orientation
Setting Tabs
Setting Tabs on the Ruler
Using the Tabs Dialog Box
Displaying Non-Printing Characters
Clearing Tabs
Clearing the Formats from a Paragraph
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyDocument Formatting
Lesson Skill Matrix
Key Terms
Formatting a Document's Background
Setting a Colored Background
Adding a Watermark
Placing a Border Around a Document’s Pages
Inserting Headers and Footers
Adding Page Numbers to a Document
Inserting a Built-In Header or Footer
Adding Content to a Header or Footer
Page Layout
Setting Margins
Selecting a Page Orientation
Choosing a Paper Size
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyManaging Text Flow
Lesson Skill Matrix
Key Terms
Controlling Paragraph Behavior
Controlling Widows and Orphans
Keeping a Paragraph's Lines on the Same Page
Keeping Two Paragraphs on the Same Page
Forcing a Paragraph to the Top of a Page
Working with Breaks
Forcing a Page Break
Inserting Section Breaks
Setting Up Columns
Creating Columns
Formatting Columns
Changing Column Widths
Inserting a Blank Page Into a Document
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyEditing Basics
Lesson Skill Matrix
Key Terms
Using Quick Parts to Add Content to a Document
Using Built-In Building Blocks
Inserting a Field from Quick Parts
Creating Your Own Building Blocks
Copying and Moving Text
Using the Clipboard to Copy and Move Text
Using the Mouse to Copy or Move Text
Finding and Replacing Text
Finding Text in a Document
Replacing Text in a Document
Navigating a Long Document
Using the Go To Command
Using the Document Map
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCreating Tables and Lists
Lesson Skill Matrix
Key Terms
Creating Tables
Inserting a Table by Dragging
Using the Insert Table Dialog Box
Drawing a Table
Inserting a Quick Table
Software Orientation
Formatting a Table
Applying a Quick Style to a Table
Turning Table Style Options On or Off
Software Orientation
Managing Tables
Resizing a Row or Column
Moving a Row or Column
Setting a Table's Horizontal Alignment
Creating a Header Row
Sorting a Table's Contents
Performing Calculations in Table Cells
Merging and Splitting Table Cells
Changing the Position of Text in a Cell
Changing the Direction of Text in a Cell
Working with Lists
Creating an Outline-Style List
Sorting a List's Contents
Changing a List's Formatting
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet Ready
Workplace ReadyAdding Pictures and Shapes to a Document
Lesson Skill Matrix
Key Terms
Software Orientation
Inserting a Picture
Using SmartArt Graphics
Inserting and Resizing a Clip Art Picture
Inserting a Picture from a File
Software Orientation
Adding Shapes
Inserting Shapes
Creating a Flowchart
Adding Text to a Shape
Software Orientation
Formatting Pictures
Cropping, Resizing, Scaling, and Rotating a Picture
Applying a Quick Style to a Picture
Adjusting a Picture's Brightness, Contrast, and Color
Arranging Text Around a Picture
Compressing a Picture
Resetting a Picture
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCustomizing Word
Lesson Skill Matrix
Key Terms
Software Orientation
Customizing Word
Personalizing Word
Changing Display Options
Configuring Proofing Options
Setting Save Options
Using Advanced Options
Customizing the Quick Access Toolbar
Viewing and Managing Add-Ins
Protecting Your Computer
Software Orientation
Changing Research Options
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyExcel Unit
Excel Essentials
Lesson Skill Matrix
Key Terms
Software Orientation
Working in the Excel Window
Changing Excel's View
Splitting a Window
Opening a New Window
Workplace Ready
Working with an Existing Workbook
Navigating a Worksheet
Entering Data in a Worksheet
Selecting, Editing, and Deleting a Cell's Contents
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCreating and Editing a
Workbook
Lesson Skill Matrix
Key Terms
Software Orientation
Creating a Workbook
Starting a Workbook from Scratch
Populating a Worksheet with Data
Entering Labels
Entering Dates
Entering Values
Filling a Series with Auto Fill
Cutting, Copying, and Pasting Data
Copying with the Mouse
Moving a Data Series with the Mouse
Copying and Pasting Data
Cutting and Pasting Data
Printing a Worksheet
Setting the Print Area
Using Print Preview
Setting Other Print Options
Saving a Workbook
Saving a Workbook for Use in a Previous Version of Excel
Choosing a Different File Format
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyFormatting Cells and Ranges
Lesson Skill Matrix
Key Terms
Software Orientation
Inserting and Deleting Cells
Adding a New Cell to a Worksheet
Deleting a Cell from a Worksheet
Manually Formatting Cell Contents
Selecting Cells and Ranges
Aligning Cell Contents
Choosing Fonts and Font Sizes
Applying Special Character Attributes
Changing Font Color
Filling Cells with Color
Applying Number Formats
Wrapping Text in a Cell
Merging and Splitting Merged Cells
Placing Borders Around Cells
Copying Cell Formatting with the Format
Painter
Formatting Cells with Styles
Applying a Cell Style
Modifying a Cell Style
Working with Hyperlinked Data
Placing a Hyperlink in a Cell
Removing a Hyperlink
Applying Conditional Formatting to Cells
Using the Rule Manager to Apply Conditional
Formats
Allowing Multiple Conditional Formatting Rules to Be True
Applying Specific Conditional Formats
Clearing a Cell's Formatting
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWorksheet Formatting
Lesson Skill Matrix
Key Terms
Software Orientation
Working with Rows and Columns
Inserting or Deleting a Row or Column
Modifying Row Height and Column Width
Formatting an Entire Row or Column
Hiding and Unhiding a Row or Colum
Using Themes
Choosing a Theme for a Worksheet
Customizing a Theme
Customizing a Theme by Selecting Colors
Customizing a Theme by Selecting a Font and Effects
Modifying a Worksheet's On-Screen and Printed Appearance
Formatting a Sheet Background
Changing the Color of a Worksheet Tabs
Viewing and Printing a Worksheet's Gridlines
Viewing and Printing Column and Row Headings
Inserting Headers and Footers
Adding Page Numbers to a Worksheet
Inserting a Predefined Header or Footer
Adding Content to a Header or Footer
Preparing a Document for Printing
Adding and Moving a Page Break
Setting Margins
Setting a Worksheet's Orientation on the Page
Scaling a Worksheet to Fit on a Printed Page
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyManaging Worksheets
Lesson Skill Matrix
Key Terms
Software Orientation
Organizing Worksheets
Copying a Worksheet
Renaming a Worksheet
Reposition the Worksheets in a Workbook
Hiding and Unhiding a Worksheet
Inserting a New Worksheet into a Workbook
Deleting a Worksheet from a Workbook
Working with Multiple Worksheets
Hiding and Unhiding Worksheets in a Workbook
Using Zoom and Scroll to Change Onscreen View
Finding and Replacing Data
Locating Data with the Find Command
Replacing Data with the Replace Command
Navigating a Worksheet with the Go To Command
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWorking with Data
Lesson Skill Matrix
Key Terms
Software Orientation
Ensuring Your Data's Integrity
Restricting Cell Entries to Certain Data Types
Allowing Only Specific Values to Be Entered in Cells
Removing Duplicate Cells, Rows, or Columns
from a Worksheet
Sorting Data
Sorting Data on a Single Criterion
Sorting Data on Multiple Criteria
Sorting Data by Using Conditional Formatting
Sorting Data by Using Cell Attributes
Filtering Data
Using AutoFilter
Creating a Custom AutoFilter
Filtering Data by Using Conditional Formatting
Filtering Data by Using Cell Attributes
Subtotaling Data
Grouping and Ungrouping Data for Subtotaling
Subtotaling Data in a List
Setting Up Data in a Table Format
Formatting a Table with Quick Style
Inserting a Total Row in a Table
Adding and Removing Rows or Columns in a Table
Summary Skill Matrix
Workplace Ready
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyUsing Basic Formulas and Functions
Lesson Skill Matrix
Key Terms
Software Orientation
Building Basic Formulas
Creating a Formula that Performs Addition
Creating a Formula that Performs Subtraction
Creating a Formula that Performs Multiplication
Creating a Formula that Performs Division
Using Cell References in Formulas
Using Relative Cell References in a Formula
Using Absolute Cell References in a Formula
Referring to Data in Another Worksheet
Referring to Data in Another Workbook
Using Cell Ranges in Formulas
Naming a Range
Changing the Size of a Range
Keeping Track of Ranges
Creating a Formula that Operates on a Named Range
Summarizing Data with Functions
Using SUM
Using COUNT
Using COUNTA
Using AVERAGE
Using MIN
Using MAX
Using Formulas to Create Subtotals
Selecting Ranges for Subtotaling
Modifying a Range in a Subtotal
Building Formulas to Subtotal and Total
Controlling the Appearance of Formulas
Displaying Formulas on the Screen
Printing Formulas
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCreating Charts from Your Data
Lesson Skill Matrix
Key Terms
Software Orientation
Building Charts
Selecting Data to Include in a Chart
Choosing the Right Chart for Your Data
Creating a Bar Chart
Formatting a Chart with a Quick Style
Manually Formatting the Parts of a Chart
Changing the Chart's Fill Color or Pattern
Changing the Chart's Border Line
Formatting the Data Series
Modifying a Chart's Legend
Modifying a Chart
Adding Elements to a Chart
Deleting Elements from a Chart
Moving a Chart
Resizing a Chart
Choosing a Different Chart Type
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyPowerPoint Unit
PowerPoint Essentials
Lesson Skill Matrix
Key Terms
Software Orientation
Working with an Existing Presentation
Viewing a Presentation in Different Ways
Change PowerPoint's View
Use Zoom
Navigating a Presentation
Scroll with the Mouse
Navigate a Presentation from the Keyboard
Working with Text
Add Text to a Text Placeholder
Add Text on the Outline Tab
Select, Replace, and Delete Text
Copy and Move Text from One Slide to Another
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyPresentation Basics
Lesson Skill Matrix
Key Terms
Software Orientation
Creating a Blank Presentation
Opening a Blank Presentation
Changing a Slide's Layout
Adding Text to a Blank Slide
Saving a Presentation with a Different File Format
Choosing a Different File Format
Creating a Presentation from a Template
Using a Template as the Basis for a Presentation
Adding a New Slide to a Presentation
Reusing a Slide from Another Presentation
Creating a New Presentation from an Existing One
Starting a Presentation from a Microsoft Word Outline
Change Indent Levels in a List
Organizing Your Slides
Rearranging the Slides in a Presentation
Deleting a Slide
Adding Notes to Your Slides
Workplace Ready
Printing a Presentation
Using Print Preview
Setting Print Options
Printing a Presentation in Grayscale Mode
Previewing a Presentation on the Screen
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWorking with Text
Lesson Skill Matrix
Key Terms
Software Orientation
Choosing Fonts and Font Sizes
Applying Font Sizes and Effects
Changing Font Color
Copying Character Formats with the Format Painter
Formatting Paragraphs
Aligning Paragraphs
Setting Paragraph Line Spacing
Working with Lists
Creating Numbered Lists
Working with Bulleted Lists
Inserting and Formatting WordArt
Inserting a WordArt Graphic
Formatting a WordArt Graphic
Changing the WordArt Fill Color
Changing the WordArt Outline Color
Applying Special Effects to WordArt
Formatting Text with WordArt Styles
Creating and Formatting Text Boxes
Adding a Text Box to a Slide
Resizing a Text Box
Setting Formatting Options for a Text Box
Applying a Quick Style to a Text Box
Applying Fill and Border Formatting to a Text Box
Working with Text in a Text Box
Aligning Text in a Text Box
Orienting Text in a Text Box
Setting Margins in a Text Box
Setting Up Columns in a Text Box
Deleting a Text Box
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyDesigning a Presentation
Lesson Skill Matrix
Key Terms
Software Orientation
Formatting Presentations with Themes
Applying a Theme to a Presentation
Changing Theme Colors
Changing Theme Fonts
Changing Slide Backgrounds
Selecting a Theme Background
Applying a Textured Background
Working with Different Layouts
Inserting Date, Footer, and Slide Numbers
Linking to Web Pages and Other Programs
Adding a Hyperlink to a Slide
Adding an Action to a Slide
Testing Links in a Slide Show
Setting Up Slide Transitions
Applying a Transition
Modifying a Transition
Determining How Slides Will Advance
Animating Your Slides
Using Built-In Animations
Modifying an Animation
Creating a Customized Animation
Software Orientation
Customizing Slide Masters
Applying a Theme to a Slide Master
Changing a Slide Master's Background
Adding New Elements to a Slide Master
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyAdding Tables, Charts, and SmartArt Graphics to Slides
Lesson Skill Matrix
Key Terms
Software Orientation
Creating Tables
Inserting a Table
Inserting an Excel Worksheet
Formatting Tables
Applying a Quick Style to a Table
Software Orientation
Building Charts
Inserting a Chart from a Content Placeholder
Choosing a Different Chart Type
Applying a Different Chart Layout
Workplace Ready
Formatting Charts with Quick Styles
Applying a Quick Style to a Chart
Software Orientation
Adding SmartArt to a Slide
Insert a SmartArt Diagram
Insert an Organization Chart
Add Text to a SmartArt Diagram
Converting a Bulleted List to a Diagram
Modifying SmartArt Graphics
Applying a Quick Style to a SmartArt Diagram
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyAdding Graphics and Media Clips to a Presentation
Lesson Skill Matrix
Key Terms
Software Orientation
Adding a Picture to a Slide
Inserting a Clip Art Picture
Inserting a Picture from a File
Formatting Pictures
Using the Ruler, Gridlines, and Guides
Rotating an Object
Resizing Objects
Crop an Object
Size or Scale an Object
Formatting a Picture with a Quick Style
Adjusting a Picture's Color, Brightness, and Contrast
Adding Special Effects to a Picture
Compressing the Images in a Presentation
Adding Shapes to Slides
Drawing Lines
Inserting Basic Shapes
Adding Text to Shapes
Formatting Shapes
Organizing Objects on a Slide
Setting the Order of Objects
Aligning Objects with Each Other
Grouping Objects Together
Adding Media Clips to a Presentation
Adding a Sound File to a Slide
Adding a Movie to a Slide
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyDelivering a Presentation
Lesson Skill Matrix
Key Terms
Adjusting Slide Orientation and Size
Selecting Slide Orientation
Setting Slide Size
Customizing Audience Handouts
Workplace Ready
Choosing Slides to Display
Omitting Selected Slides from a Presentation
Creating a Custom Show
Rehearsing Your Delivery
Software Orientation
Setting Up a Slide Show
Working with Presentation Tools
Use Presentation Tools
Annotate Slides with the Pen
Packaging a Presentation for Delivery
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyAccess Unit
Database Essentials
Lesson Skill Matrix
Key Terms
Software Orientation
Working in the Access Window
Navigating Access
Database Basics
Software Orientation
Using the Navigation Pane
Using Object Tabs
Changing Views
Defining Data Needs and Types
Defining Table Fields
Defining Data Types for Fields
Defining Database Tables
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet Ready
Workplace ReadyCreate Database Tables
Lesson Skill Matrix
Software Orientation
Creating a Database
Using a Template to Create a Database
Creating a Blank Database
Software Orientation
Creating a Database Table
Creating a Table from a Template
Creating a Table from Another Table
Saving a Database Object
Saving a Table
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyWork with Tables Database Records
Lesson Skill Matrix
Key Terms
Navigating Among Records
Navigating Using the Keyboard
Navigating Using Navigation Buttons
Entering, Editing, and Deleting Records
Creating and Modifying Primary Keys
Defining and Modifying a Primary Key
Defining and Modifying a Multi-field Primary Key
Finding and Replacing Data
Attaching and Detaching Documents
Sorting and Filtering Data Within a Table
Software Orientation
Sorting Data Within a Table
Filtering Data Within a Table
Removing a Filter
Understanding Table Relationships
Software Orientation
Defining Table Relationships
Modifying Table Relationships
Printing Table Relationships
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyModifying Tables and Fields
Lesson Skill Matrix
Key Terms
Modifying a Database Table
Modifying Table Properties
Renaming a Table
Deleting a Table
Software Orientation
Creating Fields and Modifying
Field Properties
Modifying Field Properties
Software Orientation
Creating and Deleting Fields
Creating and Modifying Multi-valued Fields
Creating and Modifying Attachment Fields
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCreate Forms
Lesson Skill Matrix
Key Terms
Software Orientation
Creating Forms
Creating a Simple Form
Creating a Form in Design View
Creating a Form in Layout View
Creating a Datasheet Form
Applying AutoFormat
Sorting Data Within a Form
Filtering Data Within a Form
Filter Data With Common Filters
Filter By Form
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCreate Reports
Lesson Skill Matrix
Key Terms
Software Orientation
Creating Reports
Creating a Simple Report
Using the Report Wizard
Creating a Report in Design View
Applying an AutoFormat
Sorting Data Within a Report
Filtering Data Within a Report
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyCreate and Modify Queries
Lesson Skill Matrix
Key Terms
Software Orientation
Creating a Query
Creating a Query from a Table
Create a Simple Query
Create a Find Duplicates Query
Creating a Query from Multiple Tables
Create a Query from Multiple Tables
Find Unmatched Reports
Software Orientation
Modifying a Query
Adding a Table to a Query
Remove a Table from a Query
Adding Criteria to a Query
Sorting and Filtering Data Within a Query
Sorting Data Within a Query
Filtering Data Within a Query
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyDatabase Tools
Lesson Skill Matrix
Key Terms
Maintaining a Database
Backing Up a Database
Compacting and Repairing a Database
Configuring Database Options
Software Orientation
Using Database Tools
Encrypting a Database
Identifying Object Dependencies
Using the Database Documenter
Using the Linked Table Manager
Splitting a Database
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyOutlook Unit
Getting to Know Outlook
Lesson Skill Matrix
Key Terms
Software Orientation
Working in the Outlook Window
Using the On-Screen Tools
Changing Outlook's View
Personalizing Outlook
Working with the Reading Pane
Viewing, Hiding, and Minimizing the To-Do Bar
Customizing the To-Do Bar
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyEmail Basics
Lesson Skill Matrix
Key Terms
Software Orientation
Creating and Sending Messages
Composing a Message
Sending a Message
Resending a Message
Saving a Copy of a Sent Message in a
Different Location
Reading and Replying to Messages
Automatically Previewing Messages
Sending a Reply to a Message
Forwarding a Message
Working with Attachments
Attaching a File to a Message
Previewing an Attachment in Outlook
Saving an Attachment to a Specific Location
Opening an Attachment
Personalizing Messages
Creating a Personal Signature
Adding a Signature to a Single Message
Adding a Signature to All Outgoing Messages
Working with Automated Replies
Creating an Internal Out of Office Message
Creating an External Out of Office Message
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyManaging Mail with Folders
Lesson Skill Matrix
Key Terms
Software Orientation
Working with Folders
Creating and Moving a Mail Folder
Deleting and Restoring a Folder
Moving Messages to a Different Folder
Deleting and Archiving Outlook Items
Emptying the Deleted Items Folder
Archiving Outlook Items
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyProcessing Messages with Rules
Lesson Skill Matrix
Key Terms
Software Orientation
Using Rule Templates
Creating a Rule to Move Messages from a Template
Running a Rule
Creating and Editing Rules
Creating a Rule to Categorize Messages
from a Selected Message
Creating a Rule to Forward a Message by
Copying an Existing Rule
Creating a Rule to Delete Messages from Scratch
Managing Rules
Sequencing Rules
Turning Off a Rule
Deleting a Rule
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyContact Basics
Lesson Skill Matrix
Key Terms
Software Orientation
Creating and Modifying Contacts
Creating a Contact from a Blank Contact
Creating a Contact from an Existing Contact
Modifying Contact Information
Sending and Receiving Contacts
Sending a Contact as an Attachment
Saving a Contact as a Contact Record
Creating a Contact from a Message Header
Viewing and Deleting Contacts
Creating and Modifying a Distribution List
Creating a Distribution List
Modifying a Distribution List
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyAdvanced Contact Management
Lesson Skill Matrix
Key Terms
Software Orientation
Using Electronic Business Cards
Editing an Electronic Business Card
Sending an Electronic Business Card
Creating a Contact from an Electronic Business Card
Using an Electronic Business Card in a Signature
Finding Contact Information
Searching for Contacts
Searching for Items Related to a Contact
Creating a Custom Search Folder
Creating a Secondary Address Book
Creating a Secondary Address Book for
Personal Contacts
Importing a Secondary Address Book from a File
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet Ready
Workplace ReadyCalendar Basics
Lesson Skill Matrix
Key Terms
Software Orientation
Managing Appointments
Creating a One-Time Appointment
Scheduling a Recurring Appointment
Creating an Appointment from a Message
Creating an Appointment from a Task
Marking an Appointment as Private
Managing Events
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyManaging Meetings
Lesson Skill Matrix
Key Terms
Software Orientation
Creating a Meeting
Creating a One-Time Meeting
Inviting Mandatory and Optional Attendees
Determining When Attendees Can Meet
Responding to a Meeting Request
Tracking Responses to a Meeting Request
Modifying a Meeting
Changing a Meeting Time
Proposing a New Meeting Time
Accepting a Proposed New Meeting Time
Adding and Updating a New Attendee
Managing a Recurring Meeting
Creating a Recurring Meeting
Changing One Occurrence of a Recurring Meeting
Scheduling a Meeting Resource
Cancelling a Meeting
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyManaging Tasks
Lesson Skill Matrix
Key Terms
Software Orientation
Creating New Tasks
Creating a One-Time Task
Creating a Recurring Task
Creating a Task from a Message
Modifying and Completing a Task
Modify a Task
Making a Task Private
Completing a Task
Working with Assigned Tasks
Assigning a Task to Someone Else
Responding to an Assigned Task
Reporting the Status of an Assigned Task
Searching for Tasks
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet Ready
Workplace ReadyCategories and Outlook Data Files
Lesson Skill Matrix
Key Terms
Software Orientation
Working with Categories
Assigning Outlook Items to Color Categories
Modifying and Creating Color Categories
Sorting Items by Color Category
Searching for Items by Category
Working with Data Files
Creating a Data File
Selecting a Data File for a Mail Account
Changing Data File Settings
Summary Skill Matrix
Assessment
Knowledge Assessment
Competency Assessment
Proficiency Assessment
Mastery Assessment
Internet ReadyAppendices.