Spread Designer

Notes:

To set data-binding properties, the Spread Designer view must be the active view. You cannot set data-binding properties for a sheet that you open in the Spread Designer (that is, by choosing Open from the File menu).
If you bind columns to data fields using the Spread Designer and then change the record source for the data control, you must refresh the data control (for example, run your project) before resetting data fields with the Spread Designer. Unless the data control is refreshed, the new data fields will not be reflected in the Spread Designer.

Follow the steps listed for Connecting to a Database Using Default Settings to bind the sheet to a database.
Open the Spread Designer.
From the Sheet menu, choose Data Binding.
The Data Binding dialog box appears:
In the Data Binding dialog box,
1. Clear the Use DataField Name As Column Heading check box.
2. Choose the OK button.
At run time,
1. Specify the column header in which to display the custom text by setting the Col and Row properties.
2. Supply the text for the column header using the Text property.