Home Page Icon
Home Page
Table of Contents for
6. Outlook
Close
6. Outlook
by Microsoft Corporation
2007 Microsoft® Office System Inside Out
2007 Microsoft® Office System Inside Out
SPECIAL OFFER: Upgrade this ebook with O’Reilly
A Note Regarding Supplemental Files
Acknowledgments
About the CD
What’s on the CD
Using the CD
System Requirements
Support Information
Conventions and Features Used in This Book
Text Conventions
Design Conventions
1. Introduction
Who This Book Is For
How This Book Is Organized
1. Getting Started
1. Overview of the 2007 Microsoft Office System
The New World of Work
Collaboration Workspaces and Tools
Business Intelligence on Your Desktop
The New Microsoft Office User Interface
The Ribbon
Galleries and Live Preview
The New Microsoft Office XML File Formats
What Else Is New?
Microsoft Office Word 2007
Microsoft Office Excel 2007
Microsoft Office PowerPoint 2007
Microsoft Office Outlook 2007
Microsoft Office Access 2007
2007 Office System Servers
Forms Server
Groove Server
Project Server
Templates and Assistance from Microsoft Office Online
2. The 2007 Office System User Interface: What’s Changed, What’s the Same
A Quick Tour and Comparison
The Ribbon and Command Tabs
Customizing the Quick Access Toolbar
The Microsoft Office Button and Menu
Working in Context: More Tabs, Plus Some Menus and Toolbars
Contextual Tabs
Shortcut Menus and the Mini Toolbar
Galleries and Live Preview
Getting Help
Searching Online Help
3. Managing Security and Privacy in the 2007 Office System
Working in the Trust Center
Digital Signatures and Trusted Publishers
Using Trusted Locations
Setting Security Options for Macros and Add-Ins
Security Settings for ActiveX Controls
Setting Your Privacy Options
Removing Hidden Data and Personal Information from Microsoft Office Documents
Applying Information Rights Management
Configuring Your Computer to Use Information Rights Management
Restricting Permissions
Assigning a Password to a Document
Changing a Password
Removing a Password
Avoiding Phishing Schemes
2. Collaboration Essentials
4. Collaborating and Sharing with Others
Understanding and Using the 2007 Office System Collaboration Environments
Creating and Using Shared Workspaces with Windows SharePoint Services
Understanding the Workspace
Libraries
Lists and Other Communication Tools
Accessing or Adding Content in a SharePoint Document Library
Adding Content to a Library or List
Creating or Editing a Windows SharePoint Services Shared Workspace
Adding Sites, Pages, or Lists
Understanding and Using Web Parts
Managing Site Settings and Permissions
Creating and Using Groove Workspaces
Understanding Your Workspace
Managing Files in a Workspace
Creating a Workspace
Adding Tools to Your Workspace
Inviting Others to Join a Workspace
Setting Roles and Permissions
Using Office OneNote 2007 as a Collaboration Tool
Shared Notebooks and Live Sharing Sessions
Creating a Live Sharing Session
Creating a Shared Notebook
5. Organizing and Finding Information in Microsoft Office OneNote
Organizing a OneNote Notebook
Creating a Notebook
Working in the OneNote Window
Organizing Notebook Sections
Adding and Grouping Notebook Pages
Adding Notes and Information to a Notebook
Adding and Working with Text Notes
Tagging Types of Notes
Printing to OneNote
Embedding References to Files
Using Office OneNote and Office Outlook Together
Inserting Audio or Video Recordings
Adding Information to a Notebook from the Web
Capturing Information on Your Windows Mobile–Powered Device
Inserting an Image in a Notebook
Creating a Drawing in OneNote
Creating and Working with Tables in OneNote
Finding Your Information
Using a Notebook on More Than One Computer
Creating a Notebook for Use on More Than One Computer
Share an Existing Notebook Among Your Computers
Working as a Team with Office OneNote 2007
Working with a Shared Notebook
Protecting a Shared Section
Sharing an Existing Notebook
Sharing a Notebook in a Live Session
Sharing Notes Using E-Mail
6. Working as a Team in a Microsoft Office Groove Workspace
Getting Started with Groove
Setting Up a Groove Account
The View from the Launchbar
Groove Workspace Basics
Creating a Workspace
Inviting Workspace Members and Assigning Member Roles
Using Your Groove Account on a Second Computer
Knowing When Members Are Present and Accounted For
Chatting with Workspace Members
Setting Roles and Changing Role Permissions
Exploring a Groove Workspace
Outfitting a Groove Workspace with Tools
Keeping a Calendar
Topics Under Discussion
Making Meetings More Effective
Storing, Organizing, and Sharing Files
Tracking Issues
Taking Notes
Adding Pictures to a Workspace
Sketching Your Ideas
7. Sharing and Communicating Using Microsoft Office Groove
Setting Up and Using a File-Sharing Workspace
Downloading Files in a File-Sharing Workspace
Managing Groove Communications
Using the Communications Manager
Pausing Communications
Working with Groove Offline
Viewing and Modifying Network Settings
Groove Instant Messaging
Managing Groove Messages and Message History
Managing Groove Alerts
Working with Groove Contacts
Managing Contacts from the Launchbar
Viewing a Digital Fingerprint
Verifying Contact Identities
Introducing the Groove Forms Tool
Designing a Form
Designing a View
Testing and Publishing Your Form
Managing Workspace Archives and Templates
3. Word
8. Mastering Page Setup and Pagination
Basic Page Setup Options
Changing Margins and Orientation
Changing Margin Settings
Choosing Orientation
Selecting a Paper Size and Source
Choosing a Paper Size
Selecting the Paper Source
Saving Page Setup Defaults to the Current Template
Controlling Page and Section Breaks
Adding Manual Page Breaks
Creating Additional Sections
Inserting Text Wrapping Breaks
Working with Varying Page Settings
Multiple Page Settings
Aligning Content Vertically Between Margins
Including Headers and Footers
Adding Page Numbers
Creating Headers and Footers
Deleting Headers and Footers
Working with the Document Grid
Specifying Document Grid Settings
Displaying the Drawing Grid
Adding and Controlling Line Numbers
9. Outlining Documents for Clarity and Structure
Outlining Enhancements in Word 2007
Creative Outlining with Word 2007
Eleven Reasons to Outline Your Next Complex Document
Viewing a Document in Outline View
Exploring the Outlining Tools
Creating a New Outline
Choosing Outline Display
Displaying Different Levels of Text
Showing the First Line of Text
Removing and Showing Formatting
Working with Headings in Outline View
Adding a Heading
Applying Outline Levels
Promoting and Demoting Headings
Displaying Outline and Print Layout View at the Same Time
Changing Your Outline
Expanding and Collapsing the Outline
Moving Outline Topics
Moving Topics Up and Down
Cutting and Pasting Parts of the Outline
Dragging to a New Location
Printing Your Outline
Using the Document Map vs. Using Outline View
10. Advanced Layout and Formatting
Layout and Design Fundamentals
Using Backgrounds and Watermarks
Creating Backgrounds and Watermarks
Adding Backgrounds to Online Pages
Adding Watermarks to Documents
Changing and Removing Backgrounds and Watermarks
Controlling Text Placement and Formatting with Text Boxes, Shapes, and Frames
Creating Text Boxes
Inserting Text into Text Boxes and Shapes
Using Floating Frames for Comments, Footnotes, Tables, and Fields
Formatting Text Boxes and AutoShapes
Controlling Text in Text Boxes and Shapes
Changing Text Box Shapes
Resizing Text Boxes or AutoShapes Automatically to Show All Content
Linking Text Boxes to Flow Text from One Text Box to Another
Moving Between Linked Text Boxes
Copying or Moving Linked Text Boxes
Breaking Text Box Links
Deleting Linked Text Boxes Without Losing Text
Switching Between Text Boxes and Frames
Configuring Word 2007 Layout Options
Commanding Attention with Borders and Shading
Adding a Simple Border
Creating Enhanced Borders
Choosing Border Options
Selecting Line Styles for Borders
Choosing a Border Color
Controlling Border Width
Creating Partial Borders
Using a Page Border
Creating a Page Border
Adding an Artistic Border
Adding Borders to Document Sections and Paragraphs
Bordering Sections
Adjusting Border Spacing
Inserting Graphical Horizontal Lines
Adding a Graphical Horizontal Line
Formatting a Graphical Horizontal Line
Importing a Custom Line
Adding Borders to Pictures
Using the Picture Border Tool
Adding a Picture Border by Formatting the Picture
Adding Table Borders
Applying Shading Behind Content
Applying Shades to Tables and Paragraphs
Shading Considerations
11. Revising Documents Using Markup Tools
Benefits of an Organized Revision Process
Familiarizing Yourself with Markup Tools
Using the Highlight Tool
Highlighting Information
Removing Highlighting from Documents
Finding Highlighted Items
Reformatting Highlighted Items with Another Highlight Color
Adding and Managing Comments Effectively
Configuring Reviewers’ User Names
Configuring Colors Associated with Reviewers
Allowing Reviewers to Use Only the Comments Feature
Inserting Standard Comments
Configuring Comment Balloon and Reviewing Pane Options
Changing the Styles of Balloon and Reviewing Pane Text and Labels
Showing and Hiding Balloons
Adjusting Balloon Size and Location for Online Viewing
Reviewing Comments
Deleting Comments
Printing Comments
Saving a Document with Comments as a Web Page
Tracking Changes
Tracking Changes While You Edit
Adjusting the Appearance of Tracked Changes
Specifying How Insertions and Formatting Changes Are Displayed
Tracking Moved Text and Inline Shapes
Showing Revisions in Tables
Customizing the Appearance of Changed Lines
Accepting and Rejecting Proposed Edits
Addressing Tracked Changes One at a Time
Accepting or Rejecting All Tracked Changes at Once
Printing Documents That Contain Revisions
Comparing and Combining Documents
Comparing Two Versions of a Document (Legal Blackline)
Combining Revisions from Multiple Authors
4. Excel
12. How to Work a Worksheet and a Workbook
Moving Around Regions
Navigating Regions with the Keyboard
Navigating Regions with the Mouse
Navigating with Special Keys
Understanding Selection
Selecting with the Mouse
Zooming to Select Large Worksheet Areas
Selecting Columns, Rows, and Multiple Areas
Selecting Regions
Using the Find & Select Commands
Selecting with Go To Special
Selecting Precedents and Dependents
Selecting Row or Column Differences
Techniques for Entering Data
Making Entries in Cells and in the Formula Bar
Entering Simple Numeric and Text Values
Using Special Characters
Understanding the Difference Between Displayed Values and Underlying Values
Creating Long Text Values
Using Text Wrapping
Understanding Numeric Text Entries
Entering Symbols
Making Entries in Ranges
Editing and Undoing Entries
Managing Worksheets
Inserting and Deleting Worksheets
Naming and Renaming Worksheets
Moving and Copying Worksheets
Viewing Worksheets
Splitting Worksheets into Panes
Freezing Panes
Zooming Worksheets
Using Custom Views
Protecting Worksheets
Unlocking Individual Cells
Protecting the Workbook
Allowing Password Access to Specific Cell Ranges
Hiding Cells and Worksheets
Using Passwords
Managing Multiple Workbooks
Navigating Between Open Workbooks
Arranging Workbook Windows
Getting the Most Out of Your Screen
Comparing Worksheets Side by Side
Opening Multiple Windows for the Same Workbook
Useful Inconsistencies of New Windows
Hiding and Protecting Workbooks
Hiding Workbooks
Protecting Workbooks
Encrypting Workbooks
Saving Workbooks or Windows as Hidden
Hiding Worksheets
13. Building Formulas
Formula Fundamentals
Understanding the Precedence of Operators
Using Cell References in Formulas
Entering Cell References by Clicking
Understanding Relative, Absolute, and Mixed References
Creating References to Other Worksheets in the Same Workbook
Creating References to Worksheets in Other Workbooks
Understanding Row-Column Reference Style
How Copying Affects Cell References
Copying Relative References
Copying Absolute References
Copying Mixed References
Editing Formulas
Understanding Reference Syntax
Using Numeric Text in Formulas
About Text Values
Understanding Error Values
Using Functions: A Preview
Using the Sum Button
Inserting a Function
Using Formula AutoComplete
Working with Formulas
Naming Cells and Cell Ranges
Using Names in Formulas
Defining and Managing Names
Editing Names
Workbook-Wide vs. Worksheet-Only Names
Creating Names Semiautomatically
Naming Constants and Formulas
Using Relative References in Named Formulas
Creating Three-Dimensional Names
Using Names in Formulas
Creating a List of Names
Replacing References with Names
Using Go To with Names
Getting Explicit About Intersections
Creating Three-Dimensional Formulas
Formula-Bar Formatting
Using Structured References
Understanding Structured Reference Syntax
Using Operators with Column Specifiers
About the Special Item Specifiers
Using Formula AutoComplete with Structured References
Filling and Copying Structured References
Worksheet Calculation
Recalculating Manually
Calculating Part of a Formula
Working with Circular References
Understanding the Precision of Numeric Values
Using Arrays
One-Dimensional Arrays
Array Formula Rules
Two-Dimensional Arrays
Single-Cell Array Formulas
Using Array Constants
Understanding Array Expansion
Linking Workbooks
Saving Linked Workbooks
Opening a Dependent Workbook
Editing Links
Copying, Cutting, and Pasting in Linked Workbooks
Copying and Pasting Between Workbooks
Cutting and Pasting Between Workbooks
Creating Conditional Tests
Using the Conditional Sum and Lookup Wizards
Creating Conditional Sum Formulas
Creating Lookup Formulas
14. Using Functions
Using the Built-In Function Reference in Excel
Exploring the Syntax of Functions
Expressions as Arguments
Types of Arguments
Numeric Values
Text Values
Logical Values
Named References
Arrays
Mixed Argument Types
Inserting Functions
Inserting References and Names
Understanding Mathematical Functions
Using the SUM Function
The Sum Button
Using Selected Mathematical Functions
The PRODUCT and SUMPRODUCT Functions
The MOD Function
The COMBIN Function
The RAND and RANDBETWEEN Functions
Using the Rounding Functions
The ROUND, ROUNDDOWN, and ROUNDUP Functions
The EVEN and ODD Functions
The FLOOR and CEILING Functions
The INT Function
The TRUNC Function
Understanding Text Functions
Using Selected Text Functions
The TEXT Function
The DOLLAR Function
The LEN Function
The ASCII Functions: CHAR and CODE
The Cleanup Functions: TRIM and CLEAN
The EXACT Function
The Case Functions: UPPER, LOWER, and PROPER
Using the Substring Text Functions
The FIND and SEARCH Functions
The RIGHT and LEFT Functions
The MID Function
The REPLACE and SUBSTITUTE Functions
The CONCATENATE Function
Understanding Logical Functions
Using Selected Logical Functions
The IF Function
The AND, OR, and NOT Functions
Nested IF Functions
Other Uses for Conditional Functions
Understanding Information Functions
Using Selected Information Functions
The TYPE and ERROR.TYPE Functions
The COUNTBLANK Function
Using the IS Information Functions
Understanding Lookup and Reference Functions
Using Selected Lookup and Reference Functions
The VLOOKUP and HLOOKUP Functions
The LOOKUP Function
The ADDRESS Function
The CHOOSE Function
The MATCH Function
The INDEX Function
The INDIRECT Function
The ROW and COLUMN Functions
The ROWS and COLUMNS Functions
The AREAS Function
The TRANSPOSE Function
15. Analyzing Data with PivotTable Reports
Introducing PivotTables
Creating a PivotTable
Rearranging PivotTable Fields
Refreshing a PivotTable
Changing the Numeric Format of PivotTable Data
Choosing Report Layout Options
Formatting a PivotTable
Customizing the Display of Empty or Error Cells
Merging and Centering Field Labels
Hiding Outline Controls
Hiding Row Labels and Column Labels
Displaying Totals and Subtotals
Customizing Subtotals
Sorting PivotTable Fields
Filtering PivotTable Fields
Changing PivotTable Calculations
Using a Different Summary Function
Applying Multiple Summary Functions to the Same Field
Using Custom Calculations
Using Calculated Fields and Items
Creating a Calculated Field
Creating a Calculated Item
Displaying a List of Calculated Fields and Items
Grouping and Ungrouping Data
Creating Ad Hoc Item Groupings
Grouping Items in Date or Time Ranges
Displaying the Details Behind a Data Value
Creating PivotCharts
5. PowerPoint
16. Introduction to PowerPoint 2007
Command Locations
Customizing Office PowerPoint 2007
Customizing the Quick Access Toolbar
Setting PowerPoint 2007 Options
PowerPoint Options: Popular
PowerPoint Options: Proofing
PowerPoint Options: Save
PowerPoint Options: Advanced
PowerPoint Options: Add-Ins
PowerPoint Options: Trust Center
PowerPoint Options: Resources
File Formats
Opening a PowerPoint 2007 Presentation in PowerPoint 97–2003
Saving to PowerPoint 95 and Earlier File Formats
About PDF and XPS File Formats
Formatting
PowerPoint 2007 Views
Slide Masters
Themes
Saving a Document Theme
Tables
Adding a New Table to Your Presentation
Drawing a Table in Your Presentation
Copying a Table from Word 2007 or Excel 2007
Inserting an Excel 2007 Spreadsheet
A Word About Table Styles
Custom Slide Layouts
Creating a Custom Slide Layout
PowerPoint 2007 Slide Libraries
Program Recovery
17. Working with Text
Adding a Text Box to a Slide
Finding and Replacing Words or Phrases
Creating and Saving Customized Theme Fonts
Formatting with WordArt
WordArt Styles
Adding WordArt Style to Text
Adding Punch to Your Bulleted Lists
Writing on Slides During a Presentation
Using Headers and Footers
Working with Proofing Tools
18. Working with Objects, Diagrams, and Charts in PowerPoint 2007
Working with Pictures
Adjust Your Pictures
Adding a Picture Style
Arrange Pictures
Size
Adding Clip Art
Using SmartArt
Creating a SmartArt Graphic from Scratch
Adding a SmartArt Style to Your Graphic
Adding Pictures to a SmartArt Graphic
Using Picture Placeholders in a Shape
Customizing Your SmartArt Graphic
Adding Sounds
Including Movies
Playing with Animations
Animating SmartArt Graphics
Creating Charts and Diagrams
Saving a Chart Template
Chart Formatting Options
19. Collaborating and Sharing
Using Templates
Working with Windows SharePoint Services
Reviewing, Approving, and Tracking Changes
Adding Comments
Editing and Deleting Comments
Protecting Your Document
Securing Your Presentation
Using the Document Inspector
20. Working with External Data in PowerPoint 2007
Working with Earlier Versions of PowerPoint
Working with Excel 2007
Create a New Excel 2007 Table in PowerPoint 2007
Add an Existing Excel Table from Excel 2007
Working with Access 2007
Add an Existing Table, Form, Report, or Other Object from Access 2007
Use a Screen Capture to Copy Content from Access 2007
Blocking and Unblocking External Content
Using Trusted Locations
Create a Trusted Location
Remove a Trusted Location
Modify a Trusted Location
Setting Up Security Alerts and Trusted Publishers
21. Setting Up and Presenting a Slide Show
Learning the Basics
Keep Your Viewers on Track
Copyright Your Work
Secure Your Document When It’s Complete
Verify Your Slide Show Before Delivery
Creating Custom Slide Shows
Create a Basic Custom Show
Create a Hyperlinked Custom Show
Run a Custom Show
Adding Transitions
Using Presenter View
Working with Photo Albums
Publish Your Photo Album to the Web
Exploring Printing Options
6. Outlook
22. Introducing Outlook 2007
A New Interface
The Ribbon
The Navigation Pane
The To-Do Bar
Other Interface Changes
Instant Search
Calendar Changes
E-Mail Changes
Color Categories
Collaboration and Sharing Improvements
Integration with Office SharePoint Server
Shared Calendars
Shared Business Cards
Overview of Outlook 2007 Capabilities
Messaging
Exchange Server
Internet E-Mail
HTTP-Based E-Mail
Fax Send and Receive
Extensible E-Mail Support
Scheduling
Contact Management
Task Management
Tracking with the Outlook Journal
Organizing Your Thoughts with Notes
How Outlook Stores Data
Personal Folders—.pst Files
Options for Working Offline
Sharing Storage Files
Understanding Messaging Protocols
SMTP/POP3
IMAP
MAPI
LDAP
NNTP
HTML
MIME
S/MIME
MHTML
iCalendar, vCalendar, and vCard
Security Provisions in Outlook
Protection Against Web Beacons
Attachment and Virus Security
Macro Viruses
Digital Signatures
Message Encryption
Security Labels
Understanding Outlook Service Options
Options for Starting Outlook
Normal Startup
Safe Mode Startup
Starting Outlook Automatically
Adding Outlook to the Quick Launch Bar
Changing the Outlook Shortcut
Using RUNAS to Change User Context
Startup Switches
Choosing a Startup View
Creating Shortcuts to Start New Outlook Items
23. Finding and Organizing Messages
Finding and Organizing Messages with Search Folders
Using Search Folders
Customizing Search Folders
Creating a New Search Folder
Flagging and Monitoring Messages and Contacts
Flagging Received and Previously Sent Messages
Flagging Outgoing Messages
Viewing and Responding to Flagged Messages
Flagging Contact Items
Grouping Messages by Customizing the Folder View
Filtering a View Using Categories
Managing E-Mail Effectively
24. Securing Your System, Messages, and Identity
Configuring HTML Message Handling
Protecting Messages with Digital Signatures
Understanding Digital Certificates and Signatures
Obtaining a Digital Certificate
Copying a Certificate to Another Computer
Backing Up Your Certificate
Installing Your Certificate from a Backup
Signing Messages
Understanding S/MIME and Clear-Text Options
Adding Your Digital Signature
Setting Global Security Options
Creating and Using Security Profiles
Reading Signed Messages
Changing Certificate Trust Relationships
Configuring CA Trust
Configuring CA Trust for Multiple Computers
Viewing and Validating a Digital Signature
Encrypting Messages
Getting Ready for Encryption
Swapping Certificates
Obtaining a Recipient’s Public Key from a Public CA
Sending Encrypted Messages
Reading Encrypted Messages
Importing Certificates from Outlook Express
Protecting Data with Information Rights Management
Using Microsoft’s IRM Service
Viewing IRM-Protected Messages
Working with Multiple Accounts
25. Collaboration with Outlook and Windows SharePoint Services
Understanding Windows SharePoint Services Collaboration
Setting Up Alerts
Working with Shared Documents
Uploading a Document
Creating a Document from the Site
Working with Existing Documents and Version Control
Working with Shared Contacts
Viewing Contacts on a Windows SharePoint Services Site
Linking Windows SharePoint Services 2.0 Contacts Lists to Outlook
Copying Contacts from Windows SharePoint Services 2.0 to Outlook
Copying Contacts from Outlook to Windows SharePoint Services 2.0
Linking a Team Calendar to Outlook
Configuring Alerts in Outlook
Adding Alerts from Outlook
Editing and Deleting Alerts from Outlook
Rules Based on Alerts
Using Outlook to Work with SharePoint Libraries and Files
Connecting a SharePoint Library to Outlook
Downloading Files from a SharePoint Library to Outlook
Opening Files from a SharePoint Site in Outlook
Editing Files from a SharePoint Site in Outlook
Removing SharePoint Files in Outlook
Removing SharePoint Folders in Outlook
Using E-Mail to Add a File to a SharePoint Library
7. Access
26. Exploring the New Look of Access 2007
Opening Access for the First Time
Getting Started—A New Look for Access
Opening an Existing Database
Exploring the Microsoft Office Button
Taking Advantage of the Quick Access Toolbar
Understanding Content Security
Temporarily Enabling a Database That Is Not Trusted
Understanding the Trust Center
Enabling Content by Defining Trusted Locations
Understanding the New Ribbon Feature
Home Tab
Create Tab
External Data Tab
Database Tools Tab
Understanding the New Navigation Pane
Exploring Navigation Pane Object Views
Working with Custom Categories and Groups
Exploring the Navigation Options Dialog Box
Creating and Modifying a Custom Category
Creating and Modifying Groups in a Custom Category
Creating Object Shortcuts in Custom Groups
Hiding Custom Groups in a Category
Hiding and Renaming Object Shortcuts
Revealing Hidden Shortcuts
Sorting and Selecting Views in the Navigation Pane
Manually Sorting Objects in the Navigation Pane
Searching for Database Objects
Using the Single-Document vs. Multiple-Document Interface
Modifying Global Settings via the Access Options Dialog Box
27. Creating Your Database and Tables
Creating a New Database
Using a Database Template to Create a Database
Creating a New Empty Database
Creating Your First Simple Table by Entering Data
Creating a Table Using a Table Template
Creating a Table in Design View
Defining Fields
Understanding Field Data Types
Setting Field Properties
Completing the Fields in the Companies Table
Defining Simple Field Validation Rules
Defining Input Masks
Defining a Primary Key
Defining a Table Validation Rule
Understanding Other Table Properties
Defining Relationships
Defining Your First Relationship
Creating a Relationship on Multiple Fields
Adding Indexes
Single-Field Indexes
Multiple-Field Indexes
Setting Table Design Options
Creating a Default Template for New Databases
Printing a Table Definition
Database Limitations
28. Creating and Working with Simple Queries
Selecting Data from a Single Table
Specifying Fields
Setting Field Properties
Entering Selection Criteria
Working with Dates and Times in Criteria
AND vs. OR
Between, In, and Like
Using Expressions
Creating Text Expressions
Defining Arithmetic Expressions
Using the Expression Builder
Specifying Field Names
Sorting Data
Testing Validation Rule Changes
Checking a New Field Validation Rule
Checking a New Table Validation Rule
Working in Query Datasheet View
Moving Around and Using Keyboard Shortcuts
Working with Subdatasheets
Changing Data
Understanding Record Indicators
Adding a New Record
Selecting and Changing Data
Replacing Data
Copying and Pasting Data
Deleting Rows
Working with Hyperlinks
Activating a Hyperlink
Inserting a New Hyperlink
Editing an Existing Hyperlink
Sorting and Searching for Data
Sorting Data
Searching For and Filtering Data
Using Find
Filtering by Selection
Using the Filter Window
Using Filter By Form
29. Building a Form
Forms and Object-Oriented Programming
Starting from Scratch—A Simple Input Form
Building a New Form with Design Tools
The Form Design Tools Contextual Ribbon Tabs
The Field List
The Property Sheet
Building a Simple Input Form for the tblCompanies Table
Moving and Sizing Controls
The Font Group
Setting Border Color, Type, Line Thickness, and Special Effect
Setting Text Box Properties
Setting Label Properties
Setting Form Properties
Customizing Colors and Checking Your Design Results
Working with Quick Create Commands and the Form Wizard
Creating a Form with the Quick Create Commands
Creating the Basic Products Form with the Form Wizard
Modifying the Products Form
Simplifying Data Input with a Form
Taking Advantage of Combo Boxes and List Boxes
Using Toggle Buttons, Check Boxes, and Option Buttons
30. Constructing a Report
Starting from Scratch—A Simple Report
Building the Report Query
Designing the Report
Grouping Sorting, and Totaling Information
Completing the Report
Using the Report Command
Using the Report Wizard
Specifying Report Wizard Options
Viewing the Result
Modifying a Wizard-Created Report in Layout View
Building a Report in Layout View
Starting with a Blank Report
Adding Grouping and Sorting
Working with Control Layouts
Adding Totals to Records
Applying an AutoFormat
8. Microsoft Office Programming Primer
31. VBA Primer
When and Why to Use VBA
Introduction to the VBA Language and Code Structure
Recording Macros
How to Read VBA Code
Statements, Procedures, Modules, and Projects
Understanding and Using the Visual Basic Editor
The Code Window
Project Explorer
The Properties Window
Setting Up Your Workspace
Writing, Editing, and Sharing Simple Macros
Creating Modules and Starting Procedures
Objects, Properties, and Methods
Object Models
Using Auto Lists
Variables
Introducing Variable Data Types
Declaring Variables
Sharing Variables Throughout a Project
Document Variables
Object Model Member Arguments
Constants
Collection Objects
Grouping Statements
Loops
For Each...Next and For...Next Loops
Do Loops
Conditional Structures
Operators
Message Boxes and Input Boxes
Message Boxes
Input Boxes
Running One Macro from Another
Setting Macros to Conditionally Stop Executing Commands
Running Macros and Compiling Projects
Running Macros
Compiling Projects
Understanding Errors
Testing Your Macros and Debugging Errors
Creating Error Handlers
Trapping Individual Errors
Getting Help
Saving and Sharing Macros
Sharing Projects
Using VBA to Save Time on Document Production and Troubleshooting
Using the Immediate Window
Introduction to Using Events
Creating UserForms (Dialog Boxes)
Designing a UserForm
Automating a UserForm
Next Steps for Working with Automation in Microsoft Office
32. Office Open XML Essentials
Chapter Assumptions
XML Basics for Reading Your Documents
Reading a Markup Language
Understanding Key Terms
XML Editing Options
Getting to Know the Office Open XML Formats
Breaking into Your Document
The Office Open XML File Structure
Taking a Closer Look at Key Document Parts
Building a Basic Word Document from Scratch
Create the Folder Structure
Create the Main Document File
Create the Content_Types File
Create the .rels File
Compile and Open Your New Document
Add More Content Types, Document Parts, and Relationships
Editing and Managing Documents Through XML
Before You Begin Editing a Document Part
Editing Text and Formatting
Edit Text and Settings in document.xml
Add Formatting to Text in document.xml
Edit Custom Styles in styles.xml
Editing Pictures
Removing a Document Part
Customizing the Ribbon
The Basic Components of Ribbon Customization
Adding a Ribbon Tab
Add a Group to a Built-In Ribbon Tab
Binding Data to Content Controls
The Components of a Bound Content Control
Binding a Control to Custom XML
Create the Custom XML Files
Binding Custom XML to Content Controls
Next Steps for Working with the Office Open XML Formats
A. Appendix: Installing and Configuring the 2007 Office System
Installing the Microsoft Office System from the CD
Changing Your 2007 Office System Setup
Changing Your Setup from Control Panel
Changing Setup and Getting Updates from the Options Dialog Box
B. Index to Troubleshooting Topics
C. About the Authors
D. Choose the Right Book for You
Index
About the Author
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
Exploring Printing Options
Next
Next Chapter
22. Introducing Outlook 2007
Part 6. Outlook
Jim Boyce, Beth Sheresh and Doug Sheresh
Chapter 22
Chapter 23
Chapter 24
Chapter 25
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