• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Intellisoft Training: WSQ Funded IT Training in Singapore

Upgrade Skills With WSQ & SkillsFuture Funding from Singapore Government

  • Home
  • Schedule
  • Register
  • About
  • Contact
  • Tel: 6296-4663
MENUMENU
  • WSQ Funded Courses (Microsoft, Adobe, Soft Skills)
        • Adobe Certification
          • Adobe Photoshop Certification Training in Singapore
          • Adobe DreamWeaver
        • Microsoft Excel
          • Basic Excel 2019 / 365
          • Basic Excel 2016
          • Advanced Excel 2019 / 365
          • Advanced Excel 2016
        • Microsoft PowerPoint
          • Basic PowerPoint 2019 / 365
          • Basic PowerPoint 2016
          • Advanced PowerPoint 2019 / 365
          • Advanced PowerPoint 2016
        • Microsoft Word
          • Basic Word 2019 / 365
          • Basic Word 2016
          • Advanced Word 2019 / 365
          • Advanced Word 2016
        • Web Design / Internet Marketing
          • NICF Web Design With WordPress
          • Social Media Marketing MasterClass
          • Digital Marketing Course Singapore
        • Microsoft Access
          • Basic Access 2019 / 365
          • Basic Access 2016
          • Advanced Access 2019 / 365
          • Advanced Access 2016
        • Soft Skills
          • Communication Skills Training
          • Presentation Skills Training
        • Microsoft Project
          • Project 2016
        • ICDL Insights: IoT / Cloud
          • Cloud Computing
          • Internet of Things (IoT)
  • WSQ Grants
    • SkillsFuture
    • Mid-Career Enhanced Subsidy
    • Upcoming WSQ Funded Trainings
  • Non-Certification
        • Python / Power BI
          • ICDL Computing: Python Training
          • ICDL Data Analytics: Excel & Power BI
        • Illustrator & InDesign
          • Adobe InDesign Course in Singapore
          • Adobe Illustrator Training in Singapore
        • Excel Data Analysis
          • Excel Dashboard Masterclass
          • Data Interpretation & Analysis
          • Excel VBA Macro Course in Singapore
        • IT Courses
          • C Programming
          • Java Programming
          • Introduction to SQL
  • Articles
  • Corporate Training
  • Home
    • Introducing Intellisoft Training To You
    • Contact Us
    • Privacy Policy
    • Training Terms & Conditions
    • Safe Training Experience
    • Upcoming WSQ Funded Trainings
    • Register For A Course
Home » WSQ Funded Courses at Intellisoft Training » Advanced Access 2010 Certification

Advanced Access 2010 Certification

certificate1
Course Duration for Advanced Access 2010 Training : 3 full days (8:45 am to 5:45 pm)

Singaporeans  above 25 years can use their SkillsFuture Credits for this training course. Contact us for more information on how to apply for this SkillsFuture Grant.

Training Schedule
6, 7, 8 Jun 2022 (Classroom)
15, 16 Sep 2022 (Classroom)

Course Duration for Microsoft Access 2010 Training : 3 days

Up to 95% WSQ Funding + Absentee Payroll is available for Singaporeans & PRs .
Call (65) 6296-4663 for Details.

Certification: Upon completion, you will attain the internationally recognized ICDL Certificate in Mastering Access 2010.

We also offer Microsoft Access at Basic Level. Check course outline of Basic Access 2013 OR Basic Access 2016 training.

 

Advanced Access 2010 training at Intellisoft
Advanced Access 2010 training at Intellisoft

Course Objectives: This training is a high-level certification program which will bring your Access 2010 skills to an Expert Level. Upon completion, you will master the more advanced functions of Access, and be able to produce more sophisticated reports, perform complex mathematical calculations, saving time & improving productivity.

This module is a high-level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. Completion of this module will enable candidates to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks. – See more at: http://www.icdlasia.org/index.jsp?p=143&n=145#sthash.JqwyYjtA.dpuf

Course Duration: 3 Full Days

Advanced Access 2010 Certification: Course Outline

Module 1: Database Concepts
  • Database Development and Use – Know that different types of database models exist like: hierarchical/relational/object-oriented, know the life cycle stages of a database: logical design/database creation/data entry/data maintenance/information retrieval, recognize common business applications of databases like: dynamic website, know the term SQL and understand its main use in querying database content

Module 2: Tables and Relationships

  • Fields/Columns – Create/modify/delete a lookup in a field/column, create/modify/delete an input mask in a field/column, set data entry for a field/column: required/not required
  • Relationships and Joins – Create/modify/delete a one to-one/one-to-many relationship between tables, create/modify a many-to-many relationship using a junction table, apply referential integrity between tables, apply automatic update of related fields, apply automatic deletion of related records, apply/modify an inner join/outer join, create/modify a subtract join, apply a self join

    Advanced Access 3 days workshop in Singapore at Intellisoft
    Advanced Access 3 days workshop in Singapore at Intellisoft

