Find Jobs
Hire Freelancers

Vehicle service database MS ACCESS

$30-75 USD

Cancelled
Posted about 11 years ago

$30-75 USD

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…
Project ID: 4199769

About the project

16 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $137 USD for this job
User Avatar
Dear Sir, I'm expert on Access And MSSQL. Best Regards, NourElDeen
$100 USD in 10 days
5.0 (59 reviews)
5.8
5.8
User Avatar
Hi, I have read what you said about your payment limit but have submitted my bid nevertheless. Please see PM for further details. Thank you.
$300 USD in 10 days
4.9 (23 reviews)
5.5
5.5
User Avatar
Having more than 12 years of experience in Ms access development. Please check PM
$50 USD in 10 days
4.5 (24 reviews)
5.1
5.1
User Avatar
Hello Sir, We are Expert in VB ,We can do your Job in any Job in VB,Please see Private Message.
$90 USD in 8 days
4.8 (21 reviews)
4.8
4.8
User Avatar
Hi, Instead of your payment limit I have bid with higher amount. Please see your PM for more details and a sample access application just for your reference. I can assure you will get quality work.
$175 USD in 10 days
5.0 (9 reviews)
3.9
3.9
User Avatar
I know that you will reject the bid, but when you decide to have working application I could help you.
$500 USD in 20 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Experienced programmer/developer here. Kindly check your pmb for my details. Thanks.
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, i am ready to work with u.. Thanks Alld
$75 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 13 years experience in acces and this project is perfect for me
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi i have experience in Developing System i will make you satisfied!.
$40 USD in 10 days
0.0 (1 review)
0.0
0.0
User Avatar
New to Freelancer, but not to Access development. Experience in customer management applications (hospitality and entertainment venues). Would be interested in discussing how this works in relation to your business priorities (i.e do you start by identifying your customer or their vehicle?).
$60 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Thanks for the opportunity to bid on your project. I have looked at the attached Access Database and have read your advert. My bid utilizes previous experience developing similar Software with Access 2000 for the Ethiopian Parliament Motor Pool/Fleet Management System. Based on this actuality, I have the subject matter knowledge and necessary technical skills to enable me undertake and successfully deliver the project. I propose to develop the project with Ms Access 2007 (Database and Front-End) in a period not exceeding 10 days from the date of acceptance of my bid. Please contact me should you require any further clarifications on any or all aspects of my bid.
$75 USD in 10 days
0.0 (1 review)
2.9
2.9
User Avatar
This is what I am doing actually! I am MS Access developer and support customers using fleet management software. I can give you access via Internet for you to see. It can be used as SaaS or can be installed locally. Main feature include: Trip logs, fuel control, trip related expenses, freights and tariffs, Planned maintenance, Service cost, Inventory management.
$395 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi? I can perfectly do this job for you to your satisfaction. I am a proficient user of Microsoft Access and Visual Basic, and have instructed college students in MS Access for years. Briefly stated, I will create tables for vehicle, customer, work-done, and filled-parts details; design data entry forms; and design reports such as invoice, among others. Obviously, appropriate table relationships must be established. Then , I will perform data normalization which is a mandatory process in any database design. Let me guarantee you that you will be satisfied with my work, which I can complete in less that five days. Thank you.
$50 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Im ready for this work...
$50 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 10+ years of MS Access development experience and 7+ years of MS SQL development and administration experience.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
5.0
18
Payment method verified
Member since May 10, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.