Essentials Microsoft Office 2003. Level one / Marianne Fox ... [et al.].

MICROSOFT WORD 2003

PROJECT 1: Taking a Tour of Word 2003
Lesson 1: Exploring the Word Screen
Lesson 2: Using Menus and Toolbars
Lesson 3: Entering Text in a Document
Lesson 4: Saving a Document in a New Folder
Lesson 5: Correcting Spellings and Grammatical Errors
Etc.

PROJECT 2: Working with a Document
Lesson 1: Opening a Document
Lesson 2: Scrolling and Using the Select Browse Object Palette
Lesson 3: Inserting Text
Lesson 4: Selecting, Deleting, and Changing Text
Lesson 5: Creating a Table from Existing Text
Etc.

PROJECT 3: Formatting Text
Lesson 1: Applying and Modifying Character Formats
Lesson 2: Changing the Font, Size, and Color
Lesson 3: Applying Font Effects and Character Spacing
Lesson 4: Copying Formats with Format Painter
Lesson 5; Highlighting Text
Etc.

PROJECT 4: Editing Documents
Lesson 1: Inserting and Modifying Date and Time Fields
Lesson 2: Changing the Case of Texts
Lesson 3: Cutting, Copying,and Pasting Text
Lesson 4: Copying Between Document Windows
Lesson 5: Undoing and Redoing Actions
Etc.

PROJECT 5: Formatting Paragraphs
Lesson 1: Setting Lines and Paragraph Spacing
Lesson 2: Selecting Text Alignment
Lesson 3: Indenting Text
Lesson 4: Customizing Bulleted and Numbered Lists
Lesson 5: Creating an Outline Numbered List
Etc.

PROJECT 6: Formatting Documents
Lesson 1: Setting Margins
Lesson 2: Inserting Sections and Page Breaks
Lesson 3: Setting Vertical Alignments
Lesson 4: Preventing Text From Separating Across Page Breaks
Lesson 5: Creating Headers and Footers
Etc

PROJECT 7: Creating and formatting Tables
Lesson 1: Creating a Table
Lesson 2: Inserting Rows and Columns
Lesson 3: Deleting Rows and Columns
Lesson 4: Adjusting Column Width and Row Height
Lesson 5: Formatting Cells
Etc.

PROJECT 8: Inserting and Formatting Graphics
Lesson 1: Inserting an Image
Lesson 2: Sizing an Image
Lesson 3: Wrapping Text and Positioning an Image
Lesson 4: Inserting a Text Box
Lesson 5: Applying a Boarder and Fill Color
Etc.

MICROSOFT EXCEL 2003
PROJECT 1: Taking a Tour of Excel 2003
Lesson 1: Identifying the Parts of an Excel Screen
Lesson 2: Opening and Saving a Workbook
Lesson 3: Viewing and Editing Cell Contents
Lesson 4: Modifying a Chart
Lesson 5: Performing a Simple Sort and Filter
Etc.

PROJECT 2: Modifying a Worksheet
Lesson 1: Entering Text, Numbers, and Formulas
Lesson 2: Selecting Worksheet Items
Lesson 3: Using Auto-Fill
Lesson 4: Inserting and Deleting Rows and Columns
Lesson 5: Copying and Moving Cell Contents
Etc.

PROJECT 3: Improving the Appearance of Worksheet
Lesson 1: Formatting Numbers
Lesson 2: Aligning Cell Contents
Lesson 3: Changing Font and Font Size
Lesson 4: Applying Bold, Italic, and Underscore
Lesson 5: Adding Color
Etc.

PROJECT 4: Entering Formulas in Well-Designed Worksheets
Lesson 1: Working with Operators and Order of Precedence
Lesson 2: Using Type-and-Point to Enter Formulas
Lesson 3: Comparing Absolute and Relative Cell References
Lesson 4: Creating and Copying Formulas with Absolute or Relative Cell References
Lesson 5: Freezing and Splitting the Worksheet Display
Etc.

PROJECT 5: Working with Functions
Lesson 1: Analyzing Data with AVERAGE, MAX, and MIN
Lesson 2: Calculating a Loan Payment with PMT
Lesson 3: Creating a Loan Payment Table
Lesson 4: Evaluating Investment Plans with FV
Lesson 5: Using IF to Display Messages
Etc.

PROJECT 6: Sorting and Filtering Lists
Lesson 1: Defining an Excel List
Lesson 2: Sorting Records on Two or More Fields
Lesson 3: Setting an Exact- Match Filter on Multiple Fields
Lesson 4: Filtering for Top and Bottom Records
Lesson 5: Filtering for Blanks and Non-blanks
Etc.

PROJECT 7: Working With Charts
Lesson 1: Identifying Common Chart Types and Features
Lesson 2: Using Chart Wizard to Create an Embedded Pie-Chart
Lesson 3: Using Chart Wizard to Create an Embedded Column Chart
Lesson 4: Changing the Chart Type
Lesson 5; Charting Nonadjacent Data Series
Etc.

PROJECT 8: Developing a Multiple-sheet Workbook
Lesson 1: Copying Data From Another Application
Lesson 2: Deleting, Inserting, and Renaming Worksheets
Lesson 3: Moving Worksheets and Adding Color to Sheet Tabs
Lesson 4: Editing Multiple Worksheets Simultaneously
Lesson 5: Subtotaling Data
Etc

