# 810:022 Fall 2006 Microcomputer Applications and Systems Integration - MASI

## Now() is the time to create the Five Field Record Excel Database add record application. Due on Monday, Halloween eve, i.e. due on All Hallow's Eve Eve.

1. Read the first 4 hours (chapters) of the FLASH book. We will start FLASH on next Monday, October 30th.

Try this Excel VBA menu code from the class handout.

3. Here is the folder to download the movies Categories graphics, or you can create your own too.

4. Queries and the Movies database, especially parameter queries and expression builder.

5. Download Movies2002.mdb database by right clicking on the link. You will need this for the above exercises doing parameter queries, etc.

Assignment to throw a pair of dice: Die Throwing Excel VBA simulation.
API Sleep() Sub declare and use, along with the API GetSystemMetrics() Function declare and use and WRAPPER.
Diamonds, Gold, Silver, Bronze, Copper, Tin: Precious Metals assignment. You need to have and do the Car Loan Lesson Ten handout as a prerequisite to doing this assignment.

Email note about Precious Metals and Car Loans and the Price versus thePrice name problem.

CarLoan.xls -- Right Click and save: Car Loan Excel workbook.

Output .txt file ord9711.txt to import into Microsoft Excel.

Test one will be on Monday, October 2nd instead of the previous Friday, due to the UNI President installation ceremony from 11-1 p.m. that day.

Any version of Excel from Excel 97 to Excel 2002 to Excel 2005 or XP will suffice to do the EXCEL VBA assignments for this class. You do NOT need to have Excel 2005 latest version!
What to READ and DO assignment.

Past six year's 022 web pages.

1. Here are your Racing Rectangles Resources. By the end of the 4th week, you will have a good understanding of the racing rectangles macros. We will look at the simplest version of this during class number two on Thursday, August 25th.

2. VIP: The RACING RECTANGLES assignment is due on Wednesday, September 13th. See specifications here. You have the code as a handout.

3. I assume no previous Excel experience, so don't worry if you did not do much or any Excel in the past. You will be fine. The course covers lots of graphics and animation concepts, such as are useful for PhotoShop and Flash and clipart. It covers HTML and gives further web page experience, databases, and some authoring software. Also covers PowerPoint basics and beyond. We will do some GIMP graphics software and of course, we will make web pages dynamic using PERL/CGI and HTML FORMs.

4. Excel VBA Macros PowerPoint presentation covers all the basics, using the Birthday problem. You saw a preview of the 23 persons birthday problem in the first class. We will start teaching this series of birthday macros during the first two weeks of class.

*** IGNORE ALL MATERIAL BELOW HERE till later... ***

• Code for ShowDuplicates to color them yellow, track if there is a repeat birthday with a BOOLEAN TRUE/FALSE variable. This code calls a couple of other macros.

• Birthdays macro recorded during class on Wednesday, September 17th, 2003. This macro calls the ShowDuplicates macro.
• How do I update the totals? updateTotals macro VBA code and how and where it is used (at the end of showDuplicates macro).

5. Here is a note (from Fall 2003) about the .Offset() technique and adapting it to checking for repeats to eliminate the need for an extra variable and a couple lines of code. It also covers the ReportResult() macro code and how you could use the version that has a BOOLEAN argument instead of the zero argument TallyTheResult() macro. WE MAY NOT EVEN LOOK AT THIS BY THE END OF THE 2nd WEEK!!!