access help

[AHarvey]

Hi all,

Currently reading through the Dummies guide to access 2007 as I need to create an access database for work.

Basically we want to track players. We flag them for monitoring if they cause trouble, we can also mute and ban the from 1 hour+. We also want to track underage players and name changes.

I want each of our hosts to be able to open the DB, search for a players name and add to their mutes/bans and view their history. I also want them to be able to create new entries for players if they are not already in there!

I am trying to plan what tables I will need as everything I have read has said that the planning is the most important thing you can do.

I will BOLD the table names and then show info they will need to have. If you could have a browse and let me know if I am going down the right track I would be very grateful

Monitor
Member Name
Comments

Mutes
Member Name
Room
Date
Time
Length of Mute
Host Name
Reason for mute

Bans
Member Name
Room
Date
Time
Length of Ban
Host Name
Reason for Ban

Underage
Member Name
Room
Date
Time
Host Name

Name changes
Member Name
Room
Date
Time
Host Name

Ban lengths

Mute Lengths

Rooms

Hosts


Would you say this would be ok?

Totally new to access

Would I need a table just for player names? BTW, all player names are unique.

 

[londonbairn]

I would probably have a table called "tblPlayers" which has ID, name, age etc and then use a PlayerID as the join and not the player name