Access database tables  design

Hi

I am new to Access and I am not aware of its capabailities. I wish to do the following in this

project of mine.


I have a  form  "form1.asp". It asks for ID , Name and Password.The password is one common one.

if password is correct( which is checked on server side) in "form1check.asp" , the ID and name
get updated in the  ID_name db

ID_name table:ID | Name

e.g
1 | Joe
2 | James



now form2 is displayed: form2 asks for start time and end time. when form2 is submited, the following
tables get updated

Daily_time : Date | Dayname| ID | Count | IP address    where count is no of times ID has submiited the form
max(count)=1

23/03/2004  | Tue | 1 | 1| 129.129.129.129
23/03/2004  | Tue | 2 | 1| 129.129.129.130
23/03/2004  | Tue | 3 | 1| 129.129.129.131


Monthly_report : Month | Name | Date | ID  | Start Time | End Time

This stores the info submmited by ID for a month

e.g

March | Joe | 23/03/2004 | 1 | 10:00 | 18:00
March | Joe | 24/03/2004 | 1 | 10:00 | 18:00
March | James | 23/03/2004 | 2 | 10:00 | 18:00
...................


There is another form : form_edit.asp

this is to update info on any of these tables and any updates is logged


Log :  ID | Date | Old start time| new start time |IP address

e.g : 1 |23/03/2004| 10.00 |10:30|129.129.129.129




The reports generated from these tables  areas follows

1)  Daily report: should  call Daily_time  table to get that day's info
2)  Monthly report: on keying ID and month name should gather info of ID for that month;so call Monthly_report
3) Log report: basically just reads the info in table Log


How do i create the access .mdb file wiht these tables for efficient and quick retrieval
( relationships, primary n secondary keys etc) .Also will i need to have split  table option since there are 100 users
and  info can be changed/edited with form_edit.asp page

Sorry my available points are very less and this is very urgent for me


thnx
candy