|
·
Querying with SQL
·
SQL and Access
·
Writing SQL statements
·
Attaching SQL queries to controls
·
Advanced queries
·
Creating crosstab queries
·
Creating parameter queries
·
Using action queries
·
Macros
·
Creating, running, and modifying
macros
·
Attaching macros to the events of
database objects
·
Advanced macros
·
Creating macros to provide user
interaction
·
Creating macros that require user
input
·
Creating the AutoKeys and AutoExec
macros
|
·
Creating macros for data transfer
·
Importing, exporting, and linking
objects
·
Importing objects
·
Exporting objects
·
Interacting with the XML documents
·
Linking Access objects
·
Working with Windows SharePoint
Services
·
Database management
·
Optimizing resources
·
Replicating and synchronizing
databases
·
Security fundamentals
·
Protecting databases
·
Encrypting and decrypting databases
·
User-level security |
