X

Perform Advance Database Functions MS Access 2013 Fast Track

ICDL Module 5: ES WSQ - Perform Advanced Database Functions
(Microsoft Access 2013 Fast Track)

 Customize Training

Courses / Information Technology / Microsoft Office / Microsoft Access / ICDL Microsoft Access 2013 Advanced
  • Overview
  • Course Outline
  • Target Audience
  • Fees & Funding

What Will Be Taught For This Microsoft Access Course?

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

This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what are deemed to be advanced data management skills. The participant shall understand the variety of ways that data can be related and organized. In addition the candidate shall be able to run and record simple macros and to import, export and link data.

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
  • Exporting Data to an Excel Workbook
  • Dragging and Dropping Data into Excel
  • Creating Word Mail Merge Documents
  • Labs - Exporting Data to Excel and Word
Module 12. Exporting Data to Excel and Word
  • Exporting Data to an Excel Workbook
  • Dragging and Dropping Data into Excel
  • Creating Excel Workbooks - Office Links
  • Creating Word Documents - Office Links
  • 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.

Self Sponsored

  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:

Individual Sponsored

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding.

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 attained minimum 75% attendance and pass ALL Assessments/Exams in order to qualify for Funding.
  • Trainee undertakes to reimburse ST Electronics (e-Services) FULL course fees should he/she be ineligible for course fee grant. ST Electronics (e-Services) is not liable for any other funding not approved by WSG.
  • ST Electronics (e-Services) reserves the right to change the date or venue without prior notice.
  • ST Electronics (e-Services) reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.

 

 

 

Please select the course date to enrol
  Duration: 2 days
  Time: 9am to 6pm