IT DIGEST
Run a strong magnet over the floppy disk to erase any data on it. Buy a neodymium magnet from an office store or big box store. Rub the magnet all over both sides of your floppy disk. This will scramble all of the data on the disk, making it unusable. Can you erase a floppy […]
Instead, IP addresses might reveal your city, ZIP code, or area code of where you are connecting to the internet at that moment — this is why IP addresses change every time you connect from a new location or using a new router. Does IP address change based on location? Change your network or location: […]
Tags are simple pieces of data — usually no more than one to three words — that describe information on a document, web page, or another digital file. Tags provide details about an item and make it easy to locate related items that have the same tag. How do you use tags effectively? Use the […]
How do I find my password for Microsoft Outlook? How to recover Outlook password Install Recovery Toolbox for Outlook Password. Run Recovery Toolbox for Outlook Password. Select email account in middle panel. The recovered password will appear in right panel. What is Outlook PST password? While you can’t set a password for your entire Outlook […]
Format the Cells Select the cells that you want to format (A2:D4 in this example) On the Ribbon’s Home tab, click Conditional Formatting, then click New Rule. In the New Formatting Rule window, click Use a Formula to Determine Which Cells to Format. How do you Format different rows in Excel? Apply color to alternate […]
How To Apply Conditional Formatting Across An Entire Row In Google Sheets Highlight the data range you want to format. Choose Format > Conditional formatting… in the top menu. Choose “Custom formula is” rule. Enter your formula, using the $ sign to lock your column reference. How do I apply a rule to an entire […]
EXCEL ADVANCED FILTER (Examples) Select the entire data set (including the headers). Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). In the Advanced Filter dialog box, use the following details: Action: Select the ‘Copy to another location’ option. Click OK. What […]
Preview a report When you want to see how your report will appear when printed, use Print Preview. If you preview a report that was created in Access, the record navigation buttons appear in the default location, at the bottom of the Access window. How does a document look in print preview? Print preview is […]
Simple Query WizardEdit Go to the CREATE Tab. Go to the OTHER group on the far right. Click on Query Wizard. This is just like creating a report. Pick the table you want to query. Pick the fields you want to look at. Click NEXT. Type in the title of the Query. Click FINISH. What […]
A database query is a request for data from a database. Usually the request is to retrieve data; however, data can also be manipulated using queries. The data can come from one or more tables, or even other queries. What is a queries in database? A query can either be a request for data results […]