Microsoft Access Database for a Small Graduate School

[jodhas]

I am trying to implement a database for a small graduate school of about 200 students.
Everything from student info to grades for each semester should be handled by this database.
I want to use Access to accomplish this. Can someone point me to an online community (forums) where I can get some help? (or templates )

 

[MagnusTheBrewer]

I am trying to implement a database for a small graduate school of about 200 students.
Everything from student info to grades for each semester should be handled by this database.
I want to use Access to accomplish this. Can someone point me to an online community (forums) where I can get some help? (or templates )

This is a bad idea. I can't see allowing everyone with access to the data base to see ALL of a students records and Access doesn't have the tools to limit access. I recommend taking a look at Oracle or SQL.

 

[EagleKeeper]

This is a bad idea. I can't see allowing everyone with access to the data base to see ALL of a students records and Access doesn't have the tools to limit access. I recommend taking a look at Oracle or SQL.

If you are going to use Access to develp the database; make a front end to allow restriction to different pieces of the data.

Or then port the Access database after you have everything figured out to another SQL package that will allow more protection of info.

 

[Apathetic]

I highly recommend against using MS Access for anything as important as student grades. Access is NOT safe choice when multiple users are connected to the same database and are making changes. It's only a matter of time before your database gets corrupted.

Check out Postgres, MySQL, or MS SQL Server Express (which is also free).

http://www.microsoft.com/express/Downloads/

Dave