98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Create advanced form design
Create advanced form design
Resolved · High Priority · Version 2003
Fri 15 Aug 2008, 16:53Delegate Kirsten said...
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?
Mon 18 Aug 2008, 10:25Trainer Rajeev said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Random samplingData is th key to a good database, therefore checking is essential. |
