Home Page Icon
Home Page
Table of Contents for
Gathering Information
Close
Gathering Information
by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh,
Office 2007 Bible
Copyright
About the Authors
Credits
Acknowledgments
Introduction
Common Office Features
Welcome to Microsoft Office 2007
Learning About Top Office Applications
Taking Advantage of Other Office Applications
Starting an Application
Closing an Application
Finding Files
Getting Help
Summary
Navigating in the New Office
Discoverability
The “Results-Oriented” User Interface
Ribbons and Things
The Office Button (File)
Options
Working with Dialog Boxes
Summary
Mastering Fundamental Operations
Working with Files
Printing a File
Working with Multiple Windows
Moving and Copying Information
Finding and Replacing
Spell Checking
AutoCorrect, AutoFormat, and Smart Tags
Styles and Live Preview
Summary
Creating Documents with Word
Making a Document
Creating a Blank File
Creating a File from a Template
Saving and File Formats
Compatibility with Previous Versions of Word
.docx Versus .docm
Understanding .docx
Navigation Tips and Tricks
Views
Summary
Formatting 101: Font/Character Formatting
The Big Picture
Styles and Character/Font Formatting
Character Formatting
Summary
Paragraph Formatting
Styles and Paragraph Formatting
What Exactly Is a Paragraph, Anyway?
Structural Formatting
Paragraph Decoration
Random Bonus Tip #1 — Sort Paragraphs That Aren’t in a Table
Random Bonus Tip #2 — Move Paragraphs Easily
Summary
Styles
Styles Group
Styles Task Pane
Summary
Page Setup and Sections
Page Setup Basics
Page Borders
The Header and Footer Layer
Header and Footer Navigation and Design
Adding Header and Footer Material
Themes
Summary
Tables and Graphics
Quick Start
Table Basics
Table Layout and Design
Inserting Pictures from Files
Pictures from the Clipboard and Internet
Manipulation 101
Inserting Clip Art
SmartArt
Summary
Mail Merge
Understanding Data Sources
Choosing the Type of Data Document
Attaching a Data Source
Assembling a Data Document
Mail Merge Task Pane/Wizard
Summary
Document Security
Protection Types
Protecting Documents for Review
Summary
Making the Numbers Work with Excel
Using Excel Worksheets and Workbooks
What Is Excel Good For?
What’s New in Excel 2007?
Understanding Workbooks and Worksheets
Moving Around a Worksheet
Creating Your First Excel Worksheet
Summary
Entering and Editing Worksheet Data
Exploring the Types of Data You Can Use
Entering Text and Values into Your Worksheets
Entering Dates and Times into Your Worksheets
Modifying Cell Contents
Applying Number Formatting
Summary
Essential Worksheet and Cell Range Operations
Learning the Fundamentals of Excel Worksheets
Controlling the Worksheet View
Working with Rows and Columns
Understanding Cells and Ranges
Copying or Moving Ranges
Using Names to Work with Ranges
Adding Comments to Cells
Summary
Introducing Formulas and Functions
Understanding Formula Basics
Entering Formulas into Your Worksheets
Editing Formulas
Using Cell References in Formulas
Using Formulas in Tables
Correcting Common Formula Errors
Tips for Working with Formulas
Summary
Working with Dates and Times
How Excel Handles Dates and Times
Date-Related Functions
Time-Related Functions
Summary
Creating Formulas That Count and Sum
Counting and Summing Worksheet Cells
Basic Counting Formulas
Advanced Counting Formulas
Summing Formulas
Conditional Sums Using a Single Criterion
Conditional Sums Using Multiple Criteria
Summary
Getting Started Making Charts
What Is a Chart?
Understanding How Excel Handles Charts
Creating a Chart
Hands On: Creating and Customizing a Chart
Working with Charts
Understanding Chart Types
Summary
Working with Database Tables in Excel
Understanding Tables (Lists) and Databases
Working with a Database or Table
Entering and Editing Records
Sorting and Filtering Data
Using Excel Data in a Mail Merge
Summary
Persuading and Informing with PowerPoint
A First Look at PowerPoint 2007
What’s New in PowerPoint 2007?
Starting and Exiting PowerPoint
Changing the View
Zooming In and Out
Enabling Optional Display Elements
Opening a New Display Window
Summary
Creating a Presentation, Slides, and Text
Starting a New Presentation
Saving Your Work
Closing and Reopening Presentations
Creating New Slides
Inserting Content from External Sources
Managing Slides
Using Content Placeholders
Creating Text Boxes Manually
Working with Text Boxes
Summary
Working with Layouts, Themes, and Masters
Understanding Layouts and Themes
Changing a Slide’s Layout
Applying a Theme
Changing Colors, Fonts, and Effects
Creating and Managing Custom Color and Font Themes
Changing the Background
Working with Preset Placeholders
Customizing and Creating Layouts
Managing Slide Masters
Managing Themes
Summary
Working with Tables and Charts
Creating a New Table
Moving Around in a Table
Selecting Rows, Columns, and Cells
Editing a Table’s Structure
Applying Table Styles
Formatting Table Cells
Understanding Charts
Starting a New Chart
Working with Chart Data
Chart Types and Chart Layout Presets
Working with Labels
Controlling the Axes
Formatting a Chart
Rotating a 3-D Chart
Summary
Using SmartArt Diagrams, Clip Art, and Pictures
Understanding SmartArt Types and Their Uses
Inserting a Diagram
Editing SmartArt Text
Modifying SmartArt Structure
Modifying a Hierarchy Diagram Structure
Formatting a Diagram
Choosing Appropriate Clip Art
About the Clip Organizer
Inserting Clip Art on a Slide
Clip Art Search Methods
Working with Clip Art Collections
Understanding Raster Graphics
Importing Image Files into PowerPoint
Sizing and Cropping Photos
Compressing Images
Summary
Building Animation Effects, Transitions, and Support Materials
Understanding Animation and Transitions
Assigning Transitions to Slides
Using an Animation Preset
The When and How of Handouts
Creating Handouts
Creating Speaker Notes
Printing an Outline
Printing Slides
Summary
Delivering a Live Presentation
Starting and Ending a Show
Using the On-screen Show Controls
Using the On-screen Pen
Hiding Slides for Backup Use
Giving a Presentation on a Different Computer
Working with Audio-visual Equipment
Summary
Organizing Messages, Contacts, and Time with Outlook
Fundamentals of E-Mail
Setting Up Your E-Mail Accounts
Modifying Account Settings
Using Outlook Profiles
Composing and Sending Messages
Reading and Replying to Messages
Understanding the Inbox Display
Understanding Files and Folders
Outlook Data Files
Working with Outlook Folders
Deleting Items and Using the Deleted Items Folder
Setting Options for an Individual E-Mail Message
Setting Global E-Mail Options
Summary
Processing and Securing E-Mail
Understanding Junk E-Mail Filtering
Setting Junk E-Mail Options
Blocking and Allowing Specific Addresses
Understanding E-Mail Rule Basics
Creating a New Rule
Some Rule Examples
Managing Rules
Protecting Against Viruses
Dealing with Attachments
Macro Security
Using Certificates and Digital Signatures
HTML Message Dangers
Summary
Working with Contacts
Understanding Outlook Contacts
The Contacts Window
Adding Contacts to the Address Book
Working with Distribution Lists
More about Contacts
Performing a Mail Merge from Your Contacts
Working with Multiple Address Books
Setting Contact Options
Summary
Working with Appointments and Tasks
Understanding the Outlook Calendar
Using the Calendar
Working with Appointments
Searching the Calendar
Setting Calendar Options
Understanding Tasks
Using the Task View
Creating a New Task
Working with Assigned Tasks
Other Ways of Viewing Tasks
Setting Task Options
Summary
Designing Publications with Publisher
Introducing Publisher
The Publisher Workspace
Using a Template to Create a Publication
Working with Text
Working with Graphics
Working with Tables
Summary
Design Dazzling Publications with Publisher
Adding Special Effects
Using the Design Gallery
Updating a Publication
Fine-Tuning Objects
Working with Pages
Checking and Printing
Preparing for Outside Printing
Summary
Tracking Detailed Data with Access
An Introduction to Database Development
The Database Terminology of Access
Relational Databases
Access Database Objects and Views
A Five-Step Design Method
Summary
Creating Access Tables
Getting Started with Access 2007
Creating a Database
The Access 2007 Environment
Creating a New Table
Creating tblContacts
Setting the Primary Key
Printing a Table Design
Saving the Completed Table
Manipulating Tables in a Database Window
Adding Records to a Database Table
Navigating Records in a Datasheet
Changing Values in a Datasheet
Summary
Creating and Entering Data with Basic Access Forms
Adding Forms Using the Ribbon
Adding Controls
Selecting Controls
Manipulating Controls
Understanding Properties
Using Form View
Changing Values in a Form
Printing a Form
Summary
Selecting Data with Queries
Understanding Queries
Creating a Query
Selecting Fields
Displaying the Recordset
Working with Fields
Changing the Sort Order
Displaying Only Selected Records
Printing a Query’s Recordset
Saving a Query
Adding More Than One Table to a Query
Working with the Table/Query Pane
Adding Fields from More Than One Table
Understanding Multi-Table Query Limitations
Summary
Presenting Data with Access Reports
Understanding Reports
Creating a Report with Report Wizards
Printing a Report
Saving the Report
Summary
Gathering Information
Keeping Information at Hand with OneNote
Who Needs OneNote and Why
Touring OneNote
Creating a Notebook
Creating a Section
Creating a Page
Inserting Notes
Inserting an Outlook Task
Inserting a Picture or File
Inserting a Screen Clipping
Writing on a Page
Organizing, Finding, and Sharing
Summary
Making Data Forms with InfoPath
Understanding InfoPath
Designing a Form Template
Publish the Template
Filling Out a Form
Exporting and Merging Form Data
Summary
Sharing and Collaboration
SharePoint
Accessing Your SharePoint Server
Workspace Management and Options
Server Tasks
Summary
Groove
Groove versus SharePoint
Using the Groove 2007 Client
Summary
Integration with Other Office Applications
Excel
PowerPoint
Outlook
Access Imports and Exports
Summary
Customizing Office
Finding Program Options
Using Common Options
Top Word Options
Top Excel Options
Top PowerPoint Options
Top Access Options
Top Outlook Options
Customizing the Quick Access Toolbar
Optimizing Your Office Installation
Activating Microsoft Office
Getting Updates
Adding or Removing Office Features
Running Microsoft Office Diagnostics
Repairing Your Installation
International Support and Accessibility Features
Understanding and Choosing Text Encoding in Word
Enabling Editing Languages for Office Programs
Language Translation Features
Accessibility Features
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Summary
Next
Next Chapter
Keeping Information at Hand with OneNote
Part VIII: Gathering Information
In This Part
Chapter 38
Keeping Information at Hand with OneNote
Chapter 39
Making Data Forms with InfoPath
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset