Microsoft Access Queries

Course Details

 

This course is designed for people who are existing users of Microsoft Access databases who wish to be able to modify and enhance existing databases. The course covers the features that are used to create more advanced queries and expressions to effectively manipulating data.

Duration:

1 Day

Audience:

This course is for individuals who are working with an existing database and needs to learn how to create queries.

Prerequisites:

Access Introduction or experience using an Access database. Basic understanding of Access structure, records, fields and data.

2016

 

Creating Queries

  • Select Queries
  • Using And, Or, Not and Between operators
  • Excluding records in a query
  • Finding Top or Bottom values
  • Creating a Calculated Field
  • Formatting Calculated Fields

Advanced Queries

  • Find Duplicates query
  • Find Unique Values
  • Find Null Values
  • Finding orphaned records
  • Using data from multiple tables
  • Exporting data from a query

Understanding Joins

  • Working with multiple tables
  • Understanding Joins
  • Using different Join Types

Parameter Queries

  • Using parameters to filter results
  • Using the IN() operator in parameter queries
  • Using wildcards in parameter queries
  • Using parameters with calculations

Expressions & Expression Builder

  • Manipulating text with expressions
  • Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
  • Using conditional IIF() expressions
  • Aggregate Functions - Sum(), Avg(), Count()

Summary Queries

  • Using Totals
  • Understanding Total Functions and groups
  • Mastering Summary queries

Action Queries

  • Update queries
  • Append queries
  • Delete queries
  • Make table queries

Querying with Forms

  • Using a form form as a query criteria.

2013

 

Creating Queries

  • Select Queries
  • Using And, Or, Not and Between operators
  • Excluding records in a query
  • Finding Top or Bottom values
  • Creating a Calculated Field
  • Formatting Calculated Fields

Advanced Queries

  • Find Duplicates query
  • Find Unique Values
  • Find Null Values
  • Finding orphaned records
  • Using data from multiple tables
  • Exporting data from a query

Understanding Joins

  • Working with multiple tables
  • Understanding Joins
  • Using different Join Types

Parameter Queries

  • Using parameters to filter results
  • Using the IN() operator in parameter queries
  • Using wildcards in parameter queries
  • Using parameters with calculations

Expressions & Expression Builder

  • Manipulating text with expressions
  • Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
  • Using conditional IIF() expressions
  • Aggregate Functions - Sum(), Avg(), Count()

Summary Queries

  • Using Totals
  • Understanding Total Functions and groups
  • Mastering Summary queries

Action Queries

  • Update queries
  • Append queries
  • Delete queries
  • Make table queries

Querying with Forms

  • Using a form form as a query criteria.

2010/2007

 

Creating Queries

  • Select Queries
  • Using And, Or, Not and Between operators
  • Excluding records in a query
  • Finding Top or Bottom values
  • Creating a Calculated Field
  • Formatting Calculated Fields

Advanced Queries

  • Find Duplicates query
  • Find Unique Values
  • Find Null Values
  • Finding orphaned records
  • Using data from multiple tables
  • Exporting data from a query

Understanding Joins

  • Working with multiple tables
  • Understanding Joins
  • Using different Join Types

Parameter Queries

  • Using parameters to filter results
  • Using the IN() operator in parameter queries
  • Using wildcards in parameter queries
  • Using parameters with calculations

Expressions & Expression Builder

  • Manipulating text with expressions
  • Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
  • Using conditional IIF() expressions
  • Aggregate Functions - Sum(), Avg(), Count()

Summary Queries

  • Using Totals
  • Understanding Total Functions and groups
  • Mastering Summary queries

Action Queries

  • Update queries
  • Append queries
  • Delete queries
  • Make table queries

Querying with Forms

  • Using a form form as a query criteria.

Event Properties

Event Date 20-10-2017
Event End Date 20-10-2017
Individual Price $440.00
Course Code ACMD1
Location
Corporate Training Solutions Australia
Level 19, Waterfront Place, 1 Eagle St Brisbane, QLD 4000 Australia
Corporate Training Solutions Australia
We are no longer accepting registration for this event

Group Rate

#Registrants Rate/Person($)
3 418.00
4 396.00
$440.00 10

Location Map

Share this event: