Duration: 2 days
Time: 9am to 6pm

What Will Be Taught For This Microsoft Access Course?

The Advanced Database module sets out key database concepts and covers the use of a relational database application to create an advanced database structure and outputs.

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

  • Create a relational database using advanced table creation features and complex relationships between tables.
  • Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations.
  • Use controls and sub-forms to enhance forms and improve functionality.
  • Create report controls to perform calculations.
  • Create sub-reports and enhance report presentation.
Module 1. Designing Advanced Queries
  • Setting Top Values in a Query
  • Creating a Calculated Field
  • Formatting a Calculated Field
  • Displaying a Totals Row in a Query
  • Creating a Function Query
  • Creating a Parameter Query
  • Using Multivalued Fields
  • Creating a Concatenation in a Query
  • Filtering a Query
  • Labs
Module 2. Creating Action Queries
  • Creating a Make-table Query
  • Creating an Update Query
  • Creating an Append Query
  • Creating a Delete Query
  • Labs
Module 3. Using Advanced Query Wizards
  • Using the Crosstab Query Wizard
  • Using the Find Duplicates Query Wizard
  • Using the Find Unmatched Query Wizard
  • Labs
Module 4. Using Advanced Form Design
  • Creating a Combo Box
  • Creating a List Box
  • Creating an Option Group
  • Adding a Logic Control
  • Setting the Tab Order Automatically
  • Setting the Tab Order Manually
  • Adding a Form Header and Footer
  • Creating a Blank Form
  • Labs
Module 5. 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
Module 6. Using Subforms/Subreports
  • Creating a Subform/Subreport
  • Editing the Layout of a Subform
  • Displaying a Subform in Datasheet View
  • Displaying a Subform Total
  • Labs
Module 7. Using Other Form Techniques
  • Creating a Split Form
  • Converting an Existing Form to a Split Form
  • Editing a Split Form
  • Adding a Command Button
  • Saving a Form as a Report
  • Labs
Module 8. Creating Macros
  • Working with Macros
  • Creating a Macro
  • Assigning an Argument to an Action
  • Saving a Macro
  • Using Single Step Mode for Testing Running a Macro
  • Editing an Existing Macro
  • Labs
Module 9. Using Macros
  • Creating Embedded Macros
  • Assigning a Macro to a Control
  • Creating a Command Button
  • Adding an IF Condition to a Macro
  • Labs
Module 10. Using Advanced Database Features
  • Importing Data
  • Linking Data to an Access Table
  • Using the Linked Table Manager
  • Exporting Data
  • Converting Files
  • Printing a Relationship Document
  • Compacting a Database
  • Using Name AutoCorrect
  • Backing Up a Database
  • Labs
Module 11. Exporting Data to Excel and Word
  • Exporting Data to an Excel Workbook
  • Dragging and Dropping Data into Excel
  • Creating Excel Workbooks - Office Links
  • Exporting Access Data to Word Document
  • Practice - Exporting Data to Excel and Word

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 looking to achieve a more advanced proficiency in Microsoft Access 2013.
  • Anyone seeking to use Microsoft Access 2013 for advanced data management and analysis in home or small businesses.

Pre-requisite

An understanding of MS Access 2013 basic and intermediate level is required.

  w/o GST w GST
Course Fee $420 $449.40
Singapore Citizen & PR aged ≥ 21 years $131 $160.40
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$42 $71.40
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$21 $50.40
  w/o GST w GST
Course Fee $420 $449.40
Singapore Citizen & PR aged ≥ 21 years $131 $160.40
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$42 $71.40
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$21 $50.40
  w/o GST w GST
Course Fee $420 $449.40
Singapore Citizen & PR aged ≥ 21 years $42 $71.40
Singapore Citizen aged ≥ 40 years
(SkillsFuture Mid-Career Enhancement Funding)
$42 $71.40
Singapore Citizen aged ≥ 35 years with earning ≤ $2,000/month
(WTS Scheme)
$21 $50.40

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.