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