Avatar of yddadsjd95
 asked on

Automating an Autombile Repair Shop

I am creating an application for an automobile mechanic friend of mine to manage
his shop. Among other assistance that I am sure I will need, there are two
things that I know right off the bat that I need help with:

1. Is there a database that I can have access to that will give me all the
makes, models and years of vehicles that are on the road so the office manager
can simply click and add a vehicle to the customer's profile?

2. Is there a database that I can have access to that will give me parts for
these makes, models and years, along with the current price?

I am guessing that these services are available for a fee, but I figured that
this was the best place to start.

Oh, I do have a third question: Does anyone know of a template specifically for
an automobile shop? I am using Access 2007 and did not see any templates that
were close on the MS website

Thank you in advance,

Microsoft ApplicationsMicrosoft DevelopmentMicrosoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon

I was doing a little googling and came across this site where they made their own sql database that I think you could use, check it out - http://www.durangedesign.com/blog/p/mysql-vehicle-makes-and-models-database-sql-files-up-to-2009
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Thanks for the help guys.

Madhatter, I went to the link you gave and was unable to find the download file.

Jeff, I was able to download the file into an Excel Spreadsheet and I will import the necessary columns over the Access, and thanks for the etiquette lesson :-).
Jeffrey Coachman

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.