Microsoft Office Tutorials and References
In Depth Information
Modifying Table Structure
Alternative Method
You can also hide a field by right-clicking the
field heading you want to hide and choosing
Hide Fields.
Figure 19-8
Hiding fields.
When you want to view the column again, choose
Home>Records>More and choose Unhide fields.
4. Choose Hide Fields. The field disappears
from your view.
5. Click the Save button on the Quick Access
Toolbar.
Modifying Table Structure
Whether you created your database
from the beginning or started with an
Access template, you’ll probably find
yourself wishing you had additional fields. That’s not a
problem because you can add as many new fields as
you want. And if your table has any fields you decide
you don’t want, you can easily remove them.
The “quick and easy” method is to open the table
to which you want to add a field. Then right-click
the column heading where you want the new
column. From the resulting shortcut menu you see in
Figure 19-9, choose Insert Field. Access
immediately inserts a new text field and gives the field a
generic name like Field1, Field2, Field3, and so
forth. You can rename the field by right-clicking
the field name and selecting Rename Field. Type a
new field name and press Enter. Click the Save
button on the Quick Access Toolbar.
Adding Fields to a Table
After you create your database, if you decide you
need additional fields; go right ahead. Each Access
2010 database table can contain up to 255 fields.
And like many Access features, there’s a quick and
easy way to add fields and then there’s a way that
takes a few extra steps, but gives you more flexibility.
Search JabSto ::




Custom Search