Question questions about several workers in activities

[Nokia N93]

I have a project with several activities, each activity has specific people who work in the activity and of course an ID for the activity.
Now every person has a unique ID, name, address, birth date, address ,,,, etc

a person can work in several activities ,, now what i want to know is should i put activities in a table , and persons in another table or what !!? how can i connect the two tables? How can assign a new activity for the persons?

let us say that all the activities need 100 workers, but there will be duplicate of the workers, how can i find the actual number of the workers without duplicate?? ( i need to find the numbers of all workers and the number of the actual workers)

Finally i want a restriction that if a person worked in five activities, i want an alarm or warning that this person has worked for four activities and he can't work any more, is that something i can do !??

thanx alot for your time and concern

 

[AccessMSSQL]

For your table question, you will need to create a 3rd table to store your Person and Activity.

You would have something like the attached image. In it's simplest form.

 

[AccessMSSQL]

For the 2nd requirement of a person working for more than 4 activities you would need to be assigning your person and activity in a form or subform and then in the subform write some VBA code to determine how many activities that person is already in. You can play around with the Dlookup Function and an aggregated query to try to achieve this.

 

[Nokia N93]

AccessMSSQL thank you for your help, but i'm a beginner in access
so when i link the tables in the third table, and i inserted a new record it will be saved automatically in the tables ? how can i do that by a form ?

 

[Nokia N93]

attached is a sample Db for my initial work, i can't figure out how to make a form for inserting the data
what i really want is to attach the activity with the persons, plz help me

 

[AccessMSSQL]

Okay. I understand it's difficult if you are starting from scratch. To create a form to enter your activities what you want to do is in the Navigation Pane of Access, select the third table you created. In the Access menus go to the Create Tab and choose the form wizard. This will walk you through how to create the form that is attached to your table.

You should follow these beginner links to help you get started:

http://www.youtube.com/watch?v=KM-iBtH6VMI

http://office.microsoft.com/en-us/access-help/create-forms-for-a-new-database-RZ101773001.aspx