Access - Using queries to obtain statistical results - Training Courses | Afi U.

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.

Private session

This training is available in a private or personalized format. It can be provided in one of our training centres or at your offices. Call one of our consultants of submit a request online.

Call now at 1 877 624.2344

Duration: 1 day
Regular price: On request

Course outline

Duration : 1 day

Audience	Any data base user or manager
Prerequisites	Windows - User or equivalent To have followed the training: Access - Data structuring and normalization
Objectives	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
Contents	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

Yves Pilon

Trainer

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.

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.