Building a knowledge base

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

freddy - 22 Aug 2004 18:41 GMT

This is an access question not a c# question. I am using c# to build a
knowledge base using an access database for my company. We have multi-apps
that we use, how do I build my database. Should I build a table for each one
like:
1 Table for:
Outlook
word
portia
internet explorer
excel
adobe
and so on......
or should I build one table with different fields.
I do not know to much about building complex databases using access.

Reply to this Message

Roger Carlson - 23 Aug 2004 15:53 GMT

You definately do NOT want separate table for each app. But depending on
your business rules, you may need to split your data in to many related
tables.

You might want to look on my website (see sig below) at the Tutorials >
Database Design section for some background in what to do. You should also
look at the following site:
http://www.databaseanswers.org/data_models/index.htm for some pre-designed
databases that might come close to what you want.

Signature

--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

> This is an access question not a c# question. I am using c# to build a
> knowledge base using an access database for my company. We have multi-apps
[quoted text clipped - 10 lines]
> or should I build one table with different fields.
> I do not know to much about building complex databases using access.

Reply to this Message