Microsoft Access 2007 Advanced

Course Overview

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 eventsof database objects

Advanced Macros

• Creating macros to provide user interaction
• Creating macros that require user input
• Creating 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

• Optimising Resources
• Protecting databases
• Setting options and properties

Internet Intergration

• Hyperlink Fields
• Working with Outlook 2007

If booking for more than one delegate, please contact us on 01189 778562 for discounted prices.