最新消息:网盘下载利器JDownloader--|--发布资讯--|--解压出错.密码问题--|--百度盘链接打开页面有问题的请将Http改成Https

Lynda – Access 2016: Queries in Depth

其他教程 killking 0评论

Lynda - Access 2016: Queries in Depth

Size: 713 MB | Duration: 4h 11m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English
Learn how to find and translate complex raw data into information you can use to make better decisions, with Access queries. Access expert Adam Wilbert explains how to create real-world queries to filter and sort data and perform calculations, as well as refine query results with built-in functions, all while offering challenges that help you master the material. Find out how to identify top performers, automate repetitive analysis tasks, make queries more flexible with parameter requests, and increase accuracy and consistency in your database using program flow functions. Adam closes with an assortment of useful query tricks. Take the challenges posed along the way to test and practice your new Access skills.

Topics include:
* Creating a query with the wizard
* Defining query criteria
* Using comparison and wildcards in criteria
* Working with joins
* Creating parameter queries
* Using the built-in functions in Access
* Summarizing data
* Aggregating records with totals
* Working with dates
* Creating alternative queries: unmatched, crosstab, and more
* Writing queries with SQL
Lynda - Access 2016: Queries in Depth
Download 百度云

以下隐藏内容只提供VIP赞助会员

sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. 学习如何通过Access查询找到并将原始的数据转换为有用的信息,并为决策提供参考意见。Access专家Adam Wilbert将会讲解如何创建查询以过滤和排序数据,执行运算和使用内建函数提炼数据。学习如何找到顶级性能,自动执行重复的任务,通过参数查询让查询更灵活,使用程序流增加数据库的准确性和一致性。最后作者会讲到一些技巧。 主要内容:使用向导创建查询;定义查询标准;在标准中使用比较和通配符;处理合并;创建参数查询;使用内建函数;数据汇总;处理日期;编辑sql查询。
    wilde(特殊组-翻译)10个月前 (06-08)