Schulungsübersicht
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
Voraussetzungen
Knowledge of Windows
Erfahrungsberichte (5)
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Kurs - Advanced Slide Design in PowerPoint
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
Emilija Stoilova - EPFL HBP PCO
Kurs - Analysing Financial Data in Excel
einige kleine Tricks zur Bildformatierung und Vorlagen - sehr nützlich :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Kurs - Advanced MS PowerPoint
Maschinelle Übersetzung
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Kurs - Visual Basic for Applications (VBA) in Excel (intermediate level)
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.