Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

NOTE The default field size for Number fields is Long Integer , which is also the largest field size. You should use the smallest possible field size whenever possible so the database uses less storage space and can be processed quicker. A brief description of the selected property appears in the Field Properties pane. You may lose existing data if you decrease the size of a field. In addition, you cannot undo design changes after saving the table.



Procedures

1. Open the desired table in Design view. 2. Select the field for which you want to set the field size property. 3. Select the General tab in the Field Properties pane, if necessary. 4. Select the Field Size property. 5. Select the Field Size list, or type the desired value. 6. Select the desired option, if applicable.



Step-by-Step

From the Student Data directory, open FIELDS1.ACCDB . Limit the size of a field.

Open the Customers table in Design view.

Steps

Practice Data

1. Select the field for which you want to set the field size property. The field is selected. 2. Select the General tab in the Field Properties pane, if necessary. The General tab appears.

Scroll as necessary and click in the Credit Limit field Click the General tab, if necessary

OFFICEPRO, Inc.

Page 5