| Assignments | Link to retrieve |
|---|---|
| Assignments Week #1 January 26th |
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 February 2nd |
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 February 9th |
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 February 16th |
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 February 23rd |
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 March 2nd |
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 March 9th |
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 March 23rd |
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. The macro assignment is: Macro assignment |
| Assignments Week #9 March March 30th |
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 #10 April 6th |
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 #11 April 13th |
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 #12 April 20th |
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 Assignment: To be posted! |
| Assignments Week #13 April 27th |
DAO with Access and VB Web pages Assignment: To be posted! |
| Assignments Week #14 May 4th |
Final Exam/Project to be posted! |