Microsoft Office Tutorials and References
In Depth Information
3. Choose the data type that best matches the data for the new field.
(We explain field types in detail in Chapter 2 of this minibook.)
Access creates a field of the correct type, naming it Field1 (or whatever
field number is next for this table).
4. Before you do anything else, type a different name for the field, and
The name of the new field is selected so that you can rename it, using a
name that describes the data that the field will hold.
5. Repeat steps 2–4 to add all the fields you want.
If you find your options to be insufficient, instead of clicking Click to Add
in Step 2, you may prefer to click the buttons for common field types in the
Add & Delete group on the Fields tab of the Ribbon. To see more choices,
click the More Fields button to display the More Fields drop-down menu,
which lists field types in categories. The first category is Basic Types, which
contains options including Number, Date & Time, and Yes/No. In some cases,
you may see the type of field you want to create right away. (For details on
all these field types, see Chapter 2 of this minibook.) Choose any item to
create a new field of the clicked data type.
If you scroll down the list, you see the category Quick Start, which is
covered in the next section.
The field type — such as Short Text, Number, or Currency — defines the
data type and format (which is how the data is displayed) and may also
include field properties (see Chapter 2 of this minibook).
Chapter 2 of this minibook also provides more information about defining
fields and performing related tasks in Table Design view.
Quick-starting your table with field templates
If you’re adding fields to your table, Access 2013 provides a way for you to
quick-start your table. The Quick Start fields (which you access by clicking
the More Fields button in the Add & Delete group on the Fields tab of the
Ribbon) aren’t single fields but groups of fields, and in some cases, selecting
a Quick Start field may give you all the fields you need for your table. Each
field is defined with the appropriate properties. Figure 1-6 shows the Quick
Start field options.