|  | excel to database for improvement Advise | | |
| | | Big-dog1965 |  |
|  Posted: Wed Aug 27, 2008 1:28 am Post subject: excel to database for improvement Advise |  |
| |  | |
Let me say I am not real savvy on this stuff but manage to get stuff done
with you alls help so I hope this makes since.
I have a excel book that contains several pages these pages do some adding
and multiplying of numbers (you can see it at
excel sheet )
My excel sheet is for keeping track of points for RC car racing. Heats are
short races to qualify driver’s position for the main or feature race. Top
qualifier is a driver that makes the most laps in the shortest amount of time
in the heats.
I would like to take this to the next level and make it easier I don’t
really know if access is the thing to use or not (suggestions welcome) I do
post this to the net so I’m guessing reports would accomplish that. I need
to enter names, place finished in heats races, mains and top qualifier. The
end result is it would add numbers together to total a final number which is
used to award the winners.
I will try an clarify this more if needed |
| |
| | | Fred | |
| | Posted: Wed Aug 27, 2008 4:15 pm Post subject: RE: excel to database for improvement Advise | |
| | | |
It sounds like you are new to Access.
It sounds like it's working for you in Excel. Unless you are using this
also an an opportunity / catalyst to Learn Access, you're probably better off
in Excel.
If the answer to the above question is "yes". then I'd say go for it.
Fred
| Quote: | Let me say I am not real savvy on this stuff but manage to get stuff done
with you alls help so I hope this makes since.
I have a excel book that contains several pages these pages do some adding
and multiplying of numbers (you can see it at
excel sheet )
My excel sheet is for keeping track of points for RC car racing. Heats are
short races to qualify driver’s position for the main or feature race. Top
qualifier is a driver that makes the most laps in the shortest amount of time
in the heats.
I would like to take this to the next level and make it easier I don’t
really know if access is the thing to use or not (suggestions welcome) I do
post this to the net so I’m guessing reports would accomplish that. I need
to enter names, place finished in heats races, mains and top qualifier. The
end result is it would add numbers together to total a final number which is
used to award the winners.
I will try an clarify this more if needed
|
|
| |
| | | Big-dog1965 | |
| | Posted: Wed Aug 27, 2008 5:46 pm Post subject: RE: excel to database for improvement Advise | |
| | | |
I want to store names and things in a database, give the overall little
project a better interface and also be a stand alone so you dont need excell
to use it
yes new to access and barely new to excel
"Fred" wrote:
| Quote: | It sounds like you are new to Access.
It sounds like it's working for you in Excel. Unless you are using this
also an an opportunity / catalyst to Learn Access, you're probably better off
in Excel.
If the answer to the above question is "yes". then I'd say go for it.
Fred
Let me say I am not real savvy on this stuff but manage to get stuff done
with you alls help so I hope this makes since.
I have a excel book that contains several pages these pages do some adding
and multiplying of numbers (you can see it at
excel sheet )
My excel sheet is for keeping track of points for RC car racing. Heats are
short races to qualify driver’s position for the main or feature race. Top
qualifier is a driver that makes the most laps in the shortest amount of time
in the heats.
I would like to take this to the next level and make it easier I don’t
really know if access is the thing to use or not (suggestions welcome) I do
post this to the net so I’m guessing reports would accomplish that. I need
to enter names, place finished in heats races, mains and top qualifier. The
end result is it would add numbers together to total a final number which is
used to award the winners.
I will try an clarify this more if needed
|
|
| |
| | | Fred | |
| | Posted: Thu Aug 28, 2008 10:42 am Post subject: RE: excel to database for improvement Advise | |
| | | |
To recap my previous advice:
Access is probably not the ideal choice for your application. But if you
have a goal of learning Access (you didn't say whether or not this is the
case) , doing this on Access would be a good catalyst for learning Access.
"Big-dog1965" wrote:
| Quote: | I want to store names and things in a database, give the overall little
project a better interface and also be a stand alone so you dont need excell
to use it
yes new to access and barely new to excel
"Fred" wrote:
It sounds like you are new to Access.
It sounds like it's working for you in Excel. Unless you are using this
also an an opportunity / catalyst to Learn Access, you're probably better off
in Excel.
If the answer to the above question is "yes". then I'd say go for it.
Fred
Let me say I am not real savvy on this stuff but manage to get stuff done
with you alls help so I hope this makes since.
I have a excel book that contains several pages these pages do some adding
and multiplying of numbers (you can see it at
excel sheet )
My excel sheet is for keeping track of points for RC car racing. Heats are
short races to qualify driver’s position for the main or feature race. Top
qualifier is a driver that makes the most laps in the shortest amount of time
in the heats.
I would like to take this to the next level and make it easier I don’t
really know if access is the thing to use or not (suggestions welcome) I do
post this to the net so I’m guessing reports would accomplish that. I need
to enter names, place finished in heats races, mains and top qualifier. The
end result is it would add numbers together to total a final number which is
used to award the winners.
I will try an clarify this more if needed
|
|
| |
| | | Big-dog1965 | |
| | Posted: Fri Aug 29, 2008 9:27 pm Post subject: RE: excel to database for improvement Advise | |
| | | |
What might be a better app to use
Ive done a little with acces but not enough to really get started or where
to begin
"Fred" wrote:
| Quote: | To recap my previous advice:
Access is probably not the ideal choice for your application. But if you
have a goal of learning Access (you didn't say whether or not this is the
case) , doing this on Access would be a good catalyst for learning Access.
"Big-dog1965" wrote:
I want to store names and things in a database, give the overall little
project a better interface and also be a stand alone so you dont need excell
to use it
yes new to access and barely new to excel
"Fred" wrote:
It sounds like you are new to Access.
It sounds like it's working for you in Excel. Unless you are using this
also an an opportunity / catalyst to Learn Access, you're probably better off
in Excel.
If the answer to the above question is "yes". then I'd say go for it.
Fred
Let me say I am not real savvy on this stuff but manage to get stuff done
with you alls help so I hope this makes since.
I have a excel book that contains several pages these pages do some adding
and multiplying of numbers (you can see it at
excel sheet )
My excel sheet is for keeping track of points for RC car racing. Heats are
short races to qualify driver’s position for the main or feature race. Top
qualifier is a driver that makes the most laps in the shortest amount of time
in the heats.
I would like to take this to the next level and make it easier I don’t
really know if access is the thing to use or not (suggestions welcome) I do
post this to the net so I’m guessing reports would accomplish that. I need
to enter names, place finished in heats races, mains and top qualifier. The
end result is it would add numbers together to total a final number which is
used to award the winners.
I will try an clarify this more if needed
|
|
| |
|
|
