Microsoft Access - download the data Training Course

Last updated

Course Code



14 hours (usually 2 days including breaks)


Knowledge of Windows


The course is designed for persons with pre-information databases using SQL queries or queries.

Course Outline


  • The types of queries
  • Query Wizard
  • Query Design View
  • query Properties
  • Grouping in Queries
  • Create a simple select query
  • Crosstab queries
  • Query the search duplicates
  • Not matching the search query data
  • Parameter queries
  • Queries (forming a table, delete, append, updating)
  • Create a table with a query
  • Archiving data using an append query
  • Troubleshoot queries

Expressions in Queries

  • Examples of the use of expressions
  • Calculations in queries
  • Functions

SQL in Access

  • Download the data
  • Restrict results
  • Sorting Data
  • SQL Functions
  • Aggregating data using the grouping
  • Retrieving data from multiple tables
  • subqueries
  • Operators collective



Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

This site in other countries/regions