Microsoft Access 2013 Plain & Simple

Chapter 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 datasheet rows

• Deleting 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 ...