Lynda - Access 2013 Queries In Depth

1. 03. Creating Simple Select Queries/03_01-Defining criteria.mp4 16.96 MB
2. 06. Applying Aggregate Calculations/06_02-Understanding the Totals field.mp4 16.79 MB
3. 03. Creating Simple Select Queries/03_05-Working with joins.mp4 16.67 MB
4. 11. Useful Query Tricks/11_01-Using domain functions.mp4 16.35 MB
5. 07. Working with Dates in Queries/07_03-Using date and time functions.mp4 16.34 MB
6. 07. Working with Dates in Queries/07_07-Calculating time intervals.mp4 16.14 MB
7. 04. Creating Parameter Queries/04_03-Creating a combo box.mp4 15.92 MB
8. 05. Getting Started with Functions/05_02-Using mathematical operators.mp4 15.70 MB
9. 05. Getting Started with Functions/05_03-Applying functions to text.mp4 15.31 MB
10. 09. Alternative Query Types/09_06-Making, deleting, and appending records.mp4 15.19 MB
11. 09. Alternative Query Types/09_05-Creating update queries.mp4 13.53 MB
12. 04. Creating Parameter Queries/04_02-Obtaining parameters from forms.mp4 13.26 MB
13. 09. Alternative Query Types/09_03-Creating crosstab results.mp4 13.13 MB
14. 03. Creating Simple Select Queries/03_04-Exploring the property sheet.mp4 12.97 MB
15. 07. Working with Dates in Queries/07_05-Sorting formatted dates.mp4 12.87 MB
16. 10. Exploring SQL Syntax/10_01-Understanding SQL basics.mp4 12.84 MB
17. 08. Understanding Program Flow Functions/08_03-Using the Switch function.mp4 12.78 MB
18. 08. Understanding Program Flow Functions/08_02-Creating an IIf function.mp4 12.68 MB
19. 07. Working with Dates in Queries/07_04-Formatting dates.mp4 12.50 MB
20. 04. Creating Parameter Queries/04_01-Understanding parameter queries.mp4 12.26 MB
21. 10. Exploring SQL Syntax/10_04-Embedding SQL code in queries.mp4 11.77 MB
22. 07. Working with Dates in Queries/07_09-Solution Collect information on all orders from 2014.mp4 11.68 MB
23. Exercice Files/Ex_Files_Access2013_QiD.zip 11.68 MB
24. 06. Applying Aggregate Calculations/06_01-Creating aggregate calculations.mp4 11.27 MB
25. 01. Introduction/01_03-Introducing the database.mp4 11.15 MB
26. 02. Creating Queries in Access/02_02-Using the Query Wizard.mp4 10.94 MB
27. 02. Creating Queries in Access/02_01-Understanding queries.mp4 10.84 MB
28. 02. Creating Queries in Access/02_03-Exploring the design interface.mp4 10.50 MB
29. 04. Creating Parameter Queries/04_05-Solution Build a query that produces an employee phone list.mp4 10.33 MB
30. 10. Exploring SQL Syntax/10_03-Writing a union query.mp4 9.45 MB
31. 11. Useful Query Tricks/11_02-Returning values above or below average.mp4 9.15 MB
32. 07. Working with Dates in Queries/07_01-Understanding how dates are stored.mp4 9.09 MB
33. 10. Exploring SQL Syntax/10_02-Writing SQL queries.mp4 9.03 MB
34. 11. Useful Query Tricks/11_05-Solution Find out which products have the highest and lowest markup percentage.mp4 8.65 MB
35. 07. Working with Dates in Queries/07_02-Specifying a range of dates or times.mp4 8.12 MB
36. 09. Alternative Query Types/09_02-Identifying unmatched records.mp4 7.96 MB
37. 05. Getting Started with Functions/05_01-Exploring the Expression Builder interface.mp4 7.80 MB
38. 06. Applying Aggregate Calculations/06_03-Understanding the WHERE clause.mp4 7.75 MB
39. 03. Creating Simple Select Queries/03_07-Solution Find the top ten employees.mp4 7.60 MB
40. 09. Alternative Query Types/09_01-Finding duplicate records.mp4 7.57 MB
41. 07. Working with Dates in Queries/07_06-Defining today`s date.mp4 7.56 MB
42. 01. Introduction/01_01-Welcome.mp4 7.29 MB
43. 05. Getting Started with Functions/05_05-Solution Convert US dollars to Canadian dollars.mp4 6.87 MB
44. 08. Understanding Program Flow Functions/08_05-Solution Calculate sales prices for a product line.mp4 6.68 MB
45. 03. Creating Simple Select Queries/03_03-Renaming the column headers.mp4 6.21 MB
46. 11. Useful Query Tricks/11_03-Returning random records from the database.mp4 5.28 MB
47. 03. Creating Simple Select Queries/03_02-Understanding comparison operators.mp4 5.14 MB
48. 08. Understanding Program Flow Functions/08_01-Introducing IIf.mp4 3.79 MB
49. 09. Alternative Query Types/09_04-Creating backups.mp4 2.86 MB
50. 12. Conclusion/12_01-Next steps.mp4 2.07 MB