Briefly describe Filter by Selection and Filter by Form. Imagine that you are searching for songs in a database. Give an example of a situation where you would use Filter by Selection and a situation where you would use Filter by Form.
What will be an ideal response?
- When you use Filter By Selection, you select a field value (such as Oak Office Desk), or part of a field value (such as the just letter D) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab. A menu opens with a list of options for filtering the field.
Situation Examples (Answers will vary):
Filter by the name of an artist
Filter by the name of a song
Filter for songs recorded before a certain year
Filter for songs recorded in a certain year
- You can use Filter By Form when you need to display records that contain one or more values based on the values stored in one or more fields. To use Filter By Form, click the Advanced button in the Sort & Filter group on the Home tab.
Situation Examples (Answers will vary):
Show songs that were released on CD in the year 2010
Show songs by Elvis released by RCA
Show songs that start with the word "White" recorded by "Bing Crosby"
You might also like to view...
Two-way alternate (TWA) mode for dialog control is used in ____ communications.
A. simplex B. complex C. half duplex D. full duplex
(Simple Encryption) Some information on the Internet may be encrypted with a simple al- gorithm known as “rot13,” which rotates each character by 13 positions in the alphabet. Thus, 'a' corresponds to 'n', and 'x' corresponds to 'k'. rot13 is an example of symmetric key encryption. With symmetric key encryption, both the encrypter and decrypter use the same key.
a) Write a program that encrypts a message using rot13. b) Write a program that decrypts the scrambled message using 13 as the key. c) After writing the programs of part (a) and part (b), briefly answer the following question: If you did not know the key for part (b), how difficult do you think it would be to break the code? What if you had access to substantial computing power (e.g., supercomputers)? In Exercise 18.25 we ask you to write a program to accomplish this.
To insert a new row above the selected row, click the Row Above button on the ____.
A. Toolbox B. Tables toolbar C. Tables task pane D. Common toolbar
Which of the following media sanitization methods uses a program to write 1s and 0s on disk?
A. Formatting B. Deleting C. Degaussing D. Overwriting