Open Database Connectivity (ODBC) is designed to expose database capabilities via SQL. It improves the analytics process by giving users real-time access to data from multiple sources. Data can be transformed, within applications such as Excel and PowerBI, into reports and dashboards. Excel macros and scripting languages like PowerShell can automate the creation and distribution of reports via… Read More »
Boolean search Utilizes special words or symbols to limit, widen, or define the scope of your search. These include: AND, OR, NOT, and NEAR, as well as the symbols + (add) – (subtract) ” ” (quote). Boolean Operator Symbol Explanation Example AND + All words must be present in the results football AND nfl OR Results can include any of the words… Read More »
Press this key To do this F4 Display the items in the active list. Ctrl + Tab Move forward through tabs. Ctrl + Shift + Tab Move back through tabs. Ctrl + number (number 1–9) Move to nth tab. Tab Move forward through options. Shift + Tab Move back through options. Alt + underlined letter Perform the command… Read More »
Taskbar keyboard shortcuts Press this key To do this Shift + click a taskbar button Open an app or quickly open another instance of an app. Ctrl + Shift + click a taskbar button Open an app as an administrator. Shift + right-click a taskbar button Show the window menu for the app. Shift + right-click a grouped… Read More »
Press this key To do this Ctrl + C (or Ctrl + Insert) Copy the selected text. Ctrl + V (or Shift + Insert) Paste the selected text. Ctrl + M Enter Mark mode. Alt + selection key Begin selection in block mode. Arrow keys Move the cursor in the direction specified. Page up Move the cursor by… Read More »
Press this key To do this Windows logo key Open or close Start. Windows logo key + A Open Action center. Windows logo key + B Set focus in the notification area. Windows logo key + C Open Cortana in listening mode. Notes This shortcut is turned off by default. To turn it on, select Start > Settings > Cortana, and turn on… Read More »
Press this key To do this Ctrl + X Cut the selected item. Ctrl + C (or Ctrl + Insert) Copy the selected item. Ctrl + V (or Shift + Insert) Paste the selected item. Ctrl + Z Undo an action. Alt + Tab Switch between open apps. Alt + F4 Close the active item, or exit the… Read More »