first project

[cipo]

Hi people
I would really appreciate some advice on how to go about my first project at work

I need to create a system where I can search two criteria that will find more than one results and I am not sure wether to use access or excel. Our company produces buckets for diggers

More detail :
A customer will be asked what machine they have and what material they need it for so i need to search using the machine and material to pick out which buckets will be suitable for what the customer wants.

any help on the best way to do this would be much appreciated

thanks

 

[mcclunyboy]

I work in IT but my access knowledge is fairly limited, however I would probably use Access. You can create the project in either excel/access but considering your question a database is the way I would go...

In excel it would work but not as well. Filters etc.

You basically want to store the details of all your products in a table (may require more depending on data).Then you can create queries to search that data for the machine compatible/material compatible buckets.

Just make sure you capture all the information you require against your products - that way it will be easier to query successfully later..

Before starting though - make sure you pick the way you are comfortable with. Are you experienced at all in Access?

 

[jdraw]

Here is a link for a process to help with design of a database. There is an example for all the steps involved including the database set up. There are forms and instructions for you to use your situation, record relevant parts and work through these to build a database.

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck.

 

[cipo]

Think im going to use access not used it since school but i think i will be ok thanks for the help