种子简介

种子名称： Lynda - Access 2016 - Queries in Depth
文件类型： 视频
文件数目： 61个文件
文件大小： 674.16 MB
收录时间： 2016-11-11 21:44
已经下载： 3次
资源热度： 142
最近下载： 2024-11-20 15:41

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

Lynda - Access 2016 - Queries in Depth.torrent

01. Introduction/01_01-Welcome.mp48.76MB

01. Introduction/01_03-Trusting the exercise files.mp44.49MB

01. Introduction/01_02-Using the exercise files.mp41.09MB

01. Introduction/01_04-Explaining the challenges.mp4384.61KB

02. Introduction to Access Queries/02_04-Modify a query with the design interface.mp422.32MB

02. Introduction to Access Queries/02_01-The H Sport database.mp416.34MB

02. Introduction to Access Queries/02_03-Create a query with the wizard.mp415.58MB

02. Introduction to Access Queries/02_02-Understand queries.mp414.7MB

03. Creating Simple Select Queries/03_01-Define query criteria.mp422.34MB

03. Creating Simple Select Queries/03_05-Explore the property sheet.mp419.77MB

03. Creating Simple Select Queries/03_06-Work with joins.mp417.85MB

03. Creating Simple Select Queries/03_02-Understand comparison operators.mp411.16MB

03. Creating Simple Select Queries/03_03-Use wildcards in criteria.mp48.41MB

03. Creating Simple Select Queries/03_04-Rename the column headers.mp48.05MB

03. Creating Simple Select Queries/03_08-Solution Create a select query.mp47.87MB

03. Creating Simple Select Queries/03_07-Challenge Create a select query.mp41.7MB

04. Creating Parameter Queries/04_02-Obtain parameters from forms.mp421.6MB

04. Creating Parameter Queries/04_05-Solution Gather employee emails based on department.mp417.54MB

04. Creating Parameter Queries/04_01-Understand parameter queries.mp415.88MB

04. Creating Parameter Queries/04_03-Use a combo box to select criteria.mp414.47MB

04. Creating Parameter Queries/04_04-Challenge Gather employee emails based on department.mp41.93MB

05. Use the BuiltIn Functions/05_03-Apply functions to text.mp422.64MB

05. Use the BuiltIn Functions/05_02-Use mathematical operators.mp417.81MB

05. Use the BuiltIn Functions/05_01-Explore the Expression Builder interface.mp411.41MB

05. Use the BuiltIn Functions/05_05-Solution Convert US dollars to Canadian dollars.mp46.95MB

05. Use the BuiltIn Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp41.54MB

06. Aggregating Records with a Totals Query/06_02-Understand the Totals field.mp415.86MB

06. Aggregating Records with a Totals Query/06_01-Summarize data with aggregate functions.mp411.35MB

06. Aggregating Records with a Totals Query/06_03-Use the WHERE clause.mp44.94MB

07. Working with Dates in Queries/07_05-Sort dates chronologically.mp414.65MB

07. Working with Dates in Queries/07_04-Format dates.mp413.56MB

07. Working with Dates in Queries/07_10-Solution Expand order details.mp412.84MB

07. Working with Dates in Queries/07_01-Dates as serial numbers.mp412.61MB

07. Working with Dates in Queries/07_07-Calculate elapsed time with DateDiff.mp412.55MB

07. Working with Dates in Queries/07_03-Date and time functions.mp412.32MB

07. Working with Dates in Queries/07_08-Calculate time intervals with DateAdd.mp410.55MB

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

07. Working with Dates in Queries/07_06-Obtain todays date.mp45.62MB

07. Working with Dates in Queries/07_09-Challenge Expand order details.mp41.74MB

08. Understanding Program Flow Functions/08_03-Use the Switch function.mp416.65MB

08. Understanding Program Flow Functions/08_02-Create an IIf function.mp415.94MB

08. Understanding Program Flow Functions/08_05-Solution Calculate sales price for a product line.mp413.3MB

08. Understanding Program Flow Functions/08_01-IIf conditional statement.mp45.36MB

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

09. Alternative Query Types/09_08-Make table, delete, and append queries.mp418.94MB

09. Alternative Query Types/09_05-Add information to a crosstab query.mp415.41MB

09. Alternative Query Types/09_07-Update data with a query.mp413.29MB

09. Alternative Query Types/09_01-Find duplicate records.mp410.78MB

09. Alternative Query Types/09_02-Identify unmatched records.mp49.25MB

09. Alternative Query Types/09_03-Create an unmatched records query.mp46.96MB

09. Alternative Query Types/09_04-Make a crosstab query.mp46.44MB

09. Alternative Query Types/09_06-Create a backup of the database.mp44.25MB

10. Writing Queries with Structured Query Language/10_01-Explore the basics of SQL.mp415.35MB

10. Writing Queries with Structured Query Language/10_03-Nest SQL code in other queries.mp411.69MB

10. Writing Queries with Structured Query Language/10_02-Create a union query to join tables.mp410.42MB

11. Useful Query Tricks/11_03-Process a column of values with domain functions.mp416.15MB

11. Useful Query Tricks/11_02-Return records above or below the average.mp411.73MB

11. Useful Query Tricks/11_05-Solution Identify the highest and lowest pricing markup.mp49.89MB

11. Useful Query Tricks/11_01-Pull random records from the database.mp47.82MB

11. Useful Query Tricks/11_04-Challenge Identify the highest and lowest pricing markup.mp41.49MB

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