Database Review 4

Mrs. Bills needs to get an alphabetical list of students who have sold 100 lollipops. Which criterion is used?  

•  And
• Equals
• Not
• Or 

Chad wants to print a list of seniors who are going to any college except East Carolina University when they graduate. Which criterion is used?   

• And
• Equals
• Not
• Or

Sally wants to print a list of foods that have 100 calories, zero grams of fat, and 2 grams of fiber per serving. Which criterion will she use?   

• Equals
• Greater than
• Less than
• Or

In the Student Data Table, US History is classified as a/an: 

• entry
• field
• file
• record

In the Student Data Table, AP is classified as a/an:  

• entry
• field
• file
• record

In the Student Data Table, all of the information about Knowles is classified as a/an:

• entry
• field
• file
• record

Which field in the Student Data Table CANNOT be formatted with a drop-down list?    

• Computer I
• Math
• Reading
• Senior

Which field in the Student Data Table is formatted with an input mask?

• AP
• Graduation
• IDNo
• Senior

Which field in the Student Data Table has a default value of "No"?   A.  AP   B.  Graduation   C.  IDNo  D. Senior

• AP
• Graduation
• IDNo
• Senior

Which field is used to create a relationship between the Student Data Table and the table to which it links?

• IDNo
• LastName
• Math
• SAT