589689.xyz

Lynda-Access 2016 Queries in Depth

  • 收录时间:2018-03-24 10:33:46
  • 文件大小:706MB
  • 下载次数:46
  • 最近下载:2020-04-21 21:40:05
  • 磁力链接:
立即下载 复制链接

文件列表

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