Using Word to Present Access Data
by Marianne Moon, Jerry Joyce
2007 Microsoft® Office System Plain & Simple
- 2007 Microsoft® Office System Plain & Simple
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- Acknowledgments
- 1. About This Book
- 2. Working in Office
- 3. Common Tasks in Office
- 4. Viewing and Editing Text in Word
- What’s Where in Word 2007?
- Creating a New Document
- Composing Different Types of Documents
- Word’s Views
- Reading a Document
- Editing Text
- Finding Text
- Replacing Text
- Correcting Your Spelling and Grammar
- Correcting Text Automatically
- Adding Page Numbers
- So Many Ways to Do It
- Marking and Reviewing Changes in a Document
- Comparing Documents Side by Side
- 5. Formatting in Word
- Controlling the Look: Themes, Styles, and Fonts
- Setting the Overall Look
- Formatting Text
- Using Any Style
- Changing Character Fonts
- Setting Paragraph Alignment
- Adjusting Paragraph Line Spacing
- Indenting a Paragraph
- Formatting with Tabs
- Adding Emphasis and Special Formatting
- Copying Your Formatting
- Creating a Bulleted or Numbered List
- Formatting a List
- Creating a Table from Scratch
- Using a Predesigned Table
- Creating a Table from Text
- Adding or Deleting Rows and Columns
- Formatting a Table
- Improving the Layout with Hyphenation
- Laying Out the Page
- Changing Page Orientation Within a Document
- Flowing Text into Columns
- Creating Chapters
- Wrapping Text Around a Graphic
- Creating a Running Head
- Sorting Your Information
- Reorganizing a Document
- 6. Working with Special Content in Word
- Inserting a Cover Page
- Numbering Headings
- Adding Line Numbers
- Inserting Information with Smart Tags
- Inserting an Equation
- Adding a Sidebar or a Pull Quote
- Inserting a Watermark
- Creating Footnotes and Endnotes
- Inserting a Citation
- Creating a Table of Contents
- Printing an Envelope
- Printing a Mailing Label
- Mail Merge: The Power and the Pain
- Creating a Form Letter
- Finalizing Your Document
- 7. Working in Excel
- What’s Where in Excel?
- Entering the Data
- Editing the Data
- Excel’s Eccentricities
- Using a Predefined Workbook
- Formatting Cells
- Changing the Overall Look
- Formatting Numbers
- Moving and Copying Data
- Adding and Deleting Columns and Rows
- Creating a Series
- Hiding Columns and Rows
- Formatting Cell Dimensions
- Organizing Your Worksheets
- Setting Up the Page
- Printing a Worksheet
- Adding and Viewing Comments
- 8. Analyzing and Presenting Data in Excel
- Creating a Table
- Cell References, Formulas, and Functions
- Doing the Arithmetic
- Summing the Data
- Creating a Series of Calculations
- Making Calculations with Functions
- Troubleshooting Formulas
- Sorting the Data
- Filtering the Data
- Separating Data into Columns
- Creating Subtotals
- Summarizing the Data with a PivotTable
- Displaying Relative Values
- Automatically Highlighting Certain Data
- Customizing Conditional Formatting
- The Anatomy of a Chart
- Charting Your Data
- Formatting a Chart
- Customizing a Chart
- Reviewing the Data
- 9. Creating a PowerPoint Presentation
- What’s Where in PowerPoint?
- Creating a Presentation
- Inserting a Table
- Converting Text into a SmartArt Graphic
- Converting Text into WordArt
- Including a Slide from Another Presentation
- Inserting Multimedia
- Formatting a Slide
- Animating Items on a Slide
- Customizing Your Animation
- Adding an Action to a Slide
- Editing a Presentation
- Repeating Content on Every Slide
- Adding Transition Effects to Slides
- Modifying the Default Layout
- Creating a Photo Album
- 10. Presenting a PowerPoint Slide Show
- Adding Speaker Notes
- Printing Handouts
- The Perils of Presentation
- Running a Slide Show
- Running a Slide Show with Dual Monitors
- Customizing the Presentation
- Recording a Narration
- Timing a Presentation
- Creating Different Versions of a Slide Show
- Creating a Show for Distribution
- Taking Your Show on the Road
- Using Navigation Buttons
- Creating Pictures of Your Slides
- Reviewing a Presentation
- Changing Slide-Show Settings
- 11. Working with Messages in Outlook
- What’s Where in Outlook Messages?
- Sending E-Mail
- Receiving and Reading E-Mail
- Replying to and Forwarding a Message
- Sending or Receiving a File
- Formatting E-Mail Messages
- Managing Messages
- Signing Your E-Mail
- Setting Up RSS Subscriptions
- Reading RSS Items
- Setting Up E-Mail Accounts
- E-Mailing Your Schedule
- Understanding E-Mail Encryption
- 12. Organizing with Outlook
- 13. Creating a Publication in Publisher
- What’s Where in Publisher?
- Creating a Publication from a Design
- Creating a Publication from Scratch
- Adding Text
- Flowing Text Among Text Boxes
- Tweaking Your Text
- Adding a Table
- Repeating Objects on Every Page
- Modifying a Picture
- Formatting an Object
- Adding a Design Object
- Arranging Objects on the Page
- Stacking and Grouping Objects
- Flowing Text Around an Object
- Reusing Content
- Inserting Your Business Information
- Creating a Web Site in Publisher
- Double-Checking Your Publication
- Sending a Publication as E-Mail
- Printing Your Publication
- 14. Working in Access
- What’s Where in Access?
- What is a Relational Database?
- Using an Existing Database
- Creating a Database from a Template
- Adding a Table to a Database
- Modifying a Table
- Adding Data to a Table
- Access File Formats
- Importing Data
- Exporting Data
- Defining Relationships Among Tables
- Creating a Form
- Creating a Report from the Data
- Extracting Information from a Database (Queries)
- Analyzing Data with a PivotChart
- Collecting Data Using E-Mail
- Customizing Access
- 15. Exchanging Information Among Programs
- Inserting Excel Data into a Document, Publication, or Presentation
- Inserting an Excel Chart into a Document, Publication, or Presentation
- Analyzing a Word Table in Excel
- Using Word to Prepare PowerPoint Text
- Preparing PowerPoint Handouts in Word
- Inserting a PowerPoint Slide Show into a Document, Worksheet, or Publication
- Using Publisher to Present a Word Document
- Using Word to Prepare Publisher Text
- Using Word to Present Access Data
- Analyzing Access Data in Excel
- Adding Excel Data to an Access Database
- Using Access Data in a Mail Merge
- Using Your Contacts List in a Mail Merge
- Creating PDF or XPS Documents
- Creating an Image of Your Work
- Viewing and Annotating a Scanned Image or a Fax
- Converting a Scanned Document into Text
- Scanning a Document
- Managing and Editing Your Pictures
- Linking to a File or to a Web Page
- Managing Pictures, Videos, and Sound Files
- 16. Customizing and Securing Office
- Customizing the Quick Access Toolbar
- Customizing the Window
- Customizing Your Editing
- Changing Your User Information
- Customizing the Spelling and Grammar Checkers
- Customizing Your Spelling Dictionaries
- Changing the Location and Type of Saved Files
- Safeguarding a Document
- Protecting a Document, Workbook, or Presentation with a Password
- Signing a Document or Workbook with a Visible Signature
- Signing a Document, Workbook, or Presentation with a Digital Certificate
- Controlling Macros, Add-Ins, and ActiveX Controls
- Downloading Add-Ins and Other Free Software
- Adding or Removing Office Components
- Checking the Compatibility
- Fixing Office
- About the Authors
- Choose the Right Book for You
- Index
- About the Authors
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Microsoft Office Access 2007 is the perfect tool for analyzing relational data and for generating good-looking reports on the data. However, when it’s time to present the data in a customizable form, along with other relevant information, Access leaves something to be desired. To improve your presentation, you can send the data to Word, where you can manipulate the presentation so that it looks the way you want.
In Access, open the table, query, form, or report that you want to present in Word. If you want to export only selected records, select them.
On the External Data tab, click the Export to RTF File button.
In the Export Wizard, specify where you want the file to be located.
Select this check box if you want the file to open automatically in Word.
If you selected certain records, select this check box if you want to export only those records, or clear the check box to export all the records.
Click OK. In the Save Export Settings page of the Export Wizard, specify whether you want to save the export settings, and then click Close.
In Word, if necessary, open the document and modify it as you want. Choose the Convert command from the Office menu to save the document in the Word 2007 format.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.