Finding & Organizing Data in Access 2013 for Windows

Access 2013 (Windows)    |    Intermediate
  • 6 videos | 29m 17s
  • Earns a Badge
Likes 7 Likes 7
Adjust how you view and analyze your data by learning about the sorting and filtering features in Access 2013. Explore locating and replacing values, editing indexes, and finding duplicates.


  • Sorting your data
    Filtering your data
    Locating a data value
  • Replacing data values
    Editing your database indexes
    Finding duplicates in your database


  • 4m 1s
    In Access 2013, you can sort the data that you have added to your data tables. This can help you to find records more easily. You can use any of the fields that you have created to sort your data: you can also sort your data alphabetically or in ascending and descending order. You can even apply multiple sort criteria simultaneously. FREE ACCESS
  • 6m 50s
    Another way of finding your data more easily if to use the Access 2013 filter tools. Filtering allows you to temporarily hide records according to set criteria. This can help you to focus on specific data values. In Access 2013, you can create filter rules, visualize date ranges, and even hide numerical values below or above a certain figure. FREE ACCESS
  • Locked
    3.  Locating a data value in Access 2013 for Windows
    5m 4s
    If you have a large number of records in your data table, you can use the search function to find the value you are looking for. This search function can be configured to search for values with particular properties. FREE ACCESS
  • Locked
    4.  Replacing data values in Access 2013 for Windows
    4m 8s
    If you have made a mistake when inserting a record or data value into your Access 2013 table, you can use the find and replace tools to correct it. Rather than manually replacing values, you can create a search query that will automatically find and replace a specified value. FREE ACCESS
  • Locked
    5.  Editing your database indexes in Access 2013 for Windows
    4m 56s
    In Access 2013, creating an index can help you to find a value or record more quickly. This is particularly useful if your data table contains a large number of records. Primary key fields are automatically indexed, but you can also choose to index other fields in your data table. FREE ACCESS
  • Locked
    6.  Finding duplicates in your database in Access 2013 for Windows
    4m 18s
    Access 2013 features a special query that can be used to find record duplicates in specified data tables. It is extremely important to avoid creating duplicates in your database as this can not only make your database bloated but can also distort your analysis reports. The Access 2013 query can help you to root out any duplicates and remove them quickly from your database. FREE ACCESS


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.