Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition

Larger Cover

By Joyce Cox, Joan Lambert

Publisher: Microsoft Press

Released: April 2008

Pages: 816

Using Microsoft Office Word 2007
1. Chapter 1 Creating and Customizing Documents
  1. Create and format documents
  2. Lay out documents
  3. Make documents and content easier to find
  4. Personalize Word 2007
  5. Objective Review
2. Chapter 2 Formatting Content
  1. Format text and paragraphs
  2. Manipulate text
  3. Control pagination
  4. Objective Review
3. Chapter 3 Working with Visual Content
  1. Insert illustrations
  2. Format illustrations
  3. Format text graphically
  4. Insert and modify text boxes
  5. Objective Review
4. Chapter 4 Organizing Content
  1. Structure content by using Quick Parts
  2. Use tables and lists to organize content
  3. Modify tables
  4. Insert and format references and captions
  5. Merge documents and data sources
  6. Objective Review
5. Chapter 5 Reviewing Documents
  1. Navigate documents
  2. Compare and merge document versions
  3. Manage tracked changes
  4. Insert, modify, and delete comments
  5. Objective Review
6. Chapter 6 Sharing and Securing Content
  1. Prepare documents for sharing
  2. Control document access
  3. Attach digital signatures
  4. Objective Review
Using Microsoft Office Excel 2007
1. Chapter 1 Creating and Manipulating Data
  1. Insert data by using Auto Fill
  2. Ensure data integrity
  3. Modify cell contents and formats
  4. Change worksheet views
  5. Manage worksheets
  6. Objective Review
2. Chapter 2 Formatting Data and Content
  1. Format worksheets
  2. Insert and modify rows and columns
  3. Format cells and cell content
  4. Format data as a table
  5. Objective Review
3. Chapter 3 Creating and Modifying Formulas
  1. Reference data in formulas
  2. Summarize data by using a formula
  3. Summarize data by using subtotals
  4. Conditionally summarize data by using a formula
  5. Look up data by using a formula
  6. Use conditional logic in a formula
  7. Format or modify text by using formulas
  8. Display and print formulas
  9. Objective Review
4. Chapter 4 Presenting Data Visually
  1. Create and format charts
  2. Modify charts
  3. Apply conditional formatting
  4. Insert and modify illustrations
  5. Outline data
  6. Sort and filter data
  7. Objective Review
5. Chapter 5 Collaborating and Securing Data
  1. Manage changes to workbooks
  2. Protect and share workbooks
  3. Prepare workbooks for distribution
  4. Save workbooks
  5. Set print options for printing data, worksheets, and workbooks
  6. Objective Review
Using Microsoft Office PowerPoint 2007
1. Chapter 1 Creating and Formatting Presentations
  1. Create new presentations
  2. Customize slide masters
  3. Add elements to slide masters
  4. Create and change presentation elements
  5. Arrange slides
  6. Objective Review
2. Chapter 2 Creating and Formatting Slide Content
  1. Insert and format text boxes
  2. Manipulate text
  3. Add and link existing content to presentations
  4. Apply, customize, modify, and remove animations
  5. Objective Review
3. Chapter 3 Working with Visual Content
  1. Create SmartArt diagrams
  2. Modify SmartArt diagrams
  3. Insert illustrations and shapes
  4. Modify illustrations
  5. Arrange illustrations and other content
  6. Insert and modify charts
  7. Insert and modify tables
  8. Objective Review
4. Chapter 4 Collaborating On and Delivering Presentations
  1. Review presentations
  2. Protect presentations
  3. Secure and share presentations
  4. Prepare printed materials
  5. Prepare for and rehearse presentation delivery
  6. Objective Review
Using Microsoft Office Outlook 2007
1. Chapter 1 Managing Messages
  1. Create and send an e-mail message
  2. Create and manage your signature and automated messages
  3. Manage e-mail message attachments
  4. Configure e-mail message sensitivity and importance settings
  5. Configure e-mail message security settings
  6. Configure e-mail message delivery options
  7. View e-mail messages
  8. Objective Review
2. Chapter 2 Managing Scheduling
  1. Create appointments, meetings, and events
  2. Send meeting requests
  3. Update, cancel, and respond to meeting requests
  4. Customize calendar settings
  5. Share your calendar with other people
  6. View other calendars
  7. Objective Review
3. Chapter 3 Managing Tasks
  1. Create and modify tasks, and mark tasks as complete
  2. Accept, decline, assign, update, and respond to tasks
  3. Objective Review
