Using AutoFormat and Customizing Report Styles
by Roger Jennings
Special Edition Using Access 97, Second Edition
- Copyright
- About the Author
- Acknowledgments
- Introduction
- Learning Access Fundamentals
- Access 97 for Access 95 and 2.0 Users: What's New
- Building Your First Access Application
- Navigating Within Acces
- Working with Access Databases and Tables
- Defining the Elements of Access Databases
- Understanding Relational Databases
- Using Access Database Files and Tables
- Creating a New Database
- Understanding the Properties of Tables and Fields
- Choosing Field Data Types, Sizes, and Formats
- Using the Northwind Traders Sample Database
- Setting Default Values of Fields
- Working with Relations, Key Fields, and Indexes
- Altering Fields and Relationships
- Copying and Pasting Tables
- Entering, Editing, and Validating Data in Tables
- Sorting, Finding, and Filtering Data in Tables
- Linking, Importing, and Exporting Tables
- Designing Queries
- Using Query by Example
- Understanding Operators and Expressions in Access
- Creating Multitable and Crosstab Queries
- Joining Tables to Create Multitable Queries
- Using Lookup Fields in Tables
- Outer, Self, and Theta Joins
- Updating Table Data with Queries
- Making All Fields of Tables Accessible
- Making Calculations on Multiple Records
- Designing Parameter Queries
- Creating Crosstab Queries
- Creating Queries from Tables in Other Databases
- Using Action Queries
- Creating Forms and Reports
- Creating and Using Forms
- Designing Custom Multitable Forms
- Printing Basic Reports and Mailing Labels
- Differences and Similarities Between Forms and Reports
- Types of Access Reports
- Creating a Grouping Report with the Report Wizard
- Using Access's Report Windows
- Using AutoFormat and Customizing Report Styles
- Modifying a Basic Report Wizard Report
- Adjusting Margins and Printing Conventional Reports
- Preventing Widowed Records with the Group Keep Together Property
- Printing Multicolumn Reports as Mailing Labels
- Preparing Advanced Reports
- Publishing Data on Intranets and the Internet
- Exporting Data to World Wide Web Pages
- Creating Dynamic Web Pages
- Integrating Access with Other Office 97 Applications
- Using Advanced Access Techniques
- Exploring Relational Database Design and Implementation
- Working with Structured Query Language
- Securing Multiuser Network Applications
- Networking Access Applications
- Installing Access in a Networked Environment
- Sharing Your Access Database Files with Other Users
- Using Command-Line Options to Open a Shared Database
- Maintaining Database Security
- Understanding Database Object Ownership
- Granting and Revoking Permissions for Database Objects
- Sharing Databases on the Network
- Administering Databases and Applications
- Connecting to Client/Server Databases
- Creating Scalable Access Applications
- Defining the Client/Server Environment
- Defining Open Database Connectivity
- Understanding ODBC Drivers
- Installing the Microsoft ODBC Driver for SQL Server
- Adding and Removing SQL Server Data Sources
- Using Databases Connected by ODBC
- Using Access 97's SQL Pass-Through Queries
- Exporting Access Tables to a Client/Server Database
- Programming and Converting Access Applicationys
- Writing Visual Basic for Applications Code
- Understanding the Data Access Object Class
- Responding to Events with VBA 5.0
- Programming Combo and List Boxes
- Working with Recordsets and Native Controls
- Exchanging Data with Automation and ActiveX Controls
- Migrating Access 2.0 and Access 95 Applications to Access 97
- Appendixes
Using AutoFormat and Customizing Report Styles
The AutoFormat toolbar button works the same way for reports as for forms. Chapter 12, "Creating and Using Forms," contains a detailed, step-by-step explanation of how to use Access 97's AutoFormat button and customize the predefined AutoFormat styles or create your own AutoFormat styles. Follow the instructions in the Using AutoFormat section of Chapter 12 to apply an AutoFormat style to a report or define or customize a report AutoFormat style. Access stores styles for reports and forms separately, so you'll need to create separate AutoFormat styles for your reports.
◂◂See Using AutoFormat
As with forms, to create an AutoFormat style for customized reports, you must first create a report that contains controls that are formatted the way you want for your new style. You click the AutoFormat button on the toolbar and then click the Customize button in the AutoFormat dialog to customize the format.
-
No Comment