Microsoft Office Tutorials and References
In Depth Information
Taking Advantage of Subdatasheets
Hiding columns
If you want to hide a column in a datasheet (perhaps the data is sensitive),
select the column or columns, right-click the selected field name(s), and
choose Hide Fields from the contextual menu. To display hidden columns,
right-click any field name and choose Unhide Fields from the contextual menu.
A dialog box appears, allowing you to choose which columns to redisplay.
In fact, to hide multiple fields, make the counterintuitive choice and choose
Unhide Fields from the contextual menu. The Unhide Columns dialog box
allows you to hide several fields at the same time; just deselect the check
boxes next to the names of fields that you want to hide.
Book II
Chapter 1
Freezing columns
When you’re working with a wide datasheet, you may want to freeze one or
more columns so that they don’t scroll off the left side of your screen. To
freeze one column, right-click the field name and choose Freeze Fields from
the contextual menu. The selected column pops to the left side of the
datasheet and stays there. To freeze more than one column, select the columns,
right-click a field name, and then choose Freeze Fields from the contextual
menu. To unfreeze columns, right-click the field name and choose the
Unfreeze All Fields option from the contextual menu.
Changing default formatting for new tables
Access allows you to change default formatting for tables by using the Design
tab of the Access Options window. Any changes you make affect only new
datasheets, not existing tables and queries.
Display the Options dialog box by clicking the File button (near the
topleft corner of the Access window) to display the File menu, and choose
File Options. Click Datasheet in the navigation section of the dialog box to
display default formatting options for datasheets in the current database.
You can change font, gridline, cell-effect options, and default column width.
Most of the options in this dialog box (text colors, text font, gridlines, and
cell effects) are discussed earlier in this chapter.
Taking Advantage of Subdatasheets
Access has a nifty feature that allows you to display data from related tables
in your datasheet. You can also use a form to display related data from
different tables.
Access automatically creates subdatasheets in a datasheet if you create
a one-to-one relationship with another table or if the datasheet is on the
“one” side of a one-to-many relationship with another table. (You need to
define a relationship in the Relationship window or use the Lookup Wizard
to create a relationship.) If you have a relationship between the Customers
 
Search JabSto ::




Custom Search