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
I liked the examples and the way he explained.
Sandeep Parashar
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.
Daria Rudin
Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
commitment of the teacher
Sylwia Żokowska
I liked the way of conducting the training the most. It was not carried out too quickly, and in a way that everyone could write down everything and learn.
Agnieszka Grzywa
adapting the material to the knowledge, interests and needs of the interested; a small group of trainers helped in learning more quickly; nice way of conducting, trivia, conversation
Łukasz Madej
A lot of different exercises.
Celina Gromadzka
practical examples
Anita Sępkowska
The flexibility of the trainer and the ability to adjust the exercises to the questions raised during the training. The training did not have a rigid plan, the plan evolved during the training under the influence of my needs.
Paweł Imbir
Good knowledge of the lecturer
Marcin Doleżyk
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
all OK
- NBP
A lot of exercises, examples, recalling and discussing cases of practical applications of the issue
- UBS Business Solutions Poland Sp. z o.o.
The training was conducted thoroughly from basic to very advanced ones. Friendly trainer, happy to answer questions.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
the knowledge gained from the training can be used in the job for which he was asked, the code written in VBA certainly no one will remember, so sending this message in the email is useful