Reports

The UK's most regular instructor-led training courses.
Training information: microsoft access training · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

Reports

Eddy has attended:
Access Intermediate course
Access Advanced course

by - delegate Eddy [2 posts] (2008 May 6 Tue, 16:54) Reply

Can you create a report from multiple tables or queries?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	6	book now	£214	£230
2003	2008 Nov 5 Wed	Southwark	6	book now	£214	£230
2003	2008 Nov 21 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Nov 26 Wed	Bloomsbury	5	book now	£219	£235
2007	2008 Nov 28 Fri	Bloomsbury	5	book now	£235	£240
Full Schedule: See all 51 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Reports

by - trainer Pete platinum contributer [799 posts] (2008 May 6 Tue, 16:59) Edited on 2008 May 6 Tue, 17:00 Reply

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.

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Why a Microsoft Access Course Could Change the Way You Do Business
· Access Database Optimization: First Normal Form
· The Benefits of Certified Microsoft Training in Access
· Get More Out of MS Access Courses

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips