Microsoft Office training -  Access Querying

Access Training

Microsoft Access Querying Training Course

£375 + VAT for most venues (£495 + VAT for London)

1 day

This one-day course is aimed at people who don't know how to use Access, but have a database that they want to interrogate. The course explains the principles underlying your corporate database (if you bring a copy in, we'll do much more than this), then shows how to create queries to get at the data it contains. Learn how to select data, how to aggregate it and how to create expressions, then at the end of the course see a brief introduction to how forms and reports work.

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

Course Contents

The content of this course are as follows:

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

Covered if time allows If time

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

Covered if time allows If time

Joins

  • Training topicCreating ad hoc joins
  • Training topicTypes of join

Creating forms

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

Creating reports

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

You should already be a confident Windows user to attend this course, but do not need to have used Access before. Note that most people find Access harder to learn than Excel.

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Enjoyed (all 3) courses very much; well paced and delivered. Friendly/approachable trainer. Help when needed but also able to puzzle my way through when I wanted. Interesting subject & look forward to using/developing it."

Amanda Gilby (Coloplast Ltd)

"Great lunches, very enjoyable course at a good speed and perfect mix of lecturing and practical exercises, would definitely recommend Wise Owl."

Kevin Stirrup (Stirrup Computing Services Ltd)

"Very well structured and easy to understand through the examples provided. The trainer was incredibly friendly and engaging making the course a pleasure to attend. Course was recommended by experienced colleagues."

René Küüsvek (PricewaterhouseCoopers Services Ltd.)

"The trainer was great, explained everything and made sure everyone was getting each topic. Made the course fun and informative."

Nicola Hughes (Welsh Ambulance Service NHS Trust)

"Good introductory course. Enjoyed tips on future application of the basics in more advanced ways."

Richard Mansel (Berkeley Group)

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

Related Courses

Access Developers RECOMMENDED

Introduction/Intermediate

3 day course

Access VBA macros

Advanced

2 day course

Other Microsoft Access training resources

Access exercises

Access exercises

If you're just starting to teach yourself Access, have a look at our Access exercises to see if they're for you!

View Access VBA or Access 2010 exercises

Access skills assessment

Access skills assessment

You can assess how well you know Access by doing one of our tests online.

View Test your Access skills skills assessment tests

Access blogs

Access blogs

Have a look at some of our blogs on Microsoft Access, which are full of little nuggets of information!

View Access or VBA macros blogs

This page has 0 threads Add post