Not sure what to do

[smart512]

Let me first preface my post by stating that I have little to no knowledge of Access and how to use. Basically, I have a large group of friends who participate in friendly sports picks and I'm trying to create an easy to manage way of updating picks and also be able to view stats. I originally created a spreadsheet in excel that had multiple workbooks that contained the data I was trying to analyze. Within the spreadsheet, I had a "Main" page that I used to show the data I was analyzing based on formulas on this "Main" page as well as pulling data that was already calculated on the source pages, that also had formulas. The problem that I was running into was that as my data grew, the spreadsheets themselves caused my computer to essentially freeze up. Everything that I searched said the creating a database was the way to go. I feel like an EnglishSample Data.zipSample Data.zip only speaker in a foreign country when it comes to access. I've attached a small sample of what my existing spreadsheet looks like with all of the data and formulas included. I will also admit, that my spreadsheet is probably not the most efficient when it comes to using formulas or even the correct data for that matter (i.e. my addition of an "Outcome Value" column). I would most likely be adding additional queries down the road, but for now I am looking for assistance on what I need to do to set up a database based on the information I have, how and where to create queries based on the formulas setup in the spreadsheet example and finally how would I go about performing a mass update of these records. (i.e. the example data shows through mid-April, but I have the most recent data available and would like to update once I have it down.)

Thank you in advance for any help you all can provide. Cheers!

[smart512]

A clear sign of not knowing what I'm doing.....I added my sample file mid-sentence in the thread.

[ssanfu]

Welcome to the forum.....

Doesn't look too bad.
Consider table structures:

tblMembers
===============
MemberID_PK Autonumber
FName Text
LName Text
DateJoined Integer


tblLeagues
===============
LeagueID_PK Autonumber
LeagueName Text


tblPickData
===============
PickDataID_PK Autonumber
MemberID_FK Number-Long
LeagueID_FK Number-Long
Team1Name_FK Number-Long (split from PickGame)
Team2Name_F Number-Long (split from PickGame)
PickDate Date
Team1Score Number-Integer (split from PickScore)
Team2Score Number-Integer (split from PickScore)
PickLine Text
Outcome Text


tblTeams
===============
TeamID_PK Autonumber
LeagueID_PK Number-Long
TeamName Text



The tricky part will be to split PickGame into two fields as well as split PickScore into two fields.

Field "PickLine" (might want to split this field) - Not sure what "Under 5.5" means. And "TEX -130" is Texas, but what is -130??