Results 1 to 4 of 4
  1. #1
    Russ McCoy is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2019
    Posts
    5

    Modeling for database of bicycle race times on various segments by club members. I'm new.

    Hello kind folks. I am very new to Access and am putting together a very simple database for tracking bicycle segment race attempts and history of Personal Records (PRs) associated with those segments. I think I lack some fundamental understanding of how to properly structure relationships and/or architecture of this simple database. Although, I've watched many YT videos and online tutorials, progress has stalled, so I ask here for a little push in the right direction.
    Here are some of the particulars:
    - tblAttemptLog contains all member attempts on any segment recorded as a duration with the associated attempt date.
    - tblMembers contains member data. There are many members.
    - tblSegments contains segment data. There are many existing segments in the area.
    - tblPRs contains the date and duration that a member has a previously recorded PR duration on a segment. Not all member/segment combinations have a history of a PR. This table is populated with historical PR data when the member joins the club and remains static.

    Basically just need to query for a display of all the Segments, the members and their AttemptDurations plus any associated PRDuration (if it happens to exist for that member on that segment).
    I've attached a screenshot of my current design. Thank you for your consideration and *gentle* feedback.

    Click image for larger version. 

Name:	Capture.JPG 
Views:	17 
Size:	43.2 KB 
ID:	37894




  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    russbike-davegri-v01.zip
    See if this will get you started.
    Membership form with tab control for 2 subforms, Attempts and PRs. Includes combobox for member lookup.
    Form for entering Segments.

  3. #3
    Russ McCoy is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Mar 2019
    Posts
    5
    Thank you davegri. I'll take a look!

  4. #4
    Russ McCoy is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2019
    Posts
    5
    Looks great @davegri. Super helpful. thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-09-2018, 07:11 PM
  2. Database modeling
    By TS21 in forum Database Design
    Replies: 8
    Last Post: 09-14-2016, 11:09 AM
  3. Replies: 24
    Last Post: 02-04-2014, 07:26 PM
  4. with regard to Database Modeling
    By johnseito in forum Access
    Replies: 4
    Last Post: 11-18-2013, 01:23 PM
  5. automatically update club members age group
    By sirnickettynox in forum Programming
    Replies: 4
    Last Post: 04-06-2011, 06:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums