Need a simple LOGIN mechanism

[djcmalvern]

Is it possible, using only built in functions and the expression builder, to control from a login form a check of the validity of the username and password then pass focus to another form that has only user level access controls, but will alternatively open an administrator form if their specific username is input. I know this can be done with some VBA but the constraint here is that the kid being asked to produce this form has been told that no 'extensive coding will be needed'. So I am struggling to help him work this through.

[June7]

This is homework assignment?

I don't see how can be done without code. It might be possible with macros and parameterized queries. I don't use macros, only VBA.