Finding & Organizing Data in Access 2016 for Windows

IN THIS COURSE

• 1.  Sorting your data in Access 2016 for Windows
  3m 18s
  In Access 2016, you can sort the data that you have added to your data tables. This can help you to find records more easily. You can use any of the fields that you have created to sort your data: you can also sort your data alphabetically or in ascending and descending order. You can even apply multiple sort criteria simultaneously. FREE ACCESS
• 2.  Filtering your data in Access 2016 for Windows
  4m 40s
  Another way of finding your data more easily if to use the Access 2016 filter tools. Filtering allows you to temporarily hide records according to set criteria. This can help you to focus on specific data values. In Access 2016, you can create filter rules, visualize date ranges, and even hide numerical values below or above a certain figure. FREE ACCESS
• 3.  Locating a data value in Access 2016 for Windows
  5m 6s
  If you have a large number of records in your data table, you can use the search function to find the value you are looking for. This search function can be configured to search for values with particular properties. FREE ACCESS
• 4.  Replacing data values in Access 2016 for Windows
  3m 42s
  If you have made a mistake when inserting a record or data value into your Access 2016 table, you can use the find and replace tools to correct it. Rather than manually replacing values, you can create a search query that will automatically find and replace a specified value. FREE ACCESS
• 5.  Editing your database indexes in Access 2016 for Windows
  3m 57s
  In Access 2016, creating an index can help you to find a value or record more quickly. This is particularly useful if your data table contains a large number of records. Primary key fields are automatically indexed, but you can also choose to index other fields in your data table. FREE ACCESS
• 6.  Finding duplicates in your database in Access 2016 for Windows
  3m 51s
  Access 2016 features a special query that can be used to find record duplicates in specified data tables. It is extremely important to avoid creating duplicates in your database as this can not only make your database bloated but can also distort your analysis reports. The Access 2016 query can help you to root out any duplicates and remove them quickly from your database. FREE ACCESS