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.

Lesson 5/19/09

1. See me with your flash drive, if I did not review it yesterday.
2. Database Project: Due on Friday, May 22, 2009.
Database must include the following:

* Three Tables. Must include data all three tables.
* One or more relationships.
* A form for each table.
* Five queries that you create on your own.
* One report.
* An original logo for the organization you created the DB for.
* Password for DB. (Write it down somehere, use the organization's name, for example, hosa)
* Switchboard.
* Save all objects.

Burn your DB to a CD. Your must provide your on CD. Create a CD label with the organization name, student names and datE created. I have labels that I will give you.

2. Ex. 25 Reports: Read 702-705. Questions to comment on this post.
What is the purpose of using a report?
What are the varoius ways to create a report?
What information do you think your report will include from your project?
Do Ex. 25 Pg. 708 and Ex. 25 On your Own pg. 709: DO NOT PRINT REPORTS!!!
SAVE ON FLASH DRIVE!

Lesson 5/18/09

1. Quiz online.
2. Ex. 23 Critical Thinking. Creating queries. Review the criteria from last week page 691.
3. Print all queries, put your name on them, today's date, staple and turn in to me. Not your binder.
4. Review of reports.

Lesson 5/15/09

1. Ex. 25: Access Reports. pg. 702: Invidividual assignment:
Read and review 702 through 707. Do Ex. 25. pg. 708. DO NOT PRINT, SAVE YOUR REPORTS.
2. Quiz on Monday, review previous day lesson.
3. We will finalize your project DB on Mon and Tues next week.

Lesson 5/14/09

1. Work in your DB Project.
2. Insert on logo from your team to use in the forms.
3. DB should include 3 tables with data.
4. Forms for each table, join relationships by primary key and foreign key.
5. Tables can not have repeating data.
6. Revise forms so that it flows from left to right not top to bottom.
7. Ex. 13-21 Quiz on Monday on Vocabulary and concepts from those sections.
* You may use on page of HANDWRITTEN NOTES. No typed notes.

Lesson 5/13/09

1. Complete query lessons, if you have not done so, print our your query results, include your name and ex. number on the queries.
2. DB Project: Continue to add tables, should have at least 3.
3. Need a form form for each table, or include subdatasheets, through relationships.
4. Illustrator: Each person in team should design a new logo to go with DB, chooose the best one. Each student will receive credit for their logo.

Lesson 5/12/09

1. Reading and review. Counts as Kurl and EXTRA CREDIT today! Must be readable.
2. Creat a booklet of questions from the reading selection: 683-684, 688-691.
3. Follow instructor. Fold sheets of paper accordingly.
4. Create a title for the reading selection. Survey the reading selection, write 8 questions from the subheadings in the reading selection. Answser the questions and summarize.
Write your questions for items that are challenging to you. For example, what is Criteria in a Query?
5. Key Terms on pag 683 and 688 should be reviewed.
6. Criteria questions to be answered:
How would you display the following criteria when writing a query?
Show values in a field that is not empty?
Show dates that are between May 1, 2009 and May 22, 2009.
Show a list of cities called Weston, Southwest Ranches and Davie.
Show a city that that starts with the Wes.
Show any students who last name is Rodriquez or Smith.
Show all states that are not equal to FL.
Show all studetnts who are over the age of 16.
Show all fiels that are empty.
Show all ages that are greater than or equal to 18.
7. Complete Ex. 2o and Ex. 21 lessons from yesterday.

Lesson 5/11/09

Access Lessons, finding, sorting and replacing data.
1. Teacher review of finding data with wilcards.
2. Student needs to read and review terms on page 678.
2. Do ex. 19 pg. 681.
Ex. 20 pg. 686.
Save Databases.
3. Ex. 21 Pg. 692 and Ex. 21 Pg. 693. On Your Own, Save both DB and save queries.

Lesson 5/08/09

1. Review your tables, make sure there is no repeating data.
2. You should have at least 3 tables in your DB.
3. Develop a form for each table.
4. You are going to have to get data from your client to import into the DB. Ask your client to provide you with an excel spreadsheet or MS Word document so that you can bring the data over. Your job is not to do data entry just design.
5. Develop a logo to insert into your form, it needs to be an original use PS or Illustrator.

Lesson 5/06/09

1. Finish lessons from yesterday.
2. Complete your questionnairre to start building DB. If you have no client to interview, you must answer the questions as if you were the client.
3. Another job opening: law firm downtown Ft. Lauderdale. You would be building a website for a lawyer who immoblizes vehicles on DUI cases. Additionally, you would be doing other various office duties as needed with legal assistants and attorney. Email me your cover letter and resume. Revise objective. Cover letter should be addressed as follows:
Greg Ross, Esquire
311 SE 11th Court
Ft. Lauderdale, FL 33009.
4. Diagram your tables and fields for the DB that you are building for project. Identify a unique value for primary keys in the tables, the value can not be repeated by another record.

Less 5/05/09-5/06/09

1. Karolina's Team: Pick up pass from sub to see Ms. Waxman.
2. Andrea's Team: Pick up pass from sub to see Mr. Stember.
3. Pick up questions worksheet and get all questions answered in interview.
4. Complete ex. from yesterday, Print out screen shot showing the lookup fields from tables.
5. Ex. 14: Read 655-657. Do not do this ex.
6. Ex. 15: Read 661-663. Do Ex. 16 and On Your Own 16. Print out one copy of each form, place in binder.

Paul's Team: I have some info for you on password in forms. Will give to you when I return.

All students who RSVP will receive a pass to attend luncheon on Friday. If you did not RSVP like instructed, you will not be able to attend. I already placed the order. So do not show up if you do not get a pass on Thursday this week.

Another job oppurtunity, possibly working for a local web design company. If you have not emailed me your resume, please do so today as well. Don't worry about cover letter now. You really must be looking on your own at this point for a job this summer as severl of our business partners have backed out because of the economy. Please network with your families and see if they know any businesses that could hire a student for the summer.

Lesson 5/4

1. Interview your person that you are going to build a database, get as much information as possible.
2. Open up your EX. 11 to be graded.
3. Ex. 13: Creating a lookup field pg. 650-654.
4. Do Ex. 13 pg. 653 and On Your Own pg. 654. Print out the following:
Ex. 13 Datasheet View tblClass Offerings and tblClassEnrollement
On Your Own 13 Datasheet view of roster for baseball postions.

Friday: Team Work Day

1. Create your team. No more than 3 people. Submit your names and team leader to me.
2. Review worksheet and brainstorm who you are going to build a database for, either inside or outside school.
3. Pick team members wisely, points will be deducted each time a team member is not on task.
4. Open Relationships DB Window from Ex. 10.
5. Complete Ex. 11, show me your DB for a grade, this will be a quiz grade.
6. Students who did practice interviews: Submit a thank you letter to me via email. Address as follows. My email: mitzi.plunkett@browardschools.com

David W. McKenney
Regional Vice President - Claims
Healthcare Underwriters
1250 South Pine Island Road, Ste 300
Plantation, FL 33324