Case 18-2
Ali, a librarian, uses Microsoft Access 2016 to maintain information about the books in his library. He retrieves details about the books and authors and filters selected records using queries.
Ali retrieves a list of the authors whose names start with the letters "Jef." He wants to filter this result by including names that have only 5 letters. Which of the following should Ali use to retrieve the names that follow both criteria?
A. ?="Jef**"
B. ?>="Jef.."
C. ?Like "Jef??"
D. ?In ("Jef","$$")
Answer: C
You might also like to view...
How do methods setIn, setOut and setErr affect the standard input, output and error streams?
a. They output data to the standard input, output and error streams. b. They provide the only way to access the standard input, output and error streams. c. They redirect the standard input, output and error streams. d. They empty the standard input, output and error streams.
The ________ tool allows you to drill down through PivotTable data with a single click
A) Data Model B) PowerPivot C) PowerView D) Quick Explore
____ are privileged users, usually computer center employees, with the ability to access and maintain password files.
Password managers Superusers Resource allocators IT directors
The first line of the for statement is sometimes called the:
a) for statement header b) increment header c) repetition header d) None of the above.