How to Rename the Headers on the MS Access Report
By Leigh Thompson
Microsoft Access reports take information from a database table and present it in an attractive manner. These reports are typically used in office functions to show trends or totals for a specific time period. These reports pull information from the fields in the underlying table and have a header at the beginning to indicate what information is being shown in that row or column. By default, MS Access names the headers according to the field name in the table. However, you can change headers to suit your needs.
Start Microsoft Access. Right-click the Access report and select "Design View".
Click a specific header box to select it. Click the end of the word in the header to place your cursor. Backspace to delete the current words. Type a new header. Press "Enter" to save the new header.
Right-click the header box and select "Properties". Click the "Format" tab. Place your cursor in the "Name" box. Backspace to delete the old header and enter a new name. Close the property box.
Select the "View" button. Change to "Report" view. Click "Save" on the top menu.
References
- "Access Help and How-to"; Microsoft; 2007
- "Access Help and How-to"; Microsoft; 2010
Writer Bio
Leigh Thompson began writing in 2007 and specializes in creating content for websites. She has been published online in various capacities. Thompson has an associate degree in information technology from the University of Kansas and is working on a bachelor's degree in business and personal finance.