Hoping for guidance on creating database (Access) - Start up

Hoping someone can help with this project - see attached spreadsheet.

To explain the spreadsheet, its all tennis matches on the ATP Tour 2017.

It shows the two players and under column header 'bpb' it shows the point by point data of the match.

Example

SSRSRRSRRR;RSSSRS;RRRR;SRRSSS;SSRRSRSS;SRRRR;SRSRSS;SSRSS;RRRSSSSRRSRSSRRSRR.RSSRRSSRSRSS;

The 'S' represents a point won by the server, 'R' represents a point won by the receiver, ';' represents the end of a game and '.' represents the end of the set. The server in the first game will be Player 1 and the server in the second game will be Player 2. This will change throughout the match after each game.

So basically what I'm looking to do is create a database including all the matches which would have the ability to query results given a certain scorelines. For example if a certain player is 15-30 down on serve (which would be represented by a combination of 1 'S' and 2 'R's in the first three points of that game), how often did they go on to win that game. Another example would be if a player is 4-2 down in games how often do they come back to win that set.

Could anyone provide any suggestions as to where to start with this? How many levels would it need to be broken down into to be able to carry out queries like the above - points,sets,games?

Obviously I don't expect a step by step guide as I'm guessing this is a long winded process but anyone's input would be greatly appreciated.

i would say:
you will loop thru table, 1 record at a time, grab the pbp value, then process it to another table with pbp results
a custome routine would process 1 character at a time posting net results as you go:

game#,playerID, P1net, P2net,result
1,player1 , +1,-1
1,player1 , +2,-2
1,player2 , +1,-1
...
1,player1, -2,+2, L

then you can do some analysis on the serves.
same with Games.
it would also post results to a game analysis table.

But you have to know the question in order to get the result....ie ('if a player is 4-2 down in games how often do they

come back to win that set.')
every question may need a custom routine.

When you say custom routine are you referring to code? I'm fairly new to using vba so I can do basic stuff like looping tables etc. but currently looking to further my knowledge. Just unsure as to how you would assign net values to each letter and how it would process the game number recognising the semi colon as the end of game.