Course Outline
Queries
- The types of queries
- Query Wizard
- Query Design View
- query Properties
- Grouping in Queries
- Create a simple select query
- Crosstab queries
- Query the search duplicates
- Not matching the search query data
- Parameter queries
- Queries (forming a table, delete, append, updating)
- Create a table with a query
- Archiving data using an append query
- Troubleshoot queries
Expressions in Queries
- Examples of the use of expressions
- Calculations in queries
- Functions
SQL in Access
- Download the data
- Restrict results
- Sorting Data
- SQL Functions
- Aggregating data using the grouping
- Retrieving data from multiple tables
- subqueries
- Operators collective
Requirements
Knowledge of Windows
Testimonials (7)
Prepared examples and techniques that I did not know
Magdalena - LKQ Polska Sp. z o. o.
Course - Advanced MS PowerPoint
I enjoyed all of the tips and tricks that Adam provided. He is very knowledgeable about this subject. He also made following along very easy.
Lara Speers - Lockheed Martin
Course - Advanced Slide Design in PowerPoint
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
real life practical examples
Wioleta
Course - Data and Analytics - from the ground up
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
I like the hands on training and seeing us solve for issues on the spot.