Purchase any WEBINAR and get
10% Off
CODE: SAVE10
T&C applicable, please referFAQ
Validity : 20th Apr'24 to 30th Apr'24
Access: Queries - The Key to Powerful Data Analysis
- Creating a Basic Query
- Sorting the Query into alphabetical/numerical/chronological order
- Selecting records using criteria (simple and complex)
- Using Queries to generate subtotals
- Creating calculated fields in a Query
- Creating a Query from multiple Tables
Overview of the webinar
In this training, you will learn how to build Queries in Microsoft Access. Queries let you ask questions about your data. Queries allow you to select specific data from your database. Queries are the key to generating effective and powerful reports.
In short, a Query is the tool that lets you turn your raw data into meaningful information which is then used as the basis for making key business decisions.
A query could be as simple as "show me the names of the employees who started this year" or as complex as "show me a list of the customers based in New York or California who have purchased over $30,000 of services in the past 6 months"
Who should attend?
Anyone who uses Microsoft Access databases and needs to analyze and generate reports from large datasets.
Why should you attend?
If you use Access databases and need to analyze and generate reports from large datasets, having a good understanding and working knowledge of Queries is critical.
Faculty - Mr.Mike Thomas
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.