Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  

Go Back   > >

Fifty Plus (50+) Share the victories, challenges, successes and special concerns of bicyclists 50 and older. Especially useful for those entering or reentering bicycling.

User Tag List

Thread Tools Search this Thread
Old 10-17-04, 07:35 PM   #1
Thread Starter
DnvrFox's Avatar
Join Date: Aug 2001
Posts: 20,916
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
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.


Last edited by DnvrFox; 10-17-04 at 08:19 PM.
DnvrFox is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT -6. The time now is 12:15 AM.