validating data from two tables in access

hello  @israel your question is not clear I means i can't understand what do you want .
But as i got your qyestion  you can use the  "join"  for creation the single table from two table
then you can use this single table .   it will be easy for you..........

first of all why are you used two table for validate user is correct or not. In single table is enough for validate the user. I create a single table for you and validate records.

Create table TableName(id int,UserName varchar(50),Password varchar(max))
insert into TableName values(1,'testingOne,'India')

you have two option for communicate with database. First direct used in .cs page and another one is make a store procedure.

I have create one Store procedure

create proc Proceudre_name
(
@userName varchar(max),
@password varchar(max)
)
as
begin
select count(id) from tableName where UserName=@username and Password=@password

end

I hope this code is help full for you.