how to make ranking from the following tables

[zachariack]

Table 1: PlayerT, fields: PlayerID, PlayerName




table 2: CategoryT, fields: CategoryID, Category


Table 3: TournamentT, fields: TournamentID, Tournament


Table 4: PositionT, fields: PositionID, Position, Point


with this tables how i can make aranking database in access

[CJ_London]

Don't think you can as I don't see any way you connect players with tournaments, positions or categories. You need another 'ranking' table to connect these together something like

RankingT

• RankingID (Primary Key)
• PlayerID (Foreign Key referencing PlayerT)
• CategoryID (Foreign Key referencing CategoryT)
• TournamentID (Foreign Key referencing TournamentT)
• PositionID (Foreign Key referencing PositionT)
• Point (maybe here)

You may also need a tournament date field in the tournament or ranking table (probably the former)

Once you have done that, to help further you would need to tell us what the ranking rules are

[xps35]

I think your start is wrong.
Start by defining the purpose of the database. Based on this you can determine which tables you need. Without knowing the purpose, we don't know if these are the right tables. We don't know what you mean by a "ranking database".