Access 2007 Technical User

PPi Learning Services

Course

In London

£ 450 + VAT

The best Access courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

This course is designed to give delegates a greater understanding of Table relationships and advanced form features in Access, so that they will be able to develop a front-end application, and to design and use macros.

Facilities

Location

Start date

London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request

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?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Content

Table Relationships

  • Setting table relationships
  • Multivalued Fields
  • Referential Integrity
  • Cascade Updates and Cascade Deletes
  • Linking to other databases

Advanced Queries

  • Updating a table via a query
  • Querying queries
  • IIFstatements

Advanced Forms

  • Main/Subforms
  • Split Forms
  • Stacked and Tabular Layouts

Customising the Navigation Pane

  • Startup options
  • Synchronising forms

Macros

  • Creating standalone and embedded macros
  • Macro actions
  • Managing errors in Macros
  • Error Trapping
  • Using variables in Macros
  • Group macros and conditional macros
  • Assigning macros to command buttons
  • Requery macros
  • SendKeys and SetValue macro actions
  • Exporting data using a macro

See related categories

Access 2007 Technical User

£ 450 + VAT

The best Access courses

See all

See all