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. Click a column to select it.
2. Under Selected Column Data Binding Information, select a database field from the Database Column drop-down list box.
3. Choose the Set Data Field button.
4. Repeat steps a, b, and c for each column for which you want to specify a field.
5. Choose the OK button.