Skip to site navigation

Forms and reports in Access 2010

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 completed by people using Access 2007.  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:  Self-paced

Trainer led sessions are no longer available for Access 2010, see Access 2013.
The resources listed below can be used for self-paced learning.
Resources: