| 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! Please check the weekly schedule multiple times per week, I sometimes add information during the week. Please keep copies of all work you submit until you receive your final grade at the end of the semester. | |
| Final Week Week of May 12th |
Final exam/project due by midnight on May 12th. Status sheet is also due.
Note that the status sheet is a requirement. If you are having trouble with the VBA and the macro assignment, I will take them after the final. Please get them in Wednesday. |
| Week #15 Week of May 5th |
Work on final exam/project. |
| Week #14 Week of April 28th |
I am available on Tuesday at 11 (K101) and from 3:00ish until 7:00 in my office or in K116.
Thursday we are going to have an all day help session from 9:00 until 3:00 in K101. I will not
hold specific classes during that time, you may come anytime and stay as long as you can to work on
homework and get caught up. If you are behind, you really, really need to make the effort to be there. Assignments to turn in: This is your final exam/project. It is due by midnight on May 12th. I will be on campus in the late afternoon on May 12th from 2:30 until around 5:00ish. You can contact me if you want to see me. Final exam/project (html version) Final exam/project (word version) If you have a question, see an error I made etc., please let me know. REQUIRED Status Sheet |
| Week #13 Week of April 21st |
I am available on Tuesday at 11 (K101) and from 2:30ish until 7:00 - in my office or in K116. Finish reading the book. This week we are going to look at Visual Basic Access (VBA). VBA Notes (word version) VBA Notes (html version) VBA Array Notes (word version) VBA Array Notes (html version) withVB.accdb (DB with VBA) Audio notes on using VBA to accompany the notes above. Assignments to turn in: VBA Assignment |
| Week #12 Week of April 14th |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:00ish until 4:00 and
then from 5:30 ish until 7:00ish (I am on a committee that is doing interviews and an interview
has been scheduled for 4:00. You can look for me in my office or in the lab across the hall. This is also advisement week,
so some of the time may be taken up by advisement rather than help! This week we will focus on macros. Please read these notes and look at this sample database. Macro Notes (word version) Macro Notes (html version) student.accdb (DB with macros) Macro information from Microsoft Macro information Assignments to turn in: I want you to do something similiar to the macros that I did in the notes and on the student.accdb database. You should check and search for your own things, but you can use mine for a guide. Note you should have one group macro (like I did to find city) and one basic macro (like I did to check state). If you want to explore further and get creative, you can get extra credit. Note: I sent you this assignment and the notes etc because I am having problems uploading. |
| Week #11 Week of April 7th |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:30ish until 6:30ish
- you can look for me in my office or in the lab across the hall. This is also advisement week,
so some of the time may be taken up by advisement rather than help! I am also on a committee that
is scheduling interviews so an hour may disappear on Tuesday. I will leave a note on my door
if I am at an interview! Read chapter #6. Please check back! Assignments to turn in: Using the payroll database, I want you to set up a switchboard application that will have 5 different options. Incorporate some basic macros in your application. |
| Week #10 Week of March 31st |
I am available at 11 on Tuesday and Thursday in K101 and on Tuesday from 2:30ish until 6:30ish
- you can look for me in my office or in the lab across the hall. Please read chapter #5 on reports. Assignments to turn in: I want you to implement the payroll project I asked you to read in week #1. Payroll Example I want you to create forms to allow you to populate the tables. I want you to create a report that will show show each project and the hours put in by employess on the project There should be a listing of each hours put in and a total to date of the hours spent on the project. Note that I want to grab the employee name for this report as well. Basically, I want the report to group on project. |
| Week #9 Week of March 24th |
I will be available Tuesday and Thursday in K101 at 11:00. Check back, some other times will
probably be available. I cannot stay until 7:00 on Tuesday this week, I have an appointment off
campus. We are continuing with forms this week, be sure you have read chapter #4. Assignments to turn in: I want you to develop a form that includes the following: (a) Using data from more than one table (I want tables in a one to many relationship), (b) Using a subform to hold the data from the second table (data for the particular contributor), (c) Using command buttons on the form (use three different types), (d) Calculation on a form. Check back! |
| Week #8 Week of March 10th |
I will be available Tuesday at 11 in K101 and from 3:00 to 6:30 in my office or K116.
On Thursday, I am running an open lab for help and to get caught up from 9:00 until 3:00 in K101.
You can come for the whole 6 hours or you can come for your class and any other free time you have. Let's get caught up or ready to get caught up over vacation! Read chapter #4 on forms. Assignments to turn in: I want you to design a form (do not use the wizard) to view the information from one of your tables. Check back! |
| Week #7 Week of March 3rd |
I will be available for lab help in K101 on Tuesday and Thursday at 11, from 3:00 until 6:30 on
Tuesday in my office, we can go into a lab to work. I will also be available Thursday late
afternoon - you need to contact and confirm if you want to see me then. We will continue with chapter #3 and I would also like you to start to read chapter #4 on forms. Notes to help with maintenance: Table Maintenace web page Table Maintenance PDF Assignments to turn in: More Queries You should use one of your existing databases to do this assignment. |
| Week #6 Week of February 25th |
I will be available Tues and Thurs at 11:00 in K101 and Thursday at 2:30 in K101 and 3:00 in my
office. If you need to set up an appointment later in the day, contact me. This week I want you to start learning SQL. There is some information in your text, but you should also look at other information. I have some PowerPoint tutorials at the site (they are for a previous version but SQL is SQL. I have also posted some tutorials at del.icio.us. SQL queries can be written in a very basic way without all of the extra parenthesis etc. that Access generates when it creates the SQL. I want you to learn to write in the very straightforward way that I illustrate in my PowerPoints. Assignments to turn in: SQL queries using the Political Contribution Database: 1. I want to see all contributions that are over $1000. 2. I want to see all contributions that are for over $500 and gave to a specific activity. 3. I want to see all contributions that are either gave over $500 or gave to a specific activity. 4. I want to see all contributions that are for over $200 AND either gave to one activity you specify OR another activity you specify. 5. I want to see all contributions that are over $200. I want you to link to the contributors database and give the persons name as well. |
| Week #5 Week of February 18th |
I am at least partially recovered from my email and then computer disaster. If you have not heard back
from me by tomorrow night, I would resend anything I have not returned. This week I will be in the lab in k101 on Thursday at 11 and in my office after my 3:00 class. I will also be around some on Friday if you contact me. You should continue reading chapter #3. We are not looking at SQL yet, we will do that next week. For now we are creating queries using the user interface. Some information on queries to take a look at: Creating query in 2007 Creating query in 2003 There are several presentation on using Access (they are not 2007) but once you are in the query area, they work very much the same. Check them out. I would also recommend looking at this presentation on if statements if you are not comfortable with the idea of AND and OR questions: Presentation on logical if structures Separate speaker notes to accompany presentation on logical if structures Assignments to turn in: Database Assignment (political campaign) |
| Week #4 Week of February 11th |
I am experiencing problems with my email account starting 2/11/08. Please send email
to my backup account and try resending to my main account in a few days. I will be in lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday. I will also be available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 (I maybe free from 2 - 3:30 on Tuesday, but I am not sure yet. I will be available in my office on Thursday from 3:00 to 4:00. Check with me! This week I would like you to read chapter #3. I am leaving level 3 in chapter 2 as a read for now - depending on time we may go back to it. You should look at my site for information about queries as well. The concepts are the same in previous versions. Assignments to turn in: Query Assignment |
| Week #3 Week of February 4th |
I have asked for the lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday and some other days as well.
I am waiting for confirmation. Let's assume I will have it at the 11:00 times. I will also be
available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 (I maybe
free from 2 - 3:30 on Tuesday, but I am not sure yet. Check with me! Where we stand: Week #1 I asked you to design an oil database. The design was laying out the tables and my thought was you could pass it in using word. On week #2, I am asking you to implement the tables by creating them in Access. Check back, I want to see how people are doing. Assignments to turn in: This week I would like you to go back go in and put in the things to format, mask and validate the data. I would suggest that you might want to remove the data you experimented with last week (that is why I suggest just a little data). I want you to experiment and use the available formatting like input mask, default value, validation etc. You need to send me the tables with implementation and data you used to test. Check back! |
| Week #2 Week of January 28th |
I have asked for the lab in K-101 for 11:00 on Tuesday, 11:00 on Thursday and some other days as well.
I am waiting for confirmation. Lets assume I will have it at the 11:00 times. I will also be
available in my office (K-112) for help (we can go to a lab) on Tuesday from 3:30 to 6:30 and Thursday from
3:00 to 5:00 this week. Please make sure you have read chapter #1 very carefuly since it tells you how to deal with Access 2007. Again, it is a hard read so I would also go to a tutorial about using Access 2007. You can find some of these at the del.icio.us site for the class. If you do a search you will find others. If you find a good tutorial, please include it in del.icio.us for your classmates. I would also like you to read chapter #2 very carefully. Here is a sample database in 2007 and a PowerPoint presentation. The database follows the donor database that is one of the examples of a relational database: Creating a DB in Access 2007 Zipped Donor DB and PowerPoint Assignments to turn in: I would like you to implement the oil database that you designed last week. For now, I want a very basic implementation. Simply set up the tables and populate it with enough data to feel comfortable with the process. Next week I am going to ask you to go in and make some adustments to follow a lot of the mask and validating covered in chapter #2. Be sure you have run it by me before you implement! |
| Week #1 Week of January 21st |
I have sent out an introductory letter to your BCC account, if you did not get it please let me
know (you can use the BCC account for that). The email in that letter is the one you should use to
ask questions, keep in touch and turn in assignments. Information about the MSDN Alliance and downloading Access. To be honest, I think the text book throws too much at you to soon and can be a little confusing. I could not find one I liked better, if you do, please bring it to my attention and feel free to use it. So I need you to use my examples and things on the web to supplement and help you understand. I would like you to read over the introduction and to read chapter one. I would like you to focus this week on the concepts in level 2 and level 3 of chapter one, which are relationships and normalization. I have posted multiple links at the del.icio.us site that will help you to understand these concepts and I suggest you look them over and find one that make sense to you! Please be sure to read Relational/3rd normal form You should also look at the presentations that are grouped together as Relational Database. There are 4 presentations. Please read the following handout: Payroll Example Assignments to turn in: I want you to design the tables for this database. You should tell me what fields are in each table and you should designate a key for this table. This is a learning assignment so send me your layout, I will make comments, you can return and we will continue this way until each person has a layout that meets the criteria of normalization in a relational database. Oil Database |