Lynda - Access 2016 - Queries in Depth

1. 01. Introduction/01_01-Welcome.mp48.76MB
2. 01. Introduction/01_03-Trusting the exercise files.mp44.49MB
3. 01. Introduction/01_02-Using the exercise files.mp41.09MB
4. 01. Introduction/01_04-Explaining the challenges.mp4384.61KB
5. 02. Introduction to Access Queries/02_04-Modify a query with the design interface.mp422.32MB
6. 02. Introduction to Access Queries/02_01-The H Sport database.mp416.34MB
7. 02. Introduction to Access Queries/02_03-Create a query with the wizard.mp415.58MB
8. 02. Introduction to Access Queries/02_02-Understand queries.mp414.7MB
9. 03. Creating Simple Select Queries/03_01-Define query criteria.mp422.34MB
10. 03. Creating Simple Select Queries/03_05-Explore the property sheet.mp419.77MB
11. 03. Creating Simple Select Queries/03_06-Work with joins.mp417.85MB
12. 03. Creating Simple Select Queries/03_02-Understand comparison operators.mp411.16MB
13. 03. Creating Simple Select Queries/03_03-Use wildcards in criteria.mp48.41MB
14. 03. Creating Simple Select Queries/03_04-Rename the column headers.mp48.05MB
15. 03. Creating Simple Select Queries/03_08-Solution Create a select query.mp47.87MB
16. 03. Creating Simple Select Queries/03_07-Challenge Create a select query.mp41.7MB
17. 04. Creating Parameter Queries/04_02-Obtain parameters from forms.mp421.6MB
18. 04. Creating Parameter Queries/04_05-Solution Gather employee emails based on department.mp417.54MB
19. 04. Creating Parameter Queries/04_01-Understand parameter queries.mp415.88MB
20. 04. Creating Parameter Queries/04_03-Use a combo box to select criteria.mp414.47MB
21. 04. Creating Parameter Queries/04_04-Challenge Gather employee emails based on department.mp41.93MB
22. 05. Use the BuiltIn Functions/05_03-Apply functions to text.mp422.64MB
23. 05. Use the BuiltIn Functions/05_02-Use mathematical operators.mp417.81MB
24. 05. Use the BuiltIn Functions/05_01-Explore the Expression Builder interface.mp411.41MB
25. 05. Use the BuiltIn Functions/05_05-Solution Convert US dollars to Canadian dollars.mp46.95MB
26. 05. Use the BuiltIn Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp41.54MB
27. 06. Aggregating Records with a Totals Query/06_02-Understand the Totals field.mp415.86MB
28. 06. Aggregating Records with a Totals Query/06_01-Summarize data with aggregate functions.mp411.35MB
29. 06. Aggregating Records with a Totals Query/06_03-Use the WHERE clause.mp44.94MB
30. 07. Working with Dates in Queries/07_05-Sort dates chronologically.mp414.65MB
31. 07. Working with Dates in Queries/07_04-Format dates.mp413.56MB
32. 07. Working with Dates in Queries/07_10-Solution Expand order details.mp412.84MB
33. 07. Working with Dates in Queries/07_01-Dates as serial numbers.mp412.61MB
34. 07. Working with Dates in Queries/07_07-Calculate elapsed time with DateDiff.mp412.55MB
35. 07. Working with Dates in Queries/07_03-Date and time functions.mp412.32MB
36. 07. Working with Dates in Queries/07_08-Calculate time intervals with DateAdd.mp410.55MB
37. 07. Working with Dates in Queries/07_02-Select a range of dates or times.mp48.13MB
38. 07. Working with Dates in Queries/07_06-Obtain todays date.mp45.62MB
39. 07. Working with Dates in Queries/07_09-Challenge Expand order details.mp41.74MB
40. 08. Understanding Program Flow Functions/08_03-Use the Switch function.mp416.65MB
41. 08. Understanding Program Flow Functions/08_02-Create an IIf function.mp415.94MB
42. 08. Understanding Program Flow Functions/08_05-Solution Calculate sales price for a product line.mp413.3MB
43. 08. Understanding Program Flow Functions/08_01-IIf conditional statement.mp45.36MB
44. 08. Understanding Program Flow Functions/08_04-Challenge Calculate sales price for a product line.mp41.48MB
45. 09. Alternative Query Types/09_08-Make table, delete, and append queries.mp418.94MB
46. 09. Alternative Query Types/09_05-Add information to a crosstab query.mp415.41MB
47. 09. Alternative Query Types/09_07-Update data with a query.mp413.29MB
48. 09. Alternative Query Types/09_01-Find duplicate records.mp410.78MB
49. 09. Alternative Query Types/09_02-Identify unmatched records.mp49.25MB
50. 09. Alternative Query Types/09_03-Create an unmatched records query.mp46.96MB
51. 09. Alternative Query Types/09_04-Make a crosstab query.mp46.44MB
52. 09. Alternative Query Types/09_06-Create a backup of the database.mp44.25MB
53. 10. Writing Queries with Structured Query Language/10_01-Explore the basics of SQL.mp415.35MB
54. 10. Writing Queries with Structured Query Language/10_03-Nest SQL code in other queries.mp411.69MB
55. 10. Writing Queries with Structured Query Language/10_02-Create a union query to join tables.mp410.42MB
56. 11. Useful Query Tricks/11_03-Process a column of values with domain functions.mp416.15MB
57. 11. Useful Query Tricks/11_02-Return records above or below the average.mp411.73MB
58. 11. Useful Query Tricks/11_05-Solution Identify the highest and lowest pricing markup.mp49.89MB
59. 11. Useful Query Tricks/11_01-Pull random records from the database.mp47.82MB
60. 11. Useful Query Tricks/11_04-Challenge Identify the highest and lowest pricing markup.mp41.49MB
61. 12. Conclusion/12_01-Next steps.mp42.27MB