Enter New Table via Navigation + possibilities of MA

[NeuerUser]

Hey guys,

overall I used access at another job, but only as a user and not as the person who created anything new. And very rarely.

Now for my personal interest I started today learning it with youtube. Now I have something I would be interested and I would think a database would also make sense.

I play a game and I always wanted to look how I do or where to optimize.

For simplification lets say you have different phases lets put it as phase 1,2,3,4,...
And at the end of every phase of every game I would want to gather always the same informations but more than one. Information A,B,C,...

In the end I would want to know the average of information A in phase 1,2,3,4 or B in 1,2,3,4, etc... now my problem and asking if this is easy or takes more advanced knowledge

How would the setup look like. I cannot make one tab and just put in the informations because you have lets say 100 game so there would need to be 100 tabs which are connected with each other to read out the data.

So as a key nr i would have the phases and then A,B,C, as categories. Is there a possibility to make that happen from a navigation panel so I don't have to create manually every time (could be a lot) the exact same tabula. always same phases and same categories the difference it is also different games so they have to be looked at it seperate. and make them automatically connect with each others, so if i wanna read out average of C ind phase 3 it shows me, or show me all the game where the number of C in phase 3 was 10% over the average of the whole dataset.



And what if you have in addition also characters which play the game. So character Arnie played 10 games same dataset and Chris played 50 games same datas. now one time i wanna look only at chris one time only at arnie and third time at them combined.

Is this possible or not at all or just with a lot of tricks and programming. If possible I would try to learn it, if not possible at all with access then I will need to look for another thing which is kinda useful for me in order to use it frequently.

thanks already for the answers

[June7]

Pretty much anything is possible with appropriate db structure and enough code. Your question really is too broad and jumping the gun. Get the db structure set then look at how to get data into it. Identify data entities and relationships then build tables.

Of course there wouldn't be 100 tabs for 100 games. Each game would be a record. Apply filter criteria to table/query/form/report to view desired data.

[NeuerUser]

Okay so you say it is a big task but with good understanding, not exceptional, possible?

okay i was watching most of the time german videos about it so i need to look what a record is in access language. and its very interesting for me that i have to look at first and my database structure before I start putting in stuff.

thanks for the answer. knowing it is possible motivates me to go on

[NeuerUser]

I would have a more specific question now.

I thought to make one big tab where I would always put in phase 1 to x and game ID plust the stats i want to know for each state. as a primary key i would use the combination of phase and Game ID.

Now the question is if i wanna make a form: it should already always put phase 1 to x (x=always the same number lets say 10) and ask me which game ID and then put automatically to phase the ID I entered. then i dont need to enter always the same stuff over and over again.

At the work there was a similar stuff. I had to select from a drop down menu a destination and then i always got the same form where I could enter things. If it is very difficult could you tell me what I should look for on google/yt. Because it is hard for me to understand what the solution is in access to that task.

thanks a lot in advance

[mike60smart]

Hi

So Each GAME has a number of PHASES.

If this statement is correct then you need a minimum of 3 tables.

tblGames
-GameID - Autonumber - PK
-Game

tblGamesPhases
-GamePhaseID - Autonumber - PK
-GameID - LongInteger - FK (Linked to the PK from tblGames)
-PhaseID - LongInteger - FK (Linked to the PK from tblPhases)

tblPhases
-PhaseID - Autonumber - PK
-Phase

[NeuerUser]

Exactly each game has the exact same amount of phases.

The stats I want to enter for each phase should then be in tblPhase right?

So lets say

tblGamesPhases
-GamePhaseID - Autonumber - PK
-GameID - LongInteger - FK (Linked to the PK from tblGames)
-PhaseID - LongInteger - FK (Linked to the PK from tblPhases)
-stat1
-stat2
-stat3
.
.
.

and then create Form of tblGames in which i make a form of tblGamesPhases as a subform?

[mike60smart]

Yes spot on

[NeuerUser]

thanks a lot i will try to do this. i did this before but i think i made a mistake with linking and so if i went from game 1 to game 2 it still showed me the entries of game 1 in the subform. that shouldn't happen like that right?

Now i would want to add another thing characters. xD I make another

tblCharacter
-CharacterID - Autonumber - PK
-Character

and change the

tblGamesPhases
-GamePhaseID - Autonumber - PK
-GameID - LongInteger - FK (Linked to the PK from tblGames)
-PhaseID - LongInteger - FK (Linked to the PK from tblPhases)
-CharacterID - LongInteger - FK (Linked to the PK from tblCharacter)
-stat1
-stat2
-stat3
.
.
.

And then if I wanna read out average stats etc I will do that from the tblGames. correct? or do I need to make extra tbl with querries. thats a thing i didnt do yet a lot reports. can i tell the program when i open reports to calculate things in dependacies. lets say all phases 2 stat1 average if character =x