Database integration Process

[a00109943]

Calling all VBA; Access, and Web designer experts!

Here is the scenario:

-I have roughly 1000 records in Access.
-Each record has 26 fields
-I want to create a sort of filter on my website

Example:

If I have a list of 100 cars, all different types but categorised by; SUV, car, van, truck
Next I have Safety ratings from 1 to 5
Next I have color of vehicle, red, green, brown, gold and silver
and so on and so forth,

If I wanted to create a platform on my website that allowed the person who was browsing to filter by preference, how would you do that?

A perfect example is: http://www.autotrader.ca/

My particular case, they are not vehicles but the concept is the same. The only difference would be the number of fields that my website will have, instead of 5-6 it will have 20 or so. Come to think of it: www.itravel2000.com is another example.

Please keep in mind that I am using Microsoft Access, and most records are yes or no, numbers, city choices...etc.. We tried to make it easy to filter.

Can I accomplish all this by using Wordpress? Or do I have to write code? I am familiar with VBA but I don't think it will help me when were talking about websites.

Any help at all is appreciated, I am willing to pay for some guidance!

Thanks!

Ben

 

[chrishirst]

SELECT columnlist FROM table WHERE colour = 'blue';

Then display the returned rows.

Though as you are using Wordpress, knowing VBA & Access will be of no use at all, as Wordpress only "speaks" PHP.

 

[leroy30]

SELECT columnlist FROM table WHERE colour = 'blue';

To improve a little bit.

SELECT columnlist FROM table WHERE CONTAINS(colour, keyword);