Course Code: 3082
Duration: 14 hours
Prerequisites:
  • Basic knowledge of Windows operating system
  • Familiarity with database concepts is beneficial but not required

Audience

  • Business analysts
  • Data entry specialists
  • IT professionals managing databases
  • Anyone looking to extract and manipulate data using Microsoft Access
Overview:

Microsoft Access is a powerful relational database management system used for storing, managing, and retrieving data efficiently.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their skills in extracting, analyzing, and manipulating data within Microsoft Access using queries and SQL.

By the end of this training, participants will be able to:

  • Understand different types of queries in Microsoft Access.
  • Use query design tools to extract and analyze data effectively.
  • Write SQL queries to retrieve and manipulate data.
  • Perform data aggregation, filtering, and sorting using queries.
  • Apply advanced query techniques for troubleshooting and optimization.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
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
Sites Published:

United Arab Emirates - Microsoft Access – Downloading Data

Qatar - Microsoft Access – Downloading Data

Egypt - Microsoft Access – Downloading Data

Saudi Arabia - Microsoft Access – Downloading Data

South Africa - Microsoft Access – Downloading Data

中国 - Microsoft Access – Downloading Data

香港 - Microsoft Access – Downloading Data

澳門 - Microsoft Access – Downloading Data

台灣 - Microsoft Access – Downloading Data

USA - Microsoft Access – Downloading Data

Österreich - Microsoft Access – Downloading Data

Schweiz - Microsoft Access – Downloading Data

Deutschland - Microsoft Access – Downloading Data

Czech Republic - Microsoft Access – Downloading Data

Denmark - Microsoft Access – Downloading Data

Estonia - Microsoft Access – Downloading Data

Finland - Microsoft Access – Downloading Data

Greece - Microsoft Access – Downloading Data

Magyarország - Microsoft Access – Downloading Data

Ireland - Microsoft Access – Downloading Data

Luxembourg - Microsoft Access – Downloading Data

Latvia - Microsoft Access – Downloading Data

España - Microsoft Access – Downloading Data

Italia - Microsoft Access – Downloading Data

Lithuania - Microsoft Access – Downloading Data

Nederland - Microsoft Access – Downloading Data

Norway - Microsoft Access – Downloading Data

Portugal - Microsoft Access – Downloading Data

România - Microsoft Access – Downloading Data

Sverige - Microsoft Access – Downloading Data

Türkiye - Microsoft Access – Downloading Data

Malta - Microsoft Access – Downloading Data

Belgique - Microsoft Access – Downloading Data

France - Microsoft Access – Downloading Data

日本 - Microsoft Access – Downloading Data

Australia - Microsoft Access – Downloading Data

Malaysia - Microsoft Access – Downloading Data

New Zealand - Microsoft Access – Downloading Data

Philippines - Microsoft Access – Downloading Data

Singapore - Microsoft Access – Downloading Data

Thailand - Microsoft Access – Downloading Data

Vietnam - Microsoft Access – Downloading Data

India - Microsoft Access – Downloading Data

Venezuela - Microsoft Access – Downloading Data

Polska - Microsoft Access - pobieranie danych

United Kingdom - Microsoft Access – Downloading Data

South Korea - Microsoft Access – Downloading Data

Pakistan - Microsoft Access – Downloading Data

Sri Lanka - Microsoft Access – Downloading Data

Bulgaria - Microsoft Access – Downloading Data

Bolivia - Microsoft Access – Downloading Data

Indonesia - Microsoft Access – Downloading Data

Kazakhstan - Microsoft Access – Downloading Data

Moldova - Microsoft Access – Downloading Data

Morocco - Microsoft Access – Downloading Data

Tunisia - Microsoft Access – Downloading Data

Kuwait - Microsoft Access – Downloading Data

Oman - Microsoft Access – Downloading Data

Slovakia - Microsoft Access – Downloading Data

Kenya - Microsoft Access – Downloading Data

Nigeria - Microsoft Access – Downloading Data

Botswana - Microsoft Access – Downloading Data

Slovenia - Microsoft Access – Downloading Data

Croatia - Microsoft Access – Downloading Data

Serbia - Microsoft Access – Downloading Data

Bhutan - Microsoft Access – Downloading Data

Nepal - Microsoft Access – Downloading Data

Uzbekistan - Microsoft Access – Downloading Data