Microsoft Access | AKTINA IT

Microsoft Access

  • Course Overview
  • Course Outline
  • Course Arrangements
Introduction: 

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

Audience: 

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
Prerequisites: 

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

Forms

  • 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

Graphs

Other tasks

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

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

City: 
Lefkosia

Newsletter Subscription

Subscribe with your email address to stay up to date.

Find a Course

Go to top