Access 2002 (xp) - intermediate

Intuition Computer Training

Course

In London

£ 490 + VAT

The best Access courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Location

    London

  • Duration

    2 Days

enhance the accuracy of data entry. use a variety of techniques to extract data expertly using queries. use queries to copy, move, change, delete and summarise records. create forms to find information quickly and precisely. create and modify reports to tailor them to your own needs and appear more professional. import data into access from a variety of sources. export data into excel and word. Suitable for: users who need to become more expert in the use of access to extract the correct information stored in an access database in a timely and effective manner; to create professional-looking reports

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
target audience:
users who need to become more expert in the use of access to extract the correct information stored in an access database in a timely and effective manner; to create professional-looking reports

after completing this course, participants will be able to:
  • enhance the accuracy of data entry
  • use a variety of techniques to extract data expertly using queries
  • use queries to copy, move, change, delete and summarise records
  • create forms to find information quickly and precisely
  • create and modify reports to tailor them to your own needs and appear more professional
  • import data into access from a variety of sources
  • export data into excel and word
topic
  • database design concepts-including multiple tables and their relationships
  • importing and linking data-identify different parts of the screen; menus and toolbars; office assistant
  • tables-using properties for data validation, controlling formatting, indexing to speed up data retrieval
  • queries-calculating, autoupdate, functions e.g. iif, parameter, top values, using query properties; action queries - make table, delete, append, update; crosstab
  • forms and subforms-to enter data quickly and accurately and update more than one table at a time, find data conveniently; modify design; adding calculations; adding combo boxes; adding data validation; adding images; chart wizard
  • reports-modify reports to enhance appearance and draw together data from more than one source; parameter reports to simplify database operation; mailing labels
  • data access pages-create data access pages using a wizard

See related categories

Access 2002 (xp) - intermediate

£ 490 + VAT

The best Access courses

See all

See all