Finding & Organizing Data in Access 2016 for Windows

Access 2016 (Windows)    |    Intermediate
  • 6 videos | 24m 34s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 93 users Rating 4.4 of 93 users (93)
As your tables get larger, it gets harder to locate specific data. Discover how to sort and filter data, edit indexes, search for data, and locate duplicate values and records.

WHAT YOU WILL LEARN

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

IN THIS COURSE

  • 3m 18s
    In Access 2016, 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
  • 4m 40s
    Another way of finding your data more easily if to use the Access 2016 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 2016, 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 2016 for Windows
    5m 6s
    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 2016 for Windows
    3m 42s
    If you have made a mistake when inserting a record or data value into your Access 2016 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 2016 for Windows
    3m 57s
    In Access 2016, 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 2016 for Windows
    3m 51s
    Access 2016 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 2016 query can help you to root out any duplicates and remove them quickly from your database. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 86 users Rating 4.5 of 86 users (86)
Rating 4.5 of 482 users Rating 4.5 of 482 users (482)
Rating 4.5 of 449 users Rating 4.5 of 449 users (449)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.8 of 9 users Rating 4.8 of 9 users (9)
Rating 4.5 of 1857 users Rating 4.5 of 1857 users (1857)
Rating 4.6 of 36 users Rating 4.6 of 36 users (36)