Access Help...again! (Having trouble)

[Styles]

MS Access Help...again! (Having trouble with database)

Hi,
I've been reading through a few online tutorials about database design but I can't seem to find anything about relashionships within the database.

Basically I'm trying to make a database for my mum's workplace. They want to make a database with the ability to track and analyse jobs and stock issues.

I've been given a list of staff members and the departments they work in.

I've also been given a list of charges for copying and printing papers and photocopying etc, and a list of charges for stock (A4 paper, A3 paper etc).

So from this i've worked out so far that i need tables for the following:

Staff - Primary Key = Staff ID - Foreign Key = Department ID
Department - Primary Key = Department ID
Transaction - Primary Key = Transaction ID - Foreign Key = Staff ID
Stock
Paper (Charges)

I think what i've got above is correct? Now in the tutorials it says I have to link the tables to create a 'relashional' database. How would I do this? I'm really stuck and have no clue where to go from here? I hope i've explained it enough, it's quite difficult putting it down in words.

Any help would be excellent

Thanks

 

[Styles]

Thanks for the reply. I know how to create the relashionships in access itself, I just don't know what relashionships I need to make?

I know I need to make a one to many relashionship else it won't work but I don't know how to link my tables?

How would the staff table link to the department table to the transaction table? This is where i'm confused? Any help would be excellent. Thanks