Code24Lab
Menu
Courses Categories Guides Pricing Log in Sign up

Null, Nz and Aggregates: Where Rows Silently Vanish

Lesson 4 of 22 Lab 🔒 Locked

Lessons in this course

  1. The Access SQL Dialect: IIf, TOP and Saved QueriesLabFree
  2. Dates in Access SQL: #Literals#, DateAdd and DateDiffLab Locked
  3. LIKE in Access: *, ?, # and the ANSI-92 TrapLab Locked
  4. Null, Nz and Aggregates: Where Rows Silently VanishLab Locked
  5. Totals Queries: Group By, Where vs HAVING, First/LastLab Locked
  6. IIf and Switch: Conditional Logic Without CASELab Locked
  7. Crosstab Queries: TRANSFORM … PIVOTLab Locked
  8. Joins the Access Way: Parentheses, Unmatched, Yes/NoLab Locked
  9. Subqueries: the NOT IN + Null Trap and Correlated QueriesLab Locked
  10. Action Queries: Update, Delete, Append, Make-TableLab Locked
  11. Parameter Queries: Typed PARAMETERS and Safe VBALab Locked
  12. First Normal Form: Kill the Repeating GroupLab Locked
  13. Second Normal Form: Partial Dependencies and AnomaliesLab Locked
  14. Third Normal Form: Transitive DependenciesLab Locked
  15. Data Types and Sizes: Currency, Long Integer and the 2 GB LimitLab Locked
  16. Referential Integrity, Cascades and OrphansLab Locked
  17. Indexes and Performance: Selectivity, Seeks and ScansLab Locked
  18. Split Databases: Front-End, Back-End and Network CostLab Locked
  19. Linked Tables: Connect Strings, UNC Paths and RelinkingLab Locked
  20. VBA Essentials: Tracing a DAO Recordset LoopLab Locked
  21. Data Quality: Validation Rules, Unique Indexes, DuplicatesLab Locked
  22. Final Project: The Monthly Net Revenue ReportLab Locked