• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Sorting and Filtering Data

Once you have entered data in Access or have imported or linked to external data from your Access database file, you can use Access features and tools to analyze that data. Like Excel, Access provides tools for basic sorting and filtering so that you can quickly find one or more data records and data values.

Depending on how you view your data in Access, the sorting and filtering tools may not be available. Sorting tools are available in all views except Design view; filtering tools are available only in Datasheet view and Form view. Access data forms allow all view types, while Access data tables allow all view types except Form view. If you aren’t sure which view you are using for a table or form, look at the View button on the main toolbar or click the View menu and see which view is active. To change the view, click the arrow next to the View button or select a different view from the View menu.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint