MS Access FAQ database

[Rob W]

Greetings,

I was wondering does anyone know a link to a FAQ system that is either
written in MS Access or uses Access database for the data storage?

I'm at the ideas/brainstorming stage for a new project to create a dynamic
FAQ system.

So people could add/update their own questions and answers, capturing the
author and date stamping transaction. Perhaps providing other useful
information such as how many times the questions was viewed etc.., or a
rating scheme to suggest the usefulness of the question??

Any links, ideas or opnions are welcomed.


Thanks
Rob

 

[Arvin Meyer [MVP]]

There are several large corporations that use an Access based system like
that. I have a code database that I use which does something similar.
Basically, you need 4 fields:

A primary key, a category field, a description field and a memo field to
store the answer. You should be able to sort by category and search by
description, with occasional searches through the memo field if your
description is overly simple.

 

[Jerry Whittle]

Have you considered using a Wiki tool?

 

[Rob W]

I have been persuaded to implement a solution using an MS Access database.

So far I thought of the following fields based on the input from this
thread, I havent thought of tables (i.e FAQ, categories, Users) yet or
relationships.
Brainstorming at the moment, it only has to be simple.

Fields :- Categories, SubCategories, Answer, Question, View, UserId,
Created, Updated, Rated

Would like to see whats been done before and use this for inspiration.

Thanks Rob

 

[Rob W]

Anyone have any example FAQ MS accesss databases?

 

[Tony Toews [MVP]]

I'm at the ideas/brainstorming stage for a new project to create a dynamic
FAQ system.

So people could add/update their own questions and answers, capturing the
author and date stamping transaction. Perhaps providing other useful
information such as how many times the questions was viewed etc.., or a
rating scheme to suggest the usefulness of the question??

The bare bones of what you are looking for is the Newsgroup Answers
MDB - I designed the MDB to assist frequent newsgroup answerers, such
as MVPs, in quickly locating and pasting in their favourite snippets
of answers.
http://www.granite.ab.ca/access/newsgroupanswersmdb.htm.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/