Microsoft Access – download the data Training Course

Overview

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

Requirements

Knowledge of Windows

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

Leave a Reply

Your email address will not be published. Required fields are marked *