
Closed
Posted
Paid on delivery
I have an Access database for managing information about friends and relatives. I use this to automatically address snail mail for birthday cards & Christmas letters etc., generate monthly birthday lists, record gifts given, and various other things. It is not a particularly good design but it serves my purposes. I have developed a few queries to create address labels in various formats. The queries work fine for couples but it gets a bit tricky to NOT include a partner if they have passed on or separated etc. It is tricky because I want to keep the information about everybody even after they have passed, but I don't want to include their name when addressing a card or letter to the remaining partner. I would rather not re-write the database and am looking for someone to create some clever queries to get around my problem. I use tick boxes to indicate if someone has passed, if they should get a birthday card or a Christmas letter, or if the are English speakers etc. I may include other factor at a later time - maybe.
Project ID: 40199902
35 proposals
Remote project
Active 14 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
35 freelancers are bidding on average $126 AUD for this job

Hello Sir, I can create targeted Access queries that use your existing tick boxes to conditionally exclude deceased or separated partners while preserving all records, without redesigning the database. The queries will remain flexible so additional factors can be added later without breaking your current address label and list outputs
$150 AUD in 1 day
8.5
8.5

With over 7 years of experience in Fullstack development, specializing in database management using Microsoft Access, I strongly believe my profile as a the ideal fit for your query improvement needs. I am adept at using SQL and can skillfully utilize this to manipulate your database and create the clever queries you require. I understand the value of time, money and employer satisfaction, and thus assure you of my commitment towards providing a speedy, accurate and efficient service. Merging your love for maintaining past records with the need for privacy by excluding names during mail-merging processes; I am confident I can write queries that fulfill these specific needs. Also being a proficient VBA coder and familiar with using tick boxes like you mentioned, I will be able to quantify other factors you might need in the future into coding. My goal is to always build long-term relationships with clients, emphasizing on delivering work that is high on quality, accuracy and tailored to their needs. Please message me so we can discuss your project further.
$220 AUD in 4 days
8.4
8.4

Hello! I'm a Databases Developer, Access and SQL expert more than twenty years. I have completed many complex projects in my practice and I am ready to carry out your in the price and in the shortest possible time and with the highest quality. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f Regards, Vladimir
$40 AUD in 1 day
7.1
7.1

Hi! I specialize in Microsoft Access and database query optimization with 9+ years of experience creating efficient, flexible solutions. Here's how I can help: I will improve your queries to correctly generate address labels, ensuring partners who have passed or separated are excluded while keeping all historical data intact. I can incorporate your tick-box flags (birthday, Christmas, language, etc.) for precise filtering and make the queries easy to update if you add new conditions later. Could you share a sample of your current database and queries so I can tailor the solution without altering your existing structure?
$200 AUD in 7 days
6.6
6.6

With over a decade's experience specializing in Python web automation and data mining, I am accustomed to solving complex data-related challenges proficiently. And your Access database query improvement happens to be one such challenge that I can confidently undertake. My solid grasp of MySQL and data processing will enable me to analyze your current database structure expertly and develop custom Python scripts for clever and efficient queries. Moreover, my proficiency extends beyond just MySQL. I have a diverse tech stack background which includes javascript, PHP, solid knowledge of databases like PostgreSQL, MongoDB etc. as well as cloud services like AWS. My ability to think out-of-the-box combined with strong problem-solving skills enables me to handle projects with unique challenges like yours swiftly and efficiently. Choosing me would mean entrusting your project to someone committed to delivering not just any solution but the best one tailored specifically for you. Let's connect today!
$100 AUD in 1 day
6.7
6.7

As a seasoned Database Management professional, I'm best suited to address your unique Access database challenges. I understand the importance of preserving historical records, even if they're no longer active. Using my advanced MySQL skills, I can design and execute queries that will cleverly integrate your existing tick box system to Exclude the names of people who've passed or separated while still keeping their records intact. I take a holistic approach when approaching any project, first taking the time to comprehend your core objectives and the nuances of your specific database structure. By truly understanding your vision, I can combine my expertise in PHP and MySQL with responsive thinking to develop tailored solutions efficiently and effectively. At SoftwareLinkers, we pride ourselves on being long-term partners for our clients. This means that not only will we solve your immediate query dilemma, but we'll also ensure your database is scalable and future-ready for any possible expansions. With our commitment to clear communication and on-time delivery, you can be confident that with me at
$100 AUD in 2 days
6.2
6.2

