Perform Advance Database Functions MS Access 2013 Fast Track

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

Company Sponsored - Non SME

	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

Company Sponsored - SME

	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.

Course Dates
NOV: 1-2
DEC: 3-4
Duration: 2 days Time: 9am to 6pm