Join Mark Swift for an in-depth discussion in this video duplicate records, part of Access 2003 Essential Training.
- [Instructor] As your database grows…and more users are entering information into it,…there may come a day when you have duplicate records.…Those duplicate records can just be a waste.…If you've got several of them,…you'll end up slowing down your searches.…It'll be ambiguous and confusing and if somebody tries…to go back to amend a record, they may go back…and amend one version the first time and the other version…the next time and then those two records…are no longer exactly the same…and they both hold important pieces of information…and (sighs) it just gets to be a pain.…
One of the special queries that you can execute…involves finding duplicate records.…Now that we're in our Queries tab,…if you just simply click the New button,…the query wizards that come up…include the Find Duplicate Query Wizard.…Let's go ahead and click that.…And let's look for customers with the same last name.…Next and we'll be searching by LastName.…What other information do you want to show aside from that?…Well, let's include their first name, CompanyName…
Author
Mark Swift
Released
6/15/2004Skill Level Beginner
Duration
Views
-
Introduction
-
welcome24s
-
-
1. Database Fundamentals
-
what is a database?2m 8s
-
system overview4m 3s
-
analyze current system1m 52s
-
define data elements11m 15s
-
normalization7m 40s
-
establish relationships8m 8s
-
testing and review2m 11s
-
naming conventions4m 3s
-
-
2. The User Interface
-
exploring the interface2m 32s
-
-
3. Creating Databases
-
creating a new database6m 22s
-
Office Online2m 36s
-
-
4. Creating Tables
-
creating tables5m 36s
-
design view3m 51s
-
the table wizard4m 48s
-
tables by inputting data4m 31s
-
data types13m 30s
-
setting field properties15m 23s
-
object descriptions1m 52s
-
-
5. Working with Table Records
-
editing records5m 17s
-
display settings7m 4s
-
the find feature2m 34s
-
sorting and filtering3m 46s
-
copying tables2m 31s
-
-
6. Creating Relational Databases
-
keys11m 14s
-
table relationships17m 33s
-
object dependencies2m 6s
-
-
7. Using Select Queries
-
what are queries?2m 6s
-
creating select queries8m 24s
-
using the query wizard4m 34s
-
query criteria3m 55s
-
-
8. Calculations in Your Queries
-
performing calculations9m 44s
-
duplicate records1m 59s
-
-
9. Creating Forms and Controls
-
AutoForm3m 18s
-
form wizard2m 50s
-
working with controls14m 53s
-
control properties7m 4s
-
form properties1m 35s
-
printer forms34s
-
adding a subform2m 15s
-
adding headers & footers1m 15s
-
-
10. Creating and Using Reports
-
AutoReport2m 56s
-
report sections1m 40s
-
controls & properties4m 3s
-
-
11. Enhancing Forms and Reports
-
using AutoFormat1m 57s
-
special effects1m 40s
-
adding graphics2m 29s
-
AutoCorrect & error checking1m 28s
-
switchboards5m 9s
-
-
12. Working with External Data
-
exporting data1m 37s
-
importing external data3m 57s
-
linking to external data3m 4s
-
-
13. Adding Security
-
passwords4m 49s
-
encryption & decryption1m 41s
-
using the security wizard9m 28s
-
-
14. Access and the Web
-
dynamic vs. static data3m 5s
-
data access pages1m 43s
-
hyperlinks2m 7s
-
importing & linking html3m 6s
-
-
15. Speed Up a Database Application
-
modules & call trees3m 30s
-
tuning your computer1m 50s
-
repair - when it's useful3m 15s
-
backing up1m 13s
-
-
Conclusion
-
goodbye12s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: duplicate records