Finding & Organizing Data in Access 2010 for Windows
Access 2010 (Windows)
| Intermediate
- 6 videos | 29m 11s
- Earns a Badge
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 dataFiltering your dataLocating a data value
-
Replacing data valuesEditing your database indexesFinding duplicates in your database
IN THIS COURSE
-
3m 4sOnce 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 4sAnother 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
-
5m 23sIf 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
-
4m 55sAs 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
-
6m 2sThe 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
-
3m 44sWhen 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
Channel
Wintellect SQL Server
Book
Access For Dummies