Hello,
I have been using Excel for quite some time now and have developed a system for a football "pick 'em" type pool. It is a good system and works for me as the Admin for keeping up with the point calculations and scoring, but I am interested in possibly using Access to give my product a little more flair and usability for the members of my pool.
I obviously know very little about Access, hence the reason for my post. I do not expect anyone to try and tell me how to do what I want to do, but simply to answer if it can or cannot be done. This answer will save me a lot of time if what I would like to accomplish simply cannot be done. Anyways, here is the premise of how the pool is structured in Excel, and what I would like it to become with Access:
The pool is comprised of different competitors that pick margins of victory for a selected amount of games each week of the season. Each week has a scoring system that calculates an amount of points for each competitors picks depending on the actual outcome of each game. Each week the points are totaled and recorded. The combined weeks at the end of the season determine the winner. In Excel I have a spreadsheet that allows me to enter a players pick within a grid where that persons name on the X axis meets the team he has picked in the Y axis. Then by entering the actual scores in a separate column, the calculations are executed within hidden cells and returned nice and neat into a different area at the bottom of the sheet. I hope I am making sense...
If you understood that, here is what I am trying to do in Access: I would like to create a database that can be accessed by multiple users so that each competitor can open their version of the database and enter their picks via a form that updates a hidden table that they cannot see. This would make it easier for me to save time entering picks, as well as police turning picks in late. I would also like to be able to give each competitor the option to view a leader-board of some sort on Saturdays while the games are being played, as well as an overall standings board for each weeks scores to a particular point. Basically make my excel spreadsheet become more of a user based program of sorts to give competitors a more involved experience, rather than just sending and receiving emails with the information.
Is this a possible ability of Access, or am I wasting my time trying to create such a contraption?
Bookmarks