Description

Type

Short course
Location

London

Duration

1 Day

An Advanced guide to Microsoft Access.

Facilities

London

See map

2 Exmoor Street, W10 6BD

Start date

On request

About this course

Requirements

Access 2007: Intermediate or equivalent experience

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Overview
An Advanced guide to Microsoft Access.

Prerequisites
Access 2007: Intermediate or equivalent experience

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

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 2007

See related categories

Contact us

Access advanced

Questions & Answers

Reviews

Course programme

Add similar courses
and compare them to help you choose.

Access advanced

Questions & Answers

Reviews

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.