課程簡介
查詢
- 查詢的類型
- 查詢精靈
- 查詢設計視圖
- 查詢屬性
- 查詢中的分組
- 創建簡單的選擇查詢
- 交叉表查詢
- 查詢重複數據
- 不匹配的搜尋查詢數據
- 參數查詢
- 查詢(創建表、刪除、附加、更新)
- 使用查詢創建表
- 使用附加查詢存檔數據
- 查詢故障排除
查詢中的表達式
- 表達式的使用示例
- 查詢中的計算
- 函數
SQL 在 Access 中
- 下載數據
- 限制結果
- 數據排序
- SQL 函數
- 使用分組進行數據聚合
- 從多個表中檢索數據
- 子查詢
- 集合運算符
最低要求
- Windows操作系统的基础知识
- 熟悉数据库概念有益,但不是必须的
受众
- Business分析师
- 数据录入专家
- 管理数据库的IT专业人员
- 任何希望使用Microsoft Access提取和操作数据的人
客戶評論 (5)
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Course - Advanced Slide Design in PowerPoint
關於影像格式和範本的一些小技巧 - 非常有用的:)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Course - 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.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
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.
Luke Pontin
Course - Data and Analytics - from the ground up
Content and the way it was provided.