Visual Basic - CIS56

The information at this site is in draft form and is the property of Priscilla Grocer. The information may not be duplicated or distributed without her permission. ©Copyright 2002

Category Information
Introduction
Syllabus
Introduction to CIS56 - methods, expectations etc.
Syllabus for CIS56
Resources Notes and handouts for CIS56
PowerPoint Presentations
Sample programs for CIS56
Sample programs using Access and Excel for CIS56
Board Room
Work Weekly schedule for CIS56
Test information for CIS56
Links Links to Visual Basic for CIS56
Links to SQL for CIS56

Back to the Top



Notes and handouts Link to retrieve
BCC lab handout BCC Lab instructions to log in and use software
Information on color Color Codes
Color Codes
Color chart
Color code information and links - interesting information
Another color reference
Logic notes Notes on breaks
Notes on top down sort
Notes on bubble sort
Notes on ADO and Access Notes on ADO Data Controls
Notes on Access

These notes are from another course.
They are provided as a resource.
They are not a requirement of this course!
Intro to Access 97
Introduction to relationships
More on relationships and queries
Information on filters Written for Access97
Data properties Written for Access97
Building a table Written for Access2000
Function examples Written for Access2000
Introduction to forms Written for Access97
More information on forms Written for Access97
Creating a form using studentrel00.mdb Written for Access2000
Creating a form with buttons Written for Access2000
More options on forms Written for Access2000
Creating a form menu Written for Access2000
Macros Written for Access2000
Introduction to reports Written for Access2000
Data manipulation in reports Written for Access2000
Visual Basic in Access Introduction to VB Access Written for Access97
Continuation of VB Access Introduction Written for Access97
If statements in VB Access Written for Access97
More on IF with nesting Written for Access97
Loops in VBAccess
Call and pass in VBAccess
Experiments with VB - calculation, loop, array
Example of Visual Basic in a payroll form
Examples of Visual Basic using option buttons
Examples of navigation using Visual Basic
Example using VB for menu choices
Example of DoCmd in VB
Example of switchboard
Example of hyperlink and introduction to web
DAO with Access and VB
Web pages
Notes on SQL SQL from Access
Generic notes on SQL

Back to the Top



Presentations Link to retrieve
VB Introductory Presentations Starting in Visual Basic
    Separate speaker notes to accompany Starting in Visual Basic
Introduction to Visual Basic
    Separate speaker notes to accompany Introduction to Visual Basic
Settings in VB
    Separate speaker notes to accompany settings in VB
Pay examples (projpay)- basic calculations
    Separate speaker notes to accompany pay examples
PFirst98 which includes basic pay
    Separate speaker notes to accompany PFirst98
IF statements calculations etc.
including one on style with lines
and shapes
Style with lines and shapes
    Separate speaker notes to accompany style with lines and shapes
Inventory programs (inven1, inven2, inven3 etc.)
    Separate speaker notes to accompany inven1, inven2, inven3 etc.
Bill examples - using IF
    Separate speaker notes to accompany bill examples
Calculate examples
    Separate speaker notes to accompany calculate examples
Inventory example (inveasy)
    Separate speaker notes to accompany inventory example (inveasy)
Introduction to graphics/images Introduction to graphics/images
    Separate speaker notes to accompany introduction to graphics/images
For loops examples For loop examples
    Separate speaker notes to accompany for loops
Read and Write - I/O Read and Write - I/O
    Separate speaker notes to accompany Read and Write - I/O
Muffins Muffins
    Separate speaker notes to accompamy muffins
Breaks Break processing
    Separate speaker notes to accompany break processing
DO Loops Working with do loops
    Separate speaker notes to accompany working with do loops
More on do loops (interest)
    Separate speaker notes to accompany more on do loops (interest)
Functions and Procedures Functions
    Separate speaker notes to accompany functions
Subprograms
    Separate speaker notes to accompany subroutines
Arrays Introduction to arrays
    Separate speaker notes to accompany introduction to arrays
Topdown sort
    Separate speaker notes to accompany topdown sort
Bubble sort
    Separate speaker notes to accompany bubble sort
Arrays continued
    Separate speaker notes to accompany arrays continued
Date Conversion
    Separate speaker notes to accompany date conversion revised 3/21/01
More on arrays and introduction to menus
    Separate speaker notes to accompany more on arrays and introduction to menus
Maximum Profit explanation
    Separate speaker notes to accompany maximum profit explanation
Random Random processing
    Separate speaker notes to accompany random processing
Two forms Two form processing
    Separate speaker notes to accompany two form processing
Combo boxes etc. List combo information
    Separate speaker notes to accompany list combo information
Access
Note that I have left old
presentations on DAO out here
in case anyone is interested
in this information
Introduction to Access 2000
    Separate speaker notes to accompany introduction to Access 2000
Using an Access 97 database
    Separate speaker notes to accompany using an Access 97 database
Using ADO data control in Access 2000
    Separate speaker notes to accompany using ADO data control in Access 2000
Examples with DAO and Access 97
    Separate speaker notes to accompany examples with DAO and Access 97
Introduction to SQL in Access
    Speaker speaker notes to accompany introduction to SQL in Access
Introduction to using SQL with a ADO in VB
    Separate speaker notes to accompany introduction to using SQL with a ADO in VB
VB with Access 97 - basic code
    Separate speaker notes to accompany VB with Access 97 - basic code
ADO controls and grids
    Separate speaker notes to accompany ADO controls and grids
Using multiple tables etc. with ADO and Access 2000
    Separate speaker notes to accompany using multiple tables etc. wtih ADO and Access 2000
DAO and ADO and VisData
    Separate speaker notes to accompany DAO and ADO and VisData

Back to the Top

Test Information Link to retrieve
Final Exam See weekly assignments for posted final

Resources and sites on the Web Link to retrieve
Visual Basic Links Programming Tutorials
Lots of information on Visual Basic
Another site with lots of information and tutorials
Tutorial on databases and VB
Lots of VB links including using VB with Access
SQL Links SQL Tutorial
A Gentle Introduction to SQL
SQL Interpreter and Tutorial


Send e-mail to Mrs. Grocer:

pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page