Duration: 3 days
Time: 9am to 5.30pm

What Will Be Taught For This Microsoft Access Course?

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
  • Creating a Function Query
  • Creating a Parameter Query
  • Creating a Concatenation in a Query
  • Filtering a Query
  • Practice - Designing Advanced Queries
Module 2. Creating Action Queries
  • Creating a Make-table Query
  • Creating an Update Query
  • Creating an Append Query
  • Creating a Delete Query
  • Practice - Creating Action Queries
Module 3. Using Advanced Query Wizards
  • Using the Crosstab Query Wizard
  • Using the Find Duplicates Query Wizard
  • Using the Find Unmatched Query Wizard
  • Practice - Using Advanced Query Wizards
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
  • Practice - Using Advanced Form Design
Module 5. Using Advanced Report Design
  • Adding Report Sections in Design View
  • Creating a Calculated Control
  • Grouping Data in a Report
  • Creating Group Headers and Footers
  • 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
  • Practice - Using Advanced Report Design
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
  • Practice - Using Subforms/Subreports
Module 7. Using Other Form Techniques
  • Adding a Command Button
  • Saving a Form as a Report
  • Creating a PivotTable or PivotChart View
  • Practice - Using Other Form Techniques
Module 8. Creating Macros
  • Opening the Macro Design Window
  • 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
  • Running a Macro using the Tools Menu
  • Creating a Macro using the Macro Builder
  • Practice - Creating Macros
Module 9. Using Macros
  • Assigning a Macro to a Control
  • Creating a Command Button
  • Adding a Condition to a Macro
  • Creating a Group Macro
  • Creating an Autoexec Macro
  • Practice - Using Macros
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
  • Practice - Using Advanced Database Features
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
  • Creating Word Documents - Office Links
  • Practice - Exporting Data to Excel and Word
Module 12. Replicating Database
  • Replicating a Databases
  • Synchronizing Database Replicas
  • Practice – Replicating Databases

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 2010.
  • Anyone seeking to use Microsoft Access 2010 for advanced data management and analysis in home or small businesses.

Pre-requisite

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

  w/o GST w GST
Course Fee $750 $802.50

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD).
  • 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 click on the course date to enrol.