Microsoft Office Tutorials and References
In Depth Information
Section 5: Working with data in datasheets
5
Working with data
in datasheets
In this section:
Changing Access database options
Moving between records and using
Find And Replace
Altering the presentation by ordering,
hiding, and freezing fields
Sorting and filtering datasheet rows
Deleting, inserting, updating, and
creating summary data for records
Displaying related information with a
subdatasheet
Adjusting column/row height and
formatting
Selecting data to copy and paste
Displaying more information with the
Zoom box
Changing the datasheet presentation
A datasheet is a tabulation of your data (it can be based on a table or
a query) through which you can insert, delete, and update data. The
data can be filtered, searched, and sorted. But the humble datasheet
offers a number of more sophisticated features, including drilling down to
display related data in other tables or queries, using subdatasheets , and
displaying summary information.
There are a large number of presentation features in a datasheet. You can
change the layouts adjusting fonts; setting grid row height, column width,
and colors; and by alternating row colors. When altered, the datasheet
layouts can be saved and the datasheet remembers these settings when it
is next opened.
In addition, you can reorder columns and filter rows of data to create
areas of data that you can then copy to the clipboard and paste into other
applications.
You can also switch forms to a Datasheet view, which makes the
presentation capabilities of a datasheet an even more useful feature of Access.
Search JabSto ::




Custom Search