You can solve this problem as follows:
1. With program create three access groups:
First access group guest is for common access. For example, users can view only name of the person and graduation year.
Second access group user is for registered users that have right to view all data in the database.
Third access group admin is for administrators that will have full access to the 40 years of alumni database - edit and make changes in the records of their graduation year.
2. Create Users table with Id, Name, Password, GraduationYear and AccessLevel fields - in this table you will store data on registered users including admin users.
3. Create Custom View of the table for the admin group:
4. Create Login page:
5. Assign different permissions (according to graduation year) for records in the table:
6. Set up permissions (according to the access level) for the pages:
Applies to: