Lynda.com出品深入认识Access 2010的查询功能视频教程 Lynda.com Access 2010 Queries in Depth [光盘镜像

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Lynda.com出品深入认识Access 2010的查询功能视频教程 英文名: Lynda.com Access 2010 Queries in Depth 资源格式: 光盘镜像 学校: Lynda.com 主讲人: Adam Wilbert 发行日期: 2011年 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

语言：英语 网址：http://www.lynda.com/Access-2010-tutorials/Queries-in-Depth/79412-2.html 类别：教程 （xuehui@TLF） Lynda.com 出品的时长3小时02分钟的深入认识Access 2010的查询功能视频教程。由Adam Wilbert讲述如何建立并最大能力的利用查询功能把原始数据转化为可用信息。内容包括建立查询，执行计算，利用内建的Access功能进一步细化查询结果，并确认是否最佳运行或基于一标准范围内需要改善的地方。本教程附带练习文件。 转自TLF 目录: Introduction Welcome 01m 10s Using the exercise files 00m 41s Introducing the database 04m 29s Previewing the course 02m 49s 17m 17s 1. Creating Queries in Access Understanding queries 03m 31s Following naming conventions and best practices 02m 56s Using the Query Wizard 05m 21s Exploring the design interface 05m 29s 26m 39s 2. Creating Simple Select Queries Defining criteria 05m 40s Understanding comparison operators 03m 19s Defining the column headers 02m 49s Exploring the property sheet 07m 32s Printing query results 02m 41s Working with joins 04m 38s 14m 14s 3. Creating Parameter Queries Understanding parameter queries 04m 27s Obtaining parameters from forms 05m 17s Creating a combo box 04m 30s 23m 24s 4. Applying Aggregate Calculations (aka Totals Queries) Understanding the Totals field 05m 31s Creating aggregate calculations 03m 31s Exploring the Expression Builder interface 04m 28s Using mathematical operators 05m 46s Applying text functions 04m 08s 24m 23s 5. Working with Dates in Queries Understanding dates as serial numbers 02m 42s Specifying a range of dates or times 03m 47s Formatting dates 04m 31s Using other Date/Time functions 03m 47s Defining today's date 02m 41s Calculating time intervals 06m 55s 20m 09s 6. Understanding Conditional Statements Introducing the conditional IIf function 02m 57s Creating an IIf function 07m 31s Nesting IIf functions 04m 57s Using the Switch function 04m 44s 20m 41s 7. Linking It All Together Understanding the reporting tool 02m 13s Building the form 06m 57s Building the query 05m 04s Building the report 03m 30s Finalizing the reporting tool 02m 57s 25m 37s 8. Alternative Query Types Finding duplicate records 02m 17s Identifying unmatched records 02m 29s Creating crosstab results 02m 57s Creating backups 01m 29s Creating update queries 03m 22s Making, deleting, and appending records 05m 36s Uniting tables 03m 16s Embedding SQL code in queries 04m 11s 01m 00s Conclusion Next Steps 01m 00s