Advanced Visual Basic - CIS67

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 CIS67 - methods, expectations etc. Syllabus for CIS67
Resources	Notes and handouts for CIS67 PowerPoint Presentations Board Room Sample programs for CIS67 Sample programs continued for CIS67
Work	Weekly schedule for CIS67 Test information for CIS67
Visual Basic Links	Links to Visual Basic for CIS67

Back to the Top

Notes and handouts	Link to retrieve
BCC lab handout	BCC Lab instructions to log in and use software
Notes on ADO and Access	Notes on ADO Data Controls
Notes on Access - note these are notes from other classes provided here for Access information only	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 SQL	SQL from Access Generic notes on SQL

Back to the Top

Presentations	Link to retrieve
MDI & SDI Presentations	MDI parent child forms and menus     Separate speaker notes to accompany MDI parent child forms and menus MDI menu including cup/copy/paste     Separate speaker notes to accompany MDI menu including cup/copy/paste SDI multiple forms     Separate speaker notes to accompany SDI Multiple forms Muffin example using SDI and MDI forms     Separate speaker notes to accompany muffin example using SDI and MDI forms
Basic Printing	Printing basic reports using break processing as the example     Separate speaker notes to accompany printing simple reports with breaks
Controls	Presentation on scroll, slide and status     Separate speaker notes to accompany presentation on scroll, slide and status Presentation on tool bar and image list     Separate speaker notes to accompany presentation on tool bar and image list Presentation on toolbar and status bar     Separate speaker notes to accompany presentation on toolbar and status bar Presentation on tab controls     Separate speaker notes to accompany presentation on tab controls Presentation on add controls     Separate speaker notes to accompany presentation on add controls Presentation on tree view and list view controls     Separate speaker notes to accompany presentation on tree view and list view controls
ADO	Using ADO data control in Access 2000     Separate speaker notes to accompany using ADO data control in Access 2000 Introduction to using SQL with a ADO in VB     Separate speaker notes to accompany introduction to using SQL with a ADO in VB 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 ADO with multiple files and controls     Separate speaker notes to accompany ADO with multiple files and controls ADO notes misc     Separate speaker notes to accompany ADO notes misc
Data Environment & Reports	Basic use of Date Environment     Separate speaker notes to accompany basic use of Data Environment Data Environment and group reports     Separate speaker notes to accompany data environment and group reports Report and data relationships (hierarchy)     Separate speaker notes to accompany Report and data relationships (hierarchy) Unbound controls, find, filter etc     Separate speaker notes to accompany unbound controls, find, filter etc
Connecting to Access through code	Basic examples of connecting through code     Separate speaker notes to accompany basic examples of connecting through code Data Hierarchy and SHAPE language     Separate speaker notes to accompany data hierarchy and SHAPE language Using four tables with find and filter (code internal)     Separate speaker notes to accompany using four tables with find and filter (code internal) Shape experiments     Separate speaker notes to accompany shape experiments
Class	Introduction to class using CItem     Separate notes to accompany introduction to class using CItem More introductory material using class module savings account     Separate notes to accompany more introductory material using class module savings account Class and Collections     Separate notes to accompany Class and Collections Class and Access database     Separate notes to accompany Class and Access database
ActiveX	ActiveX DLL     Separate speaker notes to accompany ActiveX DLL ActiveX EXE     Separate speaker notes to accompany ActiveX EXE Word and Excel     Separate speaker notes to accompany Word and Excel ActiveX Control     Separate speaker notes to accompany ActiveX Control
Internet	Internet Project     Separate speaker notes to accompany Internet Project
Presentations on Access - these are reference - not part of this course	Using an Access 97 database     Separate speaker notes to accompany using an Access 97 database 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 Due December 21st at 4:00	Required status sheet Final Exam due at 4:00 on Friday the 21st of December. The final must be emailed to my usual address and to pgrocer@bristol.mass.edu. If you cannot email me the final by then, you must contact me ahead of time to make arrangements!

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