I dont know too much about access, but Im sure you can input sql commands somewhere, heres the sql i would use

SELECT employee_ID
FROM available_numbers
LIMIT 0, 1

the LIMIT 0, 1 just picks...

Ok here is how i would design the database for this, it is in the format
TABLENAME(primary_key**, foreign_key *, other field, other field)//notes
(each table has start_date and end_date at the end...

I would reccomend using www.w3schools.com (http://www.w3schools.com) for any web-based learning. There are a variety of ways you post the cookies to the users machine, but i reccomend php as being...

I am not too clear on what you are asking for, so I shall give you a solution to what i think it is, if i am wrong, post back with further queries.

First of all what tables you need depend...

Ok I can see two ways to go with this, both with only 3 tables;
the first would be to simplify what you have:
PRODUCT(product_ID*, name, desc)
VARIATION(var_ID*, colour, weight, strength, price)...