Need simple Login and passwords plus data filtered based on login

We have a database consisting of a table listing sales items, qty, salesman and sales year.  The salesmen have been assigned to monitor selected items.  The items are separated into groups.  We would like the salesmen to sign on using a sign-on form with password.  After a successfully sign-on, the user will see another form where the user will select the "year" of interest and select the type of update to be used.  the final form will present a listing of all items assigned to the user who is signed on and only items that are in the Year selected.

1. Password Table consists of: User name, password, and item group

2. Password Form: same as above with pulldows for user name and OK/Cancel buttons
Item table consists of: Item names, Qty, user name and year

3. Eight query tables are copied from the above table and numbered 1-8.  They are filtered by user groups 1-8.  Example: Query table 3 will only show group three items.

We would like for the "user group" selected from the password form to be used to select the proper query table.  We would also like the
program to automatically limit or filter by date and user group.

Finally, the user will be able to update, view and print from the limited items available from the proper query table.

Also, rather than have eight query tables, how can the filter of user group and year be done "on the fly?"

Please help.