Notice : You are now accessing LOOP SIT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Microsoft Visual Basic for Access 2010


  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course
  • Microsoft Visual Basic for Access 2010, Singapore elarning online course

Course Description

Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database.

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


Course Objectives

1. Know and understand the basics of Microsoft Visual
2. Know how to navigate the interface and tools pane 
3. Knows what are Objects, Classes, Databases and Recordsets
4. Understand the basic formulas available and be able to apply them into projects 
5. Know what is Event and Event Procedures
6. Understand about Form and Record Navigation 
7. Know about Collections and User-Defined Data Types
8. Know about VBA and Form Objects 
9. Understand about Embedded SQL 


Related Courses

  • Microsoft Project 2013

    Microsoft Project 2013

    SGD $45.00

    Course Description

    Microsoft Project is the standard-bearing tool to help project managers track all the vitals of their projects: tasks, resources, schedule, and cost. With the 2013 version of Project, Microsoft introduces several new features and improves existing ones. In this VTC course, author Brian Culp will guide users through techniques that allow project managers to quickly get up to speed on this powerful toolkit. Users will learn how to start projects, create and edit tasks, assign resources to tasks, share project information, and much more. 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 This course is SkillsFuture Credit Eligible.

    Read more...

  • Amplify Your Videos with Avid Pro Tools 12

    Amplify Your Videos with Avid Pro Tools 12

    SGD $40.00

    Course Description

    Avid Pro Tools 12 is the standard when it comes to audio recording and mixing. Version 12 brings additional polish and power to the audio production process. This VTC course explores these features along with the basics of operation. Author Sam McGuire demonstrates how to use this software in a variety of situations using provided work files. This course is an excellent resource for anyone who wants to learn how to use Pro Tools.Create your own original works with Avid Pro Tools!- Learn the tools and techniques of Avid Pro Tools 12- Know how to enhance your videos with Avid Pro Tools 12- Discover the secrets of producing a quality video- Learn the ropes of creating your own master piece with this course This course is SkillsFuture Credit Eligible.

    Read more...

  • An Essential Online Course: Microsoft Excel Course PC & MAC

    An Essential Online Course: Microsoft Excel Course PC & MAC

    SGD $79.60

    Course Description

    Cut Excel down to size with our tailored online course. Achieve certificated proficiency in hours. Available in all major PC and Mac versions. We reviewed Excel's 500 functions, ruthlessly stripping out all non-essentials, to arrive at our highly refined syllabus. Our diagnostic tool then focuses your time on those parts of that syllabus that will be most valuable to you. Our regularly updated course consists of a carefully balanced combination of text, illustrations, videos and end-of-unit tests to measure your progress. Pick up the basics of Microsoft Excel and be fluent in all of its functions! - Learn from the basics to advanced functions of Microsoft Excel  - Know about the features and functions in Microsoft Excel  - Understand the features and functions offered in Microsoft Excel  - Be able to apply the skill set into your daily work to improve productivity Training for Excel PC (PC versions: 2013, 2007/10, 2003, 2016 | Mac versions: 2011, 2016) This course is Skillsfuture Credit Eligible.

    Read more...


Content

Introduction

Preview Available

+

What the Course Is About

Why Code VBA in Access

Objects

Preview Available

+

What an Object Is

Object Properties

Object Methods

Form Methods

Referencing Data in Code

What IS Is

Application Object

Window Object

Events and Event Procedures

+

Events and Event Procedures Introduction

Reading Data

Form Events

Object Events

Events Causing Events

Sample Event Procedure

Form and Record Navigation

+

Record Navigation Buttons

DoCmd Object

Record Navigation Events

Adding New Records

Form Operation Events

Report Operation Events

Sample Navigation

Collections and User-Defined Data Types

+

Creating Composite Data Types

Declaring Variables of Composite Types

Accessing Data in Composite Types

Nested Types

Dynamic Arrays

Collections

Creating a Collection

Searching a Collection

Sample Collection

VBA and Form Objects

+

Checkbox

Option Buttons

VBA Code for Option Groups

List Box Single Selection

List Box Multiple Selection

Filling List Box

Sample Data Fill

Embedded SQL

+

What Embedded SQL Is

SELECT Statement

WHERE Clause

Computed Fields

SQL Summation Functions

SQL Row Limitation Functions

Sample Query

Sorting Results

Grouping Results

Sample Gathering

Joins

Sample Join

Action Queries

Recordsets

+

What a Recordset Is

Creating a Recordset

Opening Recordsets

Recordset Navigation

Finding Records

Reading and Updating Records

Adding and Deleting Records

Snapshot Recordsets

Sample Recordset

Sample Recordset Use

Sample Recordset Find

Classes

+

What a Class Is

Defining a Class and Data

Class Properties

Class Methods

Initialize Method

Sample Class Design

Sample Class Code

Databases

+

Using Data from a Remote Database

Database Object

Connection Object

Using Remote Databases

Referencing Remote Databases

Conclusion

+

Course Wrap Up

Planning for Events

Navigation Forms

Resource Files

Credits

+

About the Author

SGD $40.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.