Building a knowledge base

[freddy]

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.

 

[Roger Carlson]

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.