Microsoft Access - download the data Training Course

Last updated

Course Code

3082

Duration

14 hours (usually 2 days including breaks)

Requirements

Knowledge of Windows

Overview

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

Course Outline

Queries

  • 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

Testimonials

★★★★★
★★★★★

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