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
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
The own working, it helps a lot I think.
Krisztina BALOGH, Diehl
The trainer let us ask regarding our issues with our current projects. He explained really well what kind of approach we should choose.
Krisztina BALOGH, Diehl
perfect level of knowledge transfair
Pascal - Krisztina BALOGH, Diehl
I learned a lot of new things which will be useful for my tasks.
Zsolt - Krisztina BALOGH, Diehl
The trainings by our self
Andreas - Krisztina BALOGH, Diehl
I liked that all the neccessary topics have been explored.
Krisztina BALOGH, Diehl
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
complex introduction to queries, relationships. Useful tips in term of further using of Access as well as Access connection with different tools
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Trainer has very broad knowledge, not only related to access. Impressive :)
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
starting from scratch and go further and further.
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Kamil 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
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
examples and the way he explained