Lynda-Access 2016 Queries in Depth

1. 004 Explaining the challenges.mp4384.61KB
2. 002 Using the exercise files.mp41.09MB
3. 043 Challenge - Calculate sales price for a product line.mp41.48MB
4. 059 Challenge - Identify the highest and lowest pricing markup.mp41.49MB
5. 025 Challenge - Convert US dollars to Canadian dollars.mp41.54MB
6. 015 Challenge - Create a select query.mp41.7MB
7. 038 Challenge - Expand order details.mp41.74MB
8. 020 Challenge - Gather employee emails based on department.mp41.93MB
9. 061 Next steps.mp42.27MB
10. 050 Create a backup of the database.mp44.25MB
11. 003 Trusting the exercise files.mp44.49MB
12. 029 Use the WHERE clause.mp44.94MB
13. 040 IIf() conditional statement.mp45.36MB
14. 035 Obtain today`s date.mp45.62MB
15. 048 Make a crosstab query.mp46.44MB
16. 026 Solution - Convert US dollars to Canadian dollars.mp46.95MB
17. 047 Create an unmatched records query.mp46.96MB
18. 056 Pull random records from the database.mp47.82MB
19. 016 Solution - Create a select query.mp47.87MB
20. 012 Rename the column headers.mp48.05MB
21. 031 Select a range of dates or times.mp48.13MB
22. 011 Use wildcards in criteria.mp48.41MB
23. 001 Welcome.mp48.76MB
24. 046 Identify unmatched records.mp49.25MB
25. 060 Solution - Identify the highest and lowest pricing markup.mp49.89MB
26. 054 Create a union query to join tables.mp410.42MB
27. 037 Calculate time intervals with DateAdd().mp410.55MB
28. 045 Find duplicate records.mp410.78MB
29. 010 Understand comparison operators.mp411.16MB
30. 027 Summarize data with aggregate functions.mp411.35MB
31. 022 Explore the Expression Builder interface.mp411.41MB
32. 055 Nest SQL code in other queries.mp411.69MB
33. 057 Return records above or below the average.mp411.73MB
34. 032 Date and time functions.mp412.32MB
35. 036 Calculate elapsed time with DateDiff().mp412.55MB
36. 030 Dates as serial numbers.mp412.61MB
37. 039 Solution - Expand order details.mp412.84MB
38. 051 Update data with a query.mp413.29MB
39. 044 Solution - Calculate sales price for a product line.mp413.3MB
40. 033 Format dates.mp413.56MB
41. 019 Use a combo box to select criteria.mp414.47MB
42. 034 Sort dates chronologically.mp414.65MB
43. 006 Understand queries.mp414.7MB
44. 053 Explore the basics of SQL.mp415.35MB
45. 049 Add information to a crosstab query.mp415.41MB
46. 007 Create a query with the wizard.mp415.58MB
47. 028 Understand the Totals field.mp415.86MB
48. 017 Understand parameter queries.mp415.88MB
49. 041 Create an IIf() function.mp415.94MB
50. 058 Process a column of values with domain functions.mp416.15MB
51. 005 The H+ Sport database.mp416.34MB
52. 042 Use the Switch() function.mp416.65MB
53. 021 Solution - Gather employee emails based on department.mp417.54MB
54. 023 Use mathematical operators.mp417.81MB
55. 014 Work with joins.mp417.85MB
56. 052 Make table, delete, and append queries.mp418.94MB
57. 013 Explore the property sheet.mp419.77MB
58. 018 Obtain parameters from forms.mp421.6MB
59. 008 Modify a query with the design interface.mp422.32MB
60. 009 Define query criteria.mp422.34MB
61. 024 Apply functions to text.mp422.64MB