Finding & Organizing Data

Access 2019 (Windows)
  • 6 Videos | 22m 35s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 13 Likes 13
There are multiple ways to find or search for elements and Access allows you to adapt your view on fields by sorting and filtering data values. This 6-video course, "Access 2019: Finding and Organizing Data," allows learners to discover how to sort, filter, find, and replace features available in Access 2019. This process will enable you to save time and locate the information you need most within your Access database values. To begin, you will learn how to sort the data in the data tables, and then filter the data in the data tables. Explore how to search and locate data values, which is useful if you have a large number of records in your data table. Also, you will discover how to replace data values. Creating an index in Access can help find a value or record more quickly, which is particularly useful if a data table contains a large number of records; learners will also observe how to edit database indexes. Conclude with a look at finding duplicate values in a database.

WHAT YOU WILL LEARN

  • sort data in tables
    filter data in tables
    locate data values in tables
  • replace data values
    edit database indexes
    find duplicate values in a database

IN THIS COURSE

  • Playable
    1. 
    Sorting your data
    3m
    UP NEXT
  • Playable
    2. 
    Filtering your data
    5m 2s
  • Locked
    3. 
    Locating a data value
    4m 15s
  • Locked
    4. 
    Replacing data values
    3m
  • Locked
    5. 
    Editing database indexes
    4m 14s
  • Locked
    6. 
    Finding duplicates in your database
    3m 3s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 60 Likes 60  
Likes 13 Likes 13  
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 15 Likes 15  
Likes 16 Likes 16  
Likes 156 Likes 156