en
nlfr
IT Training

Access 2019/365 – Level 2

Many organisations have large databases in Access that have been built up over the years; staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports. However, when databases get large, making your queries and forms effective can become more complex and it’s worth investing in an advanced Access training course to get the most out of your data and save time. In our Microsoft Access advanced course, students will learn how to analyse data by creating complex queries, how to make forms and reports more efficient, how to speed up repetitive tasks by creating macros.

Who should attend this course?

This course is aimed at professionals who are required to create and manage database applications: sales managers, marketing managers, project managers, IT managers, etc.

Prerequisites

Master the creation of tables (types and properties of fields). Master the basic principles of selection queries

This course provides participants with the skills necessary to create and manage a relational database in Access.

The objective of an Access Level 2 course is to go further into the functionality of the software. Learn to make more targeted queries, forms and more elaborate reports.

  • Reminder of selection queries
  • Analysis (database building)
  • Advanced queries
  • Data exchange
  • Forms & Reports
  • Macros

If Access is an excellent relational database manager, the software has its limits of automation which can be exceeded via the addition of VBA and/or SQL. These two subjects are covered in other courses.

What’s new in this release

  • Support for large numbers (bigint).
  • Property sheet sorting.
  • New « Label name » property for controls.
  • Easier editing of a new value list item.
  • Easier resizing of objects in design view.
  • Choose the right Storage drive for your results
  • Classic: on a file server or the hard drive of a device.
  • Personal OneDrive / Shared OneDrive / SharePoint-Teams

Review of selection queries

  • Basic concept of queries
  • Using filters in queries (and/or, like, null, [])
  • Creating calculated fields (functions / formulas)
  • Perform aggregations (sum, average, min, max, count)

Analysis (Architecture of a database)

  • Reminder of relational database theory
    • Understand the value of relationships
    • Differentiate between the 3 types of relationships (1 to 1, 1 to many, many to many)
    • Understand the concept of primary key and foreign key
    • Master the concept of referential integrity
  • Exercises :
    • Analyze relationships in an existing database
    • Create selection queries that use multiple tables (aggregation)

Advanced queries

  • Using action queries (table creation, update, addition and deletion).
  • Properties of links in a query.
  • Mismatch query.
  • Advanced functions in queries.
  • Create a list of choices on a “foreign key” field in a table.
  • Introduction to the SQL language (union query)

Forms & Reports

  • Master the various controls (list box, option group, check box,…)
  • Master some forms and reports properties
  • Master conditional formatting

Macros

  • Understand the purpose of macros
  • Master the concept of event in forms
  • Useth most common actions in macros

Analysis of data from multiple sources with PowerPivot

  • Import / Export (xlsX , CSV,txt, Accdb…).
  • Links between tables of different types.

Practical information

Duration

2 Days

Languages

FR / NL

Price

€800,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Sessions in Dutch
23/1 - 24/1Book
20/2 - 21/2Book
20/3 - 21/3Book
27/4 - 28/4Book
15/5 - 16/5Book
19/6 - 20/6Book
17/7 - 18/7Book
07/8 - 08/8Book
18/9 - 19/9Book
16/10 - 17/10Book
13/11 - 14/11Book
11/12 - 12/12Book
Sessions in French
26/1 - 27/1Book
23/2 - 24/2Book
23/3 - 24/3Book
27/4 - 28/4Book
25/5 - 26/5Book
22/6 - 23/6Book
19/7 - 20/7Book
17/8 - 18/8Book
21/9 - 22/9Book
19/10 - 20/10Book
23/11 - 24/11Book
14/12 - 15/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    You might also be interested in

    AccessAccess
    Access 2019/365 – Level 1
    11/1 - 13/1, 01/2 - 03/2, 08 ...
    Most companies have a lot of data, from customer and employee records to product specification data and billing and scheduling…

    Prerequisite test

    Take the test

    Looking for a tailor made solution?

    Get started with personal training