Question XLS links and selecting options

[Adrian Roberts]

Howdy all,

I want to use information supplied to me by suppliers as spreadsheets to create a database that i can navigate through by selecting from drop down options.

Example;
Imagine a product being broken down by its features, such as a washing machine.

Here is a list of what i would need to sort on,

Manufacture
Model
Type
Size
Price
Colour...and so on

So, if a customer asked "what 8kg 1200rpm washing machines do you supply for under £300 and in black" i would love to able to find all that info by drilling down a few selections,

Thanks in advance for any help or advice.

Adrian

 

[Alansidman]

This is very possible in Access. With your table in a normalized manner, you can run queries with the parameters you have outlined and get results very quickly. Here is a link on setting up a database.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

Once you have a design set, you may want to post back with your questions.

Alan