Access 2002 (xp) - advanced

Intuition Computer Training

Course

In London

£ 490 + VAT

The best Access courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

use table relationships to best effect. use advanced queries to analyse data. create customised forms and subforms to find the precise data required quickly. use macros to automate the operation of the database. automate exporting data to excel. administer the database using access'' inbuilt functions

Facilities

Location

Start date

London
See map
210 Borough High St, SE1 1JX

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 description
after completing this course, participants will be able to:

  • use table relationships to best effect
  • use advanced queries to analyse data
  • create customised forms and subforms to find the precise data required quickly
  • use macros to automate the operation of the database
  • automate exporting data to excel
  • administer the database using access'' inbuilt functions

topic
revision of design concepts
  • queries
    • calculating
    • autoupdate
    • functions - iif
    • parameter
    • import / link to excel, access and text files
  • relationships
    • join types and referential integrity
  • main and subforms
    • automatic, tailored and switchboard
  • macros
    • create and run macros; use macros with forms and reports - grouped macros; conditional macros; synchronise forms using macros
    • startup options and macros; requery macro action; sendkeys & set value macro actions
  • reports
    • formatting
    • grouping
    • text box calculations
  • export data to excel
    • manual
    • automate with a macro
  • database utilities
    • compact a database
    • back-up a database
    • document a database

See related categories

Access 2002 (xp) - advanced

£ 490 + VAT

The best Access courses

See all

See all