Access 2019 Bible

Index

Symbols and Numerics

• Symbols and Numerics

• & (ampersand), parameter queries, 408
• ! (exclamation point), parameter queries, 408
• . (period), parameter queries, 408
• [] (square brackets)
  • parameter queries, 406, 408
  • wildcard, 430
• < > (not equal) comparison operator, 273, 451–452

• = (equal) comparison operator, 273, 451–452

• > (greater than) comparison operator, 274, 451–452
• >= (greater than or equal to) comparison operator, 274, 451–452
• < (less than) comparison operator, 273–274, 451–452
• <= (less than or equal to) comparison operator, 274, 451–452

• + (addition) mathematical operator, 270, 271

• / (division) mathematical operator, 270, 271

• ^ (exponentiation) mathematical operator, 270, 272

• \ (integer division) mathematical operator, 270, 271–272

• * (multiplication) mathematical operator, 270, 271

• ‐ (subtraction) mathematical operator, 270, 271
• & (concatenation) string operator, 275–276

• [!] wildcard, 430

• * (asterisk) wildcard, 430

• # (pound sign) wildcard, 430

• ? (question mark) wildcard, 430

• 1NF (first normal form), 90–93

• 2NF (second normal form), 94
  • decomposition, 97–98
  • entities, 96–98
    • identifying, 94–96
  • exceptions, 98–99
  • update anomalies, 95

• 3NF (third normal form), 99–100

A

• Access, as landing pad for data, 173
• ACE (Access Connectivity Engine), 20, 901–902
  • query optimization, 348–349
• Action Catalog, 747
  • data actions, 749–751
  • data blocks, 748–749
  • macro groups, 748
  • program flow, 748
• action queries, 320
  • append queries, 327–332
    • SQL statements, ...