START
 

Access Querying

Wise Owl
Course summary
Length: 1 day
Location: Nationwide
Next available date: Enquire for details! - Nationwide

Course Description

Access 2010 Querying Training Course - London, Manchester, BirminghamLearn Querying Skills in Microsoft Access - 1-Day In-House Training

This course equips teams with knowledge of the underlying principles of an Access corporate database and how to use that information to develop queries to get data. They will learn how to select data, how to aggregate it and how to develop expressions. Finally participants will get a brief introduction to how forms and reports work. This in-house training is fully customisable so the team can use a copy of their database and get expert tailored help with more advanced principles.

This course is ideal for teams who aren't familiar with Access but would like to extract data from their database. 

Suitability - Who should attend?

This beginning level training course is suitable for groups who have just begun using the Access programme, and would like to get effective results from the querying feature.

In order to make the most of each delegate's experience, class sizes are kept to a maximum of 6 delegates. 

Outcome / Qualification etc.

Advanced Excel Training CourseUpon completing this beginning Access course, delegates will become able to effectively create queries in Microsoft Access.

Training Course Content

This training course will cover the intermediate and advanced functions of Access, including:

Designing a database

  • Identifying the tables
  • What are relationships?
  • Setting a primary key
  • Using multivalue fields

Creating tables

  • Defining fields
  • The types of field
  • Entering data

Drawing relationships (If time)

  • Creating relationships
  • Referential integrity

Creating queries

  • The query design grid
  • Sorting
  • Setting criteria
  • Combining criteria

Advanced queries

  • Grouping and totalling
  • Creating expressions
  • Parameter queries

Joins (If time)

  • Creating ad hoc joins
  • Types of join

Creating forms

  • Layout and design view
  • Using the form wizard
  • Split forms
  • Creating controls

Creating reports

  • Using the report wizard
  • The group, sort and total pane
  • Report design

Expenses

This course can be delivered on-site for groups, teams or companies. Enquire for details to get an in-house training quote.

Provider: Wise Owl

Wise Owl - Specialist Microsoft Training in London, Birmingham, Manchester and more

The Wise Owl team has made a name for itself delivering specialist Microsoft training for software enthusiasts, by software enthusiasts. With a team of five dedicated full-time trainers, Wise Owl have the knowledge, resources and enthusiasm to deliver Microsoft training...


Read more and show all courses with Provider: Wise Owl

Request information - obligation free

Fill out your details to find out more about Access Querying.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for Wise Owl

Wise Owl


Barlow House
Minshull Street
M1 3DZ Manchester

 Show phone number
www.wiseowl.co.uk

Contact Wise Owl
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Request information

Find out more about this Access Querying course - simply fill out your details:

 
Find more courses here