1. Урок 1.00:01:03
    Introduction
  2. Урок 2.00:00:30
    Welcome
  3. Урок 3.00:01:45
    Trusting the exercise files
  4. Урок 4.00:00:17
    Explaining the challenges
  5. Урок 5.00:05:39
    The H Sport database
  6. Урок 6.00:04:46
    Understand queries
  7. Урок 7.00:06:40
    Create a query with the wizard
  8. Урок 8.00:08:57
    Modify a query with the design interface
  9. Урок 9.00:08:35
    Define query criteria
  10. Урок 10.00:04:02
    Understand comparison operators
  11. Урок 11.00:03:20
    Use wildcards in criteria
  12. Урок 12.00:03:11
    Rename the column headers
  13. Урок 13.00:07:31
    Explore the property sheet
  14. Урок 14.00:06:33
    Work with joins
  15. Урок 15.00:00:32
    Challenge: Create a select query
  16. Урок 16.00:03:15
    Solution: Create a select query
  17. Урок 17.00:06:12
    Understand parameter queries
  18. Урок 18.00:06:51
    Obtain parameters from forms
  19. Урок 19.00:04:17
    Use a combo box to select criteria
  20. Урок 20.00:00:38
    Challenge: Gather employee emails based on department
  21. Урок 21.00:06:01
    Solution: Gather employee emails based on department
  22. Урок 22.00:04:29
    Explore the Expression Builder interface
  23. Урок 23.00:06:59
    Use mathematical operators
  24. Урок 24.00:08:17
    Apply functions to text
  25. Урок 25.00:00:28
    Challenge: Convert US dollars to Canadian dollars
  26. Урок 26.00:02:37
    Solution: Convert US dollars to Canadian dollars
  27. Урок 27.00:04:30
    Summarize data with aggregate functions
  28. Урок 28.00:05:53
    Understand the Totals field
  29. Урок 29.00:01:54
    Use the WHERE clause
  30. Урок 30.00:04:52
    Dates as serial numbers
  31. Урок 31.00:03:10
    Select a range of dates or times
  32. Урок 32.00:04:42
    Date and time functions
  33. Урок 33.00:05:09
    Format dates
  34. Урок 34.00:05:26
    Sort dates chronologically
  35. Урок 35.00:02:09
    Obtain todays date
  36. Урок 36.00:04:43
    Calculate elapsed time with DateDiff
  37. Урок 37.00:04:00
    Calculate time intervals with DateAdd
  38. Урок 38.00:00:33
    Challenge: Expand order details
  39. Урок 39.00:05:15
    Solution: Expand order details
  40. Урок 40.00:02:20
    IIf conditional statement
  41. Урок 41.00:05:52
    Create an IIf function
  42. Урок 42.00:06:26
    Use the Switch function
  43. Урок 43.00:00:27
    Challenge: Calculate sales price for a product line
  44. Урок 44.00:05:57
    Solution: Calculate sales price for a product line
  45. Урок 45.00:04:20
    Find duplicate records
  46. Урок 46.00:03:31
    Identify unmatched records
  47. Урок 47.00:02:34
    Create an unmatched records query
  48. Урок 48.00:02:35
    Make a crosstab query
  49. Урок 49.00:05:46
    Add information to a crosstab query
  50. Урок 50.00:01:40
    Create a backup of the database
  51. Урок 51.00:04:41
    Update data with a query
  52. Урок 52.00:06:51
    Make table, delete, and append queries
  53. Урок 53.00:05:59
    Explore the basics of SQL
  54. Урок 54.00:03:52
    Create a union query to join tables
  55. Урок 55.00:04:08
    Nest SQL code in other queries
  56. Урок 56.00:02:46
    Pull random records from the database
  57. Урок 57.00:04:08
    Return records above or below the average
  58. Урок 58.00:05:43
    Process a column of values with domain functions
  59. Урок 59.00:00:25
    Challenge: Identify the highest and lowest pricing markup
  60. Урок 60.00:04:14
    Solution: Identify the highest and lowest pricing markup
  61. Урок 61.00:00:46
    Next steps