| 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. | |
| Week #15 Week of May 10th |
The college has sent you a survey about the CIS Department, please try to respond! Thanks! The final has been sent to you, check back if you have questions. |
| Week #14 Week of May 3rd |
Activities this week: Monday, May 3rd (11:00 in K101), speaker from Meditech coming to my 11:00 class to talk about careers, skills etc., you are invited to join us in K101. Wednesday, May 5th (7PM - 9PM in G Building Atrium), panel discussion about careers in computing and starting a business Thursday, May 6th (12:30 in C111), Chad Barraford talking about setting up a computer to be your personal assistant I sent more details to you in an email to your BCC account. Catch up week! |
| Week #13 Week of April 26th |
Some of my notes use 2007 and some use 2003. 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 19th |
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. |
| Week #11 Week of April 12th |
This is also advisement week,
so some of the time may be taken up by advisement rather than help! 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 April 5th |
Thursday April 8th at 12:30 in C111: The CIS Department is sponsoring a speech which deals with Crimes against Children with emphasis on the
impact of the Internet. The speech is by Paul Graf, Special Agent, US Naval Criminal Investigative Services Specialist
and is titled The 'Real' NCIS! Investigating Crimes Against Children. I have heard him speak and he is very good, so please try to find the time to come, listen and learn! This certification might be of interest to you or of interest to someone you know. Free Technology Training Partnership with Microsoft Please read about reports in whatever text you are using. 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 29th |
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 22nd |
Read about forms in your text or online.
I want you to focus on creating forms without using the wizard! Assignments to turn in: I want you to design and implement a form (do not use the wizard) to view the information from one of your tables. Then I want you to design and implement a second form associated with another table in the same database using some other features. Check back! |
| Vacation Week of March 15th |
Have a nice break and lets all try to get caught up! |
| Week #7 Week of March 8th |
In what ever book you are using, please read up queries, forms and maintenance. Here is some
information on maintenance to look at as well.
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 March 1st |
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 22nd |
This week I will be in the lab in k101 on Tuesday at 1:45 and in my office at 10:00. I
will also be around some on Wednesday if you contact me. You should continue reading the text book you are using (at least a chapter a week) and using it for a reference to do the assignments.. 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 15th |
Help/support lab Tuesday at 10:00 in K112 and also at 1:45 in K101. Wednesday I am available at
1:45 in my office or around (check for a note on my door). If you need to see me and these times don't work contact me and we can try to figure
something out. You should be looking at queries this week, 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: Query Assignment As always, please check back! |
| Week #3 Week of February 8th |
I have listed two books that will be helpful in following this class. I suggest you use them as
references but I also suggest that you read through the one you pick in order so you are sure you
do not miss anything. We are going to look at different topics so be sure you check out the book
or both books as we go. This week we are going to continue developing effective tables. I will be available for help on Tuesday from 10 to 11 in my office or in K101 and I will have a help lab Tuesday from 1:30/1:45 to 3:00ish. On Wednesday I am going home after classes because of the snow. 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 etc. 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. Try a variety of things. You need to send me the tables with implementation and data you used to test. |
| Week #2 Week of February 1st |
I will be available for help on Tuesday from 10 to 11 in my office and I will have a help lab Tuesday from 1:45 to 3:00
in K101. On Wednesday I will be available from 1:45 until around 3 in my office. We can go to a lab if you need help. I am using the book as a reference, I would like you to read a chapter each week, but I also want you to use it as a reference to help you do the homework. I would also use references on the web, 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 let me know. There are only two of you in this class, I would like your permission to share your email addresses so you can help each other. 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. Be sure you have run it by me before you implement! |
| Week #1 January 25th |
You can get a copy of Access through the MSDN Alliance. The school will send you an invitation. If you do
not receive one in the next week, let me know. Information about the MSDN Alliance and downloading Access. There is a book available through ebrary that Looks quite good. Lets work with that! 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 |