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 2001

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

Back to the Top

Notes and handouts	Link to retrieve
BCC lab handout	BCC Lab instructions to log in and use software
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	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 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 ADO Data Controls
Notes on SQL	SQL from Access Generic notes on SQL

Back to the Top

Presentations

Link to retrieve

VB Presentations

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 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) For loop examples     Separate speaker notes to accompany for loops Read and Write - I/O     Separate speaker notes to accompany Read and Write - I/O Functions     Separate speaker notes to accompany functions Subprograms     Separate speaker notes to accompany subroutines Muffins     Separate speaker notes to accompamy muffins Break processing     Separate speaker notes to accompany break processing 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) 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 processing     Separate speaker notes to accompany random processing Two form processing     Separate speaker notes to accompany two form processing List combo information     Separate speaker notes to accompany list combo 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

The final exam can be done using the take-home exam below or done in class using an exam that will be distributed at that time. The exam below is given using the honor system and must be passed in by 10:15 on Friday, May 11th. If you do not meet that deadline, you must take the in class final! You must pass in a completed status sheet or you have not completed the course! The status sheet is your insurance that our records agree. If there are any significant disagreements, I will get back to you! Take-home final exam alternative Required status sheet Email to my home email and to my email at pgrocer@bristol.mass.edu.

Resources and sites on the Web	Link to retrieve
Visual Basic Pages	Carl and Gary's Visual Basic Home Page On-line VB Magazine Lots of information on Visual Basic Another site with lots of information and tutorials Tutorial on databases and VB

Send e-mail to Mrs. Grocer:

pgrocer@bristol.mass.edu

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