WiseOwl Training - Established 1992
This page has 0 threads   |  Add post
Microsoft Office training - Access Developers

Access Training

Access Developers (3 days)

£725 + VAT for most venues (£875 + VAT for London)

The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.

The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.

If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking  (or consider an onsite Access training course).

Course Contents

Designing a database

  • Training topicIdentifying the tables
  • Training topicWhat are relationships?
  • Training topicSetting a primary key
  • Training topicUsing multivalue fields

Creating tables

  • Training topicDefining fields
  • Training topicThe types of field
  • Training topicEntering data

Different field types

  • Training topicCreating attachments
  • Training topicRich text format fields
  • Training topicDate fields (using calendars)
  • Training topicCalculated fields

Importing data

  • Training topicImporting from Excel
  • Training topicMaking tables from Excel

Covered if time allows If time

Table rules

  • Training topicRecord-level validation
  • Training topicBasic triggers

Drawing relationships

  • Training topicCreating relationships
  • Training topicReferential integrity

Creating queries

  • Training topicThe query design grid
  • Training topicSorting
  • Training topicSetting criteria
  • Training topicCombining criteria

Advanced queries

  • Training topicGrouping and totalling
  • Training topicCreating expressions
  • Training topicParameter queries

Joins

  • Training topicCreating ad hoc joins
  • Training topicTypes of join

Covered if time allows If time

Crosstab queries

  • Training topicColumns, rows and values
  • Training topicOverriding column headings

Covered if time allows If time

Action queries

  • Training topicMaking tables
  • Training topicUpdating records
  • Training topicAppending records
  • Training topicDeleting records

Creating forms

  • Training topicLayout and design view
  • Training topicUsing the form wizard
  • Training topicSplit forms
  • Training topicCreating controls

Covered if time allows If time

Advanced controls

  • Training topicMultitabs
  • Training topicWebbrowser controls
  • Training topicNavigation bars

Creating reports

  • Training topicUsing the report wizard
  • Training topicThe group, sort and total pane
  • Training topicReport design

Creating subforms

  • Training topicMultiple item forms
  • Training topicCreating subforms
  • Training topicTidying up subforms

Basic VBA coding

  • Training topicCreating modules
  • Training topicUsing Project Explorer
  • Training topicWriting comments
  • Training topicIndenting code

Uses of VBA

  • Training topicForm validation
  • Training topicCriteria forms
  • Training topicA simple menu system

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"I really enjoyed the course, it was the right balance of practical and exercises, with supported leaning on topics covered. The handouts are very detailed too. The memory sticks are a nice touch too."

Ruth Botwright (Skipton Building Society)

"Very well planned course. Learnt all the basics and am confident that I will be able to build on this."

Nikola Slifkin (Electricity North West Ltd)

"Very useful."

Simon Haddock (Helix Trading Ltd)

"This was a great course and pitched perfectly for my needs. I have been on a course where I was the only delegate and it descended into farce - not the case here, the trainer managed this superbly! Faultless."

Neil Meredith (Costcutter Supermarkets Group Ltd)

"Course venue is excellent and no more than 6 in a group is excellent student/trainer ratio. Course covers all parts of basic SQL."

Andrew Wilson (Salford Royal NHS Foundation Trust)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You do not need to have used Access before to attend this course, although you should be a confident computer user.

Related Courses

Access Querying

Basic

1 day course

Access VBA macros RECOMMENDED

Advanced

2 day course

Advanced VBA

Guru level

2 day course

Other Microsoft Access database training resources

Access exercises

Access exercises

To give you a chance to see whether this 3-day Access course is for you, we've published all of our Microsoft Access exercises online.

View Access VBA or Access 2010 exercises

Access skills assessment

Access skills assessment

You may find it useful to do one of our Access skills assessment tests, to help you know what you don't know (to misquote Donald Rumsfeld …).

View Access or Access VBA skills assessment tests

Access blogs

Access blogs

In addtion to other Access training resources, you may find some of our Access blogs useful.

View Access or VBA macros blogs

This page has 0 threads Add post

© Wise Owl Business Solutions Ltd 2017. All Rights Reserved

Sitemap

Terms & Conditions

Privacy policy