Hello! I am a new user in a new job and took on a big project too quickly. Essentially, I need to build a db for about 20 years of clinical data. For these purposes, we have participant’s demographic info and I need to connect all their extensive visit information to their demog info, and participants have differing amounts of visits. These are all in two different Excel files and I can pull them into Access w/o issue, but I don’t really know what to do with all the information once they’re resting in tables. Is a form the best way? (With one ‘page’ per participant that reveals all their extensive visit information concisely.) Any guidance would be very much appreciated! Thank so much!!
Help on starting the best db ever!?
