Microcomputer Applications and Systems Integration

1-2:50 p.m. Wednesday final exam:
Here is a helpful Final Exam Study Guide

December 7th email note #1 about the final exam, cheat sheet guidelines, PERL/CGI and Access 2000 projects.

Email note #2 on December 7th is more about the Access 2000 issues and that final database project.

What about the $TimeStamp and the back tic symbol to allow your PERL script to have the Unix server execute the date command, so you can record the date and time of the guest's visit?

The no longer simple guest book program. Your entry will be added to the file only when you enter something for BOTH the name and the comment. The guest book web page is displayed in a randomly chosen BGCOLOR color and and calculated contrasting TEXT color.

Access 2000 Movies database assignment due date, and guestbook note.
Movies handout and information on parameter queries and combo box and Form with intelligent navigation button and record operations.
More Movies and VBA and Intelligent command buttons lessons, showing both the GUI and the Form_Current() event procedure VBA techniques.
Animated GIF examples page for review of some of today's Tuesday 11/28 class. We will have our last hands-on class on Thursday, November 30th in Wright 112 lab.

Here is the link to student practice questions directory page. The Tuesday, November 21st quiz will include at at least 40 questions based upon these. There are 27 links to practice questions there as of 8:15 a.m. on Friday morning Don't see your name, send me email. I did not receive your URL if you do not see your name.
The first 5 questions are from this DATABASE slide show to study in conjunction with Lessons 1 and 2 of the Access 97 book. The Northwinds database comes with Access and the documentation often uses examples with Northwinds Tables and Forms and Reports.
Read Lessons 1, 2 and 3 of Access 97 VBA textbook and preview/review it with this slide show that highlights some aspects of the chapters. Use these slides to answer questions 6 through 25.

Here is an example of PERL and FORMS for both CheckBox and Radio Buttons , taking from questions 11 and 12 from the formOct9th080.html Discrete Structures quiz.

Try out this simple guest book program. Your entry will be added to the file. PERL not only reads and responds to your information, but PERMANENTLY saves it for future reference and display.

Practice quiz, 17 questions, 810:080 Discrete Structures. You have a portion of the .cgi PERL script that grades this quiz and greets the person with an indication of the time of day they took the quiz, etc. The quiz uses RADIO BUTTONS. Your 22 question quiz does NOT have to be all check boxes and text boxes. If you want to use some additional FORM types, such as radio buttons, feel free to.

Tuesday November 7th email review of lecture, reminder of hands-on class, clarification on $year resulting argument of the locatime(time) function.

Thursday November 2nd email on PERL and FORM assignment that is due on Tuesday, November 14th. You did this earlier as the Pre PERL and FORM assignment, but you can modify and develop improved versions of a question or new questions to replace your earlier ones as you are studying the materials again or the materials since then.

The hands-on class from Thursday, October 26th where we created a gradebook database and imported a comma separated value file, as well as created a custom form that displayed an A, B, C or below C level graphic (.bmp files). We also did a Pig Latin function and created an Access module for the Public PigLatin() function.

Pre PERL and FORM assignment to be turned in next week.

Here is the ClipArt customization and Object-Oriented graphics page.

Where and how do I find the A.wmf ClipArt file when it is not in the standard ClipArt folder?
How to use it: Use Insert menu, Picture command, From File... subcommand instead of Insert menu, Picture, ClipArt... subcommand.
Download it: Take the A.wmf file home with you on a diskette, if needed.

PhotoShop basic skills and techniques for buttons, cropping, etc.

Assignment on Excel or Word VBA due October 10th experiments with variables of the Variant variety.

Here is a six question practice quiz to illustrate FORMS and PERL CGI script techniques. We will talk about this and try to understand it during the three classes after the Labor Day holiday.

Read Lesson 1 of Access 97 VBA textbook and preview/review it with this slide show that highlights some aspects of the chapter.

Another DATABASE slide show to study in conjunction with Lessons 1 and 2 of the Access 97 book. The Northwinds database comes with Access and the documentation often uses examples with Northwinds Tables and Forms and Reports.

Review of the Tuesday, September 19th lecture with RGB, BGCOLOR attribute, PERL and CGI, practice quiz and using the http://student.cns.uni.edu/~yourUserID/cgi-bin/form022.html example file.

PERL and CGI and HTML fundamentals and review of Unix and pico and review materials for the Thursday, Sept 21st lecture and group exercise.

Look at the HTML for the FORM with its textbox and its radio button techniques, in conjunction with reading chapter 3, pages 43-54 of the PERL and CGI book.

You could also use View menu, Source on your web browser to see the HTML code for the FORM, but my annotated with PhotoShop and/or Word 97 Alt+PrintScreen Window snapshots are also useful to study.

Looking at the PERL/CGI script program as well as the HTML and FORM tags that collected the data and executed the script when the user (you, the quiz taker) clicked the SUBMIT button, is a great way to learn more.

Try running the example on different days of the week and times of the day. The PERL CGI script program is filled with different techniques you will eventually be able to understand and use.
My first ever FORM and PERL CGI attempt illustrates checkboxes and textboxes. It is a Discrete Structures 810:080 practice quiz.
To see the PERL Random quote generator in action. You can click Reload or Refresh button after you are there, to see another randomly chosen txt or html file displayed.

Here is the Fall of 1999 class web page, as it existed at the end of the class in December. Obviously, the class changes alot from year to year, but you can get an idea of some of the topics by looking at the old web page.

There will be two textbooks required for 810:022 in the fall semester of 2000.

Access 97 Visual Basic by Evan Callahan. Feel free to purchase the Access 2000 version of the book if you have Access 2000 at home on your PC instead of Access 97. Our Wright Hall lab has Access 97.
PERL and CGI for the World Wide Web by Elizabeth Castro.
No background in Access or database is required to take the 810:022 class.
No background in Web page creation is required either.

The Racing Rectangles assignment Excel and VBA code windows was handed out on Thursday, August 24th. It is due on Tuesday, September 12th, along with your Excel toolbar and 6 toggle macros with custom toolbar buttons.
We'll have a hands on class on Tuesday, August 29th in the Wright 112 lab. You will learn how to make a custom toolbar and VBA macros and attach it to an Excel workbook. We'll focus on creating a toolbar that allows convenience in doing precision graphics in Excel or Word too.
Click here and then do the REFRESH button or RELOAD button at least 5 or 10 times to see the randomly chosen quotes generated by a PERL/CGI program.