Home Page Icon
Home Page
Table of Contents for
III. Microsoft Office Access 2007
Close
III. Microsoft Office Access 2007
by Katherine Murray, Joan Preppernau, Steve Lambert, Curtis Frye, Joyce Cox
2007 Microsoft® Office System Step by Step
2007 Microsoft® Office System Step by Step
SPECIAL OFFER: Upgrade this ebook with O’Reilly
A Note Regarding Supplemental Files
A Tour of the Office 2007 User Interface
Using the "Ribbon"
Command Tabs
Command Sets
Contextual Tools
Dialog Launchers
Galleries
The New File Menu
Quick Access Toolbar
New View Controls
Key Points
Information for Readers Running Windows XP
Managing the Practice Files
Using the Start Menu
Navigating Dialog Boxes
Getting Help
Getting Help with This Book and Its Companion CD
Getting Help with an Office Program
More Information
Using the Book’s CD
What’s on the CD?
Minimum System Requirements
Step-by-Step Exercises
Installing the Practice Files
Using the Practice Files
Removing and Uninstalling the Practice Files
Features and Conventions of This Book
About the Authors
Joyce Cox
Curtis Frye
Steve Lambert
M. Dow Lambert III
Katherine Murray
Joan Lambert Preppernau
Online Training Solutions, Inc. (OTSI)
Quick Reference
1. Exploring Word 2007
2. Editing and Proofreading Documents
3. Changing the Look of Text
4. Presenting Information in Columns and Tables
5. Setting Up a Workbook
6. Working with Data and Data Tables
7. Performing Calculations on Data
8. Changing Document Appearance
9. Creating a Database
10. Simplifying Data Entry by Using Forms
11. Locating Specific Information
12. Keeping Your Information Accurate
13. Starting a New Presentation
14. Working with Slide Text
15. Adjusting the Layout, Order, and Look of Slides
16. Delivering a Presentation Electronically
17. Getting Started with Outlook 2007
18. Sending E-Mail Messages
19. Managing Your Inbox
20. Managing Appointments, Events, and Meetings
21. Managing Your Calendar
I. Microsoft Office Word 2007
1. Exploring Word 2007
Working in the Word Environment
Opening, Moving Around in, and Closing a Document
Displaying Different Views of a Document
Creating and Saving a Document
Previewing and Printing a Document
Key Points
2. Editing and Proofreading Documents
Making Changes to a Document
Inserting Saved Text
Finding the Most Appropriate Word
Reorganizing a Document Outline
Finding and Replacing Text
Correcting Spelling and Grammatical Errors
Finalizing a Document
Key Points
3. Changing the Look of Text
Quickly Formatting Text and Paragraphs
Manually Changing the Look of Characters
Manually Changing the Look of Paragraphs
Creating and Modifying Lists
Key Points
4. Presenting Information in Columns and Tables
Presenting Information in Columns
Creating a Tabular List
Presenting Information in a Table
Formatting Table Information
Performing Calculations in a Table
Using a Table to Control Page Layout
Key Points
II. Microsoft Office Excel 2007
5. Setting Up a Workbook
Creating Workbooks
Modifying Workbooks
Modifying Worksheets
Customizing the Excel 2007 Program Window
Zooming In on a Worksheet
Arranging Multiple Workbook Windows
Adding Buttons to the Quick Access Toolbar
Key Points
6. Working with Data and Data Tables
Entering and Revising Data
Moving Data Within a Workbook
Finding and Replacing Data
Correcting and Expanding Upon Worksheet Data
Defining a Table
Key Points
7. Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Summarizing Data That Meets Specific Conditions
Finding and Correcting Errors in Calculations
Key Points
8. Changing Document Appearance
Formatting Cells
Defining Styles
Applying Workbook Themes and Table Styles
Making Numbers Easier to Read
Changing the Appearance of Data Based on Its Value
Adding Images to a Document
Key Points
III. Microsoft Office Access 2007
9. Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table by Using a Template
Manipulating Table Columns and Rows
Key Points
10. Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool
Refining Form Properties
Changing the Arrangement of a Form
Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
Adding a Subform to a Form
Key Points
11. Locating Specific Information
Sorting Information in a Table
Filtering Information in a Table
Filtering Information by Using a Form
Locating Information That Matches Multiple Criteria
Creating a Query Manually
Creating a Query by Using a Wizard
Performing Calculations by Using a Query
Key Points
12. Keeping Your Information Accurate
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List
Updating Information in a Table
Deleting Information from a Table
Preventing Database Problems
Key Points
IV. Microsoft Office PowerPoint 2007
13. Starting a New Presentation
Quickly Creating a Presentation
Creating a Presentation Based on a Ready-Made Design
Converting an Outline to a Presentation
Reusing Existing Slides
Key Points
14. Working with Slide Text
Entering Text
Editing Text
Adding and Manipulating Text Boxes
Correcting and Sizing Text While Typing
Checking Spelling and Choosing the Best Words
Finding and Replacing Text and Fonts
Changing the Size, Alignment, Spacing, and Look of Text
Key Points
15. Adjusting the Slide Layout, Order, and Look
Changing the Layout of a Slide
Rearranging Slides in a Presentation
Applying a Theme
Switching to a Different Color Scheme
Using Colors That Are Not Part of the Scheme
Adding Shading and Texture to the Background of a Slide
Key Points
16. Delivering a Presentation Electronically
Adapting a Presentation for Different Audiences
Rehearsing a Presentation
Preparing Speaker Notes and Handouts
Preparing a Presentation for Travel
Showing a Presentation
Key Points
V. Microsoft Office Outlook 2007
17. Getting Started with Outlook 2007
Connecting to Your Primary E-Mail Account
Troubleshooting the Startup Wizard
Connecting to Additional E-Mail Accounts
Creating Additional Outlook Profiles
Personalizing Your Outlook Workspace
Exploring the Advanced Toolbar
Key Points
18. Sending E-Mail Messages
Working in the Message Window
Creating and Sending Messages
Addressing Messages
Sending Courtesy Copies
Saving Message Drafts
Attaching Files to Messages
Creating and Formatting Business Graphics
Personalizing the Appearance of Messages
Adding Signatures to Messages Automatically
Key Points
19. Managing Your Inbox
Quickly Locating Messages
Arranging Messages in Different Ways
Organizing Messages by Using Color Categories
Organizing Messages in Folders
Archiving Messages
Key Points
20. Managing Appointments, Events, and Meetings
Working in the Calendar Item Windows
Scheduling and Changing Appointments
Scheduling and Changing Events
Scheduling, Updating, and Canceling Meetings
Responding to Meeting Requests
Key Points
21. Managing Your Calendar
Displaying Different Views of a Calendar
Defining Your Available Time
Printing a Calendar
Sending Calendar Information in an E-Mail Message
Linking to an Internet Calendar
Working with Multiple Calendars
Key Points
Glossary
Choose the Right Book for You
Published and Upcoming Titles
Plain & Simple
Step by Step
Inside Out
Other Titles
Index
SPECIAL OFFER: Upgrade this ebook with O’Reilly
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
Key Points
Next
Next Chapter
9. Creating a Database
Part III. Microsoft Office Access 2007
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