Forum home » Delegate support and help forum » Microsoft Access Training and help » Reports
|
|
|
The UK's most regular 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. |
Reports
Resolved · Low Priority · Version 2003
Reply Tue 6 May 2008, 16:54Delegate Eddy said...
Eddy has attended:
Access Intermediate course
Access Advanced course
Reports
Can you create a report from multiple tables or queries?
For upcoming training course dates see: Pricing & availability
RE: Reports
Hi Eddy, Thank you for your post, welcome to the forum, I hope you enjoyed your course today; in answer to your question, because Access is a Relational, or Multiple Table Database, it works better when Tables are reduced to the highest level of Normalisation, (usually level 3) and then connected to each other using the Relationships window or within a query (for a temporary join), once your link has been created, you can create a report manually or using the Report Wizard, and extracting fields from multiple tables and/or queries as you require.
I hope that has answered your question, I look forward to seeing you on the forum in the future. Best regards Pete.
|