Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for existing Access users who need to produce accurate reports for viewing on screen and printing.

Objectives:

By the end of the course users will be able to create reports in a variety of layouts and summarise data. Users will also be able to manage the structure of a report and understand the importance of the sections in a report to produce the required ‘accurate’ output.

Prerequisites:

This course is designed for existing Microsoft Access users who have a sound understanding of databases. Users should be able to open, navigate and close tables and be able to create queries using a selection of criteria.

Download Outline (PDF)

Reporting Essential Skills
  • Creating Reports using the Wizard
  • Creating Auto-Reports
  • Switching Report Views
  • Navigating Records in Layout View
  • Previewing Reports in Print Preview
  • Working with Sections in Design View
  • Creating ‘White Space’
  • Modifying ‘Stacked’ & ‘Tabular’ Layouts
  • Moving & Resizing Controls
  • Inserting & Deleting Controls
  • Aligning & Sizing Text Boxes & Labels
  • Formatting Text & Controls
Creating Custom Reports
  • Sorting & Grouping Report Data
  • Forcing Page Breaks in Reports
  • Creating Simple Calculated Controls
  • Summarising Report Data with Calculations
  • Showing & Hiding Report Sections
  • Switching Data Sources

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.