Kirsten has attended:
Access Intermediate course
Create advanced form design
I have a table within a form specifying talk titles for speakers on one of our conferences. Each time I query the data, the professor/speaker comes up as many times as his talk title and I would like to use word/excel to merge this data into one report for each Professor, detailing talk titles, times etc. I think I have learned today how to avoid this, but please can I be assured on how?
RE: Create advanced form design
Dear Kirsten
Thank you attending the Access Intermediate course. I hope you enjoyed the course and benefited from it.
As mentioned after the training it would be better to split your tables using the normalization rules that you learnt. Once the tables have been split properly then you can extract any records or any fileds from any table!!
If you need a reminder of the normalization rules please let me know by replying to this post and I should be able to provide you brief explanation!!
If this post has helped in answering your query then please mark it as resolved!!
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