Hello, I’m excited about the opportunity to help you refine your existing Access database so it continues to serve your needs without requiring a full redesign. With strong experience in Access, SQL queries, and handling real-world data logic, I can create smart, flexible queries that respect your tick-box flags—such as passed away, separated, or excluded—so address labels and letters are generated correctly for the remaining partner while still preserving historical records for everyone. I’ll focus on solutions that are clean, understandable, and easy to extend later if you add more conditions, ensuring your birthday lists and mailings stay accurate and stress-free. You can expect clear communication and query logic you’ll be comfortable using and maintaining going forward. Best regards, Juan
$140 AUD in 1 day
5.5
5.5

Hi, I have 8 years of experience in Database Management and Data processing.I am Software Engineer worked here with more than 112+ clients. Let’s connect for this project
$90 AUD in 2 days
5.6
5.6

As an experienced data scientist and a pro in database programming, I can offer you an efficient solution for your Access database query improvement needs. Having worked with various programming languages over the years including MySQL, SQL, and Microsoft Access, I can easily grasp the structure of your existing database. My deep understanding of data management will enable me to propose clever queries that address your specific requirement of excluding certain individuals while still preserving their information. Moreover, my proficiency in Python can prove to be invaluable for the automation tasks you have mentioned. By leveraging the power of Python, we can enhance your database querying capabilities and streamline the mail generation process. Additionally, my experience using tick boxes to indicate different conditions aligns perfectly with your needs regarding English speakers or birthday card recipients. This will allow me to work seamlessly with your existing system while enhancing its functionality. Lastly, I take pride in offering comprehensive solutions rather than suggesting re-writes when a seemingly complex issue arises. Like you, I value retaining the data integrity and my innovative approach ensures just that.I't would be a pleasure to bring my diverse skill set to bear on making more efficient for you; something both useful, and easy-to-use on an ongoing basis.
$50 AUD in 3 days
4.5
4.5

Hello! I understand you need enhancements to your Access database queries to manage mailings effectively while maintaining the integrity of your data. My goal is to devise customized queries that will allow you to exclude names of passed or separated partners without altering your existing database structure. This way, you can continue to keep track of all relationships while ensuring your communications are appropriate. I specialize in database management and SQL, and I've successfully helped clients streamline similar processes before. Please see my portfolios for examples of past work. Regards, Davide
$230 AUD in 3 days
3.7
3.7

"I have gone through your description. "This is my area of specialization, i can get it done 100 % perfectly well. Please ping me in person. I can help you to complete all tasks. I have hands-on experience in this field. We have already done similar types of projects. Connect with us for more details. Rest assured your satisfaction is guaranteed." Looking forward to your response." Thank you for your time and I am confident that we will be a great fit for this project. Best,
$100 AUD in 7 days
2.4
2.4

Hello , We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Data Processing, SQL, Microsoft Access, MySQL, Database Programming, Database Management Please come over chat and discuss your requirement in a detailed way. Regards
$140 AUD in 7 days
1.7
1.7

Hey , Good morning! I can complete this project quickly and professionally. I’m a Senior Software Developer with 13+ years of experience delivering production-grade systems for global clients. I focus on results: clean architecture, fast execution, and long-term stability. I’ve handled similar work before and can jump in immediately without onboarding delays. I have strong experience with Database Management, MySQL, Database Programming, Data Processing, Microsoft Access and SQL and related technologies. For more information, please review my portfolio. Ready to start right away. Looking forward to hearing from you soon Eduard Shypovych
$145 AUD in 2 days
0.0
0.0

Hello,there Thank you for posting your project, "Access Database Query Improvement." I've read the description carefully and am confident that I can successfully complete this project. I have over 7 years of experience in MySQL, SQL, Microsoft Access, Database Management, Database Programming and Data Processing. I have done some projects as smiliar as this one. I can share my previous project experience if you'd like. I enjoy learning new technologies and taking on challenges, even those that seem impossible. I'm very interested in this project and am confident that I can deliver the best results possible without stress. I look forward to working with you. Thank you, Boris
$30 AUD in 4 days
3.7
3.7

