How to use • Create workbooks more efficiently using a new results-oriented interface • Use data-analysis tools and techniques for better decision making • Use organizing, processing, and presenting tools to create data in Excel • Integrate data from external sources and add hyperlinks • Use conditional formatting to visualize results • Add impact to your data with PivotTable and PivotChart reports • Create organizational data reporting and publishing solutions • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Use Groove and SharePoint Team Services to collaborate and share documents and information • Prepare for the Microsoft Certified Application Specialist (MCAS) exam • Practice your new skills with the useful workshops inside On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Excel example files that you need for project tasks are available at www.perspection.com. Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.

Microsoft Office Access 2007 For those who would rather be shown how than told how See How To Create databases more efficiently using a new results-oriented interface Use tools for building a database that makes information easier to find and use Import data from other programs, HTML, XML files, and other databases Use forms, filters, queries, and reports to capture and analyze data Discover ways to prevent data corruption and unauthorized access Share your data with others through interactive web pages Put your newly acquired skills to work using the online workshops Organize information and add impact with clip art, SmartArt diagrams, tables, and charts Use Groove and SharePoint Team Services to collaborate and share documents and information Prepare for the Microsoft Certified Application Specialist (MCAS) exam On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Access example files that you need for project tasks are available at www.perspection.com Author Bio Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com. Category Database Covers Microsoft Office Access 2007 User Level Beginning–Intermediate 1 Getting Started with Access 2 Touring Access Databases 3 Planning and Creating a Custom Database 4 Working with Fields 5 Working with Tables 6 Locating Specific Information Using a Query 7 Simplifying Data Entry with Forms 8 Creating Reports to Convey Information 9 Improving the Appearance of Forms and Reports 10 Working on the Web 11 Importing and Exporting Information 12 Managing a Database 13 Protecting and Securing a Database 14 Customizing Access 15 Enhancing a Database with Programming 16 Working Together on Office Documents New Features Microsoft Certified Applications Specialist Index

See How To • Create documents more efficiently using a new results-oriented interface • Use formatting, editing, reviewing, and publishing tools to create documents in print and online • Create great-looking documents faster using themes, styles, and templates • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Create customized letters, labels, and envelopes • Use the Full Reading view to comfortably read documents on screen • Use the Outline and Draft views to develop your documents • Use Groove and SharePoint Team Services to collaborate and share documents and information • Prepare for the Microsoft Certified Applications Specialists exam This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Word example files that you need for project tasks are available at www.perspection.com This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.

What you need, when you need it! Need answers quickly? Microsoft Office 2010 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Includes Workshops MCAS Exam Prep More than 700 Essential Office Tasks Inside the Book • Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with an improved results-oriented interface and File tab • Word: Create great-looking documents faster using themes and templates • Excel: Use organizing, processing, and presenting tools to create data in Excel Workbooks • PowerPoint: Create powerful presentations faster using readymade design templates and themes • Access: Use full-featured templates and application parts to create regular and web databases. • Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks • Publisher: Use the File tab and Ribbon to quickly create a brochure or a newsletter without being a designer • Office Web Apps: View and edit your Office documents in a browser • MCAS: Prepare for the Microsoft Certified Application Specialist exam Bonus Online Content Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts

How to Use • Office: Organize information and add impact with clip art, SmartArt diagrams, tables, and charts with a new results-oriented interface • Word: Create great-looking documents faster using themes, styles, and templates • Excel: Use organizing, processing, and presenting tools to create data in Excel • PowerPoint: Create powerful presentations faster using ready-made design templates and themes • Outlook: Use tools for creating and managing your e-mail, calendar, contacts, and tasks • Publisher: Use task panes to quickly create a brochure or a newsletter without being a designer • SharePoint: Collaborate and share documents and information • Prepare for the Microsoft Certified Application Specialist exam • Practice your new skills with the useful workshops inside On the Web This book uses real-world examples to give you a context in which to use a task. This book also includes workshops to help you put together individual tasks into projects. The Office example files that you need for project tasks are available at www.perspection.com Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com.

This book looks at the new version of Microsoft Windows Office.

