On 27 Jul 2006 02:01:54 -0700, chanl2001[ at ]hotmail.com wrote:
Most everyone who posts here needs help. SHOUTING with an
undescriptive subject line will *not* get you a faster or better
answer; it's more likely to just annoy the volunteers like me.
[Quoted Text] >Hi everyone, I would like to use access to make a search engine.
Ummm... Access *is* a search engine.
>I have created 3 different topics of database.
>e.g. database1 - Speakers
I hope that you mean that you created three Tables in a database. In
Access jargon, a "database" is the .mdb (or .mde or other) file, a
container for multiple tables, forms, reports, and other objects.
>All 3 database were contained product's information
>
>e.g Factory Tel. no Fax no Contact person
>e-mail Product Product No.
> XXXXXX XXXXX XXXXX XXXXXXXXXXX
>XXXXX XXXXXX XXXXXXXXX
>
>ok, now 3 differnet products of data have done.
If you have three identical tables differing only in the category of
the product, your design IS WRONG. You should instead have one big
table, with a Topic field to allow you to select that subset of the
records.
>then I need help for the next part.
>
>How can I make it like a search engine? For example if someone would
>like to search which factory have XXXXproudct. Or which 2 factory both
>have the same product to sell? How can I make it just show out the
>information that I want but not all? How can I make something that can
>type in enquiry's word or some button to check? Do I need to link the
>relationship?
Take a look at "Filter by Form". Create a Form based on your table (or
on one of your tables), and try using the Filter menu option.
>I know it is lots of problem here, but it is very ugrent. Pls if any
>access experts help me.
>Thanks for helping me!!!!!!!!!
You may want to go back to basics and learn a bit about how Access
works. Try using the Northwind sample database; or check the
references at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html
particularly the Database Design 101 links.
John W. Vinson[MVP]
|