Microsoft Office Tutorials and References
In Depth Information
Entering and Altering Table Fields
Switching between views with the View button: On the Home tab,
click the View button. This button changes appearance, depending on
whether you’re in Design view or Datasheet view.
Switching between views on the status bar: Click the Datasheet View or
Design View button on the right side of the status bar.
Switching between views by right-clicking: Right-click the table’s title
bar and choose Datasheet View or Design View.
Entering and Altering Table Fields
After you create a database table, the next task is to enter the fields, or if
Access created the table for you, alter the fields to your liking. As Chapter
1 of this mini-book explains, fields represent categories of information in a
database table. They are the equivalent of columns in a conventional table.
Fields determine what kind of information is stored in a database table.
These pages explain how to create a field, choose the right data type,
display data in fields, and designate the primary key field in a table. While I’m
on the subject of fields, W.C. Fields said, “Horse sense is the thing a horse
has which keeps it from betting on people.”
Creating a field
Create a field on your own or get Access’s help and create a ready-made field.
Both techniques are described here. Ready-made fields include fields designed
especially for storing currency data, hyperlinks, and date information.
Creating a field on your own
To create a field on your own, open the table that needs a new field and
follow these steps on the (Table Tools) Design tab:
1. Switch to Design view if you aren’t already there.
To switch to Design view, click the View button on the Home tab and
choose Design View on the drop-down list.
2. If necessary, insert a new row for the field.
To do so, click in the field that is to go after the new field, and then click
the Insert Rows button.
 
Search JabSto ::




Custom Search