Presenting Data with Access Reports
by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh,
Office 2007 Bible
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Introduction
- Common Office Features
- Creating Documents with Word
- Making the Numbers Work with Excel
- Persuading and Informing with PowerPoint
- A First Look at PowerPoint 2007
- Creating a Presentation, Slides, and Text
- Working with Layouts, Themes, and Masters
- Working with Tables and Charts
- Creating a New Table
- Moving Around in a Table
- Selecting Rows, Columns, and Cells
- Editing a Table’s Structure
- Applying Table Styles
- Formatting Table Cells
- Understanding Charts
- Starting a New Chart
- Working with Chart Data
- Chart Types and Chart Layout Presets
- Working with Labels
- Controlling the Axes
- Formatting a Chart
- Rotating a 3-D Chart
- Summary
- Using SmartArt Diagrams, Clip Art, and Pictures
- Understanding SmartArt Types and Their Uses
- Inserting a Diagram
- Editing SmartArt Text
- Modifying SmartArt Structure
- Modifying a Hierarchy Diagram Structure
- Formatting a Diagram
- Choosing Appropriate Clip Art
- About the Clip Organizer
- Inserting Clip Art on a Slide
- Clip Art Search Methods
- Working with Clip Art Collections
- Understanding Raster Graphics
- Importing Image Files into PowerPoint
- Sizing and Cropping Photos
- Compressing Images
- Summary
- Building Animation Effects, Transitions, and Support Materials
- Delivering a Live Presentation
- Organizing Messages, Contacts, and Time with Outlook
- Fundamentals of E-Mail
- Setting Up Your E-Mail Accounts
- Modifying Account Settings
- Using Outlook Profiles
- Composing and Sending Messages
- Reading and Replying to Messages
- Understanding the Inbox Display
- Understanding Files and Folders
- Outlook Data Files
- Working with Outlook Folders
- Deleting Items and Using the Deleted Items Folder
- Setting Options for an Individual E-Mail Message
- Setting Global E-Mail Options
- Summary
- Processing and Securing E-Mail
- Understanding Junk E-Mail Filtering
- Setting Junk E-Mail Options
- Blocking and Allowing Specific Addresses
- Understanding E-Mail Rule Basics
- Creating a New Rule
- Some Rule Examples
- Managing Rules
- Protecting Against Viruses
- Dealing with Attachments
- Macro Security
- Using Certificates and Digital Signatures
- HTML Message Dangers
- Summary
- Working with Contacts
- Working with Appointments and Tasks
- Fundamentals of E-Mail
- Designing Publications with Publisher
- Tracking Detailed Data with Access
- An Introduction to Database Development
- Creating Access Tables
- Getting Started with Access 2007
- Creating a Database
- The Access 2007 Environment
- Creating a New Table
- Creating tblContacts
- Setting the Primary Key
- Printing a Table Design
- Saving the Completed Table
- Manipulating Tables in a Database Window
- Adding Records to a Database Table
- Navigating Records in a Datasheet
- Changing Values in a Datasheet
- Summary
- Creating and Entering Data with Basic Access Forms
- Selecting Data with Queries
- Understanding Queries
- Creating a Query
- Selecting Fields
- Displaying the Recordset
- Working with Fields
- Changing the Sort Order
- Displaying Only Selected Records
- Printing a Query’s Recordset
- Saving a Query
- Adding More Than One Table to a Query
- Working with the Table/Query Pane
- Adding Fields from More Than One Table
- Understanding Multi-Table Query Limitations
- Summary
- Presenting Data with Access Reports
- Gathering Information
- Sharing and Collaboration
Chapter 37. Presenting Data with Access Reports
In This Chapter |
|
Reports provide the most flexible way of viewing and printing summarized information. Reports display information with the desired level of detail, while enabling you to view or print your information in almost any format. In this chapter, you learn to use Report Wizards as a starting point.
ON the WEB
In this chapter, you create new reports using the report wizards and by creating a blank report without using a wizard. You use tables created previously. The Chapter37.accdb database file contains the completed reports described in this chapter. The example databases are available for download from http://www.wiley.com/TOCOME. When you open the file, you can click Options in the Security Warning bar, click Enable This Content in the Microsoft Office Security Options dialog box, and then click OK.
-
No Comment