Find Jobs
Hire Freelancers

Add functionality to an existing MS Access/MS SQL Server application

€12-18 EUR / hour

En curso
Publicado hace casi 7 años

€12-18 EUR / hour

INTRODUCTION I'm an experienced MS Access developer myself. But at the moment I have too many projects so I'm looking for some help with one of my projects. The application is already in production but the customer has some additional wishes. BACKGROUND The company of the customer is an intertrade company. This company has a few wholesalers from different countries in Europe as customers. The company collects product prices from these companies via a Excel export/import. The company then compares these prices and looks for products that can be bought cheaper from another member than from the current supplier. These products are offered to the member (also in Excel). And then the member can place an order for these products. THE APPLICATION The application enables the company to register products, with the various properties of the products. The collection and comparison of prices is also supported. As is the creation of offers. The whole order process (ordering from supplying member, logistics, documentation, invoicing etc.) is also registered in the application. TECHNICAL INFORMATION The application is an MS Access application with lots of VBA code. The data is stored in SQL server and some of the code (currency conversion, finding cheapest supplier) is written in T-SQL (functions and stored procedures) on SQL server. MS Access and VBA skills are most important for this product. SQL Server skills are nice to have. We have a test database in the cloud, but you need a (more or less) fixed IP-address to access that database. You can also use you own SQL Sever if you prefer that. You also need your own copy of MS Access. The Access application is developed in a folder on Google Drive. We'll give you access to this folder, so you need a Google account, and the Google synchronization software. ENHANCEMENTS Examples of the extra functionality we want to add to the application: -Add an extra column to the pricing excel file with comments from the customer. The comments must be exported, imported and stored in the application. -Validation of prices on import (compared to prices from other members and compared to previous prices). -Performance enhancements. The forms now have a direct link to SQL server, but specially on a cloud database this is rather slow. So we want to load all the data for an order (for example) in a temporary table and let the user work with that data, and then later store the changes in the SQL database. -Add the unavailability of products in the import/export. -Additional reporting. -Exclusion between members based on product brands. -Better specifications of contact persons for an offer/order. -Filter on products without prices. -Validation of data before creating documents. -Multiple addresses per member. And almost every other week the customer has new wishes. THE PROJECT We'll have an hourly rate for the project. I have a pretty good idea how long it will take me to make the various changes. And I know my own hourly rate. So as long as the costs of the changes (including my time for writing specifications and testing the result) is cheaper than when I would have done it myself, you can keep working on the project. And in the future there might even be completely new projects for you.
ID del proyecto: 13968689

Información sobre el proyecto

