Query, Query Fields, Table, Table Fields.
You can use the Description property to provide information about objects contained in the database window as well as about individual table or query fields.
For a database object, choose the Properties command from the View menu and enter the description text in the Description box. For tables or queries, you can also enter the description in the table’s or query’s property sheet. An object’s description appears next to the object’s name in the database window
For individual table or query fields, enter the field description in the upper portion of table Design view, or in the Query window. The maximum length is 255 characters.
In Visual Basic, to set this property for the first time you must create an application-defined property using the CreateProperty method.
An object’s description is displayed in the Description column in Database window Details view by clicking Details View on the View menu.
If you create controls by dragging a field from the field list, Microsoft Access copies the field’s Description property to the control’s StatusBarText property.
Note For a linked table, Microsoft Access displays the connection information in the Description property.
Caption Property, Description Property (Microsoft Office 95 Data Access Reference), Object Properties.