Microsoft Access – Access Queries

"Navigate Data, Uncover Value: Microsoft Access Queries at Your Fingertips"

Join Online training on

Date: 12 / 08 / 2023

Day: Saturday

Duration

1 Days

Time

8am-6pm

rest on 1pm-2pm

Fee

RM 159

• PRE-REQUISITES

Familiarity with general computer operations, such as navigating the operating system & understanding of Databases

• VENUE / PLATFORM

• APPLY NOW

About this programme

Explore how Microsoft Access handles related information, reports and queries. As a relational database management application, it can be useful when spreadsheet-based approaches become difficult to manage.

Explore Microsoft Access as a relational database tool. Use queries to retrieve, manipulate and analyse information in different ways.

Learning goals

At the end of the course, you will be able to

• Query data easily using join, sort, and filter data from different tables
• Create and Use forms to make it easier to view, access, and input data
• Create and format custom reports

• Combining data from related tables using joins.
• Understanding the potential risks and confirming action queries
• Defining row and column headings for crosstab queries

Course Outline & Module

• Working With Access Select Queries

• Query Calculated Fields

• Summarizing Data in Access Query

• Working With Access Action Queries

• Querying Multiple Tables with Query Joins

• Parameter Queries

Who Should Attend Microsoft Access Queries ?

Build the knowledge needed to create efficient, well-structured and scalable database tables in Microsoft Access.

Application Developers

Database Developers

Business Professionals

IT Managers and Team Leaders

Training Packages

Certificate of Completion Provided

Participants will receive a Certificate of Completion on the last day of training.

Personalised Mentorship

Get a knowledgeable mentor who guides your learning and is focused on answering your questions, motivating you and keeping you on track.

Follow Up Training

Participants are entitled to one free follow-up training session, scheduled later to reinforce their learning.