30 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello! Basically, I completely understand the needs. In a short, but you can see it on my profile, I am working with MS Access since version 2.0 and I was MS Access MVP twice (that alone is enough I think). I see there is lots of work and I consider this as a long-term project. However, there is one big task. The performance of the SQL server when accessed over the Internet. Currently and in past more than 2 years, I am working on something similar for one company from the USA. They have a central SQL server and inspectors for oil platforms on the field. Since it was impossible to make them work directly with SQL server (for 2 reasons: non-available Internet connection and performance problems i.e. latency), I've made my own custom synchronization code between offline (Access) and online (SQL) database. I think you are looking for the same. I am jumping here because of the limit of this message. Regarding time and rate, I think I work fast (blind typing, 24 years with Access almost on a daily basis, etc) and I have some knowledge of the SQL server. I could restore a backup of their SQL server on my SQL server and work with that. I am using Freelancer time tracking app to record the work and I really record only real work, the only question is can you do it faster than me. If you like, we can have a test run to see if I can do it for you. And we are in the same time zone, which is good I think. Regards, Branislav Mihaljev
€18 EUR en 40 días
5,0 (294 comentarios)
7,8
7,8
30 freelancers están ofertando un promedio de €19 EUR /hora por este trabajo
Avatar del usuario
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
€12 EUR en 40 días
4,9 (246 comentarios)
7,1
7,1
Avatar del usuario
Dear Sir, I have read your project description & understood the initial high level requirements. This initial message is just to confirm you that we can do this project, so please initiate the chat to finalize the contract details, estimate, payment terms etc. but just so you know, I am flexible in prices, as quality comes first for me and then prices. Look forward to hearing from you & start further discussion thru' private chat. Regards, YK LEADconcept
€22 EUR en 40 días
5,0 (1 comentario)
6,4
6,4
Avatar del usuario
Hi, I have 9 years experience in development and worked on many VB6, Acess, C# win-forms applications with SQL Server as beck-end. I have very good exposure on designing UI with proper anchoring and docking. Designed win-forms with threading with proper handling on thread sync and race conditions. Involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have worked on many POS and import/export win-forms applications with rich UI and responsiveness. Used Infragistics and telerik third party controls. Used Crystal Reports and SSRS for reporting. Thanks
€20 EUR en 40 días
5,0 (26 comentarios)
6,4
6,4
Avatar del usuario
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
€16 EUR en 40 días
4,9 (58 comentarios)
6,6
6,6
Avatar del usuario
Hi, My name is Benjamin. I'm an expert programmer with 14 years of experience with VB/T-SQL/Access. Look forward to hearing from you. Regards,
€22 EUR en 40 días
5,0 (4 comentarios)
6,6
6,6
Avatar del usuario
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
€47 EUR en 40 días
5,0 (3 comentarios)
4,9
4,9
Avatar del usuario
Good day, I would be very glad to assist you with your project and would gladly work within your budget. I am a BSc. Computing graduate from the University of Greenwich, UK, and have over 10 years professional IT experience. I have excellent skills in VBA, SQL, MS Access, MS Excel, among others. Please feel free to check out my portfolio and reviews so as to get an idea of the quality of my work. For your project, I would like to work off my local SQL Server and a local copy of the MS Access application and thereafter share the updates with you on Google drive. Kindly confirm the versions of MS Access, Excel and SQL Server that your customer is using. In addition, kindly assist me with copies of the current application, back end database, and sample Excel import/export files. I look forward to your favourable response and to providing you with a solution that exceeds your expectations. Kind regards, Jeane.
€14 EUR en 40 días
5,0 (5 comentarios)
4,9
4,9
Avatar del usuario
I can work on it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access,Microsoft Excel (VBA and Charts) and MySQL, Power BI, Charts Programming languages like MVC, .Net technologies(Asp.Net, Vb.Net / C# ) ,PHP, WordPress, ASP CLASSIC etc. Scripting Languages jquery and javascript, Third party tools like Telerik, Infragistics and Reporting tools (Crystal Reports, SSIS, SSRS, RDLC and Oracle Developer). Looking forward to your feedback. Regards, Muhammad Ali Safder
€16 EUR en 40 días
5,0 (32 comentarios)
5,0
5,0
Avatar del usuario
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
€16 EUR en 40 días
5,0 (27 comentarios)
4,7
4,7
Avatar del usuario
Hi I’m an expert in MS technologies (SQL server, VBA and .Net) I have been working in software development for the last 20 years I have a lot of experience in desktop and web development I’m also available 24 x 7 Regards Carlos
€16 EUR en 40 días
4,6 (25 comentarios)
4,8
4,8
Avatar del usuario
Hi there, I have rich experiences of MS Access and VBA programming. I also have good knowledge of MS SQL Server & SQL. I can help complete the job well with good quality on time. Feel free to contact me and discuss more details. Best Regards, VL
€15 EUR en 24 días
5,0 (5 comentarios)
3,4
3,4
Avatar del usuario
Dear , Thank for your very detail job specification. Very clear & I got what you want. I think I'm a person whom you are looking for. My current job is about with MS Access & VBA coding . Also had many experience working with SQL . So think I could help you on that. Pm me for more detail. Thank you
€16 EUR en 20 días
5,0 (4 comentarios)
2,3
2,3
Avatar del usuario
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end..
€18 EUR en 40 días
4,6 (1 comentario)
1,7
1,7
Avatar del usuario
Hi, I (Myself a senior PHP Developer) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Warm Regards ~Team Shopify
€18 EUR en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have been working with MS Access and Visual Basic for Apps as well as SQL/SQL Server since 1998. The technologies have been a major part of my career since that time. I have experience building applications from the ground up, and have been hired on a number of occasions to modify, add features to, or even document complex applications written by others.
€18 EUR en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Well versed in MS SQL Server,VB,VBA and Excel automation, involved in Design,development and deployment
€16 EUR en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
MCA with GNIIT course from NIIT. Designed, developed & maintained school management software, used in many schools of my city, i used VB as front end and MS-SQL and MS Access as backend. I have some experience of web site development also. I prepared university result in MS-Access using VBA code.
€16 EUR en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de NETHERLANDS
Rossum, Netherlands
0,0
0
Forma de pago verificada
Miembro desde may 8, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.