| Schedule by week | Information to cover |
|---|---|
|
If you do not have PowerPoint:
Free PowerPoint viewer for 97,2000,2002 users Note that the speaker notes are provided on a separate Word document if you are having trouble accessing them! | |
| Week #15 Assignments Week of December 13th |
The final and required status sheet are due on Tuesday, December 21st. It is an open note,
open book exam that should not be discussed with anyone but me. Final Exam: Final Exam Required status sheet |
| Week #14 Assignments Week of December 6th |
This week I want you to look at Access on the web. Please look at my PowerPoint presentation
on Access Web. Assignment: Please get a site that you can upload an Access database to - I used Brinkster which offers free educational space (www.brinkster.com). Upload one of your databases to the site and then maintain the site with adds, changes and deletes and do several queries including a variety of features and multiple tables (5 queries should do it). Take pictures of the screen and send me the results. |
| Week #13 Assignments Week of November 29th |
This week I want you to make sure you are comfortable with the basics of security including
passwords, hyperlinks and data access pages. Assignment: Do an assignment to demonstrate some of the elements you studied in the area of security, passwords, hyperlinks and data accesspages - 3 diferent things is fine. |
| Week #12 Assignments Week of November 22nd |
Continue reading chapter #8, #9 and #10. Assignment: Continue working on the project. |
| Week #11 Assignments Week of November 15th |
Please read chapter #8, #9 and #10 in the text over the next few weeks - a chapter a week works. Many of the links I suggested last week relate to this material. Assignment: Continue working on the project. |
| Week #10 Assignments Week of November 8th |
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 We need to look at web processing, error trapping and some minor things but I will give you a lot of time to work on this project for the rest of the semester. |
| Week #9 Assignments Week of November 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 Assignment: Quiz #2 |
| Week #8 Assignments Week of October 25th |
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 #7 Assignments Week of October 18th |
Please finish reading chapter #5 and start reading chapter #6. 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 #6 Assignments Week of October 11th |
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 #5 Assignments Week of October 4th |
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 Access information: Access functions at tech on the net Access functions Access overview MS Access fundamentals Access 2000 Access 2000 tutorial Another tutorial Access tutorial 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 Note that the bulletin board is there for you to communicate - you might see if anyone is interested in getting together. |
| Week #4 Assignments Week of September 27th |
Read tutorial #3 this week. Some SQL information sources: SQL Tutorial SQL Fundamentals More SQL sources Please continue to 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 Assignments: Data assignment |
| Week #3 Assignments Week of September 20th |
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/XP2002/2003 exams. Access 2000 Core General page on exams You should be checking this list as the course goes along to make sure you know the material that Access is stressing. Continue reading tutorial #2 in the text. (remember, you need to order this book off the web - you can get the information from the syllabus) Assignments: SQL assignment |
| Week #2 Assignments Week of September 13th |
Please read tutorial #2. You should also read about 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. Assignments: I want you to design the database tables for the credit union problem and let me review the design before you implement it. You should then implement it in Access. Credit Union Assignment |
| Week #1 Assignments Week of September 6th |
I know the course really does not start until September 13th, but I will go nuts
remembering a different start date, and some of you indicated you wanted to start
early, so... Please review introductory material on Access. Please order the text for this course (see syllabus). When you receive it, please read tutorial #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. All of the versions of Access have a basic similarity so it really is up to you which version you use. You should also read information about SQL from the Web or a book. I recommend that you spend time with this tutorial: SQL tutorial If you are having trouble with SQL, please let me know. Assignments: First Access Assignment |