Rename fields to make your Access queries more meaningful

When working in Access, it may be helpful to change the
field name of an older query so that the report or form is more meaningful. For
example, suppose you have a patient database that includes a Billing Records
table. In all the tables, the field for the patient’s name is Patient Name. For
the monthly billing report, you would like to change that to Insured. To create
the query that you’ll use to create the report, follow these steps:

1. Open the Patient Database.
2. Click Query under Object and select New.
3. Select the Billing Records table and include the
   appropriate fields for the report.
4. Double-click the cell containing the Patient Name
   field.
5. Place the cursor in front of the first letter of the
   field name (in this case, P).
6. Enter the new field name Insured followed by a colon
   (:).

The cell should now contain Insured:Patient Name. When the
query is run, the new column heading is Insured
instead of Patient Name. Any new forms or reports created on the basis of the
query will use the new name. You may also use the new field name in any
calculated fields. The field name in the underlying table remains unchanged.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.