Bingo Office Database

[mikajake]

Hi there, I have been given the task of converting a excel spreadsheet to access. It is a spreadsheet that looks after daily bingo finances for both the hall and the organizations that host their charity at the hall.

Here is the outline. Each day, there are three sessions (Matinee, Evening, Late) During each session, one organization plays their 8 games, all different types of games as well as each game had a different financial structure)

I am at a loss as to how I should be designing this. Reports are another thing all together.

Any ideas would be nice.

Mika

 

[Access Hero]

As a first draft ONLY, you could start by identifying all the nouns/events in your description as potential tables.

For instance, with the little bit of information you've given us, I might create the tables named:
Sessions
Organizations (includes Halls)
Games
GameTypes
FinancialStructures

After that, you'll want to identify the relationships between your tables. This should lead to the discovery of other tables, possibly associative/junction tables, etc. For instance, you might discover additional tables like "SessionGames".

A question I frequently ask myself that will help discover other tables is "Yeah, but what about...". This leads to other nouns/events that might be candidates for other tables.

You'll also want to add columns to the candidate tables. This would be the data fields that are about the noun upon which you based your table.

When you've done that, look for similarities between your tables. It is possible you can "crunch" 2 tables into one if they have the same data structure and relationships.

That should give you a pretty good start. Look up data normalization for more information.