课程大纲
查询
- 查询的类型
- 查询精灵
- 查询设计视图
- 查询属性
- 查询中的分组
- 创建简单的选择查询
- 交叉表查询
- 查询重复数据
- 不匹配的搜寻查询数据
- 参数查询
- 查询(创建表、删除、附加、更新)
- 使用查询创建表
- 使用附加查询存档数据
- 查询故障排除
查询中的表达式
- 表达式的使用示例
- 查询中的计算
- 函数
SQL 在 Access 中
- 下载数据
- 限制结果
- 数据排序
- SQL 函数
- 使用分组进行数据聚合
- 从多个表中检索数据
- 子查询
- 集合运算符
要求
- Windows操作系统的基础知识
- 熟悉数据库概念有益,但不是必须的
受众
- Business分析师
- 数据录入专家
- 管理数据库的IT专业人员
- 任何希望使用Microsoft Access提取和操作数据的人
客户评论 (5)
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
机器翻译
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.
课程 - 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
课程 - Data and Analytics - from the ground up
Content and the way it was provided.