Microsoft Acess 2007 Module B

WWP Training Limited
Delivery Method: Face-to-face

Course Aims:

This course introduces attendees to more advanced concepts, tools and techniques of database design and usage.

Course Pre-requisites:

This course is open to anyone seeking to expand their existing knowledge of table design, creating queries and designing forms and reports. Attendees will already have some knowledge of designing and working with the aforementioned objects, preferably as a result of having attended the Access Module A (Introduction) training.

Course Objectives:

On completion of this course delegates will be able to:

  • Improve the effectiveness of data tables by adding field properties and relationships;
  • Extract information from data tables by using advanced query techniques; and
  • Create more comprehensive forms and reports for the entering, viewing and printing of data.


Course Content:

Introduction and Objectives

Table Design

  • Setting advanced field properties in tables (input mask, validation, default value, lookup)


Designing Advanced Queries

  • Setting join types between tables
  • Setting top values in a query
  • Creating calculated fields, summary queries and parameter queries


Creating Relationships Between Tables

  • Creating relationships between tables
  • Viewing subdatasheets
  • Setting referential integrity
  • Cascade options


Working in Form Design View

  • Manipulating controls in form design view
  • Changing form and control properties
  • Adding controls to a form (list boxes, check boxes, option buttons)
  • Using calculations on forms


Working in Report Design View

  • Manipulating controls in a report
  • Changing report control properties
  • Managing sorting and grouping in reports
  • Adding calculations to a report
  • Controlling pagination


Using Subforms and Subreports

Action planning

Review of Programme


Related Courses

Access 2007  - Module C

Dates available on arrangement

WWP Training Limited can also create this course for you on arrangement either at your workplace or at one of their locations.

Make Enquiry

Write A Review Of Microsoft Acess 2007 Module B

£228.00 (inc VAT)
Make Enquiry Add To Wishlist
All prices include VAT where applicable