Duration: 2 days
Time: 9am to 6pm

Funding Eligibility:

  1. Skills Development Fund (SDF) claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)
  2. SkillsFuture Credit claimable for Self Sponsored Individual (Singapore Citizen)
  3. Post Secondary Education Scheme (PSEA) claimable for Self Sponsored Individual (Singapore Citizen)
  4. Workfare Training Support (WTS) claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  5. SkillsFuture Mid-Career Enhanced Subsidy claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  6. Enhanced Training Support for SMEs claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)


What Will Be Taught For This Microsoft Access Course?

This course provides the basis for the practice-based test for ICDL Module 5 Perform Database Functions Database exam.

The exam requires the candidate to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The module is divided in two sections; the first section tests the candidate's ability to design and plan a simple database using a standard database package; the second section requires the candidate to demonstrate that he or she can retrieve information from an existing database by using the query, select and sort tools available in the data-base. The candidate shall also be able to create and modify reports.

Module 1. Exploring Access
  • Working with Access
  • Starting Access
  • Opening an Existing Database
  • Using the Ribbon
  • Using 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
  • 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
  • Adding a Record using 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
  • 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 2010.
  • Anyone seeking to use Microsoft Access 2010 for advanced data management and analysis in home and small businesses.

Pre-requisite

An understanding of Windows / MS Access 2007 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

Funding Eligibility:

  1. Skills Development Fund (SDF) claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)
  2. SkillsFuture Credit claimable for Self Sponsored Individual (Singapore Citizen)
  3. Post Secondary Education Scheme (PSEA) claimable for Self Sponsored Individual (Singapore Citizen)
  4. Workfare Training Support (WTS) claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  5. SkillsFuture Mid-Career Enhanced Subsidy claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  6. Enhanced Training Support for SMEs claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)
  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

Funding Eligibility:

  1. Skills Development Fund (SDF) claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)
  2. SkillsFuture Credit claimable for Self Sponsored Individual (Singapore Citizen)
  3. Post Secondary Education Scheme (PSEA) claimable for Self Sponsored Individual (Singapore Citizen)
  4. Workfare Training Support (WTS) claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  5. SkillsFuture Mid-Career Enhanced Subsidy claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  6. Enhanced Training Support for SMEs claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)
  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

Funding Eligibility:

  1. Skills Development Fund (SDF) claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)
  2. SkillsFuture Credit claimable for Self Sponsored Individual (Singapore Citizen)
  3. Post Secondary Education Scheme (PSEA) claimable for Self Sponsored Individual (Singapore Citizen)
  4. Workfare Training Support (WTS) claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  5. SkillsFuture Mid-Career Enhanced Subsidy claimable for Self Sponsored Individual and Company Sponsored Employee (Singapore Citizen)
  6. Enhanced Training Support for SMEs claimable for Company Sponsored Employee (Singapore Citizen/Singapore PR)

Trainee shall be bound by the Terms and Conditions of any applicable funding scheme.

Please ensure that you have read our Terms and Conditions before submitting the enrolment form.






Please click on the course date to enrol.