Cleaning Data in Microsoft Access Tables

Teacher

Lana

Categories

IT & Software, Microsoft, Popular

Review

(0 review)

$5.99

Subscribe for FREE 90 Days

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 311
Assessments Yes

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

Lana

Lana 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!