Microsoft Office Tutorials and References
In Depth Information
Organizing and Describing Your Fields
Design View
Use this button to
change your view
Right-click here to
change your view
Figure 26-2:
Right-click the tab
name to see this
menu. You can
switch to Design
view (choose Design
View) and back again
(choose Datasheet
View). Alternatively,
you can use the tiny
view buttons in the
bottomright corner to jump
back and forth.
Click here to go to datasheet view
Click here to go to design view
If you switch to Design view on a brand-new table that you haven’t saved yet,
Access asks you for a table name. Access then saves the table before switching you
to Design view.
While Datasheet view shows the content in your table, Design view shows only its
structure (see Figure 26-3).
You can use Design view to add, rearrange, and remove fields, but you can’t use it to
add new records. In the Dolls table, you can use Design view to add a Quantity field
to keep track of doll duplicates. However, you can’t add your newly purchased Bono
bobblehead without switching back to the Datasheet view. In other words, Design
view isn’t intended for data entry.
If the Property Sheet box is open on the window’s right side, you may want to close
it to reclaim more space. (The Property Sheet lets you set a few highly technical table
settings, none of which you need to consider right now.) To banish it, choose Table
Tools | Design Show/Hide Property Sheet. If you want to bring it back later, then
just repeat the same command.
Organizing and Describing Your Fields
Design view lets you rearrange the order of your fields, add new ones, rename the
existing ones, and more. You can also do all these things in Datasheet view, but
Access gurus usually find it’s easier to make these changes in Design view, because you
won’t be distracted by the data in the table.
Search JabSto ::

Custom Search