Intuition Computer Training

Access 2002 (xp) - advanced

Intuition Computer Training
In London

£490
+ VAT
Prefer to call the centre directly?
(0)20... More

Important information

Typology Course
Location London
Duration 2 Days
  • Course
  • London
  • Duration:
    2 Days
Description

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 (1)
Where and when
Starts Location
On request
London
210 Borough High St, SE1 1JX, London, England
See map
Starts On request
Location
London
210 Borough High St, SE1 1JX, London, England
See map

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

Students that were interested in this course also looked at...
See all