2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)

Chapter 2: The 2007 Office System User Interface-What’s Changed, What’s the Same

Table 2–1: Comparison of the 2007 Office Release to Microsoft Office 2003

Chapter 3: Managing Security and Privacy in the 2007 Office System

Table 3–1: Comparison of Microsoft Office 2003 and the 2007 Office System Security Settings for Macros and Add-Ins

Table 3–2: The Document Inspector Modules

Chapter 5: Organizing and Finding Information in Microsoft Office OneNote

Table 5–1: Common Keystrokes Used to Build Tables in OneNote

Chapter 7: Sharing and Communicating Using Microsoft Office Groove

Table 7–1: Communication Status Messages

Table 7–2: Activity Communication Status Messages

Chapter 8: Mastering Page Setup and Pagination

Table 8–1: Choosing Page Settings for Multiple Pages

Chapter 9: Outlining Documents for Clarity and Structure

Table 9–1: Outline Symbols

Table 9–2: Outlining Tools

Chapter 10: Advanced Layout and Formatting

Table 10–1: Border Preview Buttons

Chapter 11: Revising Documents Using Markup Tools

Table 11–1: Markup Features on the Review Tab

Chapter 12: How to Work a Worksheet and a Workbook

Table 12–1: Keyboard Modes

Table 12–2: Keyboard Shortcuts for Navigation

Table 12–3: Keyboard Shortcuts for Data Entry

Table 12–4: Examples of Numeric and Text Values

Table 12–5: Text-Alignment Prefix Characters

Chapter 13: Building Formulas

Table 13–1: Placement of Parentheses

Table 13–2: Error Values

Table 13–3: Examples of Numeric Precision

Table 13–4: Logical Operators

Chapter 14: Using Functions

Table 14–1: LOOKUP Function Arguments

Table 14–2: MATCH Function Arguments

Chapter 15: Analyzing Data with PivotTable Reports

Table 15–1: Custom Calculation Options

Chapter 16: Introduction to PowerPoint 2007

Table 16–1: Command Locations: PowerPoint 2003 and PowerPoint 2007

Table 16–2: PowerPoint 2007 File Types and File Name Extensions

Chapter 18: Working with Objects, Diagrams, and Charts in PowerPoint 2007

Table 18–1: SmartArt Layout Choices

Chapter 20: Working with External Data in PowerPoint 2007

Table 20–1: Changed Features When PowerPoint 2007 Presentation Is Opened in an Earlier Version of PowerPoint

Chapter 22: Introducing Outlook 2007

Table 22–1: Startup Switches and Their Uses

Chapter 26: Exploring the New Look of Access 2007

Table 26–1: Macro Settings

Chapter 27: Creating Your Database and Tables

Table 27–1: Access Data Types

Table 27–2: Field Properties on the General Tab

Table 27–3: Field Definitions for the Companies Table

Table 27–4: Comparison Symbols Used in Validation Rules

Table 27–5: LIKE Wildcard Characters

Table 27–6: Input Mask Definition Characters

Table 27–7: Field Definitions for the Products Table

Table 27–8: Table Properties for Defining a Subdatasheet

Table 27–9: Field Definitions for the Company Contacts Table

Table 27–10: Field Definitions for the Contact Products Table

Table 27–11: Field Definitions for the Contact Events Table

Chapter 28: Creating and Working with Simple Queries

Table 28–1: Criteria Operators for Queries

Table 28–2: Operators Used in Arithmetic Expressions

Table 28–3: Interval Settings for DateDiff Function

Table 28–4: Arithmetic Operator Precedence

Table 28–5: Date and Time Functions

Table 28–6: Keyboard Shortcuts for Scrolling in a Datasheet

Table 28–7: Keyboard Shortcuts for Selecting Data in a Datasheet

Table 28–8: Keyboard Shortcuts for Entering Data in a Datasheet

Chapter 29: Building a Form

Table 29–1: Controls Group Buttons

Table 29–2: Font Group Buttons

Table 29–3: Border Formatting Commands for Controls