Access 2019: Finding & Organizing Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
0.4

Lesson 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
  • Course Number:
    ds_msac2019_05_enus

    Expertise Level
    Intermediate