Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай 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