Ingredients

8 APPLICATION PAGES:

• 5 User Pages

  • User Login

  • New User Registration

  • User Login Confirmation

  • Send Password

  • User Profile

• 3 Administration Pages

  • Manage Users

  • Edit Users

  • User Statistics

2 DATA SOURCES:

• 1 Database with:

  • 2 Tables

    Users The registered user records, including first and last name, user name, 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 AccessGroups 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.