In the Query Wizard is an option to create a Find Duplicates Query. The Find Duplicates query is a specific query type that will locate duplicate records within the database. In this movie, Adam uses the Wizard to help locate orders that might have been entered twice, and shows how to build upon the results to get additional details.
- [Voiceover] In the Query Wizard, we've seen…that there are options beyond the simple select query.…One of those is the find duplicates query.…The find duplicates query is a specific query type…that will locate duplicate records within your database.…This could be useful for cleaning up your data tables,…or reviewing records with multiple entries.…We can create one by going to the Create tab,…and we'll find it underneath the Query Wizard options.…And it's this third one down here,…Find Duplicates Query Wizard.…Go ahead and select it, and press okay.…On the first screen of the Wizard,…it's going to ask us which table we want to sort through…to find if there's any duplicate records.…
In this case, I wanna find if there's any orders…that have been duplicated.…So let's select that table, and I'll press next.…On this screen, we're going to define…which fields we wanna look through…to see if there's matching pairs.…Now I know for a fact…that no OrderID fields are gonna duplicated,…because that's the primary key…and it's impossible for there to be two…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.