Find Jobs
Hire Freelancers

Merge 2 Access 2.0 databases

$30-250 AUD

Cancelled
Posted over 13 years ago

$30-250 AUD

Paid on delivery
I have 2 linked Access 2.0 databases, db1 has about 130 tables & db2 has about 14, with dozens of relationships. There is no one-to-one relationship in the rows, ie the large database isn't always linked to the smaller ; within the large dabase, related data isn't always in every table. I want to merge the data in those two databases into 2 other databases, which are basically the same structure but have been slighted amended over time, eg, db3 has 1 or 2 less tables, but with 1 or 2 new tables; slightly different data validation criteria etc. (The databases started off the same back in 1997 but one has been slightly amended over the years). Apart from the difference in data validation and a couple of different table names, the rows from one table in db1 one can't simply be pasted/appended into the corresponding tabel in db3 as two rows appear in db1 & db3 but with different data. As there are only two such rows, easily identified in the Master table, these two rows, plus all the corresponding relationships can be excluded (to be actioned manually). The databases must remain as Access 2.0.
Project ID: 888990

About the project

16 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $183 AUD for this job
User Avatar
send me the databases - need more clarity about the work to be done
$50 AUD in 5 days
4.9 (58 reviews)
5.6
5.6
User Avatar
Respected Sir, Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Looking forward to your prompt reply.
$200 AUD in 3 days
4.7 (14 reviews)
4.4
4.4
User Avatar
Hi! Please see PMB. Thanks! David
$250 AUD in 5 days
4.6 (3 reviews)
3.5
3.5
User Avatar
Please see PM.
$201.95 AUD in 14 days
5.0 (1 review)
2.5
2.5
User Avatar
It looks to be needed to write append query (queries) for each pair of tables, and you could use them in future as many times as you need.
$50 AUD in 6 days
5.0 (3 reviews)
1.8
1.8
User Avatar
Hello I am an experienced IT professionial with over 24 years developing software. I have years of MS Access, SQL Server, VBA and other programming languages experience. I have all MS Office 2003, 2010 and MS Windows 7 and XP systems for development requirements. Respectfully Peter Bell I have given an estimate that includes analysis and discussion of your needs to a set of requirements and customisation to your style requirements.
$220 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi I have ten years experience on MS Access. I have done serven Access DB for client in 2010 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look forward to your reply. Btw: I were MVP about Mircosoft Access in 2003 Zhi Zhang
$200 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I am a ms access guru and can easily do the task. Regards
$250 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, Plz see PMB for more detail.
$200 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please see PMB for details. Thanks.
$100 AUD in 4 days
0.0 (0 reviews)
0.9
0.9
User Avatar
I am from India, working with windows, sql server, access, vb6, vb.net,C, C#, Crystal Reports, foxpro since 1994, I have developed many projects like inventory, accounting, payroll, hotel management, School Fees Collection System, ERP solutions running successfully at many locations. Also providing hardware and networking support. I will give u exact solution to fulfil ur requirement. Please provide me ur exact requirement to evluate time taken and exact cost.
$200 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
to reduce days and milestone, let me see your databases first
$200 AUD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have the enough experience and skills to accomplish this requirement. I live in Mexico City.
$250 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Having 8 years of overall programming experience, my primary expertise is Microsoft Access/VBA database applications development, customizing and troubleshooting. I have experience working with all versions of Access starting from 2.0 and up to 2007. I am seeking an opportunity to build and support MS Access databases as well as MS SQL Server and Crystal Reports projects. I also have experience with MS Visual Studio (VB.NET, C# and ASP.NET) Thanks and Regards, aneel
$200 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good morning. I am keen to carry out this work for you. I have over 15 years' experience in database development ranging from projects such as: TOWER HEALTH & LIFE • Created and deployed the Complaints Database at TOWER (both Health & Life and Insurance) to record, track, report and investigate complaints from advisors, clients and providers alike. This replaced the antiquated spreadsheet system and gave all team members and management immediate visibility of complaints, a host of reports and the ability to update complaints directly. AIR NEW ZEALAND • Identification of the shortcomings of the Charter process in use across the Air New Zealand offices lead to the creation, development and implementation of a cross-functional Charter Database that was rolled out nationwide. This supported and enhanced the process, giving all users visibility of decisions, calculations, quotations, turn times, communication and statuses. The effort involved was now dramatically reduced and resource could concentrate on activities that added more value to the organisation. • Designed and implemented a Management Database that was used by all team members to record activities, issues and accomplishments. This was expanded to include leave, goals and measures, a toolbox (access to other databases and applications) and reporting functionality. I hope that I may be of assistance to you. Regards Ashleigh
$250 AUD in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ready for this work
$100 AUD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Mosman, Australia
4.9
7
Member since Dec 20, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.