Duration: 2 days / 17 hours
Time: 9am to 6pm
Course Code: CRS-Q-0030369-ES

Funding available for this course:

Enhanced Training Support for SMEs  Post-Secondary Education Scheme (PSEA) Skills Development Fund (SDF) SkillsFuture Credit SkillsFuture Mid-Career Enhanced Subsidy

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

 

  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

 

  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

 


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.