Microsoft Access Training - Phillipines

Learn the basics of Microsoft Access for effective database management

This 2-day Microsoft Access Essentials course is designed to introduce you to the fundamentals of database design using Microsoft Access. Gain practical skills in creating tables, managing data, designing queries, and generating reports to effectively manage and utilise your databases.

Instructor-led courses, delivered remotely across Phillipines.

Microsoft Access Training - Phillipines

This 2-day Microsoft Access Essentials course is designed to introduce you to the fundamentals of database design using Microsoft Access. Gain practical skills in creating tables, managing data, designing queries, and generating reports to effectively manage and utilise your databases. Delivered remotely across Phillipines.

₱ 44,800
10 max
2 days
₱ 44,800
10 max
2 days

Manila

Remote PH

Upcoming Courses:
Manila

We currently have no public courses scheduled. Please contact us to register your interest.

Remote PH

We currently have no public courses scheduled. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Access Phillipines Course Details

Price
₱ 44,800
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Address
Remote Classes
N/A
microsoft_gold
deloite_logo

Access Phillipines Course Details

Price
₱ 44,800
Duration
2 days
Times
9am-4pm
Class Size (max)
8
Class Size (avg)
6
Reference Materials
Provided
CPD Hours
12 hours
Delivery
Instructor-led training
Live Online
Address
Lumify Philippines
17F SM Aura Tower
Bonifacio Global City
Taguig
1630
Philippines
microsoft_gold
deloite_logo

Access Course Outlines

  • Access Essentials
    ₱ 44,800
  • Access Advanced
    ₱ 44,800

Contact Us


What do I need to know to attend?

A basic understanding of Windows and experience with one other Windows application, such as Word or Excel.

Access Phillipines Learning Outcomes

  • Create tables with appropriate fields, data types, and properties
  • Establish relationships between tables
  • Design user-friendly forms
  • Generate and print professional reports

Access Phillipines Course Content

  • Introduction to Microsoft Access
  • Understanding the Microsoft Access Interface
  • Starting and Exiting Microsoft Access
  • Overview of Database Fundamentals
  • Table Design and Data Entry
  • Designing Tables with appropriate fields and properties
  • Understanding field properties and data types
  • Entering and modifying table data
  • Working with Lookup Lists
  • Creating Tables for Lookup Lists
  • Setting up and managing Lookup Lists
  • Sorting, Finding, and Filtering Data
  • Sorting data within tables
  • Finding and filtering records
  • Using the Replace function for data management
  • Creating Simple Queries
  • Introduction to Query Design
  • Creating basic queries to extract specific data
  • Applying criteria to queries for focused results
  • Normalisation Techniques
  • Understanding 1st, 2nd, and 3rd Normal Forms
  • Normalising data to ensure database efficiency
  • Structuring tables to eliminate redundancy
  • Managing Table Relationships
  • Defining relationships between tables
  • Understanding primary and foreign keys
  • Implementing relationship types (One-to-Many, Many-to-Many)
  • Importing and Linking Data
  • Importing data from other applications
  • Linking Access Tables from other Access files
  • Using the Database Splitter for data management
  • Applied Queries and Calculations
  • Creating Multi-Table Queries
  • Working with Parameter Queries
  • Performing calculations within queries
  • Creating Forms
  • Introduction to Form Design
  • Customising forms for data entry and navigation
  • Report Design and Printing
  • Designing reports to present data effectively
  • Setting default margins for reports
  • Generating and printing reports from your database

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 77441 Reviews

Trusted by Business

Awards and Accreditations

Follow us