One to Many Form in Access -

i have form manager fills out each employee once week audit. form in excel. data tracked on time review trends. asking 1 many relationship. each answer on form should create new record in table rather 1 record per audit form. there 34 audit questions can result in either yes, no or n/a. of experience in sql , oracle databases not familiar access. looking form in access can input audit response , can create trends , forth in tableau. example rep: ms. smith date of audit: 09/10/2016 each of 34 questions year or no response. cannot seem manage form working without having enter reps name 34 times. recommendations access newbie?

correct me if misunderstood question, here do.

you can create 2 tables, 1 called representative, other audit.

in table representative, create field rep_name , let access create autonumber primary key.

in table audit, create field date/time date of audit, create number field rep_id, 34 yes/no fields audit questions , let access create autonumber primary key.

then in database relationships, link representative>id audit>rep_id.

you can create 2 forms, 1 user select/enters name, , second form date entered/pre-filled , questions asked. can link both forms using button.