【Lynda】Access 2010: Queries in Depth【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Access 2010: Queries in Depth
作者：Adam Wilbert
主题：Business
使用软件：Access 2010, Office 2010
难度等级：中级
时长： 3h 2m
发布日期： Jun 16, 2011
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Access 2010- Queries in Depth[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
│ └─◇ 0003 Introducing the database.srt
│ └─◇ 0004 Previewing the course.srt
├─◆1. Creating Queries in Access
│ └─◇ 0101 Understanding queries.srt
│ └─◇ 0102 Following naming conventions and best practices.srt
│ └─◇ 0103 Using the Query Wizard.srt
│ └─◇ 0104 Exploring the design interface.srt
├─◆2. Creating Simple Select Queries
│ └─◇ 0201 Defining criteria.srt
│ └─◇ 0202 Understanding comparison operators.srt
│ └─◇ 0203 Defining the column headers.srt
│ └─◇ 0204 Exploring the property sheet.srt
│ └─◇ 0205 Printing query results.srt
│ └─◇ 0206 Working with joins.srt
├─◆3. Creating Parameter Queries
│ └─◇ 0301 Understanding parameter queries.srt
│ └─◇ 0302 Obtaining parameters from forms.srt
│ └─◇ 0303 Creating a combo box.srt
├─◆4. Applying Aggregate Calculations (aka Totals Queries)
│ └─◇ 0401 Understanding the Totals field.srt
│ └─◇ 0402 Creating aggregate calculations.srt
│ └─◇ 0403 Exploring the Expression Builder interface.srt
│ └─◇ 0404 Using mathematical operators.srt
│ └─◇ 0405 Applying text functions.srt
├─◆5. Working with Dates in Queries
│ └─◇ 0501 Understanding dates as serial numbers.srt
│ └─◇ 0502 Specifying a range of dates or times.srt
│ └─◇ 0503 Formatting dates.srt
│ └─◇ 0504 Using other Date Time functions.srt
│ └─◇ 0505 Defining today’s date.srt
│ └─◇ 0506 Calculating time intervals.srt
├─◆6. Understanding Conditional Statements
│ └─◇ 0601 Introducing the conditional IIf function.srt
│ └─◇ 0602 Creating an IIf function.srt
│ └─◇ 0603 Nesting IIf functions.srt
│ └─◇ 0604 Using the Switch function.srt
├─◆7. Linking It All Together
│ └─◇ 0701 Understanding the reporting tool.srt
│ └─◇ 0702 Building the form.srt
│ └─◇ 0703 Building the query.srt
│ └─◇ 0704 Building the report.srt
│ └─◇ 0705 Finalizing the reporting tool.srt
├─◆8. Alternative Query Types
│ └─◇ 0801 Finding duplicate records.srt
│ └─◇ 0802 Identifying unmatched records.srt
│ └─◇ 0803 Creating crosstab results.srt
│ └─◇ 0804 Creating backups.srt
│ └─◇ 0805 Creating update queries.srt
│ └─◇ 0806 Making, deleting, and appending records.srt
│ └─◇ 0807 Uniting tables.srt
│ └─◇ 0808 Embedding SQL code in queries.srt
├─◆Conclusion
│ └─◇ Next Steps.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