Access/Google Function... Possible?

[vagabond_drifter]

Curious on anyones input. Mostly want to know if this idea is possible, and whether I'm onto the right track, or should try to use "sub-reports" (which seems to be a pain and I run into several problems based on the non-relational material I am trying to squeeze into a relational databse). Or should the JOIN function be used, and switch to SQL in general? Access is clunky, but maybe clunky is okay.

So this is what I have to do, if I am going to re-create a simple Google type search function.

I have 3 tables.

Table 1= Contact List
Column 1=ID
Column 2=Issue
Column 3=Contact
Column 4=Phone
Column 5=Category
This table contains a list of all AE employees, their contact information, what area/issue within the environment they deal with, and what category they are relevant to (Air, Water, Land, Waste, Other).

Table 2= FAQs
Column 1=ID
Column 2= Topic
Column 3= FAQ Question
Column 4= FAQ Answer
This contains the AE Information Centre FAQs sorted by topic.

Table 3= Inquiries
Column 1=ID
Column 2=Date
Column 3= Question/Request
Column 4= Subject
Column 5= Type
Column 6= Action Taken (Referred/Answered) Column 7= Comments This contains a list of all the inquiries I received while working at the front desk. Type is whether it was a call/e-mail/walk-in. Subject is Air, Water, Land, Waste, Other.

I have created wildcard searchable queries which generate reports:
Report 1= AEIssueContactQuery
Report 2= InfoCentreFAQsQuery
Report 3= Search AE Contacts
I also created a form which can be filled to add to inquiries (so all calls can be added to the system).

My AEGoogle goal is to make it such that...
The query is, "Search AEGoogle"
In which the query will generate a report, which contains 3 sections: Contact Name, Relevant FAQ, Relevant Inquiry.

So, for example, if someone calls the information centre and asks, "What do I do about asbestos?"
The informatin officer can type, "asbestos"
And a report would be generated saying:

Contact
Tony Ferafd... 780-999-9999

Relevant FAQs
Adfjal;fjlajflajfasd

Relevant Inquiries
afljalfjaldfj

On one report.

I am trying to find a way to link the tables, so I created an extra column which contains "Subject" so that everything within the tables is categorized as either Air, Water, Waste, Land, or Other. However, this method is not working, and I am unsure of whether using SQL would solve any problems, because, essentially, I am trying to create a search engine that scours the 3 unique tables...

Thoughts? Is my AEGoogle idea possible for someone using Access, and what would you recommend being the best way to generate such reports?

 

[vagabond_drifter]

I also apologize if this is a ridiculously simple question... I'm an English major doing Database work!