how to create user login and account access

is there a way to create a form that asks for a user name and password, validates that against a pre-defined or user-updatable database, and then gives the person access to their record in the database.

so you are john, when you enter your password smith, if it checks out...you are able to see your grades for the semester, but not those of anyone else.

thanks