Access Report Writing Course Outline. Summary of Microsoft Access training course content.

Learn Access VBA With The Smart Method.  Microsoft Access tutorials, Discussion Forums, Training Courses and Support
Home Home  Site Map Site Map  Free Tutorials Free Tutorials Application
application development Buy The Book Buy My Book Classroom
Classroom delivered courses Contact Contact Details
Course Outline for Access Report Writing Training. Training course by Microsoft Master Instructor
All training is not the same
  High quality 100-200 page course manual
  Buffet lunch
  Laminated quick-reference card
  Instruction by Mike Smart (A Certified Microsoft Master Instructor)
  Held at excellent air-conditioned training venues throughout the UK and the world
Access Training Course by Microsoft Master Instructor
About our courses
Terms & Conditions
Course FAQ
Course Level Duration Prerequisites Covers
Microsoft Access Logo Report Writing
None Reporting
and querying
Why have a separate course for report writing?

Access is so many tools in one box that it is impossible to take a "one size fits all" approach when training in this product.  Our Access courses are always tailored to our clients precise needs while conforming to a more generalised outline.  This course has been developed for clients whose primary focus is upon creating professional reports using Access.

The course combines elements of our Competent User and Expert courses to teach you report writing without the distraction of learning Access skills that are relevant to application design rather than reporting.  By missing out these elements it is possible to learn advanced query and report design in one day rather than the two days it would take for the complete course.

The first part of this course covers Access fundamentals and then shows you how to take the Access query designer to the max.  You'll learn about stacked queries, outer, inner and equi-joins and learn to produce summary, parameter-driven and action queries.  You'll even learn how to query Excel spreadsheets from Access and how to send the results of your queries straight into Excel if you need to further analyse results.

Once you are comfortable with the advanced use of the query designer we cover advanced reporting. Professional reporting needs can rarely be met by simple wizard-generated reports.  You'll begin by constructing an advanced query to underpin your report and then explore all of the advanced report features (such as cover pages, multi-level grouping, group subtotals and report grand totals).  You'll also learn how to produce calculated fields (in both queries and report controls) using the expression builder.

After this course there will be no reporting requirement that you won't be able to address.

Who is this course for?
This course is designed for users who need to be able to create ad-hoc reports against an existing database.  The database need not be Access, the Access reporting tool is unequalled when reporting against Oracle, SQL Server, DB2 or any other modern ODBC compliant database.
Where you will be at the end of the course
When you've taken the Report Writing Expert course you will be able to produce high quality, printed reports to address any reporting requirement from any ODBC compliant database.

You will also be able to use advanced queries to extract carefully selected, sorted and filtered data into Excel for further analysis.