VBA + VB.Net and Java (edit)

  • VB6
  • VB6  for Access 2016
  • VBA
  • VBA for Excel
  • VB.NET
  • Java

App:

  • Word
    • Table
    • Image
  • Excel
    • Excel Chart
    • Excel Range
    • Excel Image
  • PowerPoint
  • PDF
  • Microsoft Print to PDF

Concept:

  • Coding Standards and Code Reviews
  • Coding Techniques
  • Best Practices
  • Conclusion
  • Suggested Reading​

RVBA Naming Conventions - Xoc Software (RVBA Conventions, Maya Calendar, et.al.)

Object Naming Conventions | Microsoft Docs (VB6)

Constant and Variable Naming Conventions | Microsoft Docs (VB6)

Structured Coding Conventions | Microsoft Docs (VB6)

Visual Basic for Applications - Excel VBA - The full course | Udemy

  • create your own macro in Excel
  • program in VBA
  • understand Visual Basic for Applications
  • create automated reports in Excel
  • develop your applications and tools in Excel

Visual Basic for Microsoft Access Tutorial | Udemy

Visual Basic 6.0 Tutorial: Getting Started With Visual Basic Programming - Udemy Blog

Visual Basic Timer: How to Use It to Schedule Your Tasks - Udemy Blog

C# and Access 2016

C# Database Driven WinForm Apps (step by step projects) | Udemy

  • Students will understand the basics of database programming using C# and MS Access database.
  • Students will become familiar with database programming concepts.
  • Students will be able to create small database-driven desktop apps.
  • Students will understand basics of database concepts.
  • Students will be able to create and modify Windows Forms and bind form objects with database objects.
  • Students will be ready to tackle more complex projects.
  • Visual Studio
  • Basic familiarity with Windows Forms
  • Basic C# Skills (loops, conditional statements, very basics of OOP etc.)
  • Basic knowledge of Database terminology

VB and Access

Microsoft Access, SQL: Visual Basic, Database Administration | Udemy

VB.NET

VB.NET Masterclass: Learn Visual Basic and VBScript | Udemy

Learning Visual Basic .NET Tutorials: VB.NET Programming | Udemy

Coding Conventions - Visual Basic | Microsoft Docs

Visual Basic .NET Tutorial for Beginners Make App That Sells | Udemy

Visual Basic .NET Programming for Complete Beginners | Udemy

  • Produce Windows Console Applications
  • Learn the fundamentals of Visual Basic .NET
  • How to understand and write simple Visual Basic .NET programs
  • Design and build Windows Forms Application
  • By learning Visual Basic .NET Basics, you will be able to jump quickly into the intermediate level of this programming language
  • Create a database in Microsoft Access 2016
  • Connect to Access database by using commands in a central module
  • Do Simple Data Binding and Complex Data Binding
  • Manage data in the database by doing CRUD Operations
  • Write SQL statements for retrieving and searching from a single point
  • Create a Product Management System (Complete CRUD Application)
  • Create Multiple Document Interface (MDI) Application

Some pet projects:

  • Create and write Excel files in C# and VB.NET
  • Create an Excel (XLSX) or PDF file in ASP.NET
  • Create Excel Chart in C# and VB.NET
  • Open and read Excel files in C# and VB.NET
  • Read and write CSV (or TSV) in C# and VB.NET
  • Convert Excel files to PDF in C# and VB.NET
  • Convert Excel files to image formats in C# and VB.NET
  • Convert Excel files to HTML in C# and VB.NET
  • Print Excel files in C# and VB.NET
  • Export Excel files from ASP.NET GridView
  • Export a DataTable or DataSet to an Excel file in C# and VB.NET
  • Export Excel sheet into DataTable in C# and VB.NET
  • Import and Export Excel to DataGridView in C# and VB.NET
  • Referencing Excel cell and range in C# and VB.NET
  • Excel Formula Calculation in C# and VB.NET