Access Venue Database Deduplication
Budget: $100 – $300 USD
I have a single-table Access file that holds roughly 47,000 live-music venue records. Each record has 40 fields. Years of inconsistent data entry mean the same club might appear ten different ways—and often with slightly different contact spellings as well. You may create additional tables (contacts, etc) if necessary.
What I need from you
• Run a smart, repeatable deduplication process that matches venues by a blend of name similarity and contact-detail similarity, not just one or the other.
• Collapse every detected cluster into one master record while preserving every phone, email, address, or website tied to that venue. All contact info must survive the merge.
• Return the cleaned data in the very same Access format so it can drop straight back into our internal tools.
Helpful context
– One table only, but up to four contacts per venue.
– I want exactly one row per real-world venue when you’re done.
– No data loss: if two duplicates list different bookers, both bookers must appear in the merged contact list.
Deliverables
1. The deduplicated .accdb file.
2. A brief log or summary showing how many duplicates were detected and merged—helpful for audits and future imports.
Acceptance criteria
• Zero duplicate venue names left after fuzzy + contact match passes.
• All original contact fields retained; nothing overwritten or dropped.
• Database opens and runs with no broken relationships or field type changes.
Let me know the tools or scripting language you plan to use (Python with fuzzywuzzy, VBA, SQL Server Integration Services, etc.) and the turnaround time you’d need. Please include your fixed price or milestone breakdown when you respond.
I will provide the selected freelancer with the ACCESS database. Let me know if there are additional questions you need answered in order to provide a bid.
What I need from you
• Run a smart, repeatable deduplication process that matches venues by a blend of name similarity and contact-detail similarity, not just one or the other.
• Collapse every detected cluster into one master record while preserving every phone, email, address, or website tied to that venue. All contact info must survive the merge.
• Return the cleaned data in the very same Access format so it can drop straight back into our internal tools.
Helpful context
– One table only, but up to four contacts per venue.
– I want exactly one row per real-world venue when you’re done.
– No data loss: if two duplicates list different bookers, both bookers must appear in the merged contact list.
Deliverables
1. The deduplicated .accdb file.
2. A brief log or summary showing how many duplicates were detected and merged—helpful for audits and future imports.
Acceptance criteria
• Zero duplicate venue names left after fuzzy + contact match passes.
• All original contact fields retained; nothing overwritten or dropped.
• Database opens and runs with no broken relationships or field type changes.
Let me know the tools or scripting language you plan to use (Python with fuzzywuzzy, VBA, SQL Server Integration Services, etc.) and the turnaround time you’d need. Please include your fixed price or milestone breakdown when you respond.
I will provide the selected freelancer with the ACCESS database. Let me know if there are additional questions you need answered in order to provide a bid.