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.
Subscribe to:
Post Comments (Atom)
This comment has been removed by the author.
ReplyDelete1.yOU WILL FILTER BY FORM,
ReplyDelete2.is NOT NULL
3.bETWEEN# 05/1/2009# AND #05/22/2009#
4.IN("WESTON","SOUTHWEST RANCHES","DAVIE")
5.LIKE "WES*"
6."RODRIGUEZ" OR "SMITH"
7.<>"fL"
8.>16
9.IS NULL
10.>=18()
Show values in a field that is not empty?
ReplyDelete- Is Not Null
Show dates that are between May 1, 2009 and May 22, 2009.
- Between #05/01/09#and#05/22/09
Show a list of cities called Weston, Southwest Ranches and Davie.
- IN(“Weston”, “Southwest Ranches”, “Davie”)
Show a city that that starts with the Wes.
- Like”Wes”
Show any students who last name is Rodriquez or Smith.
- “Rodriguez” or “Smith”
Show all states that are not equal to FL.
- <>”FL”
Show all studetnts who are over the age of 16.
- >=16
Show all fiels that are empty.
- Is Null
Show all ages that are greater than or equal to 18.
- >=18
Go to my Blog.
ReplyDeleteHow would you display the following criteria when writing a query?
ReplyDeleteIn a datasheet.
Show values in a field that is not empty?
Is Not Null
Show dates that are between May 1, 2009 and May 22, 2009.
Between# 05/1/2009# AND #05/22/2009#
Show a list of cities called Weston, Southwest Ranches and Davie.
(“Weston”,”Southwest Ranches”,”Davie”)
Show a city that that starts with the Wes.
Like”Wes”
Show any students who last name is Rodriquez or Smith.
“Rodriguez”or”Smith”
Show all states that are not equal to FL.
<>”FL”
Show all students who are over the age of 16.
>=16
Show all fields that are empty.
Is Null
Show all ages that are greater than or equal to 18.
.=18
Stuart R.
ReplyDeleteHow would you display the following criteria when writing a query:
1. Show values in a field that is not empty?
Is Not Null
2. Show dates that are between May 1, 2009 and May 22, 2009.
Between #5/1/09# and #5/22/09#
3. Show a list of cities called Weston, Southwest Ranches and Davie.
In ("Weston","Southwest Ranches","Davie")
4. Show a city that that starts with the Wes.
Wes*
5. Show any students who last name is Rodriquez or Smith.
"Rodriquez" Or "Smith"
6. Show all states that are not equal to FL.
<>"FL"
7. Show all students who are over the age of 16.
>16
8. Show all fields that are empty.
Is Null
9. Show all ages that are greater than or equal to 18.
>=18
Michael Urow Period #1 5-12-09
ReplyDelete1. How would you display the following criteria when writing a query?
FILTER BY FORM
2. Show values in a field that is not empty?
Is Not Null
3. Show dates that are between May 1, 2009 and May 22, 2009.
Between#05/1/2009# AND #05/22/2009#
4. Show a list of cities called Weston, Southwest Ranches and Davie.
IN("WESTON","SOUTHWEST RANCHES","DAVIE")
5.Show a city that that starts with the Wes.
Like”WES”
6.Show any students who last name is Rodriquez or Smith.
“Rodriguez” or ”Smith”
7. Show all states that are not equal to FL.
<>”FL”
8. Show all studetnts who are over the age of 16.
>=16
9. Show all fiels that are empty.
Is Null
10.Show all ages that are greater than or equal to 18.
>=18()
1. <>"Null"
ReplyDelete2. 4/30/09 > 5/23/09
3. IN("Weston","Southwest Ranches","Davie")
4. IN("Wes*")
5. "Rodriquez" or "Smith"
6. <>"Florida"
7. 16 <
8. IS NULL
9. 18 > (cant type equal to symbol)
How would you display the following criteria when writing a query?
ReplyDeleteDatasheet
Show values in a field that is not empty?
Isn't Null
Show dates that are between May 1, 2009 and May 22, 2009.
Between# 05/1/2009# AND #05/22/2009#
Show a list of cities called Weston, Southwest Ranches and Davie.
(“Weston”,”Southwest Ranches”,”Davie”)
Show a city that that starts with the Wes.
Like”Wes”
Show any students who last name is Rodriquez or Smith.
“Rodriguez”or”Smith”
Show all states that are not equal to FL.
<>”FL”
Show all students who are over the age of 16.
>=16
Show all fields that are empty.
Is Null
Show all ages that are greater than or equal to 18.
.=18
1. How would you display the following criteria when writing a query?
ReplyDelete*In a datasheet.
2. Show values in a field that is not empty?
*Not Null
3. Show dates that are between May 1, 2009 and May 22, 2009.
*Between# 05/1/2009# AND #05/22/2009#
4. Show a list of cities called Weston, Southwest Ranches and Davie.
*("Weston",Southwest Ranches","Davie)
5. Show a city that that starts with the Wes.
*Like"Wes"
6. Show any students who last name is Rodriquez or Smith.
* "Rodriquez"or"Smith"
7. Show all states that are not equal to FL.
*<>"FL"
8. Show all students who are over the age of 16.
*>=16
9. Show all fields that are empty.
*Is Null
10. Show all ages that are greater than or equal to 18.
* .=18
Being posted by David Galvez and Nestor Maysonet
ReplyDelete1. Is Not Null
2. Between #05/01/09#and#05/22/09
3. IN("Weston", "Southwest Ranches", "Davie")
4. Like"Wes*"
5. "Rodriguez" or "Smith"
6. <>"FL"
7. >16
8. Is Null
9. >=18
This comment has been removed by the author.
ReplyDelete1. In a datasheet.
ReplyDelete,
2.is not null
3.between# 05/1/2009# and #05/22/2009#
4in ("weston","southwest ranches","davie")
5.like "wes*"
6."rodriguez" or "smith"
7.<>"fL"
8.>16
9.is null
10.>=18()
afc
How would you display the following criteria when writing a query?
ReplyDeletefilter by form
Show values in a field that is not empty?
is not null
Show dates that are between May 1, 2009 and May 22, 2009.
Between# 05/1/2009# AND #05/22/2009#
Show a list of cities called Weston, Southwest Ranches and Davie.
In (“Weston”,”Southwest Ranches”,”Davie”)
Show a city that that starts with the Wes.
Wes
Show any students who last name is Rodriquez or Smith.
“Rodriguez” or ”Smith”
Show all states that are not equal to FL.
<>"FL"
Show all studetnts who are over the age of 16.
>=16
Show all fiels that are empty.
Is Null
Show all ages that are greater than or equal to 18.
>=18()
1.) IS NOT NULL
ReplyDelete2.) BETWEEN #05/01/2009# AND #05/22/2009#
3.) IN("WESTON","SOUTHWEST_RANCHES","DAVIE")
4.) LIKE "WES*"
5.) "RODRIQUEZ" OR "SMITH"
6.) <>"FL"
7.) >16
8.) IS NULL
9.) >18=()
How would you display the following criteria when writing a query?
ReplyDeletefilter by form
Show values in a field that is not empty?
is not null
Show dates that are between May 1, 2009 and May 22, 2009.
between# 05/1/2009# and #05/22/2009#
Show a list of cities called Weston, Southwest Ranches and Davie.
IN("Weston", "Southwest Ranches", "Davie")
Show a city that that starts with the Wes.
like "wes*"
Show any students who last name is Rodriquez or Smith.
“Rodriguez” or ”Smith”
Show all states that are not equal to FL.
<>"FL"
Show all studetnts who are over the age of 16.
>=16
Show all fiels that are empty.
is null
Show all ages that are greater than or equal to 18.
>18=()
CRITERIA QUESTIONS:
ReplyDelete1.How would you display the following criteria when writing a query?
You would filter it by form
2. Show values in a field that is not empty?
Is Not Null
3. Show dates that are between May 1, 2009 and May 22, 2009.
Between #5/1/09# AND #5/22/09#
4. Show a list of cities called Weston, Southwest Ranches and Davie.
IN("Weston","Southwest Ranches","Davie")
5. Show a city that that starts with the Wes.
Like "Wes"
6.Show any students who last name is Rodriguez or Smith.
"Rodriguez" or "Smith"
7. Show all states that are not equal to FL.
<>"FL"
8. Show all students who are over the age of 16.
>16
9.Show all fields that are empty.
Is null
9. Show all ages that are greater than or equal to 18
>=18
Michael Huang Period 1
1. Is Not Null
ReplyDelete2. Between #05/01/09#and#05/22/09
3. IN("Weston", "Southwest Ranches", "Davie")
4. "Wes*"
5. "Rodriguez" or "Smith"
6. <>"FL"
7. >16
8. Is Null
9. >=18
1. Is Not Null
ReplyDelete2. Between #05/01/09#and#05/22/09
3. IN("Weston", "Southwest Ranches", "Davie")
4. Like"Wes*"
5. "Rodriguez" or "Smith"
6. <>"FL"
7. >16
8. Is Null
9. >=18
Arash Afshar!!!!!
1. In a datasheet.
ReplyDelete2. Is Not Null
3. Between# 05/1/2009# AND #05/22/2009#
4. (“Weston”, “Southwest Ranches”, “Davie”)
5. Like “WES”
6. “RodrÃguez”or “Smith”
7. <>”FL”
8. >=16
9. Is Null
10 >=18
1. Filter By Form
ReplyDelete2. Is Not Null
3. Between #05/01/09# and #05/22/09
4. IN("Weston", "Southwest Ranches", "Davie")
5. Like "Wes*"
6. "Rodriguez" or "Smith"
7. <>”FL”
8. >16
9. Is Null
10. >=18