Thank you for you reply, thank you I will look into the normalization. for back round this was done originally on excel and thought access might be easier once the time had been spent building it...I have no experience of access just You Tube and this database. the one attached is just what I use to test, the full has 10 other tables and forms which each will have between 50-100 sets of data.
the reason for same data is just that is how the study was agree that data would have a three point check to ensure data quality.