Lynda-Access 2016 Queries in Depth

1. Ex_Files_Ac2016_QueriesID.zip 32.80 MB
2. 024 Apply functions to text.mp4 23.18 MB
3. 009 Define query criteria.mp4 22.88 MB
4. 008 Modify a query with the design interface.mp4 22.86 MB
5. 018 Obtain parameters from forms.mp4 22.12 MB
6. 013 Explore the property sheet.mp4 20.25 MB
7. 052 Make table, delete, and append queries.mp4 19.39 MB
8. 014 Work with joins.mp4 18.28 MB
9. 023 Use mathematical operators.mp4 18.24 MB
10. 021 Solution - Gather employee emails based on department.mp4 17.96 MB
11. 042 Use the Switch() function.mp4 17.05 MB
12. 005 The H+ Sport database.mp4 16.73 MB
13. 058 Process a column of values with domain functions.mp4 16.54 MB
14. 041 Create an IIf() function.mp4 16.33 MB
15. 017 Understand parameter queries.mp4 16.26 MB
16. 028 Understand the Totals field.mp4 16.24 MB
17. 007 Create a query with the wizard.mp4 15.96 MB
18. 049 Add information to a crosstab query.mp4 15.78 MB
19. 053 Explore the basics of SQL.mp4 15.72 MB
20. 006 Understand queries.mp4 15.06 MB
21. 034 Sort dates chronologically.mp4 15.00 MB
22. 019 Use a combo box to select criteria.mp4 14.82 MB
23. 033 Format dates.mp4 13.88 MB
24. 044 Solution - Calculate sales price for a product line.mp4 13.62 MB
25. 051 Update data with a query.mp4 13.61 MB
26. 039 Solution - Expand order details.mp4 13.15 MB
27. 030 Dates as serial numbers.mp4 12.92 MB
28. 036 Calculate elapsed time with DateDiff().mp4 12.86 MB
29. 032 Date and time functions.mp4 12.61 MB
30. 057 Return records above or below the average.mp4 12.01 MB
31. 055 Nest SQL code in other queries.mp4 11.97 MB
32. 022 Explore the Expression Builder interface.mp4 11.68 MB
33. 027 Summarize data with aggregate functions.mp4 11.63 MB
34. 010 Understand comparison operators.mp4 11.43 MB
35. 045 Find duplicate records.mp4 11.04 MB
36. 037 Calculate time intervals with DateAdd().mp4 10.81 MB
37. 054 Create a union query to join tables.mp4 10.67 MB
38. 060 Solution - Identify the highest and lowest pricing markup.mp4 10.13 MB
39. 046 Identify unmatched records.mp4 9.47 MB
40. 001 Welcome.mp4 8.97 MB
41. 011 Use wildcards in criteria.mp4 8.61 MB
42. 031 Select a range of dates or times.mp4 8.32 MB
43. 012 Rename the column headers.mp4 8.25 MB
44. 016 Solution - Create a select query.mp4 8.05 MB
45. 056 Pull random records from the database.mp4 8.00 MB
46. 047 Create an unmatched records query.mp4 7.12 MB
47. 026 Solution - Convert US dollars to Canadian dollars.mp4 7.12 MB
48. 048 Make a crosstab query.mp4 6.59 MB
49. 035 Obtain today`s date.mp4 5.75 MB
50. 040 IIf() conditional statement.mp4 5.48 MB