Access 2007 Database Tutorial Series 5: Importing Many to Many Data and Deleting Duplicate Data
In my Access class, I take the databases created by each of the students for the first assignment and combine these databases into one large database that they use for subsequent assignments. I do this by creating a single Excel worksheet that contains the contents of all of the student databases, and then import that worksheet into Access. The process is a little labor intensive, but it also makes each class unique because the data is always unique. Plus, I'm a big movie buff, so I like to keep an eye out for movies that people think are good. The first two videos of the series show this process. The third video shows how you might delete duplicate records, if you run into such a situation.
In this video, Access 2007 Tutorial 5.1. Many to Many Import:
- Importing Excel Data
- Skipping Fields
- Table Analyzer Wizard
- Creating an Association Table
- Correcting Information
In this video, Access 2007 Tutorial 5.2. Make Table and Append:
- Importing Data
- Unique Values/Distinct
- SQL View
- Make Table Query
- Append Query
- Joins
In this video, Access 2007 Tutorial 5.3. Deleting Duplicate Records:
- Unique Values
- Append Query
- Count and First
- SQL View
- In Criteria
- Delete Query