Access 2010 - 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 2007 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 transfe

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
• Protecting databases
• Setting options and properties

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