User manual

Chapter 3 | Creating databases 60
2. In the Field Picker dialog box, add, delete, or change fields.
3. Repeat step 2 to continue defining fields.
To Do this
Add a field Click New Field. A placeholder Field is created in the fields list, with a field
type assigned. With the field selected, type a new name for the field. See
“About naming fields” on page 57.
Change the field type Click the field type and choose a new field type from the list. See “About
choosing a field type” on page 58.
Important Changing the field type can permanently and irretrievably
erase data.
Set options for the field Right-click the field and choose Field Options. See “Setting options for
fields” on page 67.
Delete a field Right-click the field and choose Delete Field.
To delete multiple fields at a time, select the fields, then right-click and
choose Delete Field.
Important Before you delete a field, confirm that you don’t need any of
the data it contains.
Change a field’s name Windows: Double-click the field, then type a new field name.
OS X: Select the field, then click the field name and type a new field name.
Sort fields in the list Click , then choose how you want to sort the fields.
Locate a field in a long list Type the field name in the search box near the top of the Field Picker
dialog box.
Display the Manage
Database dialog box
Click to add a field to
the database
Fields appear here
as you add them
Specify settings for position
and labels of fields dragged
to the layout
Search for fields
Sort fields