Access Advanced Training Course

Primary tabs

Duration Duration

21 hours (usually 3 days including breaks)

Requirements Requirements

Knowledge of Windows.

Basic knowledge of Microsoft Access database or other.

Overview Overview

The course participants will learn how to speed up the operation of the database, how to write advanced queries, create a convenient system of forms and reporting. The course introduces the participant to automate all operations using macros and VBA.

Course Outline Course Outline

Tables and Fields

  • Indexes and their usage
  • Validation rules in tables
  • Lists of values
  • Search field
  • Creating and Using OLE Object data type


  • Queries with Union operator
  • Crosstab queries
  • Logical, date, text, convert, aggregate functions
  • Finding duplicates and unmatched records


  • Creating subforms
  • Viewing Totals
  • Opening subforms in a new window
  • Setting the default values for controls
  • Changing form views


  • Records numbering in groups
  • Creating a multi-column reports
  • Creating report templates
  • Creating user "labels"


  • Creating Charts
  • Embedding charts in forms and reports
  • Editing and modifying charts


  • Creating simple macro
  • Macros Wizard
  • Adding conditions
  • Assigning macros to control events
  • Ways to run macros
  • Creating a macro group
  • Autoexec macro
  • AutoKeys macro
  • Testing macro in the "single step mode"

Switchboard Manager

Export and import data
  • Exporting tables and queries
  • Exporting reports as a snapshot
  • Exporting reports to Microsoft Word
  • Importing data from other databases
  • Importing text files (CSV)
  • Importing Excel spreadsheets
  • Linking tables from other databases

Database Relational Model and the Database Integrity

  • Foreign keys and ways to maintain consistency
  • Cascade deletion and updating related records
  • Ways to join tables
  • Joining internal, external right and left
  • Joining tables without the clause "join"
  • Testing integrity

Tools and Maintenance of the database.

  • Compacting and repairing database
  • Backing up and restoring
  • Database Documenter
  • Database Replication
  • Synchronization
  • Viewing dependencies between objects

Smart tags

Startup options

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1830PLN
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 3690PLN
Request quote

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Remote
1 1830PLN 3690PLN
2 1515PLN 2445PLN
3 1410PLN 2030PLN
4 1358PLN 1823PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
A Practical Guide to Successful Pricing Strategies Poznan, Garbary 100/63 Wed, 2016-10-26 09:00 3366PLN / 1883PLN
Design Patterns in C# Bielsko-Biała, Al. Armii Krajowej 220 Wed, 2016-10-26 09:00 3861PLN / 2130PLN
Creating and delivering presentations in Power Point (social skills workshop) Poznan, Garbary 100/63 Thu, 2016-10-27 09:00 3346PLN / 1414PLN
Agile Project Management with Scrum Kraków, ul. Rzemieślnicza 1 Wed, 2016-11-02 09:00 3386PLN / 1929PLN
Understanding Windows Communication Foundation (WCF) Szczecin, ul. Małopolska 23 Wed, 2016-11-02 09:00 10266PLN / 3611PLN
Python Programming Szczecin, ul. Małopolska 23 Mon, 2016-11-07 09:00 N/A / 5434PLN
Agile Project Management with Scrum Poznan, Garbary 100/63 Mon, 2016-11-07 09:00 3386PLN / 1529PLN
Business Analysis, BABOK V3.0 and IIBA Certification Preparation Katowice ul. Opolska 22 Mon, 2016-11-07 09:00 9405PLN / 5753PLN
Adobe InDesign Lublin, ul. Spadochroniarzy 9 Mon, 2016-11-07 09:00 1881PLN / 1327PLN
Administration of Linux System Olsztyn, ul. Kajki 3/1 Tue, 2016-11-08 09:00 3861PLN / 1920PLN
SQL Fundamentals Warszawa, ul. Złota 3/11 Wed, 2016-11-09 09:00 3663PLN / 1510PLN
Adobe Illustrator Katowice ul. Opolska 22 Wed, 2016-11-09 09:00 2871PLN / 1848PLN
Excel For Statistical Data Analysis Warszawa, ul. Złota 3/11 Mon, 2016-11-14 09:00 2673PLN / 1291PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 3455PLN / 2202PLN
Prototypowanie interaktywnych makiet - Axure Szczecin, ul. Małopolska 23 Mon, 2016-11-14 09:00 5445PLN / 2101PLN
Social Media - facebook, twitter, blog, youtube, google+ Gdynia, ul. Ejsmonda 2 Mon, 2016-11-14 09:00 1881PLN / 1102PLN
Apache Web Server Administration Kraków, ul. Rzemieślnicza 1 Tue, 2016-11-15 09:00 4732PLN / 3177PLN
SQL in MySQL Gdynia, ul. Ejsmonda 2 Thu, 2016-11-17 09:00 2851PLN / 1413PLN
OCUP2 UML 2.5 Certification - Intermediate Exam Preparation Wroclaw, ul.Ludwika Rydygiera 2a/22 Thu, 2016-11-17 09:00 5148PLN / 2175PLN
Creating and managing Web sites Kraków, ul. Rzemieślnicza 1 Mon, 2016-11-21 09:00 5841PLN / 3298PLN
Stress management Gdynia, ul. Ejsmonda 2 Mon, 2016-11-21 09:00 5148PLN / 1730PLN
Angular JavaScript Katowice ul. Opolska 22 Mon, 2016-11-21 09:00 5940PLN / 3380PLN
Agile w projektach zdalnych Katowice ul. Opolska 22 Tue, 2016-11-22 09:00 5049PLN / 1962PLN
Effective working with spreadsheet in Excel Rzeszów, Plac Wolności 13 Thu, 2016-11-24 09:00 PLN / 767PLN
Visual Basic for Applications (VBA) for Analysts Kielce, ul. Warszawska 19 Tue, 2016-11-29 09:00 2772PLN / 1974PLN
Graphic techniques (Adobe Photoshop, Adobe Illustrator) Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2016-12-06 09:00 4851PLN / 2740PLN
Test Automation with Selenium Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2016-12-06 09:00 7722PLN / 3624PLN
Programming in WPF 4.5 Kraków, ul. Rzemieślnicza 1 Tue, 2016-12-06 09:00 6435PLN / 2893PLN
Docker and Kubernetes Gdańsk, ul. Powstańców Warszawskich 45 Wed, 2016-12-07 09:00 N/A / 4989PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
Warszawa, ul. Złota 3/11Mon, 2016-11-14 09:003690PLN / 1830PLN
Tarnów ul. Kościuszki 10 Mon, 2016-11-14 09:003690PLN / 2280PLN
Gdańsk, ul. Powstańców Warszawskich 45Wed, 2016-11-16 09:003690PLN / 2280PLN
Wroclaw, ul.Ludwika Rydygiera 2a/22Wed, 2016-11-16 09:003690PLN / 1830PLN
Kielce, ul. Warszawska 19Mon, 2016-11-21 09:003690PLN / 2280PLN

Some of our clients