Getting to Know Microsoft Access 2003, Part 4 - Changing Datasheet Appearances
(Page 4 of 4 )
The datasheet view of your table shows columns and rows and looks similar to an Excel spreadsheet. As in Excel you can make changes to the colors, fonts, and cells of the datasheet. You may also hide certain fields from view or choose to keep a row or column of data visible, even while you scroll through other records, a feature known as freezing. Use the formatting toolbar to change colors and fonts. Freeze a column using the Format | Freeze Columns menu option. Make sure to put your insertion point somewhere in the column you wish to freeze. Unfreeze the columns using the Format | Unfreeze All Columns menu option. To hide a column from view use the Format | Hide Columns option and the Format | Show Columns option to see them again.
Choose Format | Datasheet to format the gridlines and the cell appearance. This will allow you to raise or sink cells, show or hide gridlines, change gridline color and background color, change the style of gridlines, or change the column display.
The final thing I’d like to discuss in this lesson is subdatasheets. Subdatasheets are datasheets contained within records in your main table that hold additional information about each record. To add a subdatasheet to a table or query choose the Insert | Subdatasheet menu command. A dialog opens up giving you three options: Tables, Queries, or Both. Pick the one you want to use for the subdatasheet and select the table or query name from the list. Choose the foreign key, the primary key, and add other subdatasheets if you like. You can remove a subdatasheet using the Format | Subdatasheet | Remove command.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 14 
