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