Database Programming and Management with Access - CIS61

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
Information about CIS61 Introduction to CIS61 - methods, expectations etc
Syllabus
Resources Notes and handouts for CIS61
Presentations for CIS61
Databases for CIS61
Bulletin Board for CIS61
Work Weekly schedule for CIS61
Projects for CIS61
Test information for CIS61
Internet Information Links to information for CIS61
Back to the Top



Notes Link to retrieve
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
SQL SQL from Access
Generic notes on SQL
Functions etc with SQL
Maintenance through SQL
Subqueries
SQL Tutorial
SQL Fundamentals
More SQL sources
Relational databases Definitions
Notes on contribution or donation database design
Notes on very basic student database design

Back to the Top



Powerpoint presentations of material. These presentations can be opened or downloaded for future viewing. Free viewer for PowerPoint
NOTE: Students are reporting more success using Netscape for these presentations.
Apparently the speaker notes are a problem with the downloaded viewer. I will make copies of the speaker notes and store them in word documents.
Presentations Link to retrieve
Introduction to Access Introduction to Access 2000
    Separate speaker notes to accompany Introduction to Access 2000
Introduction to SQL Introduction to SQL in Access
    Speaker Notes to accompany Introduction to SQL in Access
Relational Database Normalization - information on third normal form
      Separate speaker notes to accompany normalization presentation
Relational database using donor
      Separate speaker notes to accompany relational databse using donors presentation
Relational Database Student System
      Separate speaker notes to accompany relational database student system presentation
Relational database order system example
      Separate speaker notes to accompany relational database order system example
Relational Database and Queries Implementation of a relational database and some advanced queries
      Separate speaker notes to accompany Implementation of a relational database and some advanced queries
Access setup Formatting data sheet and basic tools
      Separate speaker notes to accompany Formatting data sheet and basic tools
Access import and link Importing and linking from Access
      Separate speaker notes to accompany importing and linking from Access

Back to the Top



Databases Link to retrieve
Save File... and open in Access
Access 97 databases textbook.mdb
donor00.mdb
Access 2000 basic databases First2000.mdb
donor.mdb
Access 2000 relational databases donor.mdb With relations set and more queries
order2000.mdb Order database and queries
newdonor.mdb Advanced SQL
studentrel00.mdb Student relational database with forms
Access 2000 experiments createstu.mdb Experiment with data entry
import.mdb Experimenting with importing and linking
I stored the linked files on my C drive under the directory Access2000DB. Listed below are the files that I used if you want to experiment:
FirstlstL.dbf The dBase file that I used
Toimport.xls The spreadsheet I used - Sheet 1
nainfolink.txt The text file (created in Word and saved as .txt)
textmanipu.mdb Functions etc.
studentrel00.mdb Student relational database with macros & VB
customdonor.mdb Creating report
testreport.mdb Report with data manipulation
misc.mdb Misc. with VB
misctry.mdb Misc. with VB continued
oilco.mdb oil company with VB

Back to the Top



Projects Link to retrieve

Back to the Top



Test Information Link to retrieve
Quizzes Quiz #1 Read the notes about this on the assignment page.
Quiz #2 This quiz may be discussed with others but each person must pass in individual answers - we will start the work in class.

Back to the Top



Internet Information Link to retrieve
Relational databases Relational database info link
Relational example with explanation
Explanation of normalization - looks fairly straight forward
Article on Codd and relational databases, normalization etc.
Part II of the article above
Slide show on normalization etc.
Explanation of normalization etc.
Relational model - Codd
Second part
Third part
Lots of information on normalization and related concepts
One more...
Developing a relational database
Relational database info link - course including some info
Access Tutorials and References A Tutorial on Databases Using Access 97
Access tutorial
Access tutorial
MS-Access 97 Tutorial Part I
MS-Access 97 Tutorial Part II
MS-Access 97 Tutorial Part III
Tutorial on Access
Database Tutorial
MOUS Access Expert Level specifications
Lots of VB links including using VB with Access
SQL Tutorials and References SQL tutorial
SQL tutorial
List of SQL Tutorials


Send e-mail to Mrs. Grocer:

pgrocer@bristol.mass.edu

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