Vehicle service database MS ACCESS

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

I need a small database to allow the storage of customer and vehicle details, details of work done, Details of parts fitted, be able to print an invoice, be able to print any invoice easily from the data input/job form

I need a basic job or work order form, On entry of the Vehicle Reg Number in a combo box, the form will check to see if the Vehicle is already saved, if it is, the rest of the vehicle details will be filled in on the form automatically, if the vehicle is not already in the database then I must be given the option to add it to the system and on completion of adding the new vehicle, I will be returned to the main form to continue adding the rest of the data, with the new vehicle data added.

Primary Key MUST NOT be Ref No, to allow for private plates which may in the future be on another car, you must also think of a way to deal with the possibility of 2 different vehicles having the same number historically.

Customer details must be done in a similar way, enter the Customer name and if an customer matches then other details from the form are prefilled, if not in DB the option to add in the same way as above, Also you need to account for 2 different people having the same name.

I must be able then be able to enter details of work done, probably as memo as this may well exceed 254 characters.

Parts used will need to be on a subform of the main form, I need to be able to select from a list of parts and be able to add certain info such as description and sale price, these will need to be stored with the Job, as these will change on Job to Job, again, if parts are not shown, option to add

Goes without saying that date and invoice number should also be stored

Decent navigation is a must

All this information will then be used to generate an invoice showing, Owner details, Vehicle details, Work done and all parts used and unit price of parts, this unit price must also be editable on the Job sheet without affecting the other data in the database.. so must not alter the price in the parts table.

I will also need to scroll through the invoices.

I have included a sample database that I have created to include a general idea of what I am after

This includes an invoice , this is the layout required

Parts, customer, vehicle and supplier input forms,

Job form, this is the layout required only as the FORM DOES NOT WORK

Tables, these include parts (filled), customer, vehicle makes (filled) , Vehicles, Suppliers and Job,

The database provided is for reference only and it will not function properly but it gives an idea of the layout required. you are not trying to fix what's provided, tables will need to be added to enable full normalization, you are to create a working system and will need various skills and plenty of initiative.

Now the horrible bit !!!! reading this and understanding this part will save everyone time and money.

PLEASE ONLY BID IF YOU ARE ABLE TO DO ALL OF THE ABOVE AND ADD A BIT OF INITIATIVE WHERE REQUIRED, I DO NOT EXPECT TO HAVE TO BABYSIT THE FREELANCER WORKING ON THE PROJECT AND HAVE TO REMIND THEM OF THE BASIC RULES OF DATABASE DESIGN AS SEEMS TO HAVE BEEN THE CASE SO FAR. If you do not understand normalization or do not understand how to create a decent relationship structure then please do not bid as you will not be able to complete the task

MILESTONE PAYMENTS , simply providing the basic tables and using the access form builder does not warrant a milestone payment, to request a milestone payment, I expect a significant milestone to be reached, this will be along the lines of fully functioning job form, working as requested above, I seem to have been paying a stream of milestone payments to coders and then never getting completed work as the coder does not know how to do it.

BUDGET, Simply put, if you bid over $100 you won’t be getting it, my budget is Small ideally around $50.

IT MUST BE IN MICROSOFT ACCESS, I do not want or need it in any other format including .NET and C etc…

Microsoft Access Visual Basic

Project ID: #11182070

About the project

22 proposals Remote project Active 7 years ago

22 freelancers are bidding on average $80 for this job

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$300 USD in 10 days
(75 Reviews)
6.1
zu02

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 Acc More

$58 USD in 3 days
(24 Reviews)
5.5
aleator

I am not a mediator. I will help quickly and efficiently. Ready to do this job. I have several dozens of completed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.

$60 USD in 4 days
(47 Reviews)
4.8
carlosperezit

Hi Im an expert in .Net technologies. I have been working in banking sw development for the last 20 years Regards Carlos

$83 USD in 5 days
(14 Reviews)
4.6
crypthne

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 administ More

$50 USD in 3 days
(17 Reviews)
3.7
workerbee1974

hi my name is Donna, I have been working with Microsoft access for 16 years. I have taken the class from 03 to 10. from beginner to expert and all. I have built well over 250 databases. I can start today. I am currentl More

$83 USD in 5 days
(6 Reviews)
3.4
rashmisingh2990

I am database expert having experience of 3 years.I will complete your work as per requirements and deliver it on time.

$74 USD in 3 days
(12 Reviews)
3.4
satishtl

Have good expertise in MS Access. Have done Database design, table creation, normalization, constraints, indexes queries, complex queries, form designing and reporting. Please see my profile on the recent reviews and More

$50 USD in 3 days
(8 Reviews)
3.3
chetanraj81lx

HI, I am experienced software engineer and i have developed lots of software. I will make this application which you can store your client's vehicle part info and can create invoice as well. Kindly contact me. T More

$111 USD in 3 days
(2 Reviews)
3.1
SCKRamana

I am ready to work on your task as per the requireemnt given in the requirement specification and delivery as per the time line . Message me . we are available 24/7 online More

$58 USD in 3 days
(3 Reviews)
3.0
cerim57

Hi, I'm very interested in this project, which I can accomplish due to my knowledge and experience. I'd like to talk about details. Thank you for your time. Kind regards, Cerim

$50 USD in 10 days
(1 Review)
0.8
bigmast3664

I understand all of your requirements and I'm pretty sure I know how to handle the private plates issue. I have built many types of job tracking/CRM databases for clients, and I would love to help you improve yours. More

$70 USD in 3 days
(0 Reviews)
0.0
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Access. I red carefully your description. I see some missing functionality that you'll definitely need to make th More

$100 USD in 7 days
(1 Review)
0.0
pnrfreelancer

Experience in Database application development.

$83 USD in 7 days
(0 Reviews)
0.0
sahumk2000

I am interested in this task, here is my profile Education- Masters in Computers Skills - ASP.NET, MVC, EF, C#, VB.NET, SQL Server, WCF, WPF, AngularJS, Jquery, XML, Cr Reports Experience- 12 Yrs as Developer, Tec More

$58 USD in 3 days
(0 Reviews)
1.3
SamiaMehmood

A proposal has not yet been provided

$58 USD in 3 days
(0 Reviews)
0.0
KSACHI

1). Initial Requirement Gather phase. 2). Finalize the Project Delivery Scope. (SRS Agreement) 3). Design the Back End Structures. (Client_Info, Vehicle_Info - with a Candidate Key, Part_Codes, Supplier_info, Job_He More

$30 USD in 7 days
(0 Reviews)
0.0
y2klewis

Hi, my name is Daniel, I am an Access Expert and vba programmer, i have a good experience developing similars databases, i am sure i can do an excelent work for you

$60 USD in 3 days
(0 Reviews)
0.0
trevollpereira

I can get this done for you .

$75 USD in 3 days
(0 Reviews)
0.0
meghvin

Similer kind of 4 projects completed successfully so no doubt at all

$61 USD in 10 days
(0 Reviews)
0.0