Microsoft Acess 2007 Module C

Course Aims:

This course provides attendees with the knowledge required to carry out more complex design and maintenance tasks and build an automated database application.

Course Pre-requisites:

This course is open to anyone seeking to create an effective database with an intuitive and user-friendly customised interface. Significant knowledge of designing and creating database objects (tables, queries, forms and reports) is required together with notions about how to apply the learning to a real-life database application.

Course Objectives:

On completion of this course delegates will be able to:

  • Improve the effectiveness of a database by transferring data from other sources and employing Maintenance tools;
  • Automate tasks and functionality using macros; and
  • Produce a customised interface to facilitate using the database.


Course Content:

Introduction and Objectives

Database Design

  • Importing data tables into an Access database
  • Linking data tables into an Access database
  • Database tools and utilities


Special Queries

  • Action queries
  • Find duplicates query
  • Find unmatched query
  • Crosstab query


Creating Macros

  • Using the Macro Builder
  • Macro actions and arguments
  • Running macros


Using Macros

  • Assigning macros to form event properties
  • Creating conditional macros
  • Using macro groups


Creating and Using a Switchboard


Customising start up options for enabling switchboard use


Action planning

Review of Programme


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 C

Make Enquiry Add To Wishlist
All prices include VAT where applicable