Case-Based Critical Thinking QuestionsCase 1Brenda has finished constructing her new database and populating it with data, and the time has come to begin to test out queries on her new database. She has asked you for some quick tips on the finer points of database queries.

Brenda wants to search for records with “Jan” in the Firstname field but wants to exclude “Jen” or “Jon” in the query. Which of the following entries will yield the correct results?

A. J[!eo]n
B. J[e,o]n
C. J[eo]n
D. J?n


Answer: A

Computer Science & Information Technology

You might also like to view...

Similar to websites, the navigation form allows for top-level navigation commands across the top of the page or vertical navigation along the side of the page as well as subnavigation directly below or along the side of the page

Indicate whether the statement is true or false

Computer Science & Information Technology

?A _____ is a graphical representation of the conditions, actions, and rules found in a decision table.

A. ?decision board B. ?decision tree C. ?decision element D. ?decision point

Computer Science & Information Technology

When adding an account, you can add either a local or a Microsoft account.?

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

In Datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting.

What will be an ideal response?

Computer Science & Information Technology