ITM 102 Chapter Notes - Chapter 2: Logical Connective, Intelligent Code Completion, Autocomplete

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 102
• Professor: Joel Marcus

Document Summary

And logical operator=logical comparison of 2 criteria that is true when both criteria outcomes are true. Asterisk wildcard=wildcard that matches any combo of characters. Autocomplete= intellisense menu of commands matching characters you type. Between and operator= operator finds numbers/dates between and including 2 values. Calculated field=column added to query that derives its value from other fields. Quick info= style that can be accessed from a ribbon gallery of thumbnails. Summary statistic= calculation for a group of data such as a total, avg or count. Wildcard=special character, eg; asterisk used in query criteria to allow matches for any combo of letters/characters.