Microsoft Access Training - Essentials Course - Indonesia

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 Indonesia.

Microsoft Access Training - Essentials Course - Indonesia

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 Indonesia.

Rp 9.765K
10 max
2 days

Remote JKT

Upcoming Courses:
Remote JKT

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 Essentials Indonesia Course Details

Price
Rp 9.765K
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
N/A
microsoft_gold
deloite_logo

Access Course Outlines

  • Access Essentials
    Rp 9.765K
  • Access Advanced
    Rp 9.765K
Course Rating
Microsoft Access Training Courses

4,72 5 Microsoft Access Training Courses
4,72 out of 5
77441 Student Reviews

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 Essentials Indonesia 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 Essentials Indonesia 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