Lesson 6/1/09

1. Complete handwritten notes for study guide. Answer all questions 1-26. Be thorough in your respones.
2. Complete the SQL create table section from Friday if you did not do it on Friday.
3. Pick up your binders and take home today, or they will be tossed today.
4. Exam will be on Wednesday, Periods 1 & 2. Bring a number two pencil PLEASE!.

Lesson 5/29/09

1. Second section in SQL online interpreter. Do create tables section pages, 4-5.
2. Final Exam Review worksheet. Notes must be handrwritten to receive a grade.

Lesson 5/28/09

1. Students who are finishing DB continue to make corrections.

2. SQL Review: Review the following webisite:

http://sqlcourse.com/intro.html

Do practice tutorial through http://sqlcourse.com/select.html , which is page three of the tutorial and stop.

Questions to answers:

1. What does the select statement do?
2. When extracting data from a table what must the strings be enclosed with?
3. What is the word from used for?
4. What clause specifies the criteria you will use to extract specific information?


From the following table, write SQL statements:

FRUIT TABLE

Item No: Fruit Price Quantity
1 Plums 1.00 100
2 Apples 2.00 200
3 Oranges 3.00 300
4 Grapes 1.00 300
5 Kiwi 7.00 100


a. List all fruit whose price is less than 3.00
b. List all fruit whose quantity is equal to 300 units.
c. List all fruit for whose price is not equal to 1.00
d. List all fruit where quanitity is leass than 300

Post answers in a comment to this post with your name.

Lesson 5/27/09

1. Query Practice: Using DB AC10, write the following;
a. Display all products of bread where the quanity in stock is greater than 50.
Save as qryproducts.

b. Display all products of bread where the quantiy is less than 50.
Save as qryproductsunder50

c.Display all customer names for customers who live in the city of San Francisco.
Save as qrySanFrancisco

d.Display all customers who live in Mill Valley or Larkspur.
Save as qryMillLarskspur

e. Display all customers names who currently receive a newsletter.
Save as qrynewsletter
2. Report: Create a report totalling the quantity of all bread products. Save the report as rptQuantity.

3. Review and make final corrections to DB.

Lesson 5/26/09

1. Compelte DB. Give DB to instructor on a CD for grade.
2. Final Access Lesson:

Creating a Report wtih a calculated field
Pg. 710-714. Do Ex. 26 pg. 713 and On Your Own Page. 714. SAVE ALL REPORTS, DO NOT PRINT.

Ex. 27: Formatting Reports with Labels. Pg. 717 & 718 On Your Own.
SAVE ALL FOUR REPORTS. DO NOT PRINT.

Lesson 5/22/09

1. Review of Switchboard. You will create a switchboard for your forms in your DB project. If you have not created your forms yet, you must do that before you create the switchboard.
2. Listent, watch and follow instructions.
3. Create your label for your CD.
4. Continue to finalize DB, let's shoot for completion on Monday.
5. Review your database with the assigned teacher as well and find out what information they would like extracted from the database that would be useful for them so you can write the queries and reports.

Lesson 5/20/09

1. Query Review
2. Continue working on your DB entire class period. You will not have a lot of time on Friday.
3. Follow requirements from yesterday's posting.
4. Students who I have noted will not working as a team will refelect in grade.