Hi, I’ve reviewed your Access-based system for managing friends and relatives and the challenge of generating address labels without duplicating names when a partner has passed away or become separated. I can deliver a compact, safe set of clever queries that keep all records intact but render only the appropriate names on labels. My approach is to add a lightweight, modular solution that reuses your existing tick-box flags (IsDeceased, IncludeInLabels, Language, etc.) and a simple relationships helper to decide who should appear on each label. The result will be a reusable LabelRecipients query (and optional supporting views) you can run for monthly birthday lists or Christmas mail, with minimal disruption to your current database design. I’ll provide clear documentation and test data so you can verify the outputs quickly, and I’ll tailor the queries to your existing field names after a quick schema check. Next steps: I can start immediately and deliver an initial working version within 2 days after you confirm the current field names and table structure. Best regards,
$155 AUD in 6 days
0.0
0.0

Hi, I would like to grab this opportunity and will work till you get 100% satisfied with my work. I just applied after read your job posting carefully and I believe that I am good fit to your project. I'm a serious bidder. I will satisfy you with my high skills! I am an expert which have 8+ years of experience on Data Processing, SQL, Microsoft Access, MySQL, Database Programming, Database Management I will work on your project hard with full time. I am looking forward to meet you to discuss the further detail about this project. Looking forward to hearing from you. Thank You
$150 AUD in 7 days
0.0
0.0

Hello, How are you? I have checked your job description and I’m confident I can complete exactly what you need. I have extensive experience with SQL and Microsoft Access, particularly in designing queries that handle complex conditions such as yours. I understand the challenge you face in managing the delicate balance of keeping your database comprehensive while ensuring accurate addressing for your correspondence. Based on your requirements, I can create tailored queries that will appropriately filter out names of deceased partners while preserving the remaining information. This way, your database will remain both functional and respectful. I believe this job is an ideal match with my skills and experience. Please send me a message so that we can discuss more. Thanks
$150 AUD in 1 day
0.0
0.0

Hello, I can help you refine your existing Microsoft Access queries to correctly handle couples, partners, and edge cases such as bereavement or separation — without requiring a redesign of your database. I have experience working with Microsoft Access, SQL queries, conditional logic, and data filtering, and I understand the challenge of keeping historical records while dynamically excluding certain people from outputs like address labels and mail merges. Using your existing tick boxes (for passed away, correspondence preferences, language, etc.), I can create clear and maintainable queries that: • Include couples when appropriate • Exclude a partner when required (e.g. deceased or separated) • Preserve all underlying data for reporting and historical use I’ll focus on keeping the solution simple, readable, and flexible so that additional conditions can be added later if needed. I’m also happy to explain the logic so you can adjust it yourself in the future. If you’d like, we can start with one label format and extend the approach to the others once you’re happy with the result.
$140 AUD in 7 days
0.0
0.0

Hi there, I just read your posting. It sounds like you need an experienced Microsoft Access developer to help you create smarter queries that correctly handle couples—while excluding partners who have passed away or separated—without redesigning your existing database. I am a software and database developer with 9+ years of experience working with Microsoft Access, complex queries, and legacy database logic. Designing clean, flexible query logic that respects real-world edge cases—while preserving historical data—is what I specialize in. I can work with your current tables, tick boxes, and flags to create clever, maintainable queries that dynamically include or exclude partners based on status (passed, separated, mailing preferences, language, etc.), while keeping all records intact for history and reporting. I’ll also structure the queries so future conditions can be added easily without breaking what already works. Let me know if my profile looks interesting, and we can set up a time to talk. Best regards, Cody H.
$250 AUD in 4 days
0.0
0.0

Forestville, Australia
Payment method verified
Member since Feb 3, 2026
$30-250 AUD
₹100000-160000 INR
$750-1500 USD
₹75000-150000 INR
₹15000-30000 INR
£250-750 GBP
€30-250 EUR
$250-750 USD
₹12500-37500 INR
$30-250 USD
min $50 CAD / hour
$250-750 USD
₹600-1500 INR
€750-1500 EUR
₹37500-75000 INR
$250-750 USD
₹12500-37500 INR
₹600-1500 INR
₹12500-37500 INR
$15-25 USD / hour
$30-250 USD