Constraints in SQL or PostgreSQL is like ‘gate keepers’ which controls the type of data that can go into a table. Constraints are the rules that enforced on the data columns of a table. This ensures the accuracy and reliability of the data in the database. It maintains the integrity of data in the table. Levels of Constraints in SQL Constraints could be on a column level or a table… Read More »Constraints in SQL/PostgreSQL
Table is one of the most commonly used elements in Ms Word Table. Following are the Ms Word table shortcuts that may help you save time and effort while working with them. Note: In the shortcut described below, + is used where keys are pressed simultaneously while “,” is used in case where keys needs to be pressed successively (one after other) To do this Windows shortcut Mac shortcut Move… Read More »Must know shortcuts for working with Tables in Ms Word (Windows & Mac)
An array in python is a data structure that contain a group of elements. These are use in computer program to organize data so that related set of value can easily stored or searched. It is a collection of elements having the same data type and always start from index value and index start from 0 to 1. It doesn’t have a fixed size which means it can be expand… Read More »Array in Python
Microsoft Word is the most popular and widely used word processor. Keyboard shortcut helps user do task quickly and efficiently. Ms Word provides keyboard shortcut for almost all tasks. Following list contains the Ms Word’s most useful and frequently used shortcut. List of most useful and commonly used Ms Word shortcut. You can get most of the Mac shortcut by simply replacing Ctrl (of Windows) with Command (of Mac) To… Read More »Most useful Word shortcut that you should not forget [Windows & Mac]
Microsoft Word has a feature to show non-printing characters like paragraph mark (¶) in case you need it. Though it is useful to see them in some situation, they don’t look good & you may want to get rid of paragraph symbol and other formatting characters in Word. There are a couple of different ways to get rid of these annoying non-printing formatting characters in Word. In most of the… Read More »Get rid of paragraph mark (¶) & other formatting symbol in Word
Getting words count is easy in Google Docs. You can also let Google Doc to show live word count if you need with one quick setting. How to get words count in Google Doc 1. Go to Tools > Word Count. (see image) You can also use keyboard shortcut “Ctrl + Shift + C” (Windows) or “Command + Shift + C” (Mac) 2. A new window showing word count along… Read More »Count words in Google Docs using these easy steps
We use a watermark to show copyright / owner (company name), state (draft, final) or status (confidential) of the document. However, when they change, you may sometime need to delete the watermark. In majority of the cases it is not possible to select watermark and delete it (like we do with normal text and images) There are a couple of different ways by which you can delete watermark in Word.… Read More »Easy way to get rid of any watermark in Ms Word (Windows and MacOs)
Developer tab give Word user additional advance options like write/record and run Macro, Active-X control, XML command etc. However, it’s not available in Word by default and you need to enable it with one time setting. In our earlier blog, we covered how to enable/show developer tab in Ms Word for Windows. This blog covers how to do the same in Ms Word for Mac along with video tutorial. The… Read More »How to show developer tab in Ms Word for Mac
Developer tab opens up advance Microsoft Word features like option to record/write & run macros, use Active-X controls & XML commands, create applications in Microsoft Office, and more advance feature. However, it’s hidden by default and you need to activate it. This blog covers steps by step method to add developer tab in Ms Word for Windows along with video tutorial (Mac user can find similar tutorial here). Steps to… Read More »How to add developer tab in Microsoft Word [Windows]
Word count feature of Microsoft Word one of the useful feature if you need to make a document which has limitations on word count. Microsoft Word has a build in feature to count Pages, Words, Characters (with and without spaces), Paragraphs and lines. You can get these values for the entire document or for the selected text. This blog shows you different ways (along with keyboard shortcut) by which you… Read More »How to quickly count words in Word (Windows and MacOS)