In this tutorial i will tell you how to use some properties like Table filtering and sorting in MS Access and i will also show you how to create a form in this software.

First of all we will need a dummy data sheet or a example sheet for testing,
First of all lets start with sorting and filtering

 

You have to click on the home tab to view these options.

For example you want to arrange this data by the Alphabetical – Ascending or descending all you have to do is select the column and click on A>Z button or Z>A button provided. It can be done for any column.

Filter option : It will allow you to filter values that you want to see.The checked items will be shown while others will be hidden.In other words it actually hides the data which is irrelevant to your analysis.

sorting

You can even apply advanced filter and sort

advancedsortingmsaccess

Here is a dummy dbase you can try with.