OntarioTECK VBA Developers!

OntarioTECK VBA Developers is a small organization incorporated to offer services to the government. My wife and business partners and I are the only ones in this company.

I am always learning something new, not because I like to, but because I have to in order to offer my skills effectively. The digital revolution has transformed virtually every area of human activity, making it essential to acquire new skills to stay at the heart of today’s dynamic workforce.

Carleton University Boot Camp is an intensive 24-week program that prepares you to build end-to-end web applications and become a full stack web developer. It features online classes and hands-on projects, all designed to fit within your busy schedule.

Here is a small list of Departments and Organizations I've worked with:


During my long career, I have worked for many government departments as well as in the private sector. I definitely enjoy working for the government, where projects, needs, and ideas are usually well-grounded. In other words, I jump right into the fast lane, learning their needs and developing their projects.

Visual Basic for Applications (VBA)

Definition and Explanation:

Visual Basic for Applications (VBA) is an event-driven programming language from Microsoft that is primarily used for automating tasks in Microsoft Office applications. VBA allows users to write macros to automate repetitive tasks, manipulate data, and create custom functions and forms within Excel, Word, Access, and other Office applications.

Benefits:
  • Automates repetitive tasks, saving time and effort.
  • Enhances functionality of Office applications.
  • Easy to learn for beginners with basic programming knowledge.
  • Integrates seamlessly with other Microsoft Office tools.
  • Allows creation of custom user interfaces and forms.

Yes! I still do work in Visual Basic for Applications. The very text you are ready was entered in Access VBA, now the HTML formatting can be done by any On-Line html services existing in the Internet. Click here to see some snapshot of Applications in VBA.

SQL Server - TSQL (SQL)

Definition and Explanation:

SQL Server is a relational database management system developed by Microsoft. Transact-SQL (TSQL) is an extension of SQL that includes procedural programming, local variables, and various other features for managing and manipulating data within SQL Server. TSQL is used for querying, updating, and managing data in SQL Server databases.

Benefits:
  • Efficiently manages large volumes of data.
  • Provides robust security features.
  • Supports complex queries and data manipulation.
  • Integrates well with other Microsoft products.
  • Offers high availability and disaster recovery options.

Microsoft Access (Database)

Definition and Explanation:

Microsoft Access is a database management system that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is used to create and manage databases, allowing users to store, retrieve, and analyze data. Access is suitable for small to medium-sized databases and is often used for personal or small business applications.

Benefits:
  • User-friendly interface for database management.
  • Supports integration with other Microsoft Office applications.
  • Provides powerful querying and reporting tools.
  • Allows creation of custom forms and reports.
  • Suitable for small to medium-sized databases.

ASP.Net (Active Server Pages)

Definition and Explanation:

ASP.Net is an open-source server-side web application framework designed for web development to produce dynamic web pages. Developed by Microsoft, it allows developers to build web applications, services, and websites with HTML, CSS, JavaScript, and server-side scripting. ASP.Net supports multiple programming languages, including C# and VB.Net.

Benefits:
  • Supports rapid development of web applications.
  • Provides robust security features.
  • Integrates seamlessly with other Microsoft technologies.
  • Offers high performance and scalability.
  • Supports multiple programming languages.

Razor Pages (ASP.Net Core Razor Pages)

Definition and Explanation:

Razor Pages is a page-based coding model for building web applications in ASP.Net Core. It simplifies the development of web applications by providing a more straightforward approach compared to MVC (Model-View-Controller). Razor Pages are designed to make coding page-focused scenarios easier and more productive.

Benefits:
  • Simplifies web application development.
  • Enhances productivity with a page-focused approach.
  • Integrates seamlessly with ASP.Net Core.
  • Provides robust security features.
  • Supports clean and maintainable code.

Bootstrap (CSS Platform)

Definition and Explanation:

Bootstrap is a free and open-source CSS framework directed at responsive, mobile-first front-end web development. It contains CSS- and JavaScript-based design templates for typography, forms, buttons, navigation, and other interface components. Bootstrap helps developers create responsive and visually appealing web pages quickly and efficiently.

Benefits:
    Facilitates responsive web design. Provides a wide range of pre-designed components. Easy to use and integrate. Enhances consistency across web pages. Supports customization and scalability.