Professional Access 2013 Programming

INDEX

INDEX

Symbols & Numbers

& (concatenation) operator, 129

/ (integer division) operator, 129

^ (power) operator, 130

1NF (first normal form), 566–567, 568

2NF (second normal form), 567, 569

2013Team.accdb file, 698

3NF (third normal form), 567, 569–570

32-bit Office versions, 611–613

4NF (fourth normal form), 568

5NF (fifth normal form), 568

64-bit Office versions, 611–613

A

Abs() function, 141

.accdb files, 5, 6

converting .mdb files to, 768–769

linking files to, 572–576

Access 2013

vs. Access 2010, 11

deprecated components, 4–11

new components, 12–13

Access apps. See also web apps

deploying, 772–777

maintaining, 786–791

user-level security, 764–772

Access client

connecting to web apps, 401–412

controls without web app counterparts, 109

security, 482, 509–513

templates

linking to, 467

storing in document libraries, 450–462

Access Data Projects, 5

Access SQL, 581–582

Access Template Library, 449

Account page, backstage, 58–59

ACE database engine, 566, 572, 578

ACM Server, 13

Action Bar, 93–96

custom action button properties, 93–94

default action buttons, 94–95

action buttons

custom, 95–96

default, 94–95

Action Catalog, Macro Designer, 150, 151, 153, 162

action queries, 125

Active Directory (AD), 766

Adhoc environment, 779–780

.adp files, 5

After Delete table event, 158

After Insert table event, 158

After Update table event, 158, 169, 283

agent-based security, 482–483

aggregate queries, 126

AJAX (Asynchronous JavaScript And XML), 309, 311, 348

Allow Zero Length property, 10 ...