Database in MsAccess(ver 2000 !)
1. Table Students with Name, adress, telephone,number1, number2, number3 - maybe some new in future.
2. Table Give related to Students with fields id, date,action,comment,userid - can by many "gives" for one student - user should be able to add, choose action from pre-defined list and comment it.
3. DB User can login with their own login/password. - users are difrent than students, they have nothing common.
4. 3 security levels:
- admin - full access,add/remove dbusers
- manager - add/edit/delete records
-user - add/edit records
5. System must force user to change his password every 30 days. Users passwords must have at least 8 chars, small and capital letters and digit or special char.
6. Database must record who and when entred/altred data in database - some kind of changelog keeping old and new value of given field in every table.
7. Posibility to manage users from database.
8. Ability to work on database simultaneus by few users - database on win2000 serwer accessed by local network from local pc.
Please provide plan for doing project, how you gone solve user permissions(own system or build in access permisions ).
mdb files (without any protection so i'll be able to change some things in db)
Shorcuts to place on local PC.
Db documentation (or large comments in source)
If you have any questions, please ask me.