Learn Microsoft Access Course in Singapore
Access Course Singapore: Master the fundamentals of databases with hands-on training in Microsoft Access. Learn how to create, modify, and manage tables, queries, forms, and reports effectively for efficient data handling and analysis.
Course Start Date
Schedule
- Days: 3 Days
- Duration: 21 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
Who Should Attend This Microsoft Access Training Course Singapore
Access training Singapore is ideal for beginners, assuming little or no knowledge of the software.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
Microsoft Access Course in Singapore
About the Course: This Microsoft Access schooling gives a complete, hands-on introduction to building and dealing with databases. You'll gain sensible experience in creating and editing databases and their key gadgets, while studying how to preserve statistics consistency and integrity at some stage in your initiatives.
This Microsoft Access Training Course is designed for beginners, assuming little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
Target Student: All working professionals who want to create and manage database and learn to manage their own data
What will you learn-
- Learn how to improve queries, create forms, export reports
- Learn how to create a database
- Learn how to manipulate data to provide viable information
- Learn how to store databases as well as the integration of Microsoft
- Access with other applications.
MS Access Training Outline
Introduction To Access
- Getting familiarize with Access
- Planning, Designing, Handling Database
- Play with Database
- Creating Database and Updating using templates
Using Pivot Table In Access (And Via Excel)
- Creating Pivot Tables Within Access
- Using Access Pivot Tables
Using The Navigation Pane
- Tables and Related Views
- Navigation Pane Objects
- Custom Groups
Introducing Access Macros And VBA
- Just what is a Macro?
- Macro Review
- Creating and Editing Macros
- Enhancing Macros with TempVars
- Adding Conditions to Macros
- Introducing Access VBA
- Adding Conditions to Macros
- Introducing Access VBA
Validating And Standardising Table Data
- Setting Default Values
- Defining Field Validation
- Requiring a Field to be Completed
- Adding Date Picker to Date Fields
- Using Rich Text Formatting (Memo Fields)
- Table Validation Rules
Advanced Form Design
- GUI Design
- Designing a Standardised User Interface Model
- Working with Form Filters
- Validating Form Data
- Cascading Combo Boxes
Setting Table Relationships
- Locating Orphan Records
- Cascading Updates and Deletes
- Join Types
Designing With Layout View
- A Quick Look at Layout View
- Creating a Form Using the Quick Form Tool
Introducing Access SQL
Commonly used SQL Keywords
Advanced Reports
- No Data Event
- Show/Hide Report Sections based on User Selections
- Add Running Sums to Report Sections
- Add a Watermark to a Report
Advanced Select Queries
- Using Left
- Using Mid
- Using the LEN Function
- Using IIF Functions
- Using LCASE Functions
- Using TRIM Functions
Reporting Systems
- Reviewing Methods to Run Reports
- A Fully Featured Reporting Module
Aggregate Queries
- Grouping Data
- Adding Criteria to Aggregate Queries
Preparing The Database For User Access
- Restricting User Access to Design Elements
- Converting to ACCDE Format
Cross Tab Queries
- Creating CrossTab Queries
- Modifying a CrossTab
Frequently Asked Questions (FAQ)
What is the course about?
This Microsoft Access training offers a hands-on introduction to building and managing databases. You’ll gain practical experience creating and modifying database objects—including tables, queries, forms, and reports—while learning how to ensure data consistency and integrity.
Who is this course for?
Ideal for beginners with little or no prior knowledge of Microsoft Access. It’s recommended for analysts, business professionals, entrepreneurs, trainers, students, and anyone keen to manage their own data efficiently.
What are the prerequisites?
Participants should:
- Be over 16 years old
- Have High School level English
- Possess basic computer and Internet skills
A general understanding of personal computers and the Windows environment also helps.
What are the course requirements for certification?
Participants must maintain a minimum 75% attendance rate to qualify for a course completion certificate.
What is the course duration?
Duration: 3 days (21 hours total)