| Assignments | Link to retrieve |
|---|---|
| Assignments Week #1 September 8th |
Please go to the board and introduce yourself. Also 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. 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 |
| Assignments Week #2 September 15th |
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 |
| Assignments Week #3 September 22nd |
Please view the PowerPoint presentation on a simple Relational Database Order System. Also view the PowerPoint presentations under Relational Databases and Queries. Also, I am posting notes for Access 97 on this topic that you might find has some good information. Implement the oil design |
| Assignments Week #4 September 29th |
Please read the following. Functions etc with SQL Maintenance through SQL Subqueries Look at the examples in the database shown - I went over these examples in class: Newdonor.mdb database with advanced SQL Assignment: SQL assignment |
| Assignments Week #5 October 6th |
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 Read/skim chapter #1 in the text and read chapter #2 Your assignment: Building a table |
| Assignments Week #6 October 13th |
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 #3 in the text book. textmanipu.mdb Functions etc. Function examples Written for Access2000 We did not get to importing and linking this week - they will be done next week. Your assignment is a quiz that is a little different from most quizzes. You are welcome to discuss it with people and try to figure out the correct solution, you are welcome to try you solutions on the computer. I just want you to figure out and understand the solution. Due in 1 week. Quiz #1 |
| Assignments Week #7 October 20th |
Look at the information on importing and linking from last week. Read chapter #4 in the text book. 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 Assignment on forms, linking and importing |
| Assignments Week #8 October 27th |
Please look at the information on forms, buttons and macros that is posted on the site. That
is what we would have gone over this week in class. Creating a form with buttons - Written for Access2000 More options on forms - Written for Access2000 Creating a form menu - Written for Access2000 Also read chapter #5 in the text book. Since I was out today, we will have a catch up week with no new written assignments. |
| Assignments Week #9 November 3rd |
Please look at the information on macros - the creating a form menu that I posted last week
and the handout on macros. Remember chapter #4 has information on macros. Macros Written for Access2000 The macro assignment is: Macro assignment |
| Assignments Week #10 November 10th |
Veterans Day - no class Otherwise known as catch up week!!! |
| Assignments Week #11 November 17th |
Please read the following:
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 The databases that accompany these examples are at the site. Assignment: Report and VB assignment |
| Assignments Week #12 November 24th |
Please read the following: Loops in VBAccess Call and pass in VBAccess Experiments with VB - calculation, loop, array Assignment: Visual Basic in Access assignment |
| Assignments Week #13 December 1st |
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 Quiz #2 This quiz may be discussed with others but each person must pass in individual answers - we will start the work in class. |
| Asssignments Week #14 December 8th |
Please read the following: Example using VB for menu choices Example of DoCmd in VB Example of switchboard Example of hyperlink and introduction to web No assignment - the final exam will be posted next week. I will be on campus on Sunday from 10:00 until 4:00 if people need help. |
| Assignments Week #15 December 15th |
DAO with Access and VB Web pages Final Exam - due by December 22 at 4:00 - pass in via email Final Exam Required status sheet - must be passed in by this weekend |