中文名: Access 2007:查詢功能深入講解教程
英文名: Access 2007: Queries in Depth
資源格式: 光盤鏡像
主講人: Adam Wilbert
發行日期: 2010年09月09日
地區: 美國
對白語言: 英語
文字語言: 英文
簡介:

資源簡介
Lynda最新出品的Access 2007: Queries in Depth 深入講解教程.
主講：Adam Wilbert
教程時長：2小時9分
教學光盤提供有配套素材文件.
官網鏈接：http://www.lynda.com/home/DisplayCourse.aspx?lpk2=63146
Microsoft Office Access是由微軟發布的關聯式數據庫管理系統。它結合了 Microsoft Jet Database Engine 和 圖形用戶界面兩項特點，是 Microsoft Office的成員之一。其實Access 也是微軟公司另一個通訊程序的名字，想與 ProComm 以及其他類似程序來競爭。可是事後微軟證實這是個失敗計劃，並且將它中止。數年後他們把名字重新命名於數據庫軟件。另外，Access還是c語言的一個函數名和一種交換機的主干道模式。
Description
In Access 2007: Queries in Depth, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria. Exercise files are included with the course.
Topics include:
Naming conventions and best practices
Working with joins and primary keys
Using comparison operators
Printing query results
Creating parameter queries
Creating calculated fields
Using the Expression Builder
Making conditional statements
Appending queries
Updating queries
截圖預覽：


目錄:
Introduction 02:10
Welcome 00:50
Using the exercise files 00:30
Reviewing the Access interface 00:50
17:30 1. Creating Queries in Access
Query basics 05:37
Naming conventions and best practices 02:19
Using the Query Wizard 04:08
Exploring the Query By Example (QBE) interface 05:26
32:46 2. Creating Simple Select Queries
Defining a single criterion 06:15
Comparison operators 03:42
Defining the column headers with aliases 02:38
Exploring the field properties 03:50
Understanding query level properties 05:33
Working with joins and primary keys 05:10
Printing query results 05:38
07:42 3. Creating Parameter Queries
Understanding parameter queries 04:06
Obtaining parameters from other Access objects 03:36
12:48 4. Creating Calculated Fields
Using Totals to calculate values 02:55
Introducing mathematical operators 03:38
Using mathematical operators 02:09
Using text 04:06
05:06 5. Using the Expression Builder
The Expression Builder interface 02:16
Exploring some built-in functions 02:50
21:44 6. Working with Dates in Queries
Understanding dates as serial numbers 03:30
Specifying a range of dates or times 02:36
Using the Format function 04:34
Using other Date/Time functions 03:01
Defining today's date 02:53
Working with time intervals 03:15
Using the DateDiff function 01:55
10:02 7. Understanding Conditional Statements
Introduction to the conditional IIf function 02:46
Creating an IIf function with the Expression Builder 03:33
Using the Switch function 03:43
18:58 8. Using Alternate Query Types
Using crosstab queries 04:46
Finding duplicate queries 02:11
Finding unmatched queries 02:10
Working with action queries and backups 01:23
Updating queries 02:57
Making tables and appending queries 02:37
Deleting queries 02:54
00:14 Conclusion
Goodbye 00:14

資源來自網絡收集 未經過一一的質量 安全等檢測
只是把收集的資源和各位驢友分享 僅作網絡學習交流使用 請勿用於商業用途 !
希望各位下載的驢友能多多參與分流保源