|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.
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.
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.
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.
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
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
|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.
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.
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 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
MS Access fundamentals
Access 2000 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
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:
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
|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
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)
|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.
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
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.
First Access Assignment