Module 3: Queries

  • Query Types – Create/run a query to update data/append records/delete records in a table, create, run a query to save selected data as a new table, create/run a cross tab query, show duplicated records within a table, show unmatched records in related tables
  • Refining a Query – Create/modify/run a one/two variable parameter query, use wildcards, show highest/lowest range of values, create and name a calculated field that performs arithmetic operations, group information in a query using functions: sum, count, average, max, min

Module 4: Forms

  • Controls – Create/modify/delete bound controls, text/combo/list/check box and option groups, add/remove bound control properties, create/modify/delete unbound controls containing arithmetic/logical expressions, modify sequential tab order of controls, create/delete a linked sub form

Module 5: Reports

  • Controls – Format arithmetic calculation controls with percentage/currency, apply running sum for a group, concatenate fields
  • Presentation – Insert/delete a data field in group/page/headers/footers, sort/group records by fields, force page breaks for groups, create/delete a linked sub report

Module 6: Enhancing Productivity

  • Linking/Importing with Macro – Link external data to a spreadsheet/text/existing database, import spreadsheet/text/XML/existing database
  • Automation Using Macro – Create/run a simple macro, assign a macro to a command button/object/control

How to Register: Simply fill this Online Registration Form. The Intellisoft Training Officer will get in touch with you to confirm your seat shortly. You can call at at +65 6296-4663 if you have any questions.

Do You Have Any Questions

on Course Fee, WSQ Grant or Funding?

Ask Us. We’ll be happy to assist you.

Our Participants says:

Well planned lessons with adequate rest time. Pace is ok. Step by step approach. This training helps to understand more advanced features of Access. – Chan Wei

Customer service is good. Very cooperative staff & trainer. Friendly environment. Practical hands-on for better understanding of topic. – Lee Kee

Experienced & knowledgeable trainer. Organized course style. Greatest strength of this training is user friendly & applicable for real life situation. – Idy Chua

Small class, Sufficient practice exercises. I have learnt to manage the table relationships, queries & reports. . – Tee Way

Primary Sidebar

Recent Posts

  • Are You Making These Presentation Mistakes?
  • Frequently Asked Questions About Microsoft Excel
  • Use the Rectangular Marquee Tool in Photoshop
  • Convert Any Photo to Black & White in Photoshop
  • What are Infographics?

Recent Comments

    Archives

    • May 2022
    • April 2022
    • September 2021
    • August 2021
    • July 2021
    • June 2021
    • April 2021
    • May 2020
    • March 2020
    • July 2019
    • May 2018
    • March 2018
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • April 2016
    • January 2015
    • July 2014

    Categories

    • Adobe Photoshop
    • Computer Basics
    • Digital Marketing
    • Employee Training
    • Intellisoft Tutorials – WSQ Funded Courses
      • Cloud Computing
    • Microsoft Excel
    • Microsoft Office Training
    • Presentation Techniques
    • Python Training
    • Soft Skills
      • Communication Skills
    • Web Design Training
    • Home
    • Schedule
    • Register
    • About
    • Contact
    • Tel: 6296-4663
    MENUMENU
    • WSQ Funded Courses (Microsoft, Adobe, Soft Skills)
          • Adobe Certification
            • Adobe Photoshop Certification Training in Singapore
            • Adobe DreamWeaver
          • Microsoft Excel
            • Basic Excel 2019 / 365
            • Basic Excel 2016
            • Advanced Excel 2019 / 365
            • Advanced Excel 2016
          • Microsoft PowerPoint
            • Basic PowerPoint 2019 / 365
            • Basic PowerPoint 2016
            • Advanced PowerPoint 2019 / 365
            • Advanced PowerPoint 2016
          • Microsoft Word
            • Basic Word 2019 / 365
            • Basic Word 2016
            • Advanced Word 2019 / 365
            • Advanced Word 2016
          • Web Design / Internet Marketing
            • NICF Web Design With WordPress
            • Social Media Marketing MasterClass
            • Digital Marketing Course Singapore
          • Microsoft Access
            • Basic Access 2019 / 365
            • Basic Access 2016
            • Advanced Access 2019 / 365
            • Advanced Access 2016
          • Soft Skills
            • Communication Skills Training
            • Presentation Skills Training
          • Microsoft Project
            • Project 2016
          • ICDL Insights: IoT / Cloud
            • Cloud Computing
            • Internet of Things (IoT)
    • WSQ Grants
      • SkillsFuture
      • Mid-Career Enhanced Subsidy
      • Upcoming WSQ Funded Trainings
    • Non-Certification
          • Python / Power BI
            • ICDL Computing: Python Training
            • ICDL Data Analytics: Excel & Power BI
          • Illustrator & InDesign
            • Adobe InDesign Course in Singapore
            • Adobe Illustrator Training in Singapore
          • Excel Data Analysis
            • Excel Dashboard Masterclass
            • Data Interpretation & Analysis
            • Excel VBA Macro Course in Singapore
          • IT Courses
            • C Programming
            • Java Programming
            • Introduction to SQL
    • Articles
    • Corporate Training
    • Home
      • Introducing Intellisoft Training To You
      • Contact Us
      • Privacy Policy
      • Training Terms & Conditions
      • Safe Training Experience
      • Upcoming WSQ Funded Trainings
      • Register For A Course

    © 2003–2022 Intellisoft Training Pte. Ltd.