Finding & Organizing Data in Access 2010 for Windows

Access 2010 (Windows)    |    Intermediate
  • 6 videos | 29m 11s
  • Earns a Badge
Rating 4.2 of 12 users Rating 4.2 of 12 users (12)
Organize data for better analysis. Explore sorting and filtering, locating and replacing data values, editing database indexes, and finding duplicates in an Access 2010 database.

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 4s
    Once your table contains a number of unique records, you can begin to analyze it. One of the simplest methods of manipulating your data is to use the sort function, which allows you to change the order in which your data appears. This video tutorial will show you how to define the sort criteria for reorganizing your records. FREE ACCESS
  • 6m 4s
    Another very useful tool for organizing your data records is the filter. A filter is used to hide records that do not match certain specified criteria, thereby allowing you to visualize only the information that you need. In this video tutorial, you will find out how to apply and remove filters in Access 2010. FREE ACCESS
  • Locked
    3.  Locating a data value in Access 2010 for Windows
    5m 23s
    If your table contains a large number of records, trying to find a single value could prove a waste of time. In Access 2010, it is possible to perform a value search in order to locate the data entry that you are looking for. This video tutorial will show you how to use this extremely useful function. FREE ACCESS
  • Locked
    4.  Replacing data values in Access 2010 for Windows
    4m 55s
    As well as being able to locate individual data entries, you can also seek out and replace certain values in your table. This can save you time, particularly if you need to replace every occurrence of a particular value. In this video tutorial, you will find out how to use the Replace and Replace All functions in Access 2010. FREE ACCESS
  • Locked
    5.  Editing your database indexes in Access 2010 for Windows
    6m 2s
    The index function can help speed up access to the data in your table. In this video tutorial, you will find out first of all how to modify the primary key. You will also learn how to index your field in order to more quickly locate the data that it contains. FREE ACCESS
  • Locked
    6.  Finding duplicates in your database in Access 2010 for Windows
    3m 44s
    When creating your database, duplicates are to be avoided at all costs. They are often the source of any anomalies in your data collection or attempts to analyze your records. It is therefore extremely important to know how to locate any duplicates and remove them. 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

Course Finding & filtering data in Google Sheets 2022
Rating 4.5 of 24 users Rating 4.5 of 24 users (24)
Channel SQL Database Development & Design
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Course Finding & organizing files in Teams 2022
Rating 4.4 of 167 users Rating 4.4 of 167 users (167)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Inserting, Importing & Formatting Data in Access 2019 for Windows
Rating 4.4 of 71 users Rating 4.4 of 71 users (71)
Course Using the Bash Shell
Rating 4.7 of 185 users Rating 4.7 of 185 users (185)
Course Navigating the Post-Pandemic Workplace
Rating 4.4 of 562 users Rating 4.4 of 562 users (562)