Cleansing Excel data for import into Access in pdf

Aims and Learning Objectives

By the end of this workbook, you will be able to:

• explain the problems that can be encountered if data is not consistently entered 
• cleanse Excel data for import into a simple, multi-table Access database;
• import cleansed Excel data into multiple Access tables;
• create relationships between the tables;
• modify the tables so that data input via Access is simplified

Contents

• Spreadsheet examples
• Spreadsheet with cleansed data
• Spreadsheet without cleansed data
• Prepare cleansed data for import into Access
• The identified data model and fields
• Split the spreadsheet data into three worksheets
• Remove duplicate values from Label and Artist worksheets 
• Split the Artist column into two separate columns
• Create Access tables from Excel data
• Add relationships and test the data
• Add dropdowns that show artist and label details