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
Machine Translated
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
The instructor's interaction with the participants, knowledge, openness to discussion and ideas.
Paweł - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
practical examples
weronika josiek - Denso
Course - Advanced MS PowerPoint
Machine Translated
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
The pace of classes is perfect, not too fast, not too slow, lots of examples and exercises. Each participant could freely perform the exercises without any pressure to answer questions. Everyone could act in their own time, and in case of a failed attempt, you could catch up when the trainer showed the solution.
Anna - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
I really was benefit from the real life practical examples.