Duration: 2 days
Time: 9am to 6pm

What Will Be Taught For This Microsoft Access Course?

This Databases module sets out essential concepts and skills relating to understanding the concept of a database and demonstrating competence in using a database application.

On completion of this module the candidate will be able to:

  • Understand what a database is and how it is organised.
  • Create a simple database and view the database content in various modes.
  • Create a table, define and modify fields, and create relationships between tables.
  • Use filters and queries to retrieve specific information from a database.
  • Create a form to enter, modify, and delete records and data in records.
  • Create routine reports and prepare outputs ready for print or electronic distribution.
Module 1. Exploring Access
  • Working with Access
  • Starting Access
  • Opening an Existing Database
  • Familiarizing with the Ribbon
  • Familiarizing with the Contextual Tabs
  • Using the Mini Toolbar
  • Using the Navigation Pane
  • Opening a Database Object
  • Using Tabbed Documents
  • Closing a Tabbed Document
  • Closing All Tabbed Documents
  • Using the Status Bar
  • Using the Options Dialog Box
  • Closing a Database
  • Exiting Access
  • Labs
Module 2. Creating Tables
  • Using the Database Templates
  • Creating a New Database
  • Creating a Table in Design View
  • Adding Field Names
  • Assigning Data Types
  • Saving a New Table
  • Adding a Field Description
  • Setting a Primary Key
  • Using Multi-valued Fields
  • Labs
Module 3. Setting Field Properties
  • Using Field Properties
  • Limiting Field Size
  • Setting Number Formats
  • Setting Date/Time Formats
  • Setting Yes/No Formats
  • Setting Default Values
  • Setting Validation Rules
  • Creating an Input Mask Wizard
  • Creating an Input Mask Manually
  • Creating a Custom Input Mask
  • Typing a Lookup List
  • Looking up value from another table
  • Modifying Lookup Properties
  • Labs
Module 4. Working with Tables
  • Using Field Templates
  • Adding Records
  • Moving through Records
  • Selecting Records
  • Editing Records
  • Deleting Records
  • Displaying Totals Row in a Table
  • Labs
Module 5. Editing Tables
  • Changing the Row Height
  • Changing the Column Width
  • Changing a Font Attribute
  • Changing a Cell Effect
  • Using Alternate Background Colors
  • Selecting a Column
  • Moving a Column
  • Hiding a Column
  • Unhiding a Column
  • Freezing a Column
  • Labs
Module 6. Finding and Filtering Data
  • Sorting Records
  • Finding Specific Records
  • Finding Records using Wildcards
  • Using Replace
  • Using Filter By Selection
  • Applying/Removing a Filter
  • Using Filter Excluding Selection
  • Using the Search Box
  • Using Quick Filter
  • Using AutoFilter
  • Labs
Module 7. Using Simple Queries
  • Using Queries and Record sets
  • Using the Simple Query Wizard
  • Creating a Query in Design View
  • Opening a Query
  • Adding a Table to a Query
  • Joining Tables in a Query
  • Running a Query
  • Labs
Module 8. Modifying Query Results
  • Sorting a Query
  • Adding Criteria to a Query
  • Hiding a Field in a Query
  • Displaying Totals Row in a Query
  • Printing a Query
  • Labs
Module 9. Using Operators in Queries
  • Using Comparison Operators
  • Using an And Condition
  • Using an Or Condition
  • Using the Between And Operator
  • Using the Expression Builder
  • Using a Wildcard Character
  • Labs
Module 10. Creating Relationships
  • Using Related Tables
  • Creating a Relationship between Tables
  • Setting Referential Integrity
  • Viewing Subdatasheets
  • Deleting a Join Line
  • Labs
Module 11. Creating Basic Forms
  • Using the Forms Button
  • Adding a Record using a Form
  • Using the Calendar for Date Picking
  • Using the Form Wizard
  • Viewing Records in a Form
  • Printing Records in a Form
  • Basing a Form on a Query
  • Labs
Module 12. Using Design View
  • Understanding Controls
  • Adding a Label
  • Adding an Image
  • Adding a Rectangle
  • Adding a Line
  • Editing an Unbound Control
  • Using Multiple Undo/Redo in Design View
  • Labs
Module 13. Creating Basic Reports
  • Using the Reports Button
  • Using the Print Preview - Reports
  • Printing Pages of a Report
  • Using the Report Wizard
  • Changing Views in a Report
  • Grouping and Summarizing Report Data
  • Basing a Report on a Query
  • Labs
Module 14. Using Advanced Report Design
  • Adding Report Sections in Design View
  • Creating a Calculated Control
  • Creating a Running Summary
  • Inserting a Date/Time Control
  • Inserting a Page Break
  • Changing the Report Margins
  • Using the Label Wizard
  • Creating a Report without Using a Wizard
  • Labs

Who Should Attend This Microsoft Access Training?

  • For professionals across a broad spectrum of industries such as PA, EA, VA, Administrator, Secretary, Customer Services Executives and much more to gain solid foundational grasp in Microsoft Access 2016.
  • Anyone seeking to use Microsoft Access 2016 for advanced data management and analysis in home and small businesses.

Pre-requisite

An understanding of Windows / MS Access 2013 will be an added advantage.

  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60
  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $91 $117.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60
  w/o GST w GST
Course Fee $380 $406.60
Singapore Citizen & PR aged ≥ 21 years $38 $64.60
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$38 $64.60
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$19 $45.60

Remarks:

COMAT is a business centre of e-Services, Electronics, ST Engineering.

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.
  • This course is eligible for using PSEA funds.

Company Sponsored

  • Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
  • Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr
  • Absentee payroll claimable by companies (SMEs and Non-SMEs) sponsoring candidates under WTS Scheme: Up to 95% of hourly basic salary (no dollar cap)

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD). This funding support is only applicable for Singapore Citizen and Permanent Residents.
  • Trainee must attain minimum 75% attendance and pass ALL Assessments/Exams in order to qualify for Funding.
  • Trainee undertakes to reimburse e-Services, Electronics, ST Engineering FULL course fees should he/she be ineligible for course fee grant. e-Services, Electronics, ST Engineering is not liable for any other funding not approved by WSG.
  • e-Services, Electronics, ST Engineering reserves the right to change the date or venue without prior notice.
  • e-Services, Electronics, ST Engineering reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.


Please click on the course date to enrol.