Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.DnvrFox
10-17-04, 07:35 PM
Okay, guys and gals, I am designing an Access 2000 database to compile data from the "Special Thread for 50+ yo bicyclists".
I have had a lot of experience designing databases in the old Q&A Windows 3.1 and DOS (tells you how dated I am).
I have only designed one Access DB, and that was some years ago, using Access 1.0
So, I need one of you DB gurus to take a look at the DB I have designed.
I do not find Access to be very intuitive, and it also uses language that I am not familiar with, and for some reason typing a help query in the stupid little box NEVER gives me an answer I need, and the index is little better.
For example, I designed 3 separate entry pages off of the table I created, then I tried to link the pages so that it would automatically go from page 1 to page 2 to page 3 (This was easy and automatic in Q&A) A help search turned up nothing about linking pages, so I redesigned the whole thing on one page - I have about 35 fields or so - and it looks awfully crowded. I thought Access would link pages automatically and sequentially, as it all derives from the same table. I guess I thought wrong!
Also, I would like to have a main field which if the answer is "no" then you go on to the next field, but if the answer is "yes" you go to a separate group of applicable fields.
I.e, "Do you take supplements" - if the answer is "NO" then I would not want to see any more on the page; if the answer is "Yes" then I would like a list of supplements to chekc "YES" or "NO" - such as Glucosamine, Vitamin C, - you get the idea. Yet I can find no way to set this up. I can find no "IF" "THEN" operators
Anyone out there help me design. I would be pleased to email you what I have for your review. It is pretty basic right now.
Also, I need to design the queries - mean age, modal age, range, Std Dev, etc., and perhaps age of roadies v. age of mtn bikers, etc. Also, compilation of text lists - names of bike brands, etc.
Average annual mileage vs. years in biking v. age. Stuff like that.
HELP!
I have had a lot of experience designing databases in the old Q&A Windows 3.1 and DOS (tells you how dated I am).
I have only designed one Access DB, and that was some years ago, using Access 1.0
So, I need one of you DB gurus to take a look at the DB I have designed.
I do not find Access to be very intuitive, and it also uses language that I am not familiar with, and for some reason typing a help query in the stupid little box NEVER gives me an answer I need, and the index is little better.
For example, I designed 3 separate entry pages off of the table I created, then I tried to link the pages so that it would automatically go from page 1 to page 2 to page 3 (This was easy and automatic in Q&A) A help search turned up nothing about linking pages, so I redesigned the whole thing on one page - I have about 35 fields or so - and it looks awfully crowded. I thought Access would link pages automatically and sequentially, as it all derives from the same table. I guess I thought wrong!
Also, I would like to have a main field which if the answer is "no" then you go on to the next field, but if the answer is "yes" you go to a separate group of applicable fields.
I.e, "Do you take supplements" - if the answer is "NO" then I would not want to see any more on the page; if the answer is "Yes" then I would like a list of supplements to chekc "YES" or "NO" - such as Glucosamine, Vitamin C, - you get the idea. Yet I can find no way to set this up. I can find no "IF" "THEN" operators
Anyone out there help me design. I would be pleased to email you what I have for your review. It is pretty basic right now.
Also, I need to design the queries - mean age, modal age, range, Std Dev, etc., and perhaps age of roadies v. age of mtn bikers, etc. Also, compilation of text lists - names of bike brands, etc.
Average annual mileage vs. years in biking v. age. Stuff like that.
HELP!