Access 2003 - Advanced level
Categories: Microsoft Access
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Access 2003 - Advanced level

Objectives
After completing this course you will know how to:
- Use SQL
- Create Cross-tab queries, parameter queries and action queries
- Create and run macros
- Use more advanced macros
- Import and export data
- Use database utilities
- Protect a database

Pre-requisites
- Experience of Windows 2000 or later.
- Attendance on Access 2003 Intermediate course or equivalent

Course Contents
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




 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£250
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).