MICROSOFT ACCESS 2003
PROJECT 1: Taking a Tour of Access 2003
Lesson 1: Opening a Database and Identifying Parts of the Access Window
Lesson 2: Using the Database Window
Lesson 3: Opening and Navigating Tables
Lesson 4: Viewing Forms and Reports
Lesson 5: Glimpsing the Power of Queries
Etc.

PROJECT 2: Building a Database
Lesson 1: Creating a New Blank Database
Lesson 2: Creating a Database Table Using Design View
Lesson 3: Creating an Auto-Form
Lesson 4: Adding Records to a Table
Lesson 5: Creating an Auto-Report
Etc.

PROJECT 3:Maintaining a Database
Lesson 1: Modifying Table Field Properties
Lesson 2: Formatting and Modifying Table Layout
Lesson 3; Locating, Deleting, and Editing Records
Lesson 4: Using Find and Replace to Update Records
Lesson 5: Sorting Records and Setting a Sort Order
Etc.

PROJECT 4: Modifying Tables and Establishing Relationships
Lesson 1: Editing, Adding, and Deleting Table Fields
Lesson 2: Assigning Primary Keys
Lesson 3: Formatting Data Using Input Marks
Lesson 4: Setting Validation Rules
Lesson 5: Setting Default Values
Etc.

PROJECT 5: Querying a Database
Lesson 1: Creating, Saving, and Running Select Queries
Lesson 2: Designing a Query Using Multiple Tables
Lesson 3: Setting Query Criteria
Lesson 4: Defining a Query Sort Order
Lesson 5: Creating and Formatting a Calculated Field
Etc.

PROJECT 6: Customizing Input Forms
Lesson 1: Creating Forms Using Wizards
Lesson 2: Modifying Form Controls
Lesson 3: Adding Unbound Controls to Forms
Lesson 4: Formatting Form Sections
Lesson 5: Setting Form Properties
Etc.

PROJECT 7: Creating Custom Reports
Lesson 1: Creating a Report Using a Wizard
Lesson 2: Modifying Reports
Lesson 3: Creating a Report Using Report Design View
Lesson 4; Adding Report Sorting and Grouping Levels
Lesson 5: Adding Graphics to Reports and Applying Auto-Formats
Etc.

PROJECT 8: Integrating Access with other Applications and the Internet
Lesson 1: Converting Access 2003 Databases to other Access Formats
Lesson 2: Linking an Excel Worksheet to an Access Database
Lesson 3; Merging Access Data with Word Documents
Lesson 4: Exporting Access Data To Excel
Lesson 5; Creating a Data Access Page
Etc.

MICROSOFT POWER POINT 2003

PROJECT 1: Taking a Tour of PowerPoint 2003
Lesson 1: Identifying Elements in the PowerPoint Window
Lesson 2: Opening and Resaving an Existing Presentation
Lesson 3: Exploring PowerPoint Views and the Zoom Feature
Lesson 4: Navigating a Presentation in Normal View
Lesson 5: Running an Electronic Slide Show
Etc.

PROJECT 2: Creating Presentation
Lesson 1: Creating a Blank Presentation
Lesson 2: Using a Design Template to Create a Presentation
Lesson 3: Entering, Deleting, and Editing Text
Lesson 4: Using the Spelling Checker
Lesson 5: Saving a Presentation
Etc.

PROJECT 3: Modifying the Presentation's Text and Structure
Lesson 1: Using the AutoContent Wizard to Create a Presentation
Lesson 2: Adding, Demoting, and Promoting Text
Lesson 3: Selecting, Moving and Copying Text
Lesson 4: Changing Text Appearance
Lesson 5: Changing Text Alignment
Etc.

PROJECT 4: Working with Visual and Multimedia Elements
Lesson 1: Applying Design Template to an Existing Presentation
Lesson 2: Using Color Schemes
Lesson 3: Changing the Slide Background
Lesson 4: Inserting, Resizing, and Moving Clip Art
Lesson 5: Using the Clip Art Task Pane and Modifying a Graphic
Etc.

PROJECT 5: Working with the Slide Master and Slide Layout
Lesson 1: Applying Various Slide Layouts
Lesson 2: Formatting Slide Placeholders
Lesson 3: Modifying Text Formatting and Bullets on the Slide Master
Lesson 4: Adding a Picture to the Slide Show
Lesson 5: Modifying and Deleting Placeholders on the Slide Master
Etc.

PROJECT 6: Working with Charts
Lesson 1: Selecting an Appropriate Chart Type
Lesson 2: Creating a Data Chart
Lesson 3: Editing Chart Data
Lesson 4: Resizing, Moving, and Changing Chart Type
Lesson 5: Choosing a Chart Subtype and Formatting a Chart
Etc.

PROJECT 7: Preparing and Delivering Electronic Slide Shows
Lesson 1: Applying Slide Translations
Lesson 2: Applying Animation Schemes
Lesson 3: Animating Objects
Lesson 4: Timing the Slide Show Presentation
Lesson 5: Setting Up the Slide Show
Etc.

PROJECT 8: Interfacing PowerPoint with Other Applications and the Internet
Lesson 1: Using Design Principles
Lesson 2: Copying and Pasting Data from Word
Lesson 3: Copying and Pasting Data from Excel
Lesson 4: Using Web Page Preview
Lesson 5: Saving a Presentation for Web Use

Includes: Glossary p.1432-1439 and Index p.1441-1455