Find Jobs
Hire Freelancers

Write some Software

$250-750 AUD

Cancelado
Publicado hace más de 8 años

$250-750 AUD

Pagado a la entrega
Hello, I am currently looking for someone who can help us with database development (VBA, SQL), specifically with inventory/stock management extension. Our database is created using MS Access 2013. Short description: We have developed bill-of-material database to help manage our projects in-house (we are playground designers). Our project is basically playground structure for our clients with list of assemblies, price calculations, Cost Estimate and other related reports. Our assemblies includes list of components (component is the lowest level here). We want to be able to add colour variations for selected components on Project level so it will allow us to have different colours for the same component type (For example 5xComponent1 in Blue, 6xComponent1 in Red etc) in one project. What we want to do: We, however, decided to improve this database and add inventory/stock management functionality. We want to have something like demo template from Microsoft called Northwind Traders on top of our database. We managed to integrate Nortwind into our database but it works only with components without colour variations (mentioned above). We would like to make this to work with colour variations in order to see how many component in what colour we sold, ordered etc. We will appreciate any help.
ID del proyecto: 9534276

Información sobre el proyecto

33 propuestas
Proyecto remoto
Activo hace 8 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
33 freelancers están ofertando un promedio de $582 AUD por este trabajo
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. Regards, Eyad
$2.526 AUD en 50 días
5,0 (28 comentarios)
7,2
7,2
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 have a question: Is the database webdatabase based on sharepoint or is it a desktop database. It is difficult to format web databases - however these might be useful if you need users to access the database on the web. If you can send me your database with sample data, I will be able to give you better feedback. I look forward to hearing from you. regards Rajiv
$300 AUD en 10 días
4,9 (160 comentarios)
6,9
6,9
Avatar del usuario
Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you are looking for someone who can help you with database development (VBA, SQL) in Access 2013, specifically with inventory/stock management extension (like demo template from Microsoft called Northwind Traders with color variations) as you described in your project description. I have 6 year's experience designing and developing Microsoft Access Application with advance knowledge of SQL and VBA and particular skill in integrated Microsoft Office solutions based upon automation of Excel, Word and Outlook. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. I can make it so it can be use in Multi-user environment (Many user can work simultaneously from different computer) with log-in dialog, search, filter and save the filter features using Microsoft Access with Access Reports. I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, Search data, Validation rules, Filter some data then save the filter with a name so you don't need to filter for future use. The user interface structure of the application will be such that there will be a single Home form and all the other forms can be loaded on this main Home form th
$277 AUD en 10 días
5,0 (81 comentarios)
6,5
6,5
Avatar del usuario
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$777 AUD en 10 días
4,7 (82 comentarios)
6,5
6,5
Avatar del usuario
Hi I am interested in this project. I am an experienced MS Access applications developer. i can do this job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks Regards Jawad
$555 AUD en 10 días
5,0 (92 comentarios)
5,8
5,8
Avatar del usuario
EXPERIENCED DEVELOPER... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick
$555 AUD en 10 días
5,0 (18 comentarios)
5,2
5,2
Avatar del usuario
Hi. I'm Emmanuel Ovabor and I'm highly proficient in MS Access and have done numerous access projects as you will notice on my profile. I read your description and understand that you need to improve your database to add stock management functionality that works with colour variations as stated to see the number of components in the colours used. I would like to work with you on this and assure you of an excellent job with 100 % accuracy and attention to detail. Regards Emmanuel Ovabor
$444 AUD en 10 días
5,0 (42 comentarios)
5,3
5,3
Avatar del usuario
Hello sir, I am very interested in your project and offer my services. I am giving 2 links of my past projects in Microsoft Access here matching your project. Task Management System in Microsoft Access In this project I used color indications for different task statuses and user can select color of their choice. For example green color for completed project and yellow color for 'awaiting customer' status. https://www.freelancer.com/projects/Microsoft-Access-Anything-Goes/Tasks-Management-with-ACCESS.2293216/ Defect Tracking System in Microsoft Access This database was built to track different stages of a defect until it is resolved. https://www.freelancer.com/projects/Microsoft-Access-visual-basic-for-applications/Defect-Tracking-Database/ Please see my portfolio for other projects. I have done retail and distribution projects in Access including stock management. And I also know financial accounting and can take care of it regarding your project. Feel free to contact for further discussions. Looking forward, nblsoft
$555 AUD en 10 días
5,0 (14 comentarios)
5,1
5,1
Avatar del usuario
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$526 AUD en 10 días
4,8 (32 comentarios)
5,4
5,4
Avatar del usuario
Hello, I'm an very experienced MS Access/Excel developer. I've created databases from like the one you've provided for a number of Australian companies like BUPA, NAB and AustralianSuper. I only recently created a quote management system for an engineering company in NSW. I've also had experience with product/colour combinations in databases with some work I did for a clothing company. My fee would include: -Enhancing the database to manage stock/colour combinations as a unique item reference -Development of stock management component to database in line with sample database provided I'm happy to provide example screenshot of my work so you can see what I've done in the past. I am based in Australia as well which could make communications easier. Thanks, Adam
$500 AUD en 10 días
4,9 (7 comentarios)
4,6
4,6
Avatar del usuario
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$250 AUD en 1 día
4,9 (37 comentarios)
4,7
4,7
Avatar del usuario
Hi, I am 12+ years experienced Visual Basic,ASP.NET, VB.NET,MVC, C#,Bootsrap,Telerik control,Crystal report,WCF,JSON,SharePoint,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your work confidently. I am very much Interested to do your work,Please revert me if you have any concern.
$1.000 AUD en 15 días
3,9 (41 comentarios)
5,7
5,7
Avatar del usuario
Hi there - my name is Paul. I have more than 25 years of experience in designing and developing MS Access applications especially for small and medium sized enterprises. I'm new at Freelancer and don't have so many feedbacks until now. But as you can see my existing customers were 100% satisfied! I'll provide one year free support for my developments and with a short specification before each change I can provide 100% customer satisfaction. Summarizing that I'm very interested to modify your existing application to integrate the coloured components in the Northwind forms. I'd like to start with a short specifiaction phase to be sure that all requirements are considered. The timeline of 14 days is a rough estimation because of different tiemezones it's sometimes difficult to get a feedback in a short time. Please have a look at my protfolio to get an impression what can be done and how this could look like. Looking forward to hearing from you! Best regards, Paul
$555 AUD en 14 días
5,0 (5 comentarios)
4,3
4,3
Avatar del usuario
Hello, Over the past 18 years, I’ve worked in a variety of functions spanning Information Technology, Supply Chain, Finance and Process Optimization with a key point of connectivity being my use of MS Access/Visual Basic to solve many of the problems presented in each role. You can see more details on my educational and professional background on my LinkedIn profile (Rob Sliter), if you choose. I’ve built numerous applications varying from simple reporting tools to more complex multi-user client-server applications used in production environments. I am very motivated to exceed your expectations, earn a great review from you to post on the website, and begin a long standing business relationship. Your projects sounds interesting and I believe that my background will allow me to provide additional perspectives and insights into how to optimally leverage the data once we develop the base application. Developing the application that you’ve specified should be a straight forward exercise that I can complete quickly for you. After that, depending on what you're looking for, we can collaborate to take advantage of the rich functionality that Access presents. If you choose to hire me, I promise you won’t be disappointed and I promise to go above and beyond for you. Thanks for your consideration, Rob
$300 AUD en 10 días
5,0 (6 comentarios)
4,2
4,2
Avatar del usuario
Hi, from my profile you can see that I have many years work experience in Access, Excel, and VBA. I also have a strong IT, database and data analysis background (SQL, Oracle, PL SQL, Java). Can you pls give me more specific details of the project and timelines? Any example data you can send would also be helpful. I am eager to build my freelancer reputation so rates are negotiable. Regards, Colm
$833 AUD en 10 días
5,0 (1 comentario)
3,7
3,7
Avatar del usuario
I believe i am the best candidate for this project because i have more than enough hands on experience in designing and developing database application using Microsoft Access. I also have very good attention to details and accuracy when working with data (i.e. conversion or processing).
$255 AUD en 7 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
I know your heart is set on MS Access, but consider my browser-based cloud database application service that includes ALL IT services in a single plan. During twenty years of creating database applications for clients, I developed a method to support a diverse set of CUSTOM applications. We combine all services: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT into a single plan--one low monthly fee to fully support your IT needs. Search for "Konduit Transaction Editor". I can set up your CUSTOM database application on a production Transaction Editor (TEd) cloud server within two weeks for just US$495 (A$696). Users can Test Drive the application online for two months as we continue to refine your requirements. You get immediate hands-on experience as we calculate the affordable monthly recurring fee based on the complexity of your application. * Each TEd application combines spreadsheet ease-of-use with the accountability of a database and includes ongoing professional APPLICATION support. * Save SEARCHES and SORT on multiple columns * Recover from mistakes with CHANGE HISTORY LOG * Column and Row-defined MULTI-USER ACCESS * ATTACH FILES to data record * EMAIL PDF proposals/orders/bills/invoices * IMPORT/EXPORT multiple file formats * SCHEDULED and EVENT-based updates * Automated NOTIFICATIONS * Flexible WORKFLOW Management * Highly RELIABLE and SECURE * and so much more... Contact me for a demonstration.
$773 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I have 10+ years of experience in access development. I am interested in your project. Send me your requirement details and database with sample data.
$555 AUD en 30 días
0,0 (0 comentarios)
2,4
2,4
Avatar del usuario
Without having seen your database, I can only reference the Northwind database. It seems your requirement of REPORTING on color could be met by adding a "Color" field to the OrderDetails table (maybe what you've called "Project" table), and then working it into the forms/queries that support your reports. I'm a professional software developer, and have developed and maintained MS Access databases for the past 15 years, in a wide array of applications, including maintaining medical qualifications, tracking inventory and purchasing, data-mining against a back-end database, QA work tracking, and even a reservation program for a local RV park. I try to use best practices where I can, and focus on maintainability and writing human-readable code. Please feel free to contact me if you'd like to discuss anything. Have a great day.
$356 AUD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I would like to modify/rebuild and finish your inventory Access database. I have several years experience using Access to make several databases including VBA automation. At a previous physical job (not Freelancer), I created or modified databases to (1) track tasks for several employees, and (2) track inventory parts that to be assembled into various completed products, tracked by part number, individual serial numbers, and individual sales to discrete customers. We did examine the Northwind base, but I ended up making a fresh one because of our special needs. For instance, many parts had to be combined into sub-assemblies, and many of those were combined in different ways for different products. (And would list how many raw materials are currently available, and the cost of assembling a completed product from those parts.) There was also a lot of VBA special features--customized buttons, special sorting and filtering features with highlights on the columns, and reading/writing from Excel sources. In a different database, the system split between a backend that held the data, and different front-ends at different computer stations: ranging from simple ones for clerk data entry, to a "CEO" front end that had full power to modify the database categories. And all database tables were designed with referential integrity directly through SQL, not through any wizard. I'm in the US, working in evenings & weekends. Please contact me on Freelancer so we can discuss details. Thanks
$500 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Marrickville, Australia
0,0
0
Miembro desde feb 2, 2016

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.