• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Creating a Table > Requiring and Indexing a Field

Requiring and Indexing a Field

A required field must have an entry before the record can be saved. An indexed field is specially prepared so that its information can be searched through more quickly when you later search the database.

To set a field as required and indexed:

1.
On the Tables tab of the Database window, choose a table and click Design.

or

If the table is already open, click the Design View button.

2.
In the Table window, click the name of the field to format.

3.
Click the Required box and choose Yes or No from the drop-down list.

4.
Click the Indexed box and choose an option from the drop-down list. See Table 31.3 for the Index options (Figure 31.28).

Figure 31.28. Make the field a required and indexed field.


5.
To save changes to the table design, click the Save button on the Access toolbar, or press Ctrl+S, or choose Save from the File menu.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint