Access 2003 - Advanced level

This course can be run as an onsite Access course anywhere in England and Wales, and as a scheduled course at our Bristol and Swindon training centres.

Call 0845 485 1173 today for more details

You can view this course outline as a PDF for printing

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

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message