Access 2010 Module 4 - Generating Reports and Exchanging Data

Aimed At: Staff who are required to extract data from an Access data base in order to output in report format.

Workshop Overview

This workshop is suitable for staff who are familiar with Microsoft Access or have attended Access Modules 1 and 2.

Learning Objectives

At the end of the workshop participants will be able to:

  • Produce a report
  • Customise reports
  • Import and link data to Access
  • Export data from Access
Outline Programme

The workshop programme is as follows:

  • Creating single-column and tabular reports
  • Work with Preview, Layout and Design views
  • Modifying a report’s layout
  • Sorting and grouping in reports
  • Working with report controls and properties
  • Creating reports with sub-reports
  • Adding calculated controls to a report
  • Printing mailing labels
  • Using Access mail merge wizard
  • Exporting data to Word and Excel
  • Import data from Excel
Note

In addition to the workshops we offer we also have the on-line courses available through the SDU's Learning Resource Centre.

Booking Details
Trainer

Simon Patterson

9:15am - 12:30pm

    It is not possible to access the workshop booking form unless connected to the University's campus network, should you wish to book a place on this workshop please contact the Staff Development Unit on 0191 2226119 direct.
    Duration

    1/2 Day
    Contact

    Victoria Beesley Extension 3424

    Related Information

    Workshops