4. Chapter 4 Managing Contacts and Personal Contact Information
  1. Create and modify contacts
  2. Edit and use an electronic business card
  3. Create and modify distribution lists
  4. Create a secondary address book
  5. Objective Review
5. Chapter 5 Organizing Information
  1. Categorize Outlook 2007 items by color
  2. Create and manage Outlook 2007 data files
  3. Organize mail folders
  4. Locate Outlook 2007 items by using the search feature
  5. Create, modify, and remove rules to manage e-mail messages
  6. Customize your Outlook 2007 experience
  7. Objective Review
Using Microsoft Office Access 2007
1. Chapter 1 Structuring a Database
  1. Define data needs and types
  2. Define and print table relationships
  3. Add, set, change, or remove primary keys
  4. Split databases
  5. Objective Review
2. Chapter 2 Creating and Formatting Database Elements
  1. Create databases
  2. Create tables
  3. Modify tables
  4. Create fields and modify field properties
  5. Create forms
  6. Create reports
  7. Modify the design of reports and forms
  8. Objective Review
3. Chapter 3 Entering and Modifying Data
  1. Enter, edit, and delete records
  2. Navigate among records
  3. Find and replace data
  4. Attach documents to and detach from records
  5. Import data
  6. Objective Review
4. Chapter 4 Creating and Modifying Queries
  1. Create queries
  2. Modify queries
  3. Objective Review
5. Chapter 5 Presenting and Sharing Data
  1. Sort data
  2. Filter data
  3. Create and modify charts
  4. Export data
  5. Save database objects as other file types
  6. Print database objects
  7. Objective Review
6. Chapter 6 Managing and Maintaining Databases
  1. Perform routine database operations
  2. Manage databases
  3. Objective Review

Appendix About the Authors
1. The Team
2. Online Training Solutions, Inc. (OTSI)
Appendix Choose the Right Book for You

Title:

Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition

By:

Joyce Cox, Joan Lambert

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

April 2008

Ebook:

November 2009

Pages:

816

Print ISBN:

978-0-7356-2548-8

| ISBN 10:

0-7356-2548-4

Ebook ISBN:

978-0-7356-3033-8

| ISBN 10:

0-7356-3033-X

Description

Table of Contents

Product Details

About the Author

Recommended for You

Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews

Microsoft Press Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition

3.0

(based on 1 review)

Reviews

Reviewed by 1 customer

Displaying review 1

6/24/2011

3.0

No practice files with purchase

By TMD

from Ontario, Canada

About Me Educator

Pros

Accurate
Easy to understand

Cons

Best Uses

Comments about Microsoft Press Microsoft® Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition:

Overall content was helpful, however I never did recieve the hard copy and practice files that I ordered.

Displaying review 1

Save a Tree - Go Digital what is this?

Ebook: $31.99

Formats: APK, DAISY, ePub, Mobi, PDF

Print & Ebook: $43.99

This item is not available.

Print: $39.99

The shipment of this item may be delayed.

Safari Books Online - Read now >

Using Microsoft Office Word 2007

Chapter 1 Creating and Customizing Documents

Chapter 2 Formatting Content

Chapter 3 Working with Visual Content

Chapter 4 Organizing Content

Chapter 5 Reviewing Documents

Chapter 6 Sharing and Securing Content

Using Microsoft Office Excel 2007

Chapter 1 Creating and Manipulating Data

Chapter 2 Formatting Data and Content

Chapter 3 Creating and Modifying Formulas

Chapter 4 Presenting Data Visually

Chapter 5 Collaborating and Securing Data

Using Microsoft Office PowerPoint 2007

Chapter 1 Creating and Formatting Presentations

Chapter 2 Creating and Formatting Slide Content

Chapter 3 Working with Visual Content

Chapter 4 Collaborating On and Delivering Presentations

Using Microsoft Office Outlook 2007

Chapter 1 Managing Messages

Chapter 2 Managing Scheduling

Chapter 3 Managing Tasks

Chapter 4 Managing Contacts and Personal Contact Information

Chapter 5 Organizing Information

Using Microsoft Office Access 2007

Chapter 1 Structuring a Database

Chapter 2 Creating and Formatting Database Elements

Chapter 3 Entering and Modifying Data

Chapter 4 Creating and Modifying Queries

Chapter 5 Presenting and Sharing Data

Chapter 6 Managing and Maintaining Databases

Appendix About the Authors

The Team

Online Training Solutions, Inc. (OTSI)

Appendix Choose the Right Book for You

Joyce Cox

Joan Lambert

About O'Reilly

Community

More O'Reilly Sites

Partner Sites

Shop O'Reilly