Bizi tercih ettiğiniz için teşekkür ederiz. Ekip üyelerimiz en kısa sürede sizlerle iletişime geçecektir.
Rezervasyonunuzu gönderdiğiniz için teşekkür ederiz! Ekibimizden bir yetkili kısa süre içinde sizinle iletişime geçecektir.
Eğitim İçeriği
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
Kurs İçin Gerekli Önbilgiler
- Windows işletim sistemi hakkında temel bilgi
- Veritabanı kavramlarına aşinalık faydalıdır ancak gerekli değildir
Hedef Kitle
- Business analistler
- Veri giriş uzmanları
- Veritabanlarını yöneten IT profesyonelleri
- Microsoft Access kullanarak veri çıkarmak ve işlemek isteyen herkes
14 Saat
Danışanlarımızın Yorumları (5)
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Eğitim - Advanced Slide Design in PowerPoint
some small tricks regarding image formating and templates - very useful :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Eğitim - Advanced MS PowerPoint
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.
Eğitim - Visual Basic for Applications (VBA) in Excel (intermediate level)
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Eğitim - Excel VBA Introduction
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.
