Finding & Organizing Data in Access 2010 for Windows

IN THIS COURSE

• 1.  Sorting your data in Access 2010 for Windows
  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
• 2.  Filtering your data in Access 2010 for Windows
  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
• 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
• 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
• 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
• 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