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

  • An Essential Online Course: Digital Collaboration with Office 365

    An Essential Online Course: Digital Collaboration with Office 365

    SGD $79.60

    Course Description

    Working with several separate software applications can be challenging. Microsoft Office 365 simplifies the process with an integrated collaboration and communication solution. Combining well known software applications with cloud features helps individuals and teams work together more productively. This course looks at the common features of Office 365 and how they can be used to support collaboration and communication. You and your staff will learn how to monitor and collaborate on projects and tasks, share knowledge and content with colleagues, and use social and communication tools efficiently. Discover the different products of Office 365 today! - Explore the different features in Office 365 - Know more about the functions of each individual product  - Learn about the purpose of the different products in Office 365 - Discover the usefulness of Office 365 for your job  This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft OneNote 2013

    Microsoft OneNote 2013

    SGD $40.00

    Course Description

    Microsoft OneNote 2013 is used to store information in a central location where it can easily be shared, backed up, and searched. In this VTC course, author Brian Culp compares OneNote to a digital version of a spiral-bound notebook as he shows you how to quickly add text, pictures, video, and even handwritten notes. He also explains how OneNote integrates with other Office 2013 applications, especially Word, Excel, and Outlook. Additionally, Brian covers how to leverage powerful features such as the ability to link notes automatically, customize the interface, and quickly track down unread notes. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course 

    Read more...

  • eLearning Brother Master Suite (USD)

    eLearning Brother Master Suite (USD)

    SGD $4,749.05

    Course Description

    Original Price: $4,999.00 USD                                       Sale Price: $4,749.05 USD   Checkout via Smoovpay   Become an eLearning Rockstar | Characters | Scenarios | Games & Quizzes | Stock Assets | Icons | xAPI Templates | Mobile Learning | To be a true eLearning Rockstar™, you need the entire tool set. Meet the eLB Master Suite—the ultimate collection of eLearning resources. The eLB Master Suite gives you an unparalleled asset library, fully developed, customizable eLearning courses, and games from the award-winning game authoring tool, The Training Arcade™. Whatever form of training you need to develop, the eLB Master Suite will help you shine. Includes the following: * Cutout People  * eLearning Templates  * Stock Assets  * PowerPoint Graphics * Icons 

    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.