Microsoft Access – Basic and Intermediate
Nett Course Fee
$436
Please be advised that as of 1st January 2025, there will be changes to both course fees and subsidies available.
Nett Course Fee (effective 1st January 2025)
$545
Course Description
Some may feel that having knowledge of Microsoft Excel will suffice at work. In fact, Microsoft Access is preferred over Excel for people who deals with numerous reports and queries, especially for small business owners. Microsoft Access is used for collecting and sorting of data, and is part of the RDMS (Relational Database Management Systems).
While both Excel vs Access are important applications, their functions are useful for different purposes. Excel only provides worksheets that are flat or non-relational. On the other hand, Access provides tables that are relational at multiple levels.
Prerequisites
Regularly use Microsoft Office applications such as Excel. Familiarity with data management would be advantageous.
Course Objectives
As a beginner, we make sure you understand the key Access functionality, such as entering data and the basics of tables, forms, queries and reports. Upon completion of the course, you will be able to design, create and manage Access 2019 database confidently. You will be able to:
- Create and work with Access Table and Fields. Understand field properties, indexing a field and adding a primary key to the table.
- Create a Relationships between tables.
- Query data easily using join, sort, and filter data from different tables.
- Create and Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
Course Outline
Database Basics
- Introduction to Databases
- What’s New in Access 2019
- Understanding the Access Program Screen
- Working with Database Objects
- Tour of a Table, Form, Query & Report
- Adding, Editing and Deleting Records
- Selecting Data & Using the Zoom Box
Creating and Working with a Database
- Planning a Database
- Creating a New Database
- Converting an Access Database
Working with Tables and Fields
- Modifying a Table
- Understanding Field Properties
- Indexing a Field
- Adding a Primary Key to a Table
- Inserting, Deleting, and Reordering Fields
- Adding Field Descriptions and Captions
- Changing the Field Size
- Formatting Number, Currency & Date/Time Fields by Hand
- Formatting Text Fields
- Using Hyperlink Fields
- Setting a Default Value
- Requiring Data Entry
- Validating Data
- Creating an Input Mask
- Creating a Lookup Field
- Creating a Value List
- Modifying a Lookup List
Creating Relational Databases
- Understanding Table Relationships
- Creating Relationships Between Tables
- Enforcing Referential Integrity
- Printing and Deleting Relationships
- Understanding Relationship Types
Working with Queries
- Creating & Sorting a Query
- Using AND and OR Operators in a Query
- Understanding Different Types of Queries
- Creating a Multiple Table Query
- Creating a Calculated Field
- Summarizing Groups of Records
- Display Top or Bottom Values
Working with Forms
- Creating a Form with the Form Wizard
- Creating and Using a Form
- Understanding Form Views
- Modifying a Form in Layout View
- Form Design View Basics
- Creating a Subform
- Modifying and Working with Subforms
Working with Reports
- Creating a Report with the Report Wizard
- Creating a Report
- Working in Layout View
- Adding a Logo
- Working in Design View
- Adjusting Page Margins and Orientation
- Adding Page Numbers and Dates
- Creating Mailing Labels with the Label Wizard
Formatting Forms and Reports
- Formatting Fonts
- Changing Text Alignment
- Changing Colors
- Using Conditional Formatting
- Adding Pictures, Lines, and Gridlines
- Working with Number Formatting
- Using Themes
Related Courses
Microsoft Access 2019 – Advanced
In the ‘Microsoft Access 2019 – Advanced’ course, participants will deepen their Access 2019 expertise, mastering intricate queries, form and report design, data import/export, and adeptly managing database security.
Course Duration:
2 Days (9.00am – 5.00pm)
View course details here
Microsoft Access – Basic and Intermediate
Course Duration:
2 Days (9.00am – 5.00pm)
Course Fee Details:
$436 (incl. of 9% GST)
SkillsFuture Credits & UTAP claimable
SDF grant entitled, $2/hr x 14hrs = $28
Eligible for Singaporeans, and PR employees
This course will no longer be eligible for SDF Grant.
Please be advised that as of 1st January 2025, there will be changes to both course fees and subsidies available.
Course Fee Details (effective from 1st January 2025):
$545 (incl. of 9% GST)
UTAP Claimable
This course will no longer be eligible for SDF Grant.
Course Code: ASKMAB
Course Schedule
| Course Name | Course Code | Venue | January 2025 | February 2025 | March 2025 | April 2025 | May 2025 | June 2025 |
|---|---|---|---|---|---|---|---|---|
| Microsoft Access - Basic and Intermediate | ASKMAB | JTC Summit | - | 03-04 | - | - | - | 09-10 |
| ASKMAB | Mountbatten Square | 09-10 | - | 06-07 | - | 08-09 | - |