种子简介
种子名称:
Lynda - Access 2016 - Queries in Depth
文件类型:
视频
文件数目:
61个文件
文件大小:
674.16 MB
收录时间:
2016-11-11 21:44
已经下载:
3次
资源热度:
133
最近下载:
2024-11-3 03:54
下载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