Create a custom database for a small business by Microsoft Access
Budjetti $750-1500 CAD
Currently, we are using MS Word documents and Excel tables to produce our company invoices, shippers, quotations, purchase orders and job forms. We are looking for an individual to combine all of these forms into a MS Access or web-based database so we may automate and make this process more efficient.
Database pages:
Customer / Information input database
Page to input customer information, internal information and other items which will populate all below forms
Purchase Orders
This is a single form which can be approved via signature and emailed (output as PDF) to vendor or printed and filed. Purchase order information will transfer into the “Job Form” costing analysis for material and outsourcing.
Job Forms
Main form showing all information pertaining to job (see “Job form” excel file). This information includes pictures of the job, reference information, line-ups, job costing, etc. The formulas can be seen and transferred from the Excel file to the database.
Job Tracker
This form shows some overall information of all of all our current jobs in progress and is displayed on a monitor on the shop floor. This form is a “snap shot” of job timing and current status.
Shippers
Are single forms which are printed for the customer / vendor to sign and get sent out with the job. The signed hard copy stays in our records. The information for the shipper is pulled from the job form. They are currently printed on a pre-printed template which will be eliminated for the database.
Invoices
Are single forms that are sent via PDF or printed and mailed to customers. The information for the invoice is pulled from the job form. They are currently printed on a pre-printed template which will be eliminated for the database.
Scope of the project:
Our current solution is to create these above forms form a template and copy the information from form to form also manually changing dates, and numbers. We have started to create a MS Access Database to incorporate all of these items but the project was left undone. You can use this database to start with or other available templates and combine them.
We will create milestones at the database completion and also another after a few weeks of debugging is completed. Please note that there will be continuous changes based on ease of use and functionality. Your bid must accommodate this challenge. Lastly the database must be completely open and must not have any locks preventing future modifications. I am looking to start this project immediately.
Myönnetty käyttäjälle:
Hello! Can I help you with the database? You have to make one decision - will it be a web-based database (using web-pages) or will you keep a frontend in Access format with the ability to use it over the internet? I Lisää
54 freelanceria on tarjonnut keskimäärin $1181 tähän työhön
ID : 24896634 Greetings, We are interested to work on this project, please find my comments inline with yours in the following link. [login to view URL] h Lisää
Hello! This is not an easy project, but I'm sure I can handle it. You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladi Lisää
Hello, I can help you with your project - Create a custom database for a small business by Microsoft Access I have gone through your job posting and become very much interested to work with you. I am an expert in th Lisää
Hi, I'm an expert application software developer, with significant experience in developing accounting and inventory control database software for small and medium business, including manufacturing operations where yo Lisää
Good day, My name is Donna. I have read your project description and I feel with more detail I could complete it to your vision. I am a expert Microsoft access database developer, I am also an expert in Microsoft Exc Lisää
Hi Classic tool and die team, Greetings, need to discuss in details in chat, please open a chat.. Please check once.. 1. Case Management system. [login to view URL] you can Lisää
Hi, I have gone through the attachments. Is it possible to share more details in terms of your current MS Access environment. Which version of MS Access you are using. The file extension is .mdb so it appears to be an Lisää
I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy r Lisää
Sir, I have gone through your project description and am looking to provide my service for web portal development for small [login to view URL] leave a message on my chat so we can discuss the budget and deadline of the p Lisää
I have a framework application from which I can build your database very efficiently. I have over 20 years experience developing applications in Access, Excel, Word and Outlook with advanced knowledge of SQL and VBA. Lisää
Hi there, Greetings! I hope you are well and safe. I have gone through all your documents and understood your project description. I have done a few similar jobs before and happy to show you over chat. I am an exper Lisää
Hello? I have worked on Excel/Word/PPT/MACRO projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you ar Lisää
Dear client I am feeling confident at this job Why? I have developed very similar job recently for my beef company invoice, booking certificate system - [login to view URL] Can we discuss in detail? Regards
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 Access Lisää
Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Can start the job immediately. Database will be designed, cr Lisää
