會員登錄
軟體搜尋
您的位置： 網站首頁 >> 專業知識教學 >> 電腦教學認證 >> 商品詳情
商品詳情
|
商品編號：TIC2091 碟片數量：1片 銷售價格：200 瀏覽次數：37196 
【轉載TXT文檔】 |
您可能也喜歡：
TIC3086--新多益滿分講師授課：全新制NEW TOEIC多益閱讀高分關鍵＋狠準擬真試題＋解析 繁體中文教學版
DVDP4341--Unreal Engine 5 The Complete Automotive Cinematic Course (UE5 電影感車輛製作教學) 英文教學版(DVD9一片裝 此片售價200元)
DVD29802--Udemy - Blender Essential From Beginner to 3D Masterclass (B3D基礎教學) 英文教學版(DVD一片裝)
DVDP4340--哈佛心理學家劉軒線上課程 繁體中文發音中文配音版(DVD9一片裝 此片售價200元)
TIC3083--預測未來的極簡統計學 (運用統計學 才能精準解析過去、洞悉未來局勢！) PDF電子書 繁體中文版
商品描述
Lynda com Access 2010 Queries in Depth 深入認識Access 2010的查詢功能視頻教學 英文正式版
![]()
軟體簡介:
Lynda.com 出品的時長3小時02分鐘的深入認識Access 2010的查詢功能視頻教學。
由Adam Wilbert講述如何建立並最大能力的利用查詢功能把原始資料轉化為可用
資訊。內容包括建立查詢，執行計算，利用內建的Access功能進一步細化查詢結
果，並確認是否最佳運行或基於一標準範圍內需要改善的地方。本教學附帶練習
文件。
目錄:
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
軟體簡介:
Lynda.com 出品的時長3小時02分鐘的深入認識Access 2010的查詢功能視頻教學。
由Adam Wilbert講述如何建立並最大能力的利用查詢功能把原始資料轉化為可用
資訊。內容包括建立查詢，執行計算，利用內建的Access功能進一步細化查詢結
果，並確認是否最佳運行或基於一標準範圍內需要改善的地方。本教學附帶練習
文件。
目錄:
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