种子简介

种子名称： Lynda - Access 2013 Queries In Depth
文件类型： 视频
文件数目： 56个文件
文件大小： 534.64 MB
收录时间： 2017-1-23 17:41
已经下载： 3次
资源热度： 157
最近下载： 2024-11-19 21:29

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:41f38ccf2cf35312a458843dddb6f79a6d5ffe14&dn=Lynda - Access 2013 Queries In Depth 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Lynda - Access 2013 Queries In Depth.torrent

01. Introduction/01_01-Welcome.mp47.29MB

01. Introduction/01_02-Using the exercise files.mp4741.49KB

01. Introduction/01_03-Introducing the database.mp411.14MB

02. Creating Queries in Access/02_01-Understanding queries.mp410.84MB

02. Creating Queries in Access/02_02-Using the Query Wizard.mp410.94MB

02. Creating Queries in Access/02_03-Exploring the design interface.mp410.5MB

03. Creating Simple Select Queries/03_01-Defining criteria.mp416.96MB

03. Creating Simple Select Queries/03_02-Understanding comparison operators.mp45.14MB

03. Creating Simple Select Queries/03_03-Renaming the column headers.mp46.21MB

03. Creating Simple Select Queries/03_04-Exploring the property sheet.mp412.97MB

03. Creating Simple Select Queries/03_05-Working with joins.mp416.67MB

03. Creating Simple Select Queries/03_06-Challenge Find the top ten employees.mp41.62MB

03. Creating Simple Select Queries/03_07-Solution Find the top ten employees.mp47.6MB

04. Creating Parameter Queries/04_01-Understanding parameter queries.mp412.26MB

04. Creating Parameter Queries/04_02-Obtaining parameters from forms.mp413.26MB

04. Creating Parameter Queries/04_03-Creating a combo box.mp415.92MB

04. Creating Parameter Queries/04_04-Challenge Build a query that produces an employee phone list.mp41.71MB

04. Creating Parameter Queries/04_05-Solution Build a query that produces an employee phone list.mp410.33MB

05. Getting Started with Functions/05_01-Exploring the Expression Builder interface.mp47.8MB

05. Getting Started with Functions/05_02-Using mathematical operators.mp415.7MB

05. Getting Started with Functions/05_03-Applying functions to text.mp415.31MB

05. Getting Started with Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp41.45MB

05. Getting Started with Functions/05_05-Solution Convert US dollars to Canadian dollars.mp46.87MB

06. Applying Aggregate Calculations/06_01-Creating aggregate calculations.mp411.27MB

06. Applying Aggregate Calculations/06_02-Understanding the Totals field.mp416.79MB

06. Applying Aggregate Calculations/06_03-Understanding the WHERE clause.mp47.75MB

07. Working with Dates in Queries/07_01-Understanding how dates are stored.mp49.09MB

07. Working with Dates in Queries/07_02-Specifying a range of dates or times.mp48.12MB

07. Working with Dates in Queries/07_03-Using date and time functions.mp416.34MB

07. Working with Dates in Queries/07_04-Formatting dates.mp412.49MB

07. Working with Dates in Queries/07_05-Sorting formatted dates.mp412.87MB

07. Working with Dates in Queries/07_06-Defining today`s date.mp47.56MB

07. Working with Dates in Queries/07_07-Calculating time intervals.mp416.14MB

07. Working with Dates in Queries/07_08-Challenge Collect information on all orders from 2014.mp41.73MB

07. Working with Dates in Queries/07_09-Solution Collect information on all orders from 2014.mp411.68MB

08. Understanding Program Flow Functions/08_01-Introducing IIf.mp43.79MB

08. Understanding Program Flow Functions/08_02-Creating an IIf function.mp412.68MB

08. Understanding Program Flow Functions/08_03-Using the Switch function.mp412.78MB

08. Understanding Program Flow Functions/08_04-Challenge Calculate sales prices for a product line.mp41.42MB

08. Understanding Program Flow Functions/08_05-Solution Calculate sales prices for a product line.mp46.68MB

09. Alternative Query Types/09_01-Finding duplicate records.mp47.57MB

09. Alternative Query Types/09_02-Identifying unmatched records.mp47.96MB

09. Alternative Query Types/09_03-Creating crosstab results.mp413.13MB

09. Alternative Query Types/09_04-Creating backups.mp42.86MB

09. Alternative Query Types/09_05-Creating update queries.mp413.53MB

09. Alternative Query Types/09_06-Making, deleting, and appending records.mp415.19MB

10. Exploring SQL Syntax/10_01-Understanding SQL basics.mp412.84MB

10. Exploring SQL Syntax/10_02-Writing SQL queries.mp49.03MB

10. Exploring SQL Syntax/10_03-Writing a union query.mp49.45MB

10. Exploring SQL Syntax/10_04-Embedding SQL code in queries.mp411.77MB

11. Useful Query Tricks/11_01-Using domain functions.mp416.35MB

11. Useful Query Tricks/11_02-Returning values above or below average.mp49.15MB

11. Useful Query Tricks/11_03-Returning random records from the database.mp45.28MB

11. Useful Query Tricks/11_04-Challenge Find out which products have the highest and lowest markup percentage.mp41.38MB

11. Useful Query Tricks/11_05-Solution Find out which products have the highest and lowest markup percentage.mp48.65MB

12. Conclusion/12_01-Next steps.mp42.07MB