Reports

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

Resolved · Medium Priority · Version 2007

4 posts

ReplyMon 22 Jun 2009, 16:38Delegate Susan said...

Susan has attended:
Access Intermediate course
Access Advanced course
Access Introduction course

Reports

Can you create a report from more than one table? Is this done by linking all the required tables?

What comes first..Tables, queries, forms then reports? Or is this dependant on how you wish the information to be stored or extracted?

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
2003	Thu 19 Aug 2010	Southwark	10		£75	£80
Full Schedule: See all 10 Access Advanced course dates. Bookings currently available until 14th December 2010.

870 posts

ReplyTue 23 Jun 2009, 11:19Trainer Rajeev said...

RE: Reports

Dear Susan

Thank you for attending COURSE!! I hope you enjoyed the course and benefited from it.

To create a report that is based on two or more tables please ensure that the relationships between the tables have been established.

In the Report Wizard please choose the first table you wish to choose the fields from. Once you have input all the required fields then on the same step from the Tables/Queries Drop down field choose the second table and choose the field that you wish to display ion your report. You can repeat this until you have got all the fields from all the relevant tables for your report. Then go through all the rest of the steps and you should be able to achieve your desired result.

I am not sure about your second question. If it relating to which object is more important then I would say it is The Tables. You have to have at least one or more table to create any other objects.

Please note that you can create a Form or Report on any existing Table/s or Query/ies.

Queries are created to extract specific records from table/s.
Forms are created to have a more user friendly method of input data in your existing tables or viewing data of your existing Tables or Queries.
Reports are created from existing Tables/s or Query for printing purposes.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 29 Jun 2009: Automatically marked as resolved.

· How To Find Good Access Database Courses In London
· What You Need To Know About New Security Features In Access 2007
· Access VBA Training Adds Power to your Databases
· How Reorganising Your Data Can Take Your Business to the Next Level
· Microsoft Access as a Business's Database Management System

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

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Reports

Reports

RE: Reports

Related articles

Access tip:

How To Find All Overdue Accounts?