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