| Assignments | Link to retrieve |
|---|---|
| Week #1 Assignments Week of June 3rd |
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. Assignments: First Access Assignment |
| Week #2 Assignments Week of June 10th |
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. Assignments: Implement the oil design due in two weeks |
| Week #3 Assignments Week of June 17th |
Continue looking at relational databases - it is important to understand! Find information on the web or in a text relating to SQL to help you understand how to work with it! 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 Please review the requirements for the core Access 2000 exam. You should be checking back here as the semester goes on and making sure that you know with the skills required. Make sure that you are comfortable with the things under Planning and Designing Databases, Working with Access and Building and Modifying Tables. More on that next week. Access 2000 Core Read chapter #2 in the text. Assignments: SQL assignment |
| Week #4 Assignments Week of June 24th |
Please continue reviewing 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 Assignments: Table assignment |
| Week #5 Assignments Week of July 1st |
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_ 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 Assignment: Quiz #1 |
| Week #6 Assignments Week of July 8th |
Read chapter #4 and start reading chapter #5 (finish it next week) 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 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 Assignment: Assignment on forms |
| Week #7 Assignments Week of July 15th |
Please finish reading chapter #5. 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 |
| Week #8 Assignments Week of July 22nd |
Please read chapter #6 in the text and 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. Assignment: Access, VB Assignment |
| Week #9 Assignments Week of July 29th |
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 #10 Assignments Week of August 5th |
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 #11 Assignment Week of August 12th |
Read chapters #8, #9, and #10 - you should read them to get an understanding of
capabilities and web based implementation. Continue working on the project. No new assignments. |
| Week #12 Assignments Week of August 19th |
Final will be posted! Assignment: Experiment with security including passwords, hyperlinks and data access pages. Do examples similiar to the examples in your text - I am not looking for a major project - I am looking for basic examples that show you have an understanding of the basics covered. Test the web components with a browser and a database on your computer - not online. |
| Week #13 Assignments Week of August 26th |
The final must be passed in 4:00 on Monday, August 26th. All students must take the
final whether or not they will complete the course on time. The final is given on
the honor system and I trust you to respect that - the only person you can discuss
the final with is me! If you have not passed in the final by 4:00 on Monday, August 26th, points will be subtracted. The status sheet is a requirement of the course - it is also your insurance to make sure that you and I have the same information - I will contact you if there is a problem! Please send me the final using the usual email address and also send a copy to me at pgrocer@bristol.mass.edu. Final Exam Status Sheet - required If you need a little extra time to complete the work, let me know. The summer involves the same amount of work with less time so I will be as flexible as I can. However, if something is going to be late, we must have agreed via email or penalty points will be taken from your grade. |