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
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
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
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.