Access to SQL Accounting system

I am a concrete contractor with over 200 Employees, I purchased a complete accounting system in 2002. I am a pretty good programmer in Access, very little vba. I will keep my access front end applications and re-link the data after it is migrated to sql. I already migrated other tables to sql, not in the accounting system, and they work fine. My main problem in trying to migrate the accounting tables myself is in properly establishing the relationships. The system consists of about 400 tables although most are temporary support tables that are then cleared during the posting process. I am including a screen shot of the relationships that can be expanded later.

Compétences : Microsoft Access, Serveur SQL Microsoft, SQL

en voir plus : how to change address in sql, sql accounting for gst, accounting sql, sql software, import data access sql, import data access sql script, conversion access sql, migrate access sql server, converting access sql server database, access sql report, access sql project, access sql filtern, biztalk access sql project, problem access sql update, access sql server convert vbnet, vbnet access sql datagrid, database access sql freelancer, consultant vancouver access sql, count access sql server, freelancer microsoft access sql

Concernant l'employeur :
( 0 commentaires ) Atwater, United States

Nº du projet : #18191513

49 freelance font une offre moyenne de $3695 pour ce travail


Hi! Most of the programmers do not set relationships the way it is in Access, but it does not hurt to have them. So, as I understand, you have an Access backend (database) with Access frontend (user interface) an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(220 Commentaires)

Hi I have been working with MSSQL for over 18 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(76 Commentaires)

Hi, I have 11 years experience in development and worked on many Access and SQL Server-based applications. Migrated many access databases into SQL Server. Involve in designing databases, Indexing Strategies, tabl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(46 Commentaires)

Hi I was hesitating to make a bid for your project- too many bids, you'r new here etc. But as my experience shows, working with client who knows Ms Access ("a pretty good programmer in Access"") much more easy to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(44 Commentaires)

Hi, my name is Rodrigo, I have experience in SQL and VBA. Quick question though, have you considered a full migration to .NET as an option for this project? I think it is robust enough so you could develop this in .NET Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(29 Commentaires)

Hi, I'm an expert Access / database / VBA programmer with *20 years* of programming experience in enterprises, and with domain knowledge in accounting. (I'm an MBA / University of Wales, UK). My offer is to: 1) Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(52 Commentaires)

Hi there, I am interested in the project. I have over 12 years expertise in both access and SQL server, and I am sure I can deliver you the exact solution you are looking for. Please contact me through messenger for mo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(29 Commentaires)

I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(15 Commentaires)

Hi, my name is Mark. I have 20+ years of expertise with MS Access, VBA and SQL Server and will be happy to work on your project. I've designed, developed and maintained many Access applications using SQL Server. My Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(11 Commentaires)

I have all the necessary experience to be the best fit for your project. I have plenty of experience as you will see below in both access and .NET SQL server solutions. I am also familiar with interfacing with accounti Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(15 Commentaires)

I am ready to check and fix the establishing the relationships in tables. Highly experienced in VBA. I checked attached. I am able to create/Improve online database so that multiple users can access into db and keep tr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 40 jours
(7 Commentaires)

With my 9+ years of Software Development experience like to work on your project,Please consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF,Android Application,iOS Application, Visual Basic, Excel Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 90 jours
(39 Commentaires)

hi, i have good skills in sql. i would like to migrate your tables to sql server. get in touch to discuss more.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 60 jours
(59 Commentaires)

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(14 Commentaires)

Hi, I think, you are thinking it all wrong. If you migrate to SQL, that means the access front end will not long be in working state and neither can it be linked. The right way is 1. Create equivalent SQL data Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(3 Commentaires)

Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(29 Commentaires)

Hi, I can work with you to migrate and maintain the accounting system. I have over 9 years of SQL Server development experience. Let me know when I can start?

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(26 Commentaires)

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access cert Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(31 Commentaires)

Hi, I am a professional MS Access and SQL database developer with 7 years of corporate experience. I can give you best support on this project. I created and managing access databases which have SQL server, MySQL, sh Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(16 Commentaires)

Hi there - I'm Aly, I've seen your post and I'm interested. I've had much experience in Microsoft SQL Server including appropriately creating and managing tables and the relations between them. 400 tables is quite a n Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(10 Commentaires)