Microsoft Office Tutorials and References
In Depth Information
How Updates Work in Design View
Design View
Delete a field. Right-click the gray square immediately to the left of the field
you want to remove, and then choose Delete Rows. Keep in mind that when
you remove a field, you also wipe out any data that was stored in that field. This
action isn’t reversible, so Access prompts you to confirm that it’s really what you
want to do (unless the table is completely empty).
Add a description for a field. Type in a sentence or two in the Description
column next to the appropriate field. (You might use “The celebrity or fictional
character that this bobblehead resembles” as the description for the Character
field in the Dolls table, as shown in Figure 26-4.)
Figure 26-4:
Descriptions can
help you remember
what’s what if you
need to modify a
table later.
Descriptions are a great idea
if more than one
person maintains the
same database, in
which case you need
to make sure your
fields are as clear as
Descriptions also appear in
the status bar when
you’re entering
information in a table
(see Figure 26-5).
Figure 26-5:
The status bar text tells
you what goes in this
column, based on the field
description. Sadly, this
feature isn’t as useful as
it seems, because most
people never think to look
down at the status bar.
How Updates Work in Design View
Access doesn’t immediately apply the changes you make in Design view. Instead, it
waits until you close the table or switch back to Datasheet view. At that point, Access
asks whether you want to save the table. (The answer, of course, is Yes.)
Search JabSto ::

Custom Search