Look beyond the hype–new and noteworthy and what Vista really means for tomorrow’s desktop. Covers the Beta 2 release of Windows® Vista An unbiased, unvarnished sneak peek at everything that’s new, noteworthy, and ready for prime time in Windows Vista. Microsoft Windows Vista Unveiled is an in-depth exploration of the public release Beta 2 version of Windows Vista, Microsoft’s next major operating system and the successor to Windows XP. Whether you’re just planning ahead for a future upgrade or running Beta 2 already, Microsoft Windows Vista Unveiled takes you on a detailed tour of all the new and improved technologies, features, tools, and programs that Microsoft programmers have stitched into the Vista fabric. You will learn not only what features are new in Vista, but also why they’re important (or not), who they were designed for, and how they will affect your computing life. The goal of this book is to give you an exhaustive sneak preview of Vista’s innovations and changes so that by the end of the book you should know whether Vista is for you and what you can expect when you sit down in front of this new operating system. Here’s what you’ll find inside… In-depth coverage of all the new and improved Windows Vista tools and technologies A tour of the new Windows Vista interface, including Aero Glass What hardware you need to get the most out of Windows Vista Vista’s file system improvements, including tags, Quick Search, and virtual folders A review of Vista’s new performance and stability features A critical look at the beefed-up security features, including Windows Defender, the new Firewall, and User Account Control A complete look at Vista’s totally redesigned networking tools In-depth coverage of Vista’s new and improved tools for notebooks and Tablet PCs, digital media, and gaming Paul McFedries is the president of Logophilia Limited, a technical writing company. He has been working with computers for more than 30 years, has been using Microsoft Windows since version 1, and is widely viewed as an expert in explaining Windows and Windows technology. Paul has written more than 40 books that have sold nearly three million copies worldwide, including Microsoft Windows Vista Unleashed, available January 2007.

Explains how to use the new Windows Vista operating system, discussing how to get started; how to work with programs, folders, files, and peripherals; and how to use Windows Vista for entertainment and communication purposes.

How to Use • Create powerful presentations faster using ready-made templates and Smart Tags • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Make your presentation come alive with custom animations • Add narration, animation, 3-D effects, and movie • Add comments and e-mail your presentation to others for review and collaboration • Deliver your presentation in a meeting room on multiple screens • Use Groove and SharePoint Team Services to collaborate and share documents and information • Prepare for the Microsoft Certified Application Specialist exam. • Practice your new skills with the useful workshops inside On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The PowerPoint example files that you need for project tasks are available at www.perspection.com. Perspection has written and produced books on a variety of computer software–including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks–and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies. Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com. Chapter 1 Getting Started with PowerPoint 1 Chapter 2 Developing Presentation Content 31 Chapter 3 Designing a Look 73 Chapter 4 Drawing and Modifying Shapes 105 Chapter 5 Inserting Pictures and Multimedia 151 Chapter 6 Inserting Charts and Related Material 189 Chapter 7 Creating a Web Presentation 243 Chapter 8 Finalizing a Presentation and Its Supplements 267 Chapter 9 Preparing a Slide Show 299 Chapter 10 Starting a Slide Show 321 Chapter 11 Reviewing and Securing a Presentation 335 Chapter 12 Working Together on Office Documents 363 Chapter 13 Customizing the Way You Work 391 Chapter 14 Expanding PowerPoint Functionality 401 W Workshops: Putting It All Together 425 New Features 439 Microsoft Certified Applications Specialist 444

What you need, when you need it! Need answers quickly? Microsoft Excel 2010 on Demand provides those answers in a visual step-by-step format. We will show you exactly what to do through lots of full color illustrations and easy-to-follow instructions. Includes Workshops MCAS Exam Prep More than 500 Essential Excel Tasks Inside the Book • Create workbooks more efficiently using the improved Ribbon interface • Use data-analysis tools and techniques for better decision making • Use organizing, processing, and presenting tools to create and analyze data • Integrate data from external sources and add hyperlinks • Use conditional formatting and Sparklines to visualize results • Add impact to your data with PivotTable and PivotChart reports • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Use SharePoint to collaborate and share documents • Use the Excel Web App to view and edit documents in a browser • Prepare for the Microsoft Certified Application Specialist (MCAS) exam Bonus Online Content Register your book at queondemand.com to gain access to: • Workshops and related files • Keyboard shortcuts