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
要求
- Basic knowledge of Windows operating system
- Familiarity with database concepts is beneficial but not required
Audience
- Business analysts
- Data entry specialists
- IT professionals managing databases
- Anyone looking to extract and manipulate data using Microsoft Access
14 時間
お客様の声 (5)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
コース - Word dla zaawansowanych
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
コース - MS Word - poziom podstawowy
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
コース - Advanced Slide Design in PowerPoint
画像のフォーマットとテンプレートに関するいくつかの小さなトリック - 非常に役立ちます :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
コース - Advanced MS PowerPoint
Machine Translated
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.