Excel or Access

Knight of Nee

Knight of Nee

Board Regular
Joined
Aug 4, 2003
Messages
124
hi

i need to make either a spreadsheet or database to record the results of a league. all the players registered with the league need to be inputted along with the teams registered. also i need to be able to put the results of each match in and calculate the league table along with player rankings.

which do people think is better to use access or excel? excel is easeir to calculate stats but access is easier for data entry

all suggestions welcome

KON
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
If there's not a lot of players/data to be entered then use Excel. If you have thousands and thousands of players, use Access. Excel is great for data manipulation, but terrible for data storage. (well, maybe "innefficient" is a better adjective)

If data entry is really the only thing stopping you from using Excel, I would suggest one of three things.

1. Experiment with the built-in data form tool goto "Data|Form". (see help for more details)

2. Use j-walk's (free) Enhanced dataform v2:

http://j-walk.com/ss/dataform/index.htm

3. Make your own data entry forms using VBA.
 
Upvote 0
there are about 15 players per team and 8 teams in each division and 6 divisions so there is a fair bit of data to be entered
 
Upvote 0
Use Excel. That's 720 records, but you need to calculate league tables as well. You're going to end up using Excel anyway. This way, you don't have to mess about with setting up a database and setting up a spreadsheet.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Automated golf league scorecard entry into Excel
Replies
1
Views
550
awoohaw
awoohaw
S
  • Solved
Team Position (1, 2, 3 etc) based on multiple criteria
2
Replies
14
Views
618
Fluff
Fluff
S
  • Question
Auto Sorting League Table
Replies
2
Views
484
arun_eagertolearn
A
I
  • Question
Excel Spreadsheet - PGA Fedex Cup tracking
Replies
1
Views
328
Snakehips
Snakehips
E
  • Question
Recommendations for Sunday League Tracker Excel
Replies
1
Views
631
Excel09876
E

Forum statistics

Threads
1,221,550
Messages
6,160,459
Members
451,648
Latest member
SuziMacca

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top