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

  • Cubase 8

    Cubase 8

    SGD $45.00

    Course Description

    Steinberg's Cubase Elements 8 is their entry level, professional digital audio workstation. It contains all the aspiring musician and mix engineer requires to get started with audio and midi recording compositions. This VTC course covers installation issues and preference setting before moving on to connecting the program to a relevant soundcard. As the course progresses, functions such as creating busses and the implementation of the inspector are looked at prior to focusing on building a project.Learn how to work with audio files with Cubase 8. - Know how Cubase 8 handles audio files- Learn how to edit your own audio files with Cubase 8- Discover the potential of Cubase 8 with your audio files- Master audio editing with all the right tools and techniques in Cubase 8

    Read more...

  • Essential Online Course - Microsoft PowerPoint 2016

    Essential Online Course - Microsoft PowerPoint 2016

    SGD $299.00

    Course Description

    Take your PowerPoint presentations to the next level with our Microsoft PowerPoint 2016 online training course! Whether you are a beginner or have experience and want to sharpen your skills, this online course will help you create professional quality presentations that will grab your audience’s attention and keep them interested from start to finish. This course is separated in to three main sections covering Basic PowerPoint, Intermediate PowerPoint and Advanced PowerPoint lessons, which will provide an in depth review of the presentation software included in the Office 2016 suite of applications. Learn to navigate the interface effectively, insert a range of objects and how to create engaging presentations that will wow viewers. Topics will include design, customization and presentation of information using Microsoft PowerPoint 2016. Wow your audience with your next presentation after taking this course! - Learn the secrets of creating dynamic PowerPoint slides - Know the different functions and purpose of PowerPoint  - Be able to apply these into your next presentation slides - Impress your audience at your next presentation 

    Read more...

  • 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.

    Read more...


Content

Microsoft Access 2016

+
Content
  • 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)
GET ACCESS NOW
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.