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 »
A document can be easily converted to a fillable PDF form using either Adobe Acrobat Pro DC or Bluebeam Revu eXtreme (this feature is not available with Revu CAD or Revu Standard). If you are starting with a Word or Excel file, first convert that to a PDF, then follow these instructions:
When collaborating on a document in the cloud, it is advisable to use common fonts. A custom font loaded on your local computer, will be replaced when the recipient either does not have the font installed, or opens the file in their browser-based 365 Apps. This can lead to substantial changes in the content of the document.
Using keyboard shortcuts will greatly enhance your productivity. Ctrl + Action Ctrl + Action Ctrl + Action b Bold c Copy a Select all u Underline x Cut z Undo i Italic v Paste y Redo
To access the advanced search tool: Go to Search (Tab) > Search Tools > Advanced FindUse: AND, NOT, OR, <, >, =, operators (must be typed in all CAPS) to refine your search..
After updating your iOS you may experience issues such as: Attachments not downloading. Calendar invites showing up as .ics files. Contact searches running very slow. Unread items showing incorrect count. Email downloading only the first few lines.
Wireless headsets can be a great enhancement to your daily productivity. The Jabra Engage 75 connects to your PC, Mobile and desk phone. For those that travel the Jabra Evolve2 85 is a great over the ear solution.
Teams is a great tool for real-time collaboration. It allows your office to call, chat and meet one place. Chats are persistent and can be secured to limit access.
Workstation class laptops usually have two GPUs. The onboard Intel integrated GPU and a dedicated NVIDIA graphics card. When this is the case you need to make sure that your high-performance applications use the NVidia GPU, rather than the low-performance Intel integrated GPU. To ensure optimal application performance make the following adjustment:
Beginning with iOS 13 you can connect a Bluetooth mouse or Bluetooth keyboard & mouse combo to your iPad. Here are the steps: Go to settings > Accessibility > AssistiveTouch > Devices > Bluetooth Devices Place your device in pairing mode and select it from the iPad menu. Go back to AssistiveTouch and turn it on.
In order to protect yourself on the Internet, you need to be proficient at locating and identifying domain names. This is because, emails and attachments can be used to redirect you to sites that are loaded with bad content. Make sure you can: Verify the email sender. Verify any link contained in the message or within an attachment… Read More »
The “Grandparent Scam” is a particularly disturbing scam perpetrated on the elderly. The criminal contacts the Grandparent, pretending to be a grandchild in trouble with the law or in desperate need of cash for a medical bill. They then claim that the matter cannot be discussed with other family members (red flag). Victims report receiving calls late at… Read More »
Applications like InDesign and AutoCAD interlink files as you create content. This allows teams to share workloads, provides more efficient file storage and adds greater stability to the software platforms. These linked files can create an issue when multiple entities work on the same file or when content is moved to a new location. The solution to this… Read More »
This is the mobile version of Keepass, our recommended desktop password management tool. You can use iTunes on your PC or Mac to transfer your password database to your iOS device periodically. This will give you mobile access to your passwords without ever placing them at risk in the cloud. This can also serve as a backup location… Read More »
Grammarly is a writing assistant that can spell-check your web-based content as you write. It can be loaded as a firefox browser plugin for free. It offers advanced functionality, with a monthly subscription, to evaluate your writing in the areas of tone, engagement, clarity, and grammar.
When creating an e-mail signature in Outlook or sharing a word or excel file, it is important to remember that fonts are not common across all platforms. If you use a font that does not exist on the recipient’s device, your signature or file appearance will change as the font you selected is replaced with a default font.… Read More »
When you have a weak wireless signal, you can try and boost it in a couple of ways: Make sure the wireless access point (WAP) closest to you is not obstructed. Clear away any dense objects within a foot of the device. You might also reposition it to boost the signal. Make sure your device in not in… Read More »
A business may be held liable for all or a substantial portion of any loss when checks are stolen or altered. Positive Pay is an automated check fraud detection service offered by most banks. It matches the payee, check number, and dollar amount of each check presented for payment against a list of checks issued from your accounting… Read More »
Tips, from the FBI, to avoid becoming a victim of cyber fraud: Do Not Do not give unknown, unverified persons remote access to devices or accounts. Do not communicate with unsolicited email senders. Do not act in haste. Criminals create a sense of urgency to produce fear and lure the victim into immediate action.
There is a great deal involved in maximizing the performance of your laptop or phone battery. GPS, Temperature and screen brightness all play a role. This Page from Apple details how to optimize each device.
Whether you are in a hotel, airport, or coffee shop, WiFi can be spotty. The most common cause is the requirement for you to agree to an acceptable use policy on each device. This must be done before you can connect to your email or VPN. To do this, launch your browser and go to a new page.… Read More »
Apple announced the new features of iOS 13 More here… Do not be the first to upgrade. Turn off Automatic Updates: Settings > General > Software Update > Automatic Updates > Off
Your current Illinois driver’s license will not be accepted at airports, military bases and secure federal facilities after Oct. 1, 2020. You can obtain a REAL ID card or use a passport after that time. To see what documents you need to apply for a REAL ID, visit the REAL ID Interactive Checklist. All Driver Services facilities are… Read More »
Hackers are using the familiar Apple settings icon to trick users into hacking their own iOS devices. As I discussed in a previous post, this can permanently destroy your device. If you ever see the settings icon and a request to install, confirm or cancel, do not click any response presented. Rather, you should immediately close your app.… Read More »
The U.S. Postal Service just fixed a security weakness that allowed anyone who has an account at usps.com to view account details for some 60 million other users, and in some cases to modify account details on their behalf. This would have been less of an issue before they released their latest service called Informed Delivery, which allows users… Read More »
The Internet Crime Complaint Center received an increase in the number of Business complaints requesting false requests to purchase gift cards. The victims receive either a spoofed email, a spoofed phone call or a spoofed text from a person in authority requesting the victim purchase multiple gift cards for personal or business reasons.
Office has a new look if you are on Office 365. One advantage that Office 365 offers is real-time access to the ever growing list of features that the product receives on an ongoing basis. Microsoft has also released its on-premise version of Office 2019
Attackers exploited a vulnerability in Facebook’s code that impacted “View As” a feature that lets people see what their own profile looks like to someone else. This allowed them to steal Facebook access tokens which they could then use to take over people’s accounts.
The next generation of cellular known as 5G is being rolled out on October 1. Verizon is first in the world to provide a commercial 5G service, with plans for rapid broadband internet, and 5G mobility service More Here …
Remote administration tools, such as Remote Desktop Protocol (RDP), as an attack vector has been on the rise since mid-late 2016 with the rise of dark markets selling RDP Access. Malicious cyber actors have developed methods of identifying and exploiting vulnerable RDP sessions over the Internet to compromise identities, steal login credentials, and ransom other sensitive information.
Your iPhone is capable of making higher quality voice calls with VoLTE. The quality improvement comes from increasing the bandwidth used to carry your voice, relative to a traditional cellular call. To enable this go to Settings > Cellular > Cellular Data Options > Enable LTE > Select Voice & Data
OneNote is a virtual notebook, with incredible search capabilities, that synchronizes across all your devices and between multiple users in real time. A universal platform, it works on Windows, Mac, iOS, Android, and Online. Everything is stored as a separate element so markups can be removed, files or images can be saved or moved. Pages are a limitless… Read More »
Did you know you can use your iPhone, or iPad with cellular service, as a backup internet connection. You need to set it up before you loose Internet service.
Today the greatest threat to company security is the email vector. KnowBe4 provides security awareness training and simulated phishing attacks to test employee response to manage the continuing problem of social engineering.
Did you know that prices on Amazon change hourly. CamelCamelCamel.com tracks prices and can send alerts when they are at their lowest. Browser Plug-ins help simplify the service.