Looking for starting guidance...and then I can take it from there

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all,

I'm trying to do a project, but I don't know if it is too ambitious for
Access or not. So instead of spending another 15 straight hours alternating
between working and reading the help files, I figured I'd turn to the experts.

If you all could tell me if this is possible given Access' capabilities, I'd
appreciate it.

Project: Create a fantasy baseball draft program.
Data contents:
* 6 main data tables - 2003, 2004, and 2005 (projected) statistics for
hitters and pitchers
Ideal work flow:
Main form lists all players with stats listed. Buttons up top (or perhaps
subforms?) select between 2003, 2004, and 2005 stats. If player is "taken,"
entire row is shaded. Player is marked as taken by using dropdown box for
player's "team," and row is automatically shaded. At the same time, another
form with team stats calculates total scores for each team.

Whatcha think? Simple enough, right? :)
Thanks!
Dave
 
Hi Dave

Perfectly possible for Access to do this. Some advice:-
1. Use paper and pencil lots to decide what you'd like - and keep it simple
to start
2. Design the tables to store the data. You probably only need I main table
if you include a field for year and a yes/no field for taken. As a matter of
design you may also want a table to store people who can/have taken players?
Read about SQL queries to see how to join tables for Reporting. Also Tools->
Relationships.
3. Design your forms - These are based on the tables and with decent
validation / drop down lists etc should prevent rubbish getting into the
tables.
4. Reports are probably the best thing about Access. Look into sorting and
grouping here for easy ways to get sub-totals.

For a quick start just make some tables. Enter test data. Then use queries
to see get a feel for what databases are all about

Good Luck!
 
Back
Top