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

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

Forms

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

Reporting

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

Charts

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

Macros

  • 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

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
From 1800PLN
(21)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
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
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

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 1800PLN 3600PLN
2 1500PLN 2400PLN
3 1400PLN 2000PLN
4 1350PLN 1800PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Toruń, ul. Żeglarska 10/14Wed, 2017-10-11 09:003600PLN / 2100PLN
Bielsko-Biała, Al. Armii Krajowej 220Wed, 2017-10-11 09:003600PLN / 2250PLN
Łódź, ul. Tatrzańska 11Mon, 2017-10-16 09:003600PLN / 2100PLN
Warszawa, ul. Złota 3/11Mon, 2017-10-16 09:003600PLN / 1800PLN
Zielona Góra, ul. Reja 6Mon, 2017-10-16 09:003600PLN / 1950PLN

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Visual Basic for Applications (VBA) in Excel - Advanced Warszawa, ul. Złota 3/11 Mon, 2017-09-25 09:00 3069PLN / 1623PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Katowice ul. Opolska 22 Mon, 2017-09-25 09:00 5940PLN / 3730PLN
Programming in C++ Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-09-25 09:00 5445PLN / 2815PLN
Creating and managing Web sites Poznan, Garbary 100/63 Mon, 2017-09-25 09:00 5841PLN / 2298PLN
Java Performance Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-09-25 09:00 9801PLN / 3000PLN
SQL in Microsoft Access Kraków, ul. Rzemieślnicza 1 Tue, 2017-09-26 09:00 10266PLN / 3911PLN
OCUP2 UML 2.5 Certification - Foundation Exam Preparation Kraków, ul. Rzemieślnicza 1 Wed, 2017-09-27 09:00 6930PLN / 3510PLN
Visual Basic for Applications (VBA) for Analysts Poznan, Garbary 100/63 Wed, 2017-09-27 09:00 2970PLN / 1590PLN
Adobe InDesign Katowice ul. Opolska 22 Thu, 2017-09-28 09:00 1881PLN / 1327PLN
Design Patterns in C# Rzeszów, Plac Wolności 13 Thu, 2017-09-28 09:00 3861PLN / 2331PLN
Tworzenie aplikacji na platformie Android Łódź, ul. Tatrzańska 11 Mon, 2017-10-02 09:00 4455PLN / 3128PLN
Statistical and Econometric Modelling Warszawa, ul. Złota 3/11 Mon, 2017-10-02 09:00 20483PLN / 6807PLN
Effective interpersonal communication with elements of assertiveness Kraków, ul. Rzemieślnicza 1 Tue, 2017-10-03 09:00 5148PLN / 1830PLN
Web Development with Symfony3 Kielce, ul. Warszawska 19 Mon, 2017-10-09 09:00 5554PLN / 2483PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Szczecin, ul. Sienna 9 Mon, 2017-10-09 09:00 3564PLN / 1891PLN
Analiza biznesowa i systemowa z użyciem notacji UML - warsztat praktyczny dla PO w metodyce Scrum Łódź, ul. Tatrzańska 11 Tue, 2017-10-10 09:00 7722PLN / 3474PLN
Access Basics Szczecin, ul. Sienna 9 Tue, 2017-10-10 09:00 3465PLN / 1550PLN
MS-40361 Software Development Fundamentals MTA Exam 98-361 Gdynia, ul. Ejsmonda 2 Wed, 2017-10-11 09:00 6138PLN / 2610PLN
PostgreSQL for Administrators Gdynia, ul. Ejsmonda 2 Wed, 2017-10-11 09:00 12326PLN / 4235PLN
UML Analysis and Design Kraków, ul. Rzemieślnicza 1 Wed, 2017-10-11 09:00 8910PLN / 4170PLN
Agile w projektach zdalnych Katowice ul. Opolska 22 Mon, 2017-10-16 09:00 5049PLN / 1962PLN
Programming in C++ Bielsko-Biała, Al. Armii Krajowej 220 Mon, 2017-10-16 09:00 5445PLN / 3565PLN
Programming in C++ Łódź, ul. Tatrzańska 11 Mon, 2017-10-16 09:00 5445PLN / 3315PLN
Programming in C# Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2017-10-18 09:00 4851PLN / 1870PLN
Stress management Gdynia, ul. Ejsmonda 2 Wed, 2017-10-18 09:00 5148PLN / 1530PLN
Business Analysis Kraków, ul. Rzemieślnicza 1 Wed, 2017-10-18 09:00 7722PLN / 3774PLN
Nginx Setup, Configuration and Administration Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2017-10-18 09:00 6930PLN / 2700PLN
Projektowanie stron na urządzenia mobilne Kielce, ul. Warszawska 19 Thu, 2017-10-19 09:00 2624PLN / 1305PLN
Adobe Premiere Pro Gdynia, ul. Ejsmonda 2 Mon, 2017-10-23 09:00 3960PLN / 2480PLN
Administration of Linux System Gdynia, ul. Ejsmonda 2 Tue, 2017-10-24 09:00 4950PLN / 3225PLN
Node.js Olsztyn, ul. Kajki 3/1 Thu, 2017-10-26 09:00 3861PLN / 2431PLN
Effective working with spreadsheet in Excel Warszawa, ul. Złota 3/11 Thu, 2017-10-26 09:00 2475PLN / 1225PLN
SQL Advanced in MySQL Warszawa, ul. Złota 3/11 Thu, 2017-11-02 09:00 1881PLN / 1141PLN
Android - The Basics Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-11-06 09:00 9801PLN / 4180PLN
Java Spring Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-11-06 09:00 14414PLN / 5970PLN
Nagios Core Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2017-11-13 09:00 13919PLN / 4968PLN
Data Analysis with Oracle 11g - workshop Gdynia, ul. Ejsmonda 2 Mon, 2017-11-13 09:00 9900PLN / 4664PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients