Don't click on me...I can't even spell VB

Working With DataBases
and
Visual Basic & ASP


This page is designed to help you learn about relational databases. I have include both Access and SQL lessons, projects, and videos for you. These examples were adapted from my study group I conducted at my college so they are in VB and some are in ASP.Net.

Return to Main Menu 

Access Downloads:

SQL Downloads:

Resources:

Topic/Lesson

The Details

  • Lesson 1
    MS ACCESS DATA BASES  Part I: USING WIZARDS
    Chapters 13 & 14

Access Databases Step 3: Using textboxes and validation. (Step 3 shows a different way to manage data)

Access Databases Step 4 & 5

Access Databases Searching for records using the designer.
 

  • Lesson 1 Advanced
    MS ACCESS DATA BASES Part I: USING WIZARDS
Working With ADO Objects In Code (Access DB)
  • Lessons 2
    MS ACCESS DATA BASES Part II: ADO in code
    Chapter 16
  • Get my database for lesson 2
  • ADO 2.0 Part II; Steps 1 & 2 (Step 1 displays data in a grid using code.
  • Step 2 lets you select/update/delete records. The project has 2 forms. The database & images are included.)
  • Step 2 also shows how to encrypt/decrypt your connection strings!
  • Lesson 2 Advanced
    MS ACCESS DATA BASES Part II: ADO in code

Introduction to SQL Server & SQL Express
  • Lesson 3
    SQL Express DATA BASES I (Using the ADO Objects & Wizards)
    Chapters 13 & 14
  • Lesson 4
    SQL Express DATA BASES II (ADO in Code)
    Chapters 13 & 14