new to access

[haze81]

hi guys,



i am pretty new to access and would appreciate any guidance on how to best approach this:
for a school project I already have created an excel data base containing the following information about vehicles:
general info (e.g. brand/name/model etc.) and vehicle equipment (e.g. battery, spark plug, horn etc. including various part number and description)

now i want to transform this information into an access database with the goal that when opening the database you only have to key in e.g. "Chevrolet Cruze" and then receive an output in form of a spreadsheet, containing a picture of the car as well as all the info from the database listed below.

thank you for any feedback.

[JeroenMioch]

Hello Haze,

First welcome to this forum !
I would start by making a form with a filter where you can search for brands, models, maybe date of issue and or other search criteria. e.g. When you enter "Chev" into the brand control it returns all Chevrolet models. When you enter 'Chev' into the brand control and 'Cr' into the model control it would only return Chevrolet Cruze (and all its propperties).

Then i would imput the pictures of the cars, for example pasted in a Word file and name the file exact like the brand and model. This way it will be easier later on to connect the file with the record containing the vehicle information.

This is the way i would appoach things, but maybe people here have other or better ideas.
There are loads of filters out there. Ive got a nice boolean filter wich if you wish i can provide for you.

[haze81]

Hello Haze,

First welcome to this forum !
I would start by making a form with a filter where you can search for brands, models, maybe date of issue and or other search criteria. e.g. When you enter "Chev" into the brand control it returns all Chevrolet models. When you enter 'Chev' into the brand control and 'Cr' into the model control it would only return Chevrolet Cruze (and all its propperties).

Then i would imput the pictures of the cars, for example pasted in a Word file and name the file exact like the brand and model. This way it will be easier later on to connect the file with the record containing the vehicle information.

This is the way i would appoach things, but maybe people here have other or better ideas.
There are loads of filters out there. Ive got a nice boolean filter wich if you wish i can provide for you.

thank you for your feedback and sorry for my late reply.

I am somehow still struggling..
I have imported all data now from excel to access, but I am not sure how to actually create required relationships? and form/filter or query? needed.

What I would like to have at the end is the following:
Open access > immediately get a box to key in vehicle & year > receive a sheet with all related equipment & part numbers
(leave out the pictures for now)

Can I solve this with 1 table and a simple filter?
Sorry, I am still at the very basics..

[Z1nkstar]

What you would need for your open is a start up Search form that will allow your users to imput a value then that vaule Such as "Chev" or "Chevy" it would output a form with all Makes and Models that have this in a field "Chev"

So What your looking at creating is 2 forms so far for start up you need a Start Up Search form then you will need a Main Form that has all the makes and models as records that will allow for the search to grab all related records.

Now with that said I wouldn't make a start up form your search I would have the database open then there be either filter buttons or Sub forms that have different Makes then under those categories have different models and so on.

If you think Of it like Folders:
-You have a main
--You have a sub
---Within that sub you have related records to whatever form those chose.

These are just ideas of what I would do buttons are very easy to make but also I think structure wise the folder form idea might be better, and I say this because what if you have a user that searches some weird brand of car that you had no idea about or some kind of new car that came out without you updating the database, the folder form will give them specific search forms.