"Master Microsoft Access: Unleash Advanced Capabilities with Expert Training!"
Join Classroom Training Within 1 Day
From Your Home (Zoom Application
DATE: 16-18 January 2024
Duration
3 Days
(21 hours)
Time
- 9AM - 5PM
Seats Availability
- 6
in classroom
Fee
RM 800
- VENUE / PLATFORM
- Level 3, Training Room, Bangunan Seremban Plaza, Jalan Dato Muda Linggi, 70100 Seremban, Negeri Sembilan.
- Meals Provided?
- YES
- PC/Laptop Provided?
- NO
- oUR Instructor
Coach Asyraf
(Microsoft Office Specialist: Expert)
Before you begin
Basic familiarity with using computers.
Language
50% English & 50% Bahasa Melayu
Certification
Certificate of Participation by Training Provider
About this programme
Progress from Access fundamentals to advanced tools in this three-day practical programme. Learn to create and manage databases, design clear forms and reports, automate tasks with macros and explore basic VBA for additional customisation. The course supports both new users and people extending their existing knowledge.
Learning goals
At the end of the Course, participants will be able to:
- Learn the basics of how Microsoft Access works and navigate its interface effectively.
- Build new databases and set up tables to organize your data.
- Edit and design table structures to suit your data needs.
- Develop proficiency in entering and editing data efficiently.
- Create queries to retrieve and analyze specific information from your database.
- Construct forms for easy data input and customization.
- Produce meaningful reports to present your data effectively.
- Explore advanced query techniques to retrieve specific data sets.
- Learn to use macros and VBA to automate routine database actions.
- Optimize database performance and ensure data security and protection.
Course Outline & Module
Day 1: Basic/Fundamental Modules
- Navigating the Interface
- Fundamentals of Access Objects
- Working With Table Data
- Creating Table
- Working With Table Relationships
Day 2: Intermediate Modules
- 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
Day 3: Advanced Modules
- Working with Forms
- Working with Reports
- Working with Macros and Automation
- Security and Data Management
Who this programme suits
This course is ideal for
Data Analysts
Administrative Staff and Managers
Entrepreneurs and Business Owners
Database Administrators and IT Professionals
Training Packages
Course Handbook
Exercise Files
Tutorial Videos
Lifetime Group Support
How to Register
Register Now
Click on the "Register Now" button on the course page.
Complete Registration Form
Fill out the registration form with your personal details, choose training date and preferred payment method.
Make Payment
Make the payment to secure your spot. Once your payment is confirmed, you'll receive a confirmation email.
Contact Us
Reach out to our registration team via WhatsApp to get link access to WhatsApp group.
*** Note: Course content and schedule are subject to minor adjustments based on the needs and skill levels of participants.
Ready for your next step?
Let’s find the right training for you or your team.
