Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Access 2016: Queries in Depth, а также все другие курсы, прямо сейчас!
• Урок 1. 00:01:03
Introduction
• Урок 2. 00:00:30
Welcome
• Урок 3. 00:01:45
Trusting the exercise files
• Урок 4. 00:00:17
Explaining the challenges
• Урок 5. 00:05:39
The H Sport database
• Урок 6. 00:04:46
Understand queries
• Урок 7. 00:06:40
Create a query with the wizard
• Урок 8. 00:08:57
Modify a query with the design interface
• Урок 9. 00:08:35
Define query criteria
• Урок 10. 00:04:02
Understand comparison operators
• Урок 11. 00:03:20
Use wildcards in criteria
• Урок 12. 00:03:11
Rename the column headers
• Урок 13. 00:07:31
Explore the property sheet
• Урок 14. 00:06:33
Work with joins
• Урок 15. 00:00:32
Challenge: Create a select query
• Урок 16. 00:03:15
Solution: Create a select query
• Урок 17. 00:06:12
Understand parameter queries
• Урок 18. 00:06:51
Obtain parameters from forms
• Урок 19. 00:04:17
Use a combo box to select criteria
• Урок 20. 00:00:38
Challenge: Gather employee emails based on department
• Урок 21. 00:06:01
Solution: Gather employee emails based on department
• Урок 22. 00:04:29
Explore the Expression Builder interface
• Урок 23. 00:06:59
Use mathematical operators
• Урок 24. 00:08:17
Apply functions to text
• Урок 25. 00:00:28
Challenge: Convert US dollars to Canadian dollars
• Урок 26. 00:02:37
Solution: Convert US dollars to Canadian dollars
• Урок 27. 00:04:30
Summarize data with aggregate functions
• Урок 28. 00:05:53
Understand the Totals field
• Урок 29. 00:01:54
Use the WHERE clause
• Урок 30. 00:04:52
Dates as serial numbers
• Урок 31. 00:03:10
Select a range of dates or times
• Урок 32. 00:04:42
Date and time functions
• Урок 33. 00:05:09
Format dates
• Урок 34. 00:05:26
Sort dates chronologically
• Урок 35. 00:02:09
Obtain todays date
• Урок 36. 00:04:43
Calculate elapsed time with DateDiff
• Урок 37. 00:04:00
Calculate time intervals with DateAdd
• Урок 38. 00:00:33
Challenge: Expand order details
• Урок 39. 00:05:15
Solution: Expand order details
• Урок 40. 00:02:20
IIf conditional statement
• Урок 41. 00:05:52
Create an IIf function
• Урок 42. 00:06:26
Use the Switch function
• Урок 43. 00:00:27
Challenge: Calculate sales price for a product line
• Урок 44. 00:05:57
Solution: Calculate sales price for a product line
• Урок 45. 00:04:20
Find duplicate records
• Урок 46. 00:03:31
Identify unmatched records
• Урок 47. 00:02:34
Create an unmatched records query
• Урок 48. 00:02:35
Make a crosstab query
• Урок 49. 00:05:46
Add information to a crosstab query
• Урок 50. 00:01:40
Create a backup of the database
• Урок 51. 00:04:41
Update data with a query
• Урок 52. 00:06:51
Make table, delete, and append queries
• Урок 53. 00:05:59
Explore the basics of SQL
• Урок 54. 00:03:52
Create a union query to join tables
• Урок 55. 00:04:08
Nest SQL code in other queries
• Урок 56. 00:02:46
Pull random records from the database
• Урок 57. 00:04:08
Return records above or below the average
• Урок 58. 00:05:43
Process a column of values with domain functions
• Урок 59. 00:00:25
Challenge: Identify the highest and lowest pricing markup
• Урок 60. 00:04:14
Solution: Identify the highest and lowest pricing markup
• Урок 61. 00:00:46
Next steps