5 User Pages
User Login
New User Registration
User Login Confirmation
Send Password
User Profile
3 Administration Pages
Manage Users
Edit Users
User Statistics
1 Database with:
2 Tables
Users The registered user records, including first and last name, username, password, and access group level
AccessGroups Available access group levels in both numeric (1, 2, 3, and 4) and text (Administrator, Manager, Operator, and User) format
2 Views
UserView A virtual table joining the Users and UserGroups tables
UserRegStats A calculated recordset with fields for total users and registration statistics by day, week, and month
1 Session Variable:
UserID Maintains the user's ID to verify authentication