Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
コース概要
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
要求
Knowledge of Windows
14 時間
お客様の声 (5)
私が知らなかった例やテクニックを用意した。
Magdalena - LKQ Polska Sp. z o. o.
コース - Advanced MS PowerPoint
Machine Translated
例の表示、図による翻訳方法
Aneta - LKQ Polska Sp. z o. o.
コース - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
話題が尽きた
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
コース - Excel Advanced with VBA
Machine Translated
I enjoyed all of the tips and tricks that Adam provided. He is very knowledgeable about this subject. He also made following along very easy.
Lara Speers - Lockheed Martin
コース - Advanced Slide Design in PowerPoint
実際の実践例から本当に恩恵を受けました。
Wioleta
コース - Data and Analytics - from the ground up
Machine Translated