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