Access%20-%20CH%204

Access%20-%20CH%204 - Click to edit Master subtitle style...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 11/12/07 Dr. K. Chen Dr. K. Chen 11 CIS 2640: Business Reporting Book: Access 2007 Data Analysis Chapter 4 11/12/07 Dr. K. Chen Dr. K. Chen 22 Objectives l Data cleansing l Finding and removing duplicate records l Data Transformation 11/12/07 Dr. K. Chen Scenario l You have collected customer data from various sources. Those sources define data differently (extra spaces, different capitalizations, different abbreviations, etc.) On top of that, there may be duplicates too. l You will learn a series of data cleansing and transformation procedures in the next few slides Dr. K. Chen 33 11/12/07 Dr. K. Chen Steps to Find and Remove Duplicates l Step 1: Define what it means by duplicate records Duplicate company numbers? Or a combination of company number, name and city? l Step 2: Build a Find Duplicates Query to visualize duplicates l Step 3: Remove duplicates Manual Batch Dr. K. Chen 44 11/12/07 Dr. K. Chen Step 1: Define what it means by duplicate records l What fields best make up a unique record? l Open AccessDataAnalysis.accdb and locate the LeadList table. Dr. K. Chen 55 11/12/07 Dr. K. Chen Step 2: Build a Find Duplicates Query to visualize duplicates l Create | Query Wizard Dr. K. Chen 66 Fields are defined based on Step 1 11/12/07 Dr. K. Chen Dr. K. Chen 77 Duplicate records are shown next to each other. 11/12/07 Dr. K. Chen Step 3: Remove duplicates l Manual delete In the result of Find Duplicates Query, you may...
View Full Document

This note was uploaded on 12/10/2008 for the course CIS 2640 taught by Professor Chen during the Fall '08 term at Western Michigan.

Page1 / 24

Access%20-%20CH%204 - Click to edit Master subtitle style...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online