Proasia Logo

Microsoft Access Database

This comprehensive Microsoft Access database course outline progresses logically from foundational database design concepts to advanced automation. It is structured to transform beginners into proficient database administrators
100% HRD CORP CLAIMABLE
SBL-Khas Scheme Registered

Registered employers can fully claim the course fee and allowanced through the HRD Corp portal.

HRD Corp

Course Description

This course provides a comprehensive, hands-on introduction to relational database management using Microsoft Access. Participants will learn how to design tables, build relationships, extract data using queries, create user-friendly forms, and generate professional reports. By the end of the course, students will be able to transform raw business data into a secure, organized, and scalable database application.Key Learning Objectives is Design relational databases from scratch using proper normalization.Construct advanced queries to filter, calculate, and analyze complex datasets.Build custom user interfaces with forms for seamless data entry.Generate structured reports with automated totals, groups, and conditional formatting.Automate routine business tasks using macros and data import/export tools

Course Outline

Spreadsheet vs. Database: Understanding relational database management systems (RDBMS) over flat files.Access Interface: Navigating the Ribbon, Quick Access Toolbar, Backstage view, and Navigation Pane.The Six Main Core Objects: Introduction to tables, queries, forms, reports, macros, and modules.Database Design: Planning a schema, understanding entities, fields, and records

Table Creation: Building tables using Datasheet View and Design View.Data Types: Configuring Short Text, Numbers, Currency, and Date/Time fields.Data Integrity: Enforcing primary keys, validation rules, input masks, and lookups.Table Relationships: Establishing One-to-Many and Many-to-Many relationships while enforcing Referential Integrity

Select Queries: Extracting specific dataset rows and columns using criteria expressions.Sorting and Filtering: Applying logic with AND, OR, and wildcards.Calculated Fields: Building formulas and expressions using the Expression Builder.Advanced Queries: Utilizing Parameter, Crosstab, and Action Queries (Append, Update, Delete).SQL View: Introduction to the fundamental structured query language (SELECT, WHERE, JOIN)

Form Layouts: Generating Forms using the Form Wizard, Layout View, and Design View.Form Controls: Adding text boxes, combo boxes, list boxes, and command buttons.User Data Entry: Formatting user interfaces for safe data entry and modification.Subforms: Displaying related data from secondary tables on a main form

Report Layouts: Designing summaries using the Report Wizard and Print Layout.Grouping & Sorting: Organizing inventory, sales, or customer data into structured sections.Calculated Controls: Summarizing data using totals, averages, and group counts.Conditional Formatting: Highlighting critical data anomalies visually

Importing & Exporting: Exchanging data seamlessly with Microsoft Excel, text files, and PDFs.Linking Tables: Connecting external databases or network tables safely.Macros: Automating repetitive data tasks and building database switchboards/navigation.VBA Introduction: Writing simple Visual Basic for Applications modules to handle complex event operations

Registration Details
Duration 7 Days
Individual Fee

RM 2,800.00

Exclusive of 8% SST

Download Brochure
Certified
Lab Access