Skip to site navigation

Forms and reports in Access 2013

Description:

This course covers a wide range of features of both forms and reports in Access and participants will be able to make some choices about which aspects they would like to cover. For example they may already have some knowledge and wish to cover more complex features or they may wish to focus more on forms than reports. See Delivery section below for more detail.

Note that this course can be attended by people using Access 2010.  There are some differences between the two versions but most features are the same.

Pre-requisites:

You should have attended, or be familiar with the concepts covered in, the Using databases in Access course, the Designing and Developing Databases in Access course and the Creating queries course. In particular participants should be familiar with field properties in tables and criteria in queries and be confident in using and navigating within an Access database.

Outline:

The outline below is not completely exhaustive but illustrates the main features which are covered. As explain in Delivery below, not all features need to be covered and participants will guided as to those which are essential or desirable.

  • creating forms using the form wizard
  • modifying form design
  • form controls (fields, labels, images)
  • form and control properties
  • creating forms based on multiple tables and queries
  • adding tabs, option buttons and combo boxes
  • adding user instructions to forms
  • creating reports using the report wizard
  • modifying report design
  • grouping and sorting in reports
  • creating calculated controls on forms and reports:
  • creating labels with reports
  • numbering items in reports
  • multiple column reports
  • conditional formatting in reports
  • adding subreports to reports
  • setting database startup options
  • creating command buttons

Delivery:  Trainer Led

This is delivered in two half-day trainer-led sessions with a degree of flexibility in the material that is covered.

Participants will spend the majority of the course working through practical exercises and will be guided as to which tasks are considered to be essential or desirable to complete. The trainer will explain more complex concepts and demonstrate certain features to the group collectively and will also provide individual support during the practical sessions.

Depending on the needs of the participants they may complete the material they require in less than the full three hours on each day. However, attendance is required for the first two hours as a minimum.

To see when the next session of this course is running, please check our training calendars:


Resources:

All ISD IT Training course materials are now available to download from the Moodle course: ISD IT Training

You will need to login to Moodle using your UCL user ID and password.

Materials are organised by application name e.g. SPSS or Excel 2013 then by course.

Whenever possible please ensure that you have downloaded the course materials prior to attending a booked course.