Essential Online Course - Microsoft Access 2016

Essential Online Course - Microsoft Access 2016, Singapore elarning online course

Course Description

Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues. This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.

Realise the full potential of your data with Microsoft Access.

- Learn about the functions in Microsoft Access that can help your understand data better
- Know the different ways of vizualising your data with Microsoft Access
- Pick up the knowledge of utilizing Access for better understanding your data
- Learn how you can stretch your data for optimum analysis

Course Objectives

  1. Understand the concept of database in Microsoft Access
  2. Understand the basics of Microsoft Access
  3. Know how to review Data, work with Tracking Time and Queries in Access
  4. Know the different analytics functions in Microsoft Access
  5. Understand more on Relationships, Invoices, and Tables 
  6. Able to prep data and how to input for analysis 
  7. Know more on Queries and Reports
  8. Know how to visualise charts, graphs and lines using results

Related Courses

  • FL Studio 10: Know how to work with audio

    FL Studio 10: Know how to work with audio

    SGD $54.00

    Course Description

    Version 10 is the game changer that FL Studio users have been waiting for. This new version builds on the long tradition of FL Studio excellence while bringing meaningful new tools to the platform. In this VTC course, author Sam McGuire helps FL Studio users navigate the FL Studio application, focusing on real-world workflow and example projects. In addition to discussing the basic FL Studio interface and functionality, Sam will delve into the exciting new Pitcher and Newtone plugins. Building on the FL Studio 9 course, this new material is designed to sharpen your skills and provide the means to be a master user of the software. Sharpen your skills in digital audio with FL Studio. - Know about FL Studio and what it does - Understand how you can use FL Studio to edit your audio files- Learn about the different connections in audio systems- Learn how to use different sound mixers using FL StudioThis course is SkillsFuture Credit Eligible.


  • An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    An Essential Online Course: PivotTable Course (PC: 2013 & 2007/10)

    SGD $49.60

    Course Description

    Microsoft Excel is an important and powerful program for many businesses. The PivotTable feature is one of the most useful, powerful and misunderstood features. PivotTables are absolutely not just about big data and large companies. Although PivotTables can work with very large data sets they are just as useful for micro businesses trying to understand where their sales opportunities lie or for individuals working on their household finances or even their fantasy football leagues. This PivotTable course from Skillsology teaches you how to draw these conclusions easily and present and manage your findings effectively. Using screenshots, video examples and exercises, you’ll soon be able to make the most out of your data, whether ‘Big’ or small, to further your business or personal life. Turn redundant data into useful analysis with PivotTable.  - Manage your data and information in a more intelligent system  - Realize your data's full potential to your advantage  - Discover ways to enhance your data output  - Learn about the advantages of PivotTable    This training is for PivotTable (PC version: 2013, 2007/10) This course is SkillsFuture Credit Eligible.


  • Corel Painter X3: Create Digital Art Pieces

    Corel Painter X3: Create Digital Art Pieces

    SGD $58.00

    Course Description

    Painter X3 is Corel's latest update to their powerful and popular natural media emulator which is used by professional creative artists in a wide variety of genres and styles. This VTC course, taught by longtime illustrator and fine artist Jason Maranto, is designed to quickly familiarize you with the core features of this powerful application. Focusing on all the main tools and functions with an in-depth yet easy-to-follow style, this course is packed with professional workflow tips and tricks that it will help you to master Painter in no time.  Dive into Corel Painter and unleash your artistic flare! - Learn about the tools and techniques available in Corel Painter X3  - Know about the different types of tools and techniques used in Corel Painter X3 - Discover the capability of Corel Painter X3 to create dynamic creative content  - Be able to produce content that can rival physical painting  This course is SkillsFuture Credit Eligible.



Microsoft Access 2016

  • Module 1: Access Beginner
    • 1.1 Introduction Part 1
    • 1.2 Introduction Part 2
    • 1.3 Elements Part 1
    • 1.4 Elements Part 2
    • 1.5 Reviewing Data
    • 1.6 Queries Part 1
    • 1.7 Queries Part 2
    • 1.8 Tracking Time Part 1
    • 1.9 Tracking Time Part 2
    • 1.10 Tracking Time Part 3
    • 1.11 Design Work With Forms
  • Module 2: Access Intermediate
    • 2.1 Relationships Part 1
    • 2.2 Relationships Part 2
    • 2.3 Changing Information
    • 2.4 Loading Tables
    • 2.5 Relating Invoices Part 1
    • 2.6 Relating Invoices Part 2
    • 2.7 Relating Invoices Part 3
    • 2.8 Relating Invoices Part 4
    • 2.9 Time Entry Form
  • Module 3: Access Advanced
    • 3.1 Queries Part 1
    • 3.2 Queries Part 2
    • 3.3 Queries Part 3
    • 3.4 Queries Part 4
    • 3.5 Reports Based On Queries
    • 3.6 Adding Additional Information
    • 3.7 Update Query Part 1
    • 3.8 Update Query Part 1
    • 3.9 Creating A Report From Scratch Part 1
    • 3.10 Creating A Report From Scratch Part 2
    • 3.11 Creating A Report From Scratch Part 3
  • Duration 9 hr 2 mins
  • Skill level All Levels
  • Languages English
  • Tag(s) IT Microsoft

SGD $299.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.