Questions

database management

+
0 Votes
Locked

database management

decwed
I want to be able to create a data base with several tables. Establish a relationship within the tables and develop, queries, forms, reports on these tables so that different group of staff can work on them base on their needs.
some will only update it, some will view it and some will track work other do with it.
+
0 Votes
The Ref

Without a bit more info it is hard to answer, but I'm going to make some assumptions so I appologise if these assumptions are wrong.

Given you are asking this question this way I am guessing you don?t have in house DBA skills, so I will remove the Oracle express or MySQL style products.

The simplest way to build a database without existing DBA skills is with Microsoft Access. It will let you learn how thing work and let you get an understanding of how things work.

You can later upsize it to use SQLServer express or full SQLServer if the project goes well.

While there are probably better options to meet your specific needs, Access is probably the simplest.