March 31, 2009

1. Complete any work from Monday.
2. Print out work and turn in to sub.
3. Save all work as well.
4. We will review on Wednesday when I return.
5. Be good to the sub. Do current event for this week as well.

AOIT Programming Lesson 3/30-3/31/09

1. Students who are attending the field trip on March 31, you must meet in the bus loop by 7:00 on Tuesday. You must be dressed in business attire, YOU WILL NOT BE ALLOWED ON THE BUS IF YOU ARE NOT DRESSED APPROPRIATELY. No jeans, sneakers, etc. will be allowed. Dress shirt, pants and shoes, you may wear a tie as well. Dress for Success.

2. Students who did not get to print business cards, please pick up business cards from sub, use number 8371 to create your cards. Leave them with sub.

3. Database Development:

Use the Learning MS Office 2007 Textbook:

Read pages 586-588. Answer worksheets from sub.
Define all terms on page 586 and include and example.

Read pages 589-593.
Define all terms on page 589 and provide one example.

Do the practice exercise on page 595-596. Use CD in back of book, you may have to share, save the database on your flash drive, you maywill have to take the read only property off. Right click on the file go to properties and deslect the read only once you have saved it to your flash drive.

4. Visual Basic TextBook: Chapter 11: Read pages 658-660.

Answer the following questions:
A. What are some examples of databases that you are currently familiar with?
B. What is a field?
C. What is a table and what is stored in tables.
D. What is primary key and list three examples of what would constitute a primary key?
E. How are a primary key and foreign key related?

We will review when I get back on Wednesday. Try to get the correct answers.

Chapter 6 VB 3/16/2009

Chapter 6 VB Vocabulary & Syntax

Define each term, provide an example of the syntax, where applicable, or an example.
Let’s work in teams of two for the vocabulary and applications, and syntax review.
Additional Applications to Code for String Manipulation:

Mid Statement: Pg. 363-364 (Replace Area Code)
Pad Left/Pad Right: Pg. 367-368
SubString: Pg. 384-385
Radio Button: Pg. 397-398

Length Property
TrimStart, TrimEnd, Trim Method
Remove Method
Index
Replace Method
Mid Statement
Pad Left/Pad Right Method
Insert Method
Starts/EndsWith Method
Contains Method
IndexOf Method
Substring Method
String.Compare Method
Like Operator
Radio Button Tool
Check Box Tool

Summarize via Web Site Chapt. 5

We will review DW and HTML. You will create a summary page using links, tables and images. The following should be discussed in your page:

1. What is repetition structure and how is it represented in VB.
a. Provide an example For/Next Stmt.

2. What is the Financial.Pmt Method?
a. Provide examples of arguments.

3. What method is used to select existing text in a Textbox.
a. Provide the syntax that was used in the financial payment calculator.

4. What is the difference between a list box and combo box?
a. Provide an example of coding for a list box for your favorite food.
b. Provide an example of coding for a combobox for places you would like to visit.

5. What is the function of a do loop?
a. Provide an example of a do loop.