MS Access – Intermediate

Intermediate Microsoft Access Training Course Information

Microsoft Access – Intermediate Training Courses

1 Day Course | 1 delegate £225.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information

Introduction

This one-day instructor led course is designed for existing users of Microsoft Access who need to be able to create databases and manage data more effectively. By the end of the course delegates will be able to design a new database with attractive forms for data entry and functional reports for printed management information.

Course Objectives

  • Design a multi table relational database
  • Create parameter queries and action queries
  • Perform calculations in queries
  • Create forms and sub forms
  • Incorporate a graphic in a form
  • Design reports with calculations

Pre-requisites

his course is designed for delegates who have completed the Access Introduction course or have equivalent knowledge. Delegates should already be familiar with the different Access objects (tables, queries, forms and reports) and should be looking to develop their knowledge of database design and data manipulation.

Course Content

Review of Access Basics

Database Design

  • Creating a new database
  • Understanding and modifying data types
  • Setting field properties
  • Assigning the primary key
  • Creating relationships
  • Importing data

Query Design

  • Creating parameter queries
  • Calculating in queries
  • Using action queries: Make Table / Append / Delete / Update

Form Creation

  • Creating forms with subforms
  • Customising forms
  • Using the forms control toolbox

Report Design

  • Using calculations in reports
  • Grouping and sorting data
  • Creating and formatting labels
  • Modifying field properties
  • Adding a graphic to a report