Training Calendar

Advanced Access

Instructor: Computer Training of America
Fee: $314.10

Please contact Michele Jackson at 877-662-6444 ext. 3004 for scheduling information


Advanced Access will cover the following:

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


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