Access - Using queries to obtain statistical results

Build simple queries allowing the extraction of data from a table and integrate several tables into a selected query with Access.
Microsoft Partner

Upcoming sessions

Guaranteed to run

No date suits you?

Notify me when a session is added.

  • Duration: 1 day
  • Regular price: $360
  • Preferential price: $306

Course outline

Duration : 1 day

© AFI Expertise inc.

AudienceAny data base user or manager


Windows - User or equivalent

To have followed the training: Access - Data structuring and normalization


  • Be able to build simple queries allowing the extraction of data from a table.
  • Be able to integrate several tables into a selected query

Teaching method

Presentations - Demonstrations - Guided and Individual Exercises


Chapter 1 - Interrogating the tables of a database

  • Build a query based on several tables
  • Establish relationships between tables
  • Understanding relationship types
  • Define the appropriate join type

Chapter 2 - Use calculated fields

  • Define a calculated field
  • Inserting calculated fields in a query
  • Using the expression generator
  • Concatenating fields
  • Using pre-programmed functions
  • Using functions from the Text category
  • Using functions from the Math and Date/Time categories
  • Use logical functions
  • Use calculated fields

Chapter 3 - Get statistical results

  • Create statistical and grouping operations
  • Create grouping levels
  • Create calculated fields using statistical and domain functions

Chapter 4 - Verify data integrity

  • Apply referential integrity
  • Search for duplicates
  • Search for non-matching items

Chapter 5 - Performing cross-analysis

  • Create a cross tab
  • Modify a Cross Tab query

Chapter 6 - Setting up a query

  • Create and run a parameterized query

Surround yourself with the best

Pierre-Edouard Brondel
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Yves Pilon
Yves Pilon
Yves Pilon is passionate about technological tools. His knowledge of web and office softwares has made him an expert on all Microsoft Office tools. Yves' excellent pedagogy has earned him praise from our clients on several occasions. He stands out for his spirit of synthesis and active sense of listening to the needs of the participants. The expertise he has accumulated over the years gives him the ability to ensure a productive transfer of knowledge to our clients.
Frédéric Paradis
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.
Marc Maisonneuve
Marc Maisonneuve
Training program director
Marc Maisonneuve has acted as a Training Program Director, professional effectiveness trainer and user tools practice leader at AFI for several years. Mr. Maisonneuve is known for his analytical skills, his legendary calm and his undeniable desire to encourage people to develop their skills. He has the ability to present technological solutions in a natural way and to adapt them to the concrete needs of the workplace.

Soyez au fait des tendances, innovations, bonnes pratiques et exclusivités

Stay in touch

Pour les individus

Pour les organisations

Thèmes Afi U.

Formations certifiées

À propos

La Famille Edgenda


AFI par Edgenda

Apprentx par Edgenda

Afi U.


Besoin d’aide ? Parlez à un conseiller ou appelez au 1 877 624.2344


Confidentialité | Centre de formation autorisé Emploi-Québec, Agrément : 0051460 | TPS : 141582528 - TVQ : 1019557738

Copyright © 2023 Edgenda inc.