Question on creating login page

[David Blake]

Hi-

I am in the early stages of learning basic coding. I have gone through the stages of creating a MS database as well as update, delete and add forms. Now I want to create a login page for this setup. I believe I have created the basic login page with the username and password form correctly. What I am having trouble figuring out is how to create the coding for the cfm page that the form info is sent to that verifies the user and if they have access.

I created the database table with the username field and password field. From my limited knowledge, I would understand that a query must be done to compare the database info against what was submitted and then process from there- allowing access or giving a denial statement.

Would someone be able to give me the basic coding I would need to set up? I am assuming its not too involved?

Thanks,
Dave