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