In Progress

Create a custom database for a small business by Microsoft Access

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.

Skills: Database Development, Database Administration, Microsoft Access, Software Architecture, Electronic Forms

See more: microsoft access custom database minneapolis, database project using microsoft access 2007, database car showroom microsoft access, access database templates, how to create a database in access 2013, how to create a database in access 2010 step by step, how to create a database in access 2016 step by step, how to create database in access, how to create a database in access 2016, how to create a database in access 2007, steps to create database in ms access, create html email newsletter within microsoft access, inventory database samples using microsoft access, move exchange database small business server 2008, video store database managing system microsoft access, create business ledger database microsoft access 2007, create simple database order management microsoft access, database filing system microsoft access, small business accounting access, access database small business accounting

About the Employer:
( 13 reviews ) Windsor, Canada

Project ID: #24896634

Awarded to:

branislavm

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

$1125 CAD in 7 days
(322 Reviews)
7.9

54 freelancers are bidding on average $1181 for this job

illuminesoft

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 More

$1125 CAD in 7 days
(334 Reviews)
7.7
Neno585

Hello, I am interested in building your applications. I am MS Access/SQL expert with 8+ years of contracted working experience I reviewed your database and the attached database and I see decent amount of work involved More

$1300 CAD in 7 days
(31 Reviews)
7.4
VladimirLilenko

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

$900 CAD in 10 days
(211 Reviews)
6.9
schoudhary1553

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

$1200 CAD in 10 days
(89 Reviews)
7.0
expertcoder1vw

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

$1120 CAD in 14 days
(84 Reviews)
6.5
workerbee1974

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

$1333 CAD in 15 days
(43 Reviews)
6.7
lavizsolutions

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 More

$2000 CAD in 15 days
(15 Reviews)
6.4
finecodervw

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

$2000 CAD in 20 days
(166 Reviews)
6.5
wsh2

Employer writes: "Please note that there will be continuous changes based on ease of use and functionality. Your bid must accommodate this challenge." Seriously, is this how you quote your jobs? All you can eat, for o More

$2222 CAD in 15 days
(21 Reviews)
6.1
royalcalif

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 More

$750 CAD in 12 days
(93 Reviews)
6.2
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VBA. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f and see following screens for : " More

$1500 CAD in 7 days
(62 Reviews)
6.3
ARKSolution2015

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 More

$1500 CAD in 30 days
(79 Reviews)
5.9
tutulsoft

--- 20 Years Database Software Expert for Business Automation for Small to Large Companies-------- I have also Experience for Development "Job Management Web Based Software" for JMM Tools , I would prefer WEB BASED More

$1100 CAD in 7 days
(25 Reviews)
5.5
nblsoft

Hi there, I have checked your database read project description and it is safe to say that I can help you in your project. I have extensive knowledge and experience in database designing and development, especially r More

$1125 CAD in 45 days
(13 Reviews)
4.9
NeilSargent

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

$1500 CAD in 7 days
(8 Reviews)
5.0
rayyankabir

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

$1250 CAD in 14 days
(19 Reviews)
4.9
nemanjadj20

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 More

$1125 CAD in 7 days
(15 Reviews)
5.1
shrec

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

$1125 CAD in 7 days
(7 Reviews)
5.0
KellogITSolution

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

$750 CAD in 7 days
(29 Reviews)
4.6
dionisiotumbaga

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

$750 CAD in 7 days
(8 Reviews)
4.5