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 2000
|Syllabus||Syllabus for CIS56|
|Resources||Notes and handouts for CIS56
Sample programs for CIS56
|Work||Programs for CIS56
Assignments for CIS56
Test information for CIS56
|Visual Basic Links||Links to Visual Basic for CIS56|
|Notes and handouts||Link to retrieve|
|BCC lab handout||BCC Lab instructions to log in and use
Notes on breaks
Notes on top down sort
Notes on bubble sort
|Notes on Access||
Intro to Access
Introduction to VB Access
Continuation of VB Access Introduction
If statements in VB Access
More on IF with nesting
Loops in VBAccess
Call and pass in VBAccess
Notes on ADO Data Controls
|Notes on SQL||
SQL from Access
Generic notes on SQL
|Presentations||Link to retrieve|
Minor Break Processing PowerPoint Presentation
|Assignments||Link to retrieve|
|Text||Read chapters #1, #2, #3 - look ahead and read about IF statements and For statements
in chapter #5 and #6 - honest, we will cover #4 and the rest of the information in #5 and
Now read chapter #4 and then we will move into a complete coverage of chapters #5 and #6.
Read chapter #5 and #6 for the week of Feb 21st.
Read chapter #7 on arrays.
Read chapters #8 and #9 on files.
Read information on Access from a book, the Web etc.
Read the posted notes on programming in Access using VB.
I am skipping chapter #10 and #11 for now - I will definately get back to #11 - we may not make it back to #10.
Read chapter #12 on databases.
|Programs to write||Link to retrieve|
assign1.html Try Visual Basic
assign2.html Experiment with 20 things
Assignment to flip a name using functions
Assignment using if, case and do
Writing a top down sort
Extra credit: Modify the days of the week program to handle dates in 2000.
VB in Access Assignment
Access from VB assignment - (NOTE: Revised from the original posting - Sorry, I made a mistake and copied an old problem that I meant to revise - extra credit if you already did the original posting of problem #3) - Note also this is not officially assigned until after the class on Tuesday and there is some helpful information coming. I didn't complete everything on Thursday. If you want to do it now, see the handout on ADO under Access Notes. It gives step by step instructions.
Explain the following program - be specific and explain the commands.
I will be in Saturday from 10:00 until around 4:00 to help with assignment problems.
VBfstproj00.html Visual Basic Project #1
Pay Project - Project #2
|Test Information||Link to retrieve|
|Quiz on Chapter #3||quizch3.html
|Final Exam||If you are caught up, you may take the final exam alternative that is posted here. Note, the database
you need to use will be available on Monday, May 8th in K-205. Be sure to check the exam to determine your
eligibility to take this alternative.
Final exam alternative
Status sheet for CIS56
The status sheet must be turned in with the final!
I have enoyed the class and appreciate the work you have done!
|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