book

2007 Microsoft® Office System Step by Step, Second Edition

Name: 2007 Microsoft® Office System Step by Step, Second Edition
ISBN: 9780735625310

by Joyce Cox, Curtis D. Frye, M. Dow Lambert III, Steve Lambert, John Pierce, Joan Lambert

March 2008

Beginner

960 pages

24h 34m

English

Microsoft Press

Read now

Unlock full access

2007 Microsoft® Office System Step by Step, Second Edition
A Note Regarding Supplemental Files
Your All-in-One Resource
Introducing the 2007 Microsoft Office System
The Microsoft Office Fluent User Interface
Certification
Information for Readers Running Windows XP
Managing the Practice Files
Using the Start Menu
Navigating Dialog Boxes

Features and Conventions of This Book
Using the Companion CD
What’s on the CD?
Minimum System Requirements
Installing the Practice Files
Using the Practice Files
Removing and Uninstalling the Practice Files
Getting Help
Getting Help with This Book and Its Companion CD
Getting Help with an Office Program
More Information
About the Authors
Joyce Cox
Curtis Frye
M. Dow Lambert III
Steve Lambert
John Pierce
Joan Preppernau
Online Training Solutions, Inc. (OTSI)
Quick Reference
Part I Microsoft Office Word 2007
Exploring Word 2007Editing and Proofreading DocumentsChanging the Look of TextPresenting Information in Columns and Tables
Part II Microsoft Office Excel 2007
Setting Up a WorkbookWorking with Data and Data TablesPerforming Calculations on DataChanging Workbook Appearance
Part III Microsoft Office Access 2007
Creating a DatabaseSimplifying Data Entry by Using FormsLocating Specific InformationKeeping Your Information Accurate
Part IV Microsoft Office PowerPoint 2007
Starting a New PresentationWorking with Slide TextAdjusting the Layout, Order, and Look of SlidesDelivering a Presentation Electronically
Part V Microsoft Office Outlook 2007
Sending E-Mail MessagesManaging Your InboxManaging Appointments, Events, and MeetingsManaging Your Calendar
Part VI Microsoft Office Publisher 2007
Creating Colorful Cards and CalendarsCreating Text-Based Publications
Part VII Microsoft Office OneNote 2007
Collecting Information in a NotebookOrganizing and Locating Information
Part VIII Microsoft Office Groove 2007
Setting Up a Standard WorkspaceManaging and Sharing Files
Part IX Collaboration
Enabling Collaboration by Using SharePoint
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 WorksheetArranging Multiple Workbook WindowsAdding 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 Workbook 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 Documents
Key Points
III. Microsoft Office Access 2007
9. Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table from 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 Layout, Order, and Look of Slides
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. Sending E-Mail Messages
Working in the Message Window
Creating and Sending Messages
Addressing MessagesSending Courtesy CopiesSaving Message Drafts
Attaching Files to Messages
Creating and Formatting Business Graphics
Personalizing the Appearance of Messages
Adding Signatures to Messages Automatically
Key Points
18. 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
19. 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
20. Managing Your Calendar
Displaying Different Views of a Calendar
Defining Your Available Time
Configuring Outlook for Multiple Time Zones
Printing a Calendar
Sending Calendar Information in an E-Mail Message
Linking to an Internet Calendar
Working with Multiple Calendars
Key Points
VI. Microsoft Office Publisher 2007
21. Creating Colorful Cards and Calendars
Storing Personal and Company Information
Creating Folded Cards
Choosing a Design or LayoutChanging the Color SchemeUsing Non-Color-Scheme ColorsChoosing Text
Creating Postcards
Printing Both Sides of Thick PaperUsing Mail Merge
Creating Calendars
Adding Captions, Credits, and CopyrightsChanging the BackgroundWorking with the Master Page
Packaging Publications for Printing
Key Points
22. Creating Text-Based Publications
Planning Longer Publications
Creating Newsletters
Copyfitting TextInserting Pages
Organizing Content
Working with a Table of ContentsCreating SectionsMoving ContentSolving Organization Problems
Editing and Proofing Content
Editing Content in WordCorrecting Spelling ErrorsControlling Hyphenation
Key Points
VII. Microsoft Office OneNote 2007
23. Collecting Information in a Notebook
Understanding Notebooks
Understanding Note Containers
Entering Content Directly onto a Page
Referencing External FilesCreating Handwritten Notes
Sending Content to OneNote
Collecting Screen ClippingsCollecting Web Notes
Capturing Audio and Video Notes
Recording AudioRecording VideoPlaying Back a Recording
Quickly Capturing Notes
Key Points
24. Organizing and Locating Information
Moving and Removing Information
Manipulating Objects on a PageMoving Pages, Sections, and NotebooksAccessing Information from Multiple Locations
Tagging Notes
Searching for Information
Key Points
VIII. Microsoft Office Groove 2007
25. Setting Up a Standard Workspace
Creating a Standard Workspace
Sending and Accepting Workspace Invitations
Working in the Workspace Members Pane
Changing the Role of a Workspace Member
Changing Permissions Assigned to a Workspace Role
Exploring a Groove Workspace
Adding Files to the Files Tool
Adding a Tool to a Standard Workspace
Key Points
26. Managing and Sharing Files
Adding Folders and Files to the Files Tool
Working with Files in the Files Tool
Opening, Editing, and Saving a File in the Files Tool
Specifying Download Settings for a Folder
Setting Permissions in the Files Tool
Specifying Alert Settings for Folders and Files
Creating a File Sharing Workspace
Creating a File Sharing Workspace in WindowsCreating a File Sharing Workspace from the Launchbar
Downloading Files in a File Sharing Workspace
Changing Roles and Permissions for a File Sharing Workspace
Setting Properties for a File Sharing Workspace
Key Points
IX. Collaboration
27. Enabling Collaboration by Using SharePoint
Creating a SharePoint Team Site
Creating a Document Library
Managing Files in a Document Library
Checking Files Into and Out of a Document Library
Creating a Custom List from an Excel Workbook
Working with SharePoint List Data in Access
Creating a Document Workspace from an Office Document
Creating a Document Workspace from Outlook
Working Offline with Document Library Contents
Linking a SharePoint Calendar to Outlook
Key Points
Glossary
Index
About the Authors
Copyright

Content preview from 2007 Microsoft® Office System Step by Step, Second Edition

Part III Microsoft Office Access 2007

Creating a Database

To open a template and save it as a new database

On the Getting Started with Microsoft Office Access page, in the Template Categories list, click a category.
Click the template icon for the template you want to open.
In the File Name box, type a new name for the database, and note the default path.
Click the Create button.

To open a new blank database

Open Access.
On the Getting Started with Microsoft Access page, click Blank Database.
In the File Name box, type the name for the database.
Click the Browse for a location button, browse to the folder where you want to save the database, click OK, and then click Create.

To enter information in a database

→	Click in an empty cell, type your text, and then ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

2007 Microsoft® Office System Step by Step

Publisher Resources

ISBN: 9780735625310Catalog Page Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

2007 Microsoft® Office System Step by Step, Second Edition

by Joyce Cox, Curtis D. Frye, M. Dow Lambert III, Steve Lambert, John Pierce, Joan Lambert

Part III Microsoft Office Access 2007

Creating a Database

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

More than 5,000 organizations count on O’Reilly

Julian F.

Addison B.

Amir M.

Mark W.

You might also like

2007 Microsoft® Office System Step by Step

Microsoft® Office Excel® 2007 Step by Step

Microsoft® Office Home and Student 2007 Step by Step

Microsoft® Office Word 2007 Step by Step

Publisher Resources