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

  • Discover the Benefits of VMWare Workstation 8

    Discover the Benefits of VMWare Workstation 8

    SGD $45.00

    Course Description

    Virtual computing is one of the most exciting and in-demand aspects of Information Technology. From the user's laptop to the back office server, virtual computing is changing the way we think about and utilize our physical machines. VMWare is the industry leader in virtualization technology and product innovation. Workstation 8 is the latest version of the most popular desktop virtualization software available. It provides a mature, stable, and innovative environment for creating and managing virtual machines. It is also the place to begin to introduce yourself to the world of virtual computing and the place to begin your quest to become certified on VMWare's extensive product line. In this VTC course, author Mark Long will introduce you to Workstation 8 and guide you through the process of using Workstation to create, manage, and utilize virtualization on your computer, whether you are using a laptop or a multi-processor server. VMWare is the industry leader in virtualization technology and product innovation.- Know more about the functions of VMWare- Learn about the benefits of using VMWare - Discover how VMWare can provide a smoother working experince - Learn more about the comcpet of using VMWare This course is SkillsFuture Credit Eligible.

    Read more...

  • Discover More of Your Data with Microsoft Excel

    Discover More of Your Data with Microsoft Excel

    SGD $40.00

    Course Description

    Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.Realise the full potential of your data with Microsoft Excel. - Learn about the functions in Excel that can help your understand data better - Know the different ways of vizualising your data with Excel- Pick up the knowledge of utilizing Excel for better understanding your data- Learn how you can stretch your data for optimum analysis This course is SkillsFuture Credit Eligible.

    Read more...

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

    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.