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 - Importing objects
- Exporting objects
- Interacting with XML documents
- Linking Access objects
- Working with Windows SharePoint Services
Database management - Optimizing resources
- Protecting databases
- Setting options and properties
Internet integration - Hyperlink fields
- Working with Outlook 2007
(Black and White manual)
|