• Home
  • Course Library
  • Contact
      • Cart

        0
    Have any questions?
    learn@ontracktv.com
    Login
    ontrackTVontrackTV
    • Home
    • Course Library
    • Contact
        • Cart

          0

      IT & Software

      • Home
      • All courses
      • IT & Software
      • Cleaning Data in Microsoft Access Tables

      Cleaning Data in Microsoft Access Tables

      User Avatar
      Sarah
      IT & Software, Microsoft, Popular
      (0 review)
      Free
      Register for an account
      • Overview
      • Curriculum
      • Instructor
      • Reviews

      Applicable to Microsoft Access 2007, 2010, 2013, 2016, 2019

      Before you can effectively sort, filter, and query your data, it must be cleaned first! Duplicate records, unnecessary spaces, and poor structure can wreak havoc on your results. Join this recorded class as Master Trainer, Lana, covers the most popular techniques used to ensure that the data in your Access tables are cleaned up and ready for manipulation.

      Course Features

      • Lectures 8
      • Quizzes 0
      • Duration 7 lessons (Total Time: 48 minutes)
      • Language English
      • Students 391
      • Assessments Yes
      CoursesPopularCleaning Data in Microsoft Access Tables
      • Cleaning Data 8

        • Lecture1.1
          Downloadable Lesson File(s)
        • Lecture1.2
          Removing Duplicate Records
        • Lecture1.3
          Changing Case
        • Lecture1.4
          Removing Leading and Trailing Spaces
        • Lecture1.5
          Padding Strings
        • Lecture1.6
          Parsing Strings – Part 1
        • Lecture1.7
          Parsing Strings – Part 2
        • Lecture1.8
          Filling in Blank Fields
      author avatar
      Sarah
      Sarah has been teaching for over two decades in all areas spanning IT with a particular focus on data management and business intelligence. She is one of the most demanded instructors in the nation, and is reputed for her ability to share her deep knowledge in a clear, thorough, and engaging format. We promise you'll love her videos which students have evaluated as some of the best ones online!

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5 Star
      0%
      4 Star
      0%
      3 Star
      0%
      2 Star
      0%
      1 Star
      0%
      • Overview
      • Curriculum
      • Instructor
      • Reviews
      Free
      Register for an account
      • Share:

      You May Like

      Building Your Social Media Presence – Instagram Read More
      Georgia

      Building Your Social Media Presence - Instagram

      35
      0
      Free
      Build a Great Presentation in Microsoft PowerPoint Read More
      Dave

      Build a Great Presentation in Microsoft PowerPoint

      125
      0
      Free
      Conditional Analysis for Power Excel Users Read More
      Dave

      Conditional Analysis for Power Excel Users

      123
      0
      Free
      What-If Analysis for Power Excel Users Read More
      Dave

      What-If Analysis for Power Excel Users

      180
      0
      Free
      Lists and Pivot Tables for Power Excel Users Read More
      Dave

      Lists and Pivot Tables for Power Excel Users

      211
      1
      Free

      Leave A Reply Cancel reply

      Your email address will not be published. Required fields are marked *

      All Courses

      • Adobe
      • IT & Software
      • Microsoft
      • Popular
      • Social Media

      Latest Courses

      Microsoft Excel 2016 Intermediate Level 1

      Microsoft Excel 2016 Intermediate Level 1

      Free
      Microsoft Excel Macros & VBA Beginner Level 3

      Microsoft Excel Macros & VBA Beginner Level 3

      Free
      Microsoft Excel Macros & VBA Beginner Level 2

      Microsoft Excel Macros & VBA Beginner Level 2

      Free

      Copyright 2020 ontrackTV - A division of Quizam Media Corporation

      • Sign in

      Forgot your password?

      Lost your password? Please enter your email address. You will receive mail with link to set new password.

      Back to login

      Login with your site account

      Lost your password?