【Lynda】Access 2007: Queries in Depth【CHN】中英文字幕[SRT]

作者: acely. 分类: Lynda中文字幕, ◇ 商业办公

==========教程信息=====================================================
教程名称:Access 2007: Queries in Depth
作者:Adam Wilbert
主题:Business
使用软件:Access 2007
难度等级:中级
时长: 2h 8m
发布日期: Sep 09, 2010

┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741

==========教程目录文件列表=============================================
Access 2007- Queries in Depth[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
│ └─◇ 0003 Reviewing the Access interface.srt
├─◆1. Creating Queries in Access
│ └─◇ 0101 Query basics.srt
│ └─◇ 0102 Naming conventions and best practices.srt
│ └─◇ 0103 Using the Query Wizard.srt
│ └─◇ 0104 Exploring the Query By Example (QBE) interface.srt
├─◆2. Creating Simple Select Queries
│ └─◇ 0201 Defining a single criterion.srt
│ └─◇ 0202 Comparison operators.srt
│ └─◇ 0203 Defining the column headers with aliases.srt
│ └─◇ 0204 Exploring the field properties.srt
│ └─◇ 0205 Understanding query level properties.srt
│ └─◇ 0206 Working with joins and primary keys.srt
│ └─◇ 0207 Printing query results.srt
├─◆3. Creating Parameter Queries
│ └─◇ 0301 Understanding parameter queries.srt
│ └─◇ 0302 Obtaining parameters from other Access objects.srt
├─◆4. Creating Calculated Fields
│ └─◇ 0401 Using Totals to calculate values.srt
│ └─◇ 0402 Introducing mathematical operators.srt
│ └─◇ 0403 Using mathematical operators.srt
│ └─◇ 0404 Using text.srt
├─◆5. Using the Expression Builder
│ └─◇ 0501 The Expression Builder interface.srt
│ └─◇ 0502 Exploring some built-in functions.srt
├─◆6. Working with Dates in Queries
│ └─◇ 0601 Understanding dates as serial numbers.srt
│ └─◇ 0602 Specifying a range of dates or times.srt
│ └─◇ 0603 Using the Format function.srt
│ └─◇ 0604 Using other Date Time functions.srt
│ └─◇ 0605 Defining today’s date.srt
│ └─◇ 0606 Working with time intervals.srt
│ └─◇ 0607 Using the DateDiff function.srt
├─◆7. Understanding Conditional Statements
│ └─◇ 0701 Introduction to the conditional IIf function.srt
│ └─◇ 0702 Creating an IIf function with the Expression Builder.srt
│ └─◇ 0703 Using the Switch function.srt
├─◆8. Using Alternate Query Types
│ └─◇ 0801 Using crosstab queries.srt
│ └─◇ 0802 Finding duplicate queries.srt
│ └─◇ 0803 Finding unmatched queries.srt
│ └─◇ 0804 Working with action queries and backups.srt
│ └─◇ 0805 Updating queries.srt
│ └─◇ 0806 Making tables and appending queries.srt
│ └─◇ 0807 Deleting queries.srt
├─◆Conclusion
│ └─◇ Goodbye.srt

【本字幕由ACELY.CN独家制作发布】


┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!


>>>>>>>【点我下载】<<<<<<<

标签:, ,

您的留言是我最大的支持!

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

※ 本站内容未经允许一律严禁转载!Lynda教程及字幕交流群:214645753
※ 本站文件统一解压密码:acely.cn 或 www.cgsub.com