Microsoft Access | AKTINA IT

Microsoft Access

  • Course Overview
  • Course Outline
  • Course Arrangements

With the MS Access training courses, you will gain the required knowledge to create, maintain and process large amounts of data easily.


This course is designed for new Access users or self taught users. The course will cover all aspects of database design and objects.

At Course Completion: 
After the course, you will be able to:
  • Understand Database Concepts and Objects
  • Create, Edit and Maintain Tables
  • Create Queries
  • Create Forms
  • Create Reports
  • Create Relational Tables, Forms, Queries and Reports

No previous experience of Microsoft Access is required to attend this course. You must have good basic Microsoft Windows skills, e.g. mouse and keyboard

Using Access

  • Introduction to the Relationship Database Model
  • A Short Access Tour
  • Wizards, Cue Cards, and Help
  • Working with an existing database for customer and product manipulation
  • Entering Adding and Editing Data into Tables
  • Table Field Properties
  • Customizing data sheets for better data manipulation
  • Copying, Moving and Deleting data

Creating a new database

  • Creating tables for data storing
  • Setting relationships between tables
  • Modifying Table Properties
  • Data Types and Validation


  • An Introduction to Forms and Form Controls
  • Entering and Validating data through forms
  • Intermediate Forms
  • Customising Forms
  • Dates, Expressions and Artificial Fields in Queries
  • Creating a user friendly form

Queries and Reports

  • Introduction to Queries
  • Multitable Queries
  • Parameter Queries
  • Append, Delete, and Top Queries
  • Use queries to analyse data
  • Utilizing Queries for competitive advantage
  • Forms with Subforms
  • Form Control Properties
  • Advanced Forms
  • Expressions in Reports and Queries
  • Basic Reports
  • Intermediate Reports
  • Reporting for Management
  • Creating mailing labels
  • Mail merge for producing standardised letters


Other tasks

  • Complex Reports
  • Introduction to Macros
  • Sophisticated Queries (Update, Crosstab)
  • Customizing Access
Dates and Times: 
Nov 21 - 24
Duration (Hours): 

AKTINA Training Center
20 Loukis Akritas street, 1st floor
2064 Strovolos
(behind Kykko secondary schools)


Newsletter Subscription

Subscribe with your email address to stay up to date.

Find a Course

Go to top