1. RELEASE
  3. TITLE: ACCESS 2013: QUERIES IN DEPTH
  5. PUBLISHER....: LYNDA LANGUAGE......: ENGLISH
  6. LINK.........: http://is.gd/cnxlhj RELEASE TYPE..: RETAIL
  7. AUTHOR.......: ADAM WILBERT RELEASE DATE..: 2014.07.24
  8. FORMAT.......: ISO STORE DATE....: 2014.07.24
  9. LEVEL........: INTERMEDIATE ISO CHECKSUM..: 4A590093
  10. ISO SIZE.....: 573.014.016 B DISKCOUNT.....: 11 X 50MB
  11. RUNTIME......: 4H 23M SAVED MONEY...: YOU DID!
  12. DISKNAME.....: keiso_la2013qind
  14. TUTORIAL
  16. Get more out of your Access database than just the data you put
  17. into it, using queries-tools that help you translate complex raw
  18. data into information you can use to make better decisions. Join
  19. Adam Wilbert, as he explains how to create real-world queries to
  20. filter and sort data, perform calculations, and refine query
  21. results with built-in functions, all while offering challenges
  22. that help you master the material. Find out how to identify top
  23. performers, automate repetitive analysis tasks, and increase
  24. accuracy and consistency in your database using program flow
  25. functions.
  27. Topics include:
  29. * Defining criteria
  31. * Understanding comparison operators
  33. * Using joins
  35. * Creating parameter queries
  37. * Using Expression Builder to work with functions
  39. * Working with dates and times
  41. * Creating conditional statements
  43. * Finding duplicate records
  45. * Creating backups
  47. * Making, deleting, and appending records
  49. * Understanding SQL basics and writing SQL queries
  51. * Useful query tricks
  53. NOTES/NEWS
  55. RESPECT
  57. WE PAY OUR RESPECT TO:
  59. BBL - DDU - EEn - iNTENSiTY - JGT - RBS
  61. GREETINGS FLY OUT TO:
  63. DVT - LAXiTY - SO
  65. TEAM KYRIE ELEISON!
  67. Loreen 2013
  69. kE^2013!