mikekelly

is it possible to buy software which will do the follwoing;

i am looking to store information in a database than i can burn to cd, i work in a builders merchants ans there a thousands of different products and suppliers. i am looking to build up a database which incorperates a search enigine. so say some was looking for a supplier for cement, they could enter that as a keyword and the sofware could search the database for potential matches. it may even be possible to do something like this with the MS works suite, but i cant see how.

i know your probably thinking that i should just use google, but we don't have the internet at work (just a crappy intranet) and we wont be getting it anytime soon.

is is this possible ?

Lorand

You could easily build something in MS Access that can do all this. But it's an enormous work to fill up the database...

mikekelly

thanks for that i will look into it

i know but i plan on doing it over a few months just in my own time.

thanks again

mikekelly

another question is, if i build this thing at home will i be able to open the files on the computers at work if they dont have MS access on board ?

aqsg72

No it only outputs to MS Access specific files I think.

Rambo

You would have to install MS Access on both your home and work computer(s) for it to work I think.

SFR

Quote:

Originally Posted by mikekelly is it possible to buy software which will do the follwoing;

Companies pay thousands of dollars for a database like that. The best way to be able to use that database at home and at work would be through the internet and SQL+. SQL is based on queries where you will be able to search for anything within that database (which is build on a bunch of tables which connect to eachother through related fields. A great report database is ORACLE.. but these things are not cheap. SQL is a lot like Access.. or should I say Access is a lot like SQL.



Doing some research into databases will clarify things.



MS Access is limited in what it can do and for small or medium size database, can get the job done. But for a database like the one I think you want... MS Access will take a long time to create and also to maintain.

__________________