Menu

    Call us on:
    020 8108 0298

Intermediate Microsoft Access 2010 training coursesIntermediate Microsoft Access 2010 Training Courses

If you’re looking for really great Intermediate Microsoft Access 2010 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Intermediate Access 2010 training course, at your own premises at the same price as a standard course from elsewhere.

On this course, you will increase your skills in designing Microsoft Access tables and forms for data entry, and queries and reports for data output. You will look at creating multi-table queries, crosstab queries, using wildcards in queries and creating calculated fields in queries. You will learn how to create relationships between Access tables. You will learn how to import data from other sources into Microsoft Access. You will also export data out of Access into other applications such as Microsoft Excel.

The JMD Training difference is clear:

  • We come to you - your Intermediate Microsoft Access 2010 training will be given on your site
  • You get to keep the manuals - Intermediate Access training manuals are provided as PDFs
  • We can train using your own Microsoft Access databases
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Organisations who have benefitted from our Intermediate Access 2010 training include:

Aims of the Intermediate Access 2010 course

This course aims to give delegates a greater understanding of MS Access 2010.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Access 2010. They will be able to:

  • Use field properties for protection
  • Understand table relationships and referential integrity
  • Create multi-table queries
  • Use calculations in a query
  • Design custom entry forms
  • Design custom reports

The course is of one day's duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites

Familiarity with the Windows environment, and a basic knowledge of MS Access.

Displaying the Access 2010 database

  • The Navigation pane, customising the Navigation pane
  • Database display

Table design - fields

  • Applying and modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Understanding the consequences of modifying data types such as text, memo, hyperlink, currency, date and time in a field
  • Creating and editing a lookup in a field
  • Creating and editing a validation rule in a field
  • Creating and editing an input mask in a field
  • Applying and modifying default values in a field
  • Setting a mandatory field
  • Fields with multiple values

Table Relationships

  • Understanding the basis for creating a valid relationship
  • Creating a one-to-one or a one-to-may relationship between tables
  • Understanding and modifying a many-to-many relationship between tables
  • Applying inner, outer and self joins
  • Applying and using referential integrity
  • Applying automatic deletion of related records
  • Relating or joining data when designing records
  • Adding fields to tables
  • Field templates

Microsoft Access Query design

  • Grouping information in a query
  • Using a crosstab query
  • Using wildcards in a query
  • Using arithmetic and logical expressions in a query

Form design

  • Using bound and unbound controls
  • Creating and editing a combo box, list box, check box and option groups
  • Inserting a data field to appear within form header or footer on the first page or all pages
  • Stacked and tabular layout controls

Report design

  • Inserting a data field to appear within report header or on footers on the first page or all pages
  • Forcing page breaks for groups on reports

Importing, exporting and linking data

  • Importing text, Excel, csv, dBASE or Paradox documents into an Access 2010 database
  • Exporting data in Excel, txt, dBASE and Paradox formats
  • Linking external data to an Access 2010 database

Request Course Now »

We provide Microsoft Access training courses, Microsoft Office training courses, other IT training courses  and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Intermediate Microsoft Access 2010 training Sydney, Australia, please visit our sister site at http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training/intermediate-access-2010-training