课程大纲
查询
- 查询的类型
- 查询向导
- 查询设计视图
- query 属性
- 查询中的分组
- 创建简单的选择查询
- 交叉表查询
- 查询搜索重复项
- 与搜索查询数据不匹配
- 参数查询
- 查询(形成表、删除、追加、更新)
- 使用查询创建表
- 使用追加查询存档数据
- 查询疑难解答
Expressions in 查询
- 表达式的使用示例
- 查询中的计算
- 功能
SQL 在 Access 中
- 下载数据
- 限制结果
- 对数据进行排序
- SQL 主要工作内容
- 使用分组聚合数据
- 从多个表中检索数据
- 子查询
- 运营商集体
要求
- Windows操作系统的基本知识
- 对数据库概念的熟悉是有益的,但不是必需的
观众
- Business分析师
- 数据输入专家
- 管理数据库的IT专业人员
- 任何人都希望使用MicrosoftAccess提取和操作数据
客户评论 (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.