Lynda - Access 2013 Queries In Depth

1. 01. Introduction/01_01-Welcome.mp47.29MB
2. 01. Introduction/01_02-Using the exercise files.mp4741.49KB
3. 01. Introduction/01_03-Introducing the database.mp411.14MB
4. 02. Creating Queries in Access/02_01-Understanding queries.mp410.84MB
5. 02. Creating Queries in Access/02_02-Using the Query Wizard.mp410.94MB
6. 02. Creating Queries in Access/02_03-Exploring the design interface.mp410.5MB
7. 03. Creating Simple Select Queries/03_01-Defining criteria.mp416.96MB
8. 03. Creating Simple Select Queries/03_02-Understanding comparison operators.mp45.14MB
9. 03. Creating Simple Select Queries/03_03-Renaming the column headers.mp46.21MB
10. 03. Creating Simple Select Queries/03_04-Exploring the property sheet.mp412.97MB
11. 03. Creating Simple Select Queries/03_05-Working with joins.mp416.67MB
12. 03. Creating Simple Select Queries/03_06-Challenge Find the top ten employees.mp41.62MB
13. 03. Creating Simple Select Queries/03_07-Solution Find the top ten employees.mp47.6MB
14. 04. Creating Parameter Queries/04_01-Understanding parameter queries.mp412.26MB
15. 04. Creating Parameter Queries/04_02-Obtaining parameters from forms.mp413.26MB
16. 04. Creating Parameter Queries/04_03-Creating a combo box.mp415.92MB
17. 04. Creating Parameter Queries/04_04-Challenge Build a query that produces an employee phone list.mp41.71MB
18. 04. Creating Parameter Queries/04_05-Solution Build a query that produces an employee phone list.mp410.33MB
19. 05. Getting Started with Functions/05_01-Exploring the Expression Builder interface.mp47.8MB
20. 05. Getting Started with Functions/05_02-Using mathematical operators.mp415.7MB
21. 05. Getting Started with Functions/05_03-Applying functions to text.mp415.31MB
22. 05. Getting Started with Functions/05_04-Challenge Convert US dollars to Canadian dollars.mp41.45MB
23. 05. Getting Started with Functions/05_05-Solution Convert US dollars to Canadian dollars.mp46.87MB
24. 06. Applying Aggregate Calculations/06_01-Creating aggregate calculations.mp411.27MB
25. 06. Applying Aggregate Calculations/06_02-Understanding the Totals field.mp416.79MB
26. 06. Applying Aggregate Calculations/06_03-Understanding the WHERE clause.mp47.75MB
27. 07. Working with Dates in Queries/07_01-Understanding how dates are stored.mp49.09MB
28. 07. Working with Dates in Queries/07_02-Specifying a range of dates or times.mp48.12MB
29. 07. Working with Dates in Queries/07_03-Using date and time functions.mp416.34MB
30. 07. Working with Dates in Queries/07_04-Formatting dates.mp412.49MB
31. 07. Working with Dates in Queries/07_05-Sorting formatted dates.mp412.87MB
32. 07. Working with Dates in Queries/07_06-Defining today`s date.mp47.56MB
33. 07. Working with Dates in Queries/07_07-Calculating time intervals.mp416.14MB
34. 07. Working with Dates in Queries/07_08-Challenge Collect information on all orders from 2014.mp41.73MB
35. 07. Working with Dates in Queries/07_09-Solution Collect information on all orders from 2014.mp411.68MB
36. 08. Understanding Program Flow Functions/08_01-Introducing IIf.mp43.79MB
37. 08. Understanding Program Flow Functions/08_02-Creating an IIf function.mp412.68MB
38. 08. Understanding Program Flow Functions/08_03-Using the Switch function.mp412.78MB
39. 08. Understanding Program Flow Functions/08_04-Challenge Calculate sales prices for a product line.mp41.42MB
40. 08. Understanding Program Flow Functions/08_05-Solution Calculate sales prices for a product line.mp46.68MB
41. 09. Alternative Query Types/09_01-Finding duplicate records.mp47.57MB
42. 09. Alternative Query Types/09_02-Identifying unmatched records.mp47.96MB
43. 09. Alternative Query Types/09_03-Creating crosstab results.mp413.13MB
44. 09. Alternative Query Types/09_04-Creating backups.mp42.86MB
45. 09. Alternative Query Types/09_05-Creating update queries.mp413.53MB
46. 09. Alternative Query Types/09_06-Making, deleting, and appending records.mp415.19MB
47. 10. Exploring SQL Syntax/10_01-Understanding SQL basics.mp412.84MB
48. 10. Exploring SQL Syntax/10_02-Writing SQL queries.mp49.03MB
49. 10. Exploring SQL Syntax/10_03-Writing a union query.mp49.45MB
50. 10. Exploring SQL Syntax/10_04-Embedding SQL code in queries.mp411.77MB
51. 11. Useful Query Tricks/11_01-Using domain functions.mp416.35MB
52. 11. Useful Query Tricks/11_02-Returning values above or below average.mp49.15MB
53. 11. Useful Query Tricks/11_03-Returning random records from the database.mp45.28MB
54. 11. Useful Query Tricks/11_04-Challenge Find out which products have the highest and lowest markup percentage.mp41.38MB
55. 11. Useful Query Tricks/11_05-Solution Find out which products have the highest and lowest markup percentage.mp48.65MB
56. 12. Conclusion/12_01-Next steps.mp42.07MB