Find Jobs
Hire Freelancers

Create an Access database from a simple spreadsheet

£250-750 GBP

En curso
Publicado hace más de 9 años

£250-750 GBP

Pagado a la entrega
Seeking an experienced database developer(s) to develop a fast, streamlined database application. This is to assist in the good purchasing process within our IT Company that currently makes use of a single spreadsheet. Each purchase we make of goods is entered into a spreadsheet. That key data later gets imported into our accounting application Sage. So it’s just currently one spreadsheet that we are turning into a database. The database may grow on to include other features that support our internal business process and in some regards, this project is a test project for us to develop a relationship with developer(s). We would like the initial database to be created using Microsoft Access for speed but have ambitions for the future and a more scalable platform as the project expanded. We are an IT support and services company providing IT services to SMEs. We hope this simple project could be used as a test to establish a longer term relationship to enable us to build. We want to improve the process to make purchases. Every purchase our company makes from our suppliers, needs a Purchase Order number (PO number) and this is currently generated from a basic Excel spreadsheet, but taking the next row in the spreadsheet. Only one person has it open at any one time, no verification of data input, easy for person to make errors and delete other data within the spreadsheet. Later in the process, the transactions are then imported into Sage Line 50, the accounting software package we use. An example of how the new process would work is that the employee making the purchase launches an app from the systray that very quickly brings up the option to generate a new PO. The PO number is displayed clearly and quickly on the screen, ready to be able to copied and pasted, and certain details are pre filled. For example the transaction date default to the current date, the person making the purchase defaults to the person who is logged into the application etc. The goal the process quick to minimise the time an engineer has to spend when making a process so they can focus on giving IT support. Also the database will streamline other processes such as importing the relevant data into Sage Line 50, our chosen accounting application. At present, a bookkeeper needs to note all the rows that have already been imported into Sage, adjust the data manually into a Sage friendly format and then import that data into Sage. This is a relatively cumbersome task. For a bespoke Database application this would be a trivial task to make it export data in a format ready to be imported into Sage and it could keep track of what rows have already been imported into Sage. An even better approach would be the direct interfacing into the Sage API, however this is likely beyond the scope of this project at this stage. The actual import process is straight forward, and direct interaction with the sage API can always be introduced later. An example of the spreadsheets rows and data would be provided to those interested in the project. An overview of each of the expected user forms has also been provided. List of some of the required functions and forms. Further details are available to those who are interested. • User login screen • User control area • Create new PO number / entry - equivalent to creating a row on the spreadsheet. • Review / edit PO using simple or advanced search filters. Popular search options such as ‘Review POs by date’ are provided • Verify entries – It is imagined for speed, users would be able to enter incomplete entries, but before import into Sage, details would need to be complete. • Export to Sage (Creates a spreadsheet ready for Sage import). Access is to be used, as low overheads and rapid development but scalability is a future consideration. Also, as mentioned, we may be extending the database to do asset management and maybe even ticket management in the future so some consideration of the chosen platform should factor this in.
ID del proyecto: 6765264

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 9 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 I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by going to https://www.freelancer.com/freelancers/skills/Microsoft_Access/ I glanced through the spec sheet that you have attached. It is quite detailed and it seems that a lot of thought has gone into it. I will to discuss this with you to understand it completely. The only issue that I could not grasp is the need to create a systray app. I am not sure if this can be done using MS Access and also I could not understand the need for this. I can easily create a db that permanently displays the new PO number on any or all its forms. I look forward to discussing this project with you in more detail. regards Rajiv
£400 GBP en 10 días
4,9 (159 comentarios)
6,9
6,9
36 freelancers están ofertando un promedio de £467 GBP por este trabajo
Avatar del usuario
We are a team of client server application developers with expertise and experience. We have developed custom applications of varied extents and complexity. I have read the requirements and am confident of delivering well on all aspects, including generation of excel spreadsheets for importing to Sage. I wish to confirm - are you okay with us developing the application in VB.Net with MS Access as database? Once you confirm this, I will review the finer details (excel spreadsheet) in detail with my team. This will help me to assess scope of work precisely. I will revise / confirm my bid accordingly. I ensure a very thorough job and also support for scalability of the application in future. I look forward to hearing from you and working on the project.
£736 GBP en 10 días
4,9 (773 comentarios)
8,7
8,7
Avatar del usuario
Hey, I am an expert in Access based systems as you would see in my work history here on freelancer. I have created some very large and extensible systems (for example PoS system for a chain of stores or Sports data analysis system for a client from New Zealand etc.) I reviewed the file that you shared and also read through the requirement description. I can create the Database which will be able to generate the next PO and will also facilitate entry of other details. This coould be done from within Access itself or we can also have an Excel Userform front end (since users are more comfortable working on Excel). I can present different options to you and we may then decide which is the best based on your preferences. I can also show some demo systems that I have created to showcase my skills. I can assure you of excellent quality of work and also prompt communication throughout the project. You would see in my work history that I have been highly rated and recommended for quality that I have been delivering for more than 400 projects done so far. Do let me know if you would like me to work on this project for you and we may discuss the details and next steps. Look forward to hear from you. Thanks and Regards, Shikha (Automyze Consulting)
£555 GBP en 10 días
5,0 (245 comentarios)
7,1
7,1
Avatar del usuario
I am willing to discuss further about the project specifications and deliver the same to your needs .
£421 GBP en 10 días
4,8 (76 comentarios)
7,0
7,0
Avatar del usuario
Happy to help you out. I have read complete details of the project and have understood the work required here. If we can discuss in more details, i can capture the exact workscope for the project. Kindly Discuss Thanks Dobre
£526 GBP en 15 días
4,8 (171 comentarios)
6,6
6,6
Avatar del usuario
I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases I built are. ASCL database for Major Hospital in OKC. A scheduling program for the anesthesia department for a Major Hospital in OKC. A ford Parts Database to help a company keep track of inventory in house and EBay. and Many more. I was on Freelancer for 3 years and my account was hacked and I had to create a new profile. I have all my feedback from that site if you want to see them.
£500 GBP en 10 días
4,8 (40 comentarios)
6,6
6,6
Avatar del usuario
I have been in this industry for 6 years and such jobs are my daily practice.         This is my first time on this site and hence you can see that I have only 1 ratings/feedback to show you.         I can assure you that if you work with me once, you will always work with me for these kind of projects.         I have been read your Project description throughout.         You can see my profile for more details . See some screenshots of my previous work in my portfolio.         Let's discuss for even more details before you award me the project.         Thank you in anticipation.          Have a nice day...
£555 GBP en 10 días
4,9 (75 comentarios)
6,1
6,1
Avatar del usuario
Hi, I have gone through your xls sheet and the ordering process. if you allow me to make that application in vb6.0, front end and access as database then I can make what ever you like. I have worked in retail sector so know very well about order, delivery... please reply me so that I can give I a better solution and yes later on we can integrate with sage api as well. if u want to see my back office software then please reply me I will demo u using teamviewer. regards, rajnish
£579 GBP en 25 días
5,0 (11 comentarios)
6,1
6,1
Avatar del usuario
Hi, I am interested in this project. i am an experienced MS Access database application developer. i can do this job for you. If interested in hiring me then please let me know so that we can discuss the scope, timelines and budget accordingly. Thanks regards, jawad
£277 GBP en 10 días
5,0 (89 comentarios)
5,7
5,7
Avatar del usuario
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access development and Visual Basic to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,
£500 GBP en 10 días
5,0 (14 comentarios)
5,1
5,1
Avatar del usuario
Hello, I have been working with a MNC based company in a BI DWH project since last 4 years. This project is DWH project which comprised of DWH concept,Informatica as ETL tool and Cognos & Qlikview as reporting tool. I have good knowledge of SQL queries and DWH concepts and as part of project work have written multiple complex queries to create reports as per business expectations. Apart from above I also worked on development of web based application e.g Online Reservation System,Online Examination etc. I have completed similar work earlier,Would be looking forward to work on this opportunity. Thanks,
£444 GBP en 10 días
4,9 (43 comentarios)
5,2
5,2
Avatar del usuario
Hello, First, let me congratulate you -- I just love such a dedicated thoroughness in both your explanations and requirements spreadsheet. For your project I'm proposing to break-down in several steps set as milestones payments, to be released upon delivery of each functional part. If interested, I look forward to your contact, Grunty.
£444 GBP en 20 días
5,0 (25 comentarios)
5,1
5,1
Avatar del usuario
Good Day, I would like to express my interest in your project. I am a holder of a BSc. (Hons) Computing degree from the University of Greenwich (UK) and have over 8 years professional work experience in the IT industry, holding various technical and administrative/supervisory positions. I have an excellent grasp of MS Excel, MS Access, Visual Basic for Applications, database design/development, SQL, MySQL, data import and export to MS Excel, txt, pdf, emailing reports, etc. I would be very glad to develop a Purchase Order System for your IT Company. Please find below some MS Access applications that I have worked on: ( A ) MARKETING CONTACTS DATABASE: Complex database for keeping track of clients who are targeted for various marketing campaigns. Utilises complex SQL queries to filter clients based on various criteria. Includes bulk importing from and exporting of data to MS Excel. ( B ) PROJECT COSTS DATABASE: For management of Project financial data - quotations, variations, customer orders, purchase orders, receipts, invoices, payments, report generation and emailing of reports as pdf attachments, etc. I would like to assure you that I am committed to providing you with a solution that meets and where possible exceeds your requirements. (Excellent reviews and work samples are available on my profile page.) Please feel free to contact me in case of any queries. Thank you so much for considering my application. Sincerely, Jeane.
£350 GBP en 15 días
5,0 (6 comentarios)
5,0
5,0
Avatar del usuario
Hi, I have gone through your requirements,I am a Database Programmer at CMMI-5 Level company since August 2004.I am working on MS Access, Shell Script,PL/SQL,T-SQL,MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.
£700 GBP en 15 días
4,0 (46 comentarios)
5,8
5,8
Avatar del usuario
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
£477 GBP en 9 días
4,9 (18 comentarios)
4,7
4,7
Avatar del usuario
Hello I'm Microsoft Certified Database Developer. I working with Microsoft Access since first version. With Microsoft SQL Server I working since version 2000. I can build this project in Ms Access as you wish. But I Suggest that we start this project as modern web application - it will not take more time that build it into ms Access. This approach have a more advantages: - the Database will be in ms SQL Server which is a real multi-user database with superior back-up capabilities - User interface I will build with C# in ASP.NET MVC as back-end framework and Bootstrap as front-end framework - application you can use internally (on your network) and on internet - application you can use on desktops, notebooks, tablets and smartphones I have a years of experience. Shell we start immediately. RGD's Borut Spanovic
£344 GBP en 14 días
4,3 (13 comentarios)
5,4
5,4
Avatar del usuario
I can develop a simple windows form application, that will be user friendly. Database can be access database or mysql (free for you). Also i will include reporting feature in the application which can be exported to pdf, excel etc. Keenly looking for your response
£555 GBP en 10 días
4,7 (8 comentarios)
4,3
4,3
Avatar del usuario
I have over 10+ years of experience in IT industry and worked with several access projects. I have experience with Oracle Applications on several modules which is a ERP. I would like to work with you on this project. Please let me know further. Regards, Selvan
£425 GBP en 15 días
4,6 (5 comentarios)
3,5
3,5
Avatar del usuario
Hello Sir, I am Experienced VBA Coder for MS Access for Application. I have done projects in ms access, you can check it in my profile. As per your requirement and my experience, I will suggest to make front end in VB6 for user friendly inputs and database will be in ms access. it would be helpful to prevent direct access of database, also you will have very good user interface. In future if you want to expand the application, changes also can be easy to handle. We will proceed step by step,functional deliverables will be send to you as for UAT( User Acceptance Test). I am working in IT industry in India, which work for insurance mgas and company in USA. Please consider my bid for your project. I also suggest that, you can take samples of some basic task from multiple worker and then finalize bid with the right freelancer. Thanks & Regards, Prashant Patel PraNil Infotech Quality Work In Time
£555 GBP en 15 días
4,9 (20 comentarios)
3,3
3,3
Avatar del usuario
Hi, thanks for specifying the requirements clearly. I have been in database development for last 5 years. I have expertise in access, spreadsheet conversion, oracle, mysql etc..please let me know if you want me to do this work. thanks, ayan dasgupta
£250 GBP en 5 días
2,6 (4 comentarios)
3,6
3,6
Avatar del usuario
Hi, I read carefully your project, and I think I wanna work on it. I am an experienced Web Developer and Web Designer, and have worked with wide variety of skills likeDatabase Administration, Database Development, Database Programming, Microsoft Access, Software Architecture for many years. I also have worked over many Wordpress projects. I have good communication skills and big responsibility.
£260 GBP en 20 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
5,0
6
Forma de pago verificada
Miembro desde may 21, 2008

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.