| Assignments | Link to retrieve |
|---|---|
| Week #1 Assignments Week ending January 25th |
Please send me an email
containing your name, course you are taking, what option you are in and
your reasons for taking this course. Please review the information from CIS11 on Access. Please read chapter #1 in the text - it is a combination review and intro. Read the notes on Access - Introduction to Access 97 and view the PowerPoint presentation on Introduction To Access and Introduction to SQL in Access. You should also read information about SQL from the Web or a book. First Access Assignment |
| Week #2 Assignments Week ending February 1st |
Please read information about the concepts of a relational databases and third normal form. You
can use the links provided at this site or another source. You should also look at the Presentations listed under Relational Databases. Design tables for an oil company. Send it to me for comments before you do the implementation that is required below! Please view the PowerPoint presentation on a simple Relational Database Order System. Also view the PowerPoint presentations under Relational Databases and Queries. I am posting notes for Access 97 on this topic that you might find has some good information. Implement the oil design |
| Week #3 Assignments Week ending February 8th |
Continue looking at relational databases - we will do more with this later! Find information on the web or in a text relating to SQL to help you understand how to work with it! See notes on Week #4 for some I found. Please read the following. Functions etc with SQL Maintenance through SQL Subqueries Look at the examples in the database shown: Newdonor.mdb database with advanced SQL Assignment: SQL assignment |
| Week #4 Assignments Week ending February 15th |
Read chapter #2 in the text. I just discovered that my favorite SQL tutorial is no longer there! Here are some other sources: SQL Tutorial SQL Fundamentals More SQL sources Please review the requirements for the core Access 2000 exam. Make sure that you are comfortable with the things under Planning and Designing Databases, Working with Access and Building and Modifying Tables. Access 2000 Core Please view the following presentation: Formatting data sheet and basic tools Separate speaker notes to accompany Formatting data sheet and basic tools Please read the following: Data properties Written for Access97 Building a table Written for Access2000 Your assignment: Table assignment |
| Week #5 Assignments Week ending February 22nd |
This is an interesting reference I came across Please read chapter #3 in the text. Look at the following: textmanipu.mdb Functions etc. Function examples Written for Access2000 Some sources on function information: Some basic information Access tips (functions_ Assignment: Quiz #1 |
| Week #6 Assignments Week ending March 1st |
Please view the PowerPoint presentation on importing and linking: Importing and linking from Access Separate speaker notes to accompany importing and linking from Access The sample database that I used was: import.mdb Experimenting with importing and linking Read chapter #4 in the text and start looking at information on forms. Read the notes on forms and look at the sample database available at this site. Introduction to forms - written for Access97 More information on forms - written for Access97 Creating a form using studentrel00.mdb in Access2000 studentrel00.mdb Student relational database with forms No written assignments - catch up week! However, it might be valuable to experiment a little with forms! |
| Week #7 Assignments Week ending March 8th |
Please look at the information on forms, buttons and macros that is posted on the site. 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 Also read chapter #5 in the text book. Assignment: Assignment on forms |
| Week #8 Assignments Week ending March 15th |
Please read the following:
Introduction to reports Written for Access2000 Data manipulation in reports Written for Access2000 Start looking at the following information on VBA: 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 The databases that accompany these examples are at the site. Assignment: Macro and Report Assignment |
| Spring Break Week ending March 22nd |
Catch up time for all of us! |
| Week #9 Assignments Week ending March 29th |
Please read the following: Loops in VBAccess Call and pass in VBAccess Experiments with VB - calculation, loop, array This week I would like you to play with VB in Access. Get comfortable with the concepts. No assignment to pass in! We all seem to be behind so take this opportunity to do some more catch up - I need to as well! |
| Week #10 Assignments Week ending April 5th |
Please read chapter #6 in the text. Assignment: Access, VB Assignment |
| Week #11 Assignments Week ending April 12th |
Please read the following: Example of Visual Basic in a payroll form Examples of Visual Basic using option buttons Examples of navigation using Visual Basic Assignment: Quiz #2 |
| Week #12 Assignments Week ending April 19th |
Please read chapter #7 in the text. Also read the following: 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 Assignment: Project |
| Week #13 Assignments Week ending April 26th |
I suggest that you skim chapters #8, #9 and #10. Work on the project. Please note that I had a very serious problems with my email today (4/24). I think I finally got everything, but if you sent me something today and I do not get it back to you sometime next week, please send me an email asking if I got it. |
| Week #14 Assignments Week ending May 3rd |
Continue with the project! |
| Week #15 Assignments Week ending May 10th |
The final must be passed in by 4:00, May 14th or you have to come and take it during
the designated time. The final should be emailed to me at the usual address and
also to pgrocer@bristol.mass.edu. Needless to say, the final is given on the
honor system! Please note that the status sheet is a requirement and must be
passed in with the final or before. Final Exam Status Sheet - Required |