Microsoft Access

Level: Introduction

Duration: 2 days

This course is designed for users requiring a sound foundation on databases using Microsoft Access. It will provide them with the necessary tools to design and understand simple databases. This course can only be delivered as a bespoke/tailored course at customers premises.

Intended Course Content

• Fundamental of relational databases
• The Access Environment
• Creating Tables
• Understanding Field Properties
• Working with Tables & Records
• Using Filters
• Understanding Relationships
• Understanding Join Types
• Creating Simple Select Queries
• Creating Parameter Queries
• Creating Expressions
• Analysing Tables
• Creating Forms
• Creating Reports
• Printing techniques in Access

Pre Learning Requirements

Delegates must be proficient in using the Windows environment on a personal computer. Some knowledge of entering data in Access or Excel is beneficial but not required