[ Team LiB ] Previous Section Next Section

Viewing Field Properties

graphics/04inf02.jpg

graphics/one_icon.jpg

Open the database that contains the table you want to modify.

graphics/two_icon.jpg

Click the table to select it.

graphics/three_icon.jpg

Click the Design button to open the table in Design view.

graphics/four_icon.jpg

Click a field to view its properties. In this example, Product Name, a text field, is selected.

INTRODUCTION

Each field in a table has several identifying qualities, such as a name, a size, a data type, and so on. These elements are called the field's properties and are displayed in the property sheet, found in the lower half of the Access window in Design view. In addition to the common properties that you learned about when you created a table, fields have other properties that you can display and modify such as display formats.

graphics/04inf03.jpg

graphics/five_icon.jpg

The property sheet, found in the bottom part of the window, displays the various properties for the selected text field.

graphics/six_icon.jpg

Click another field to view its properties. In this example, Price, a Number field, is selected; notice that the properties vary depending on the field type.

graphics/seven_icon.jpg

Click a field with Date/Time listed as the data type to see the available properties for a Date/Time field.

graphics/eight_icon.jpg

Click a field with Yes/No listed as the data type to see the available properties for a Yes/No field.

TIP

Viewing a Property Description

This book discusses only those field properties most commonly used in Access. For information about other field properties, click in the appropriate property field and view the description displayed on the right side of the window. You can also consult online help using the Access Help menu.

TIP

Saving Your Database

Remember that when you make changes to your database structure, you need to save the database. To do so, click the Save button on the Standard toolbar found in the main Access window.

    [ Team LiB ] Previous Section Next Section