Claim Add Field Settings For Free

Add a Description to a Field Whenever a user selects a field, anything you type in that field's Description box will appear in the status bar. In Design View, click the field's Description box, and type the description.

First you need to select the field where you want to add a description. Click the Description box for the LastName field. Now you can add a description to the LastName field that will appear in the Status bar whenever the LastName field is selected. Type Enter the Customer's Last Name .

The Format property uses different settings for different data types.The Format property affects only how data is displayed. It doesn't affect how data is stored. Microsoft Office Access 2007 provides predefined formats for Date/Time, Number and Currency, Text and Memo, and Yes/No data types.

Access opens the table in Datasheet view. Select the field (the column) that you want to change. On the Fields tab, in the Properties group, click the arrow in the drop-down list next to Data Type, and then select a data type. Save your changes.

Select the tab page to which you want to add the fields. On the Design tab, in the Tools group, click Add Existing Field. Navigate to the table that contains the fields you want to add. Drag each field from the Field List task pane to the tab page.

On the Home tab, in the Views group, click View, and then click Datasheet View. On the Fields tab, in the Add & Delete group, click More Fields. Select a field in the More Fields list to insert the new column. Access places the field to the right of the column where your cursor is currently located.

For a database object, click Properties on 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.