5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office 2019     Access 2019

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.



Objectives

Access 2019: Finding & Organizing Data

  • sort the data in the data tables
  • filter the data in the data tables
  • search and find data values
  • replace data values
  • edit database indexes
  • find duplicate values in a database