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

  • Google Sheets

    Google Sheets

    SGD $49.60

    Course Description

    Google Spreadsheets is rapidly overtaking Microsoft Excel in the workplace. Engage with this exciting new product and become a Google Sheets Master with this course. Google Sheets replicates many of Excel’s functions but has gone one step further. Expect to find charts, graphs, pivot tables, functions and formulas, but you’ll also discover what makes Google Sheets unique, like file sharing, revision history, web based scripts, macros, and much more. It’s not your typical spreadsheet.Keep up with the latest trend on how documents are made. - Know about all of the functions in Google Sheets- Learn how you can apply Google Sheets into your work - Learn about the different functions of Google Sheets- Know how Google Sheets can used in your projects 

    Read more...

  • Microsoft Excel: 2013 & Online Training Essentials

    Microsoft Excel: 2013 & Online Training Essentials

    SGD $99.00

    Course Description

    Microsoft Excel 2013 is a powerful spreadsheet application that is perfect for maintaining long lists of data, budgets, sales figures and other data. In this online series of training tutorials, we'll show you how to navigate through the basics of Excel and use some new features including Skycloud -- which allows you to share and store files in a location where you can access them with any computer that has Excel. Additionally, you'll learn how to create tables, move information around with ease, and use formulas that can calculate the totals of everything from a monthly budget to a loan payment. Microsoft 2013 has been redesigned and several common functions are now much easier to use.This training series will make sure you get the most out of the Microsoft Excel 2013.- Learn the essential components of Microsoft Excel 2013- Learn about the new features of Microsoft Excel 2013- Understand how to apply the functions into real excel spreadsheets - Equip yourself with these skillset and improve your productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • Microsoft Office for Mac 2011

    Microsoft Office for Mac 2011

    SGD $45.00

    Course Description

    Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis. 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...


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.