Access 2013, 2016, 2019, 365 ProPlus - Fundamentals

Inter-company training

Duration

 12,00 hours(s)

Language(s) of service

EN

Next session

 08.09.2026
Location
 Luxembourg

Price

590,00€

Who is organizing this training?

Fondation créée en 2015 par la Chambre de Commerce et l’Association des Banques et Banquiers Luxembourg (ABBL), la House of Training est un organisme agréé de formation professionnelle continue qui s'engage à contribuer activement à la compétitivité et à l'attractivité du Luxembourg en développant les compétences de ceux qui font vivre son économie.

Prerequisites

Basic Windows skills

Goals

Be able to understand and create the structure of an Access database.

Contents

  • Environment
  • General topics
    • Launching Microsoft Access
    • Exiting Microsoft Access
    • Using/Managing the Ribbon
    • Displaying/Hiding the tool tip texts
    • Navigation pane
    • Customising the Quick access toolbar
    • Moving the quick access toolbar
    • Cancelling/Restoring the manipulations
  • Help
    • Searching help by using keywords
  • Databases
    • Thinking about the database purpose
    • Creating a new database
    • Opening/Closing a database
    • Managing the prior database formats
    • Compacting and repairing a database
    • Saving a database
  • Introduction to database objects
    • Access database objects: tables, queries, forms, reports …
    • Modifying the display/items order
    • Searching an object
    • Managing the objects
  • Tables
    • Table structure
      • Creating a table
      • Modifying the structure of the table with the Design/Datasheet view
      • Modifying field properties
      • Creating a list of values
      • Creating a multivalued list based on permanent data
      • Indexing a table
      • Defining a primary key
    • Relationships between the tables
      • Establishing a relationship between two tables
      • Managing database relationships
      • Displaying/ Modifying linked data in a sub-datasheet
  • Data management
    • Records
      • Entering information in the datasheet
      • Managing the datasheet
      • Adding/ Modifying/ Deleting a record
      • Sorting data
      • Filtering the information
      • Adding/Hiding a total row in a datasheet
      • Inserting a hyperlink
      • Searching a value in the records
      • Replacing a value
    • Data printing
      • Using the print preview
      • Modifying print margins and orientation
      • Printing an object
  • Queries
    • Selection queries
      • Creating a query based on a single table
      • Creating a multi-table query
      • Defining query properties
      • Managing the Design grid
      • Running a query
      • Defining criteria
      • Defining a parameter
      • Modifying the join type in a multi-table query
      • Creating a non-matching query by using the assistant
      • Creating a query which allows to find duplicates by using the assistant
      • Inserting a calculated field in a query
  • Creation of forms and reports
    • Creating a Form
      • Creating an instant form
      • Creating a form with the assistant
      • Displaying a form in design view
    • Creating a Report
      • Creating a report by using the assistant
      • Sorting data
      • Creating Labels by using the Report’s wizard
      • Modifying the labels page setup
      • Printing a report for some records
      • Grouping records
      • Inserting a summary calculation in a report

Certificate, diploma

At the end of the training, the participants will receive a certificate of attendance delivered by the House of Training.

Next session

Datum
City
Language and price
08.09.2026

09.09.2026
Luxembourg
EN 590,00€

These courses might interest you