Create a custom database for a small business by Microsoft Access
$750-1500 CAD
Paid on delivery
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.
Project ID: #24896634
About the project
Awarded to:
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 More
52 freelancers are bidding on average $1180 for this job
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 More
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 More
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 More
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 More
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 More
We will do your Data base work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in More
Hello Dear Employer ⭐⭐⭐ Please see my portfolios in ms office programming & related reviews in my profile I'm developer with +12 years experience & expert in ms access, ms excel, vba macro, design databases & reporting More
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. More
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 More
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 More
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 More
Greetings, my name is Petar and I am a database developer. I went through the project description and I must admit that it is not a naive one. This is a huge project combined from several different parts. I would use t More
Hi . Honest and reliable company that you can rely on. Skilled professionals in Electronic Forms, Database Administration, Microsoft Access, Database Development and Software Architecture " Create a custom database More