Vehicle service database MS ACCESS 2010 reposted

Closed

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…

Skills: Microsoft Access, Visual Basic

See more: microsoft access vehicle database, access vehicle database, microsoft access vehicle service database, car database access 2010, vehicle part, private data entry, car service database access, access car database, car database access, microsoft access 2010 vehicle database, vehicle information microsoft access, vehicles database access, create access vehicle database, access database vehicle service, car access, access project vehicle database, vehicle service database, vehicle database project access, car database using access, vehicle service microsoft access, access database car service, vehicle parts access database 2010, car invoice access database, vehicle database access, parts database access 2010

About the Employer:
( 18 reviews ) United Kingdom

Project ID: #4210563

22 freelancers are bidding on average $116 for this job

rhomeu

MS Access expert here please see my profile for more details. Thanks

$250 USD in 3 days
(41 Reviews)
6.5
svet63

What version of Access would that be?

$250 USD in 2 days
(42 Reviews)
6.0
Premshanks

Hi I understood your requirements and I shall all the work you want. You can release the payment once the job is complete and satisfied Pl see my work history and I am well experienced. I am a self starter reg More

$99 USD in 10 days
(183 Reviews)
6.0
infoshree80

Hello Pat, Ready to start.

$75 USD in 12 days
(17 Reviews)
4.9
nikhil2010

Dear Sir, Thanks for posting the project and being precise with your requirements. I see that you did not have had a very good experience in the past with the freelancers. The project is a quite a bit as compa More

$100 USD in 30 days
(6 Reviews)
4.4
alekhine1962

Kindly check PMB. thanks ...

$80 USD in 7 days
(19 Reviews)
4.3
florinserban

Hi, Please check PM for details. Thank you!

$65 USD in 10 days
(12 Reviews)
4.2
davidt999

Hi! I can do this for you. Thanks! David

$250 USD in 90 days
(3 Reviews)
3.6
itcan

I am an MS Access Specialist with more than 14 years experience. One of my passions is motorcycles. I have a motorcycle dealership and over the past year or so I have been "developing" an application that I use for Inv More

$100 USD in 5 days
(2 Reviews)
3.3
theenggprojects

I am ready to start the job

$100 USD in 5 days
(4 Reviews)
2.6
ielkfarna

Please, See my private Message.

$100 USD in 7 days
(1 Review)
2.0
anomanpk

I would like to offer my services for this job.

$80 USD in 2 days
(1 Review)
1.4
Warrio

I want to your project.

$45 USD in 7 days
(0 Reviews)
0.0
accitpro

Experienced programmer/developer here. Kindly check your pmb for details. Thanks.

$100 USD in 10 days
(0 Reviews)
0.0
guidesme

Respected sir, I have understand your project needs. I have strong skills and past many years vast experience in developing databases in MS Access Software. I provide quality work to my clients. Recently i have develop More

$100 USD in 20 days
(0 Reviews)
0.0
meeayee

Ready to start work...

$100 USD in 30 days
(0 Reviews)
0.0
TechSystems

I can complete your project in max 10 days

$90 USD in 10 days
(0 Reviews)
0.0
yogikrish81

I can do this for you

$115 USD in 2 days
(0 Reviews)
0.0
billfan88

hi I have ten years experience on MS Access. I have done seven Access DB for client in 2012 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Btw: I were MVP about Micr More

$100 USD in 1 day
(0 Reviews)
0.0
visionsoftwareco

We have understood your requirement and can implement it easily, you need an application which can hold vehicle service summary.

$170 USD in 10 days
(0 Reviews)
0.0