Restrict access to hard disk on Window

 

1. Log on to the computer with an Administrator account.
2. Click "Start," type "Control Panel" (without quotes) and then navigate to "Control Panel > User Accounts" (Control Panel\All Control Panel Items\User Accounts).
3. Click "Manage another account."
4. Click "Create a new account" or " Add a new user in PC settings" (in case of Windows 8/10) and fill in the required username, password etc.
   
   On Windows 8/10, the process to add a new user to PC is slightly different. Add a new user following the steps below: 
•  Navigate to Control Panel\All Control Panel Items\User Accounts
• Click on Manage Another Account
• Click on "Add a new user in PC settings"
• In the PC Settings > Family & Other People > Click "Add someone else to this PC"
• Windows will attempt to let you enter Windows / Outlook account details of the person you want to add. If you have, well and good. Otherwise, click on " I don't have this person's sign-in information".
• Windows will then tell you to create an account for the user. If you want Windows / Microsoft account, go ahead. Otherwise, click on "Add a user without Microsoft Account"
• Fill in Username, Password and Password Hint if required.
• Then click on next and proceed as per the instructions.
5. If the user account already exists or you have created a new user account, then open Windows Explorer. 
6. Right-click the name of the hard drive or hard drive partition you want to restrict access to and then click "Properties."
7. Click the "Security tab" in the "Properties" window that opened. Click "Edit..." and "Add..." in the "Select Users or Groups" window that opened.
8. Type the name of the user account on your computer with which other users will login with (existing account or the one newly created). 
9. Click "OK." Uncheck the boxes against ALLOW of any options that you DO NOT want available to the user. Also check the "DENY" boxes for "Full control". It should be disabled or unchecked.
10. Click "OK," "Yes" and "OK." Close any open windows. 
11. Log off the administrator account that is signed in currently and then log on as the other user to test the settings applied.
12. After you are logged in as the other user account, open Windows Explorer.
13. Double-click the name of the hard drive or hard drive partition you restricted access to. A window indicating that "Access is denied" is shown. The user is denied access to the hard drive or hard drive partition henceforth.

The steps above will successfully restrict or deny access to a hard drive or hard drive partition from other users.

Excel - Getting List from Other Spreadsheet for Display with Data Validation List

You can create your own pull-down list or combo box by using the data validation feature in Excel but the main problem is the list has to be in the same spreadsheet as the combo box that you want to use. What most of us will do is just create a list somewhere else in the same spreadsheet and then hide it either by hiding the columns or rows of the list or change the font colour to white so it is invisible.

You can actually make use of the range name for the list that is in other sheet tabs and there is no need to copy it to the spreadsheet that you want to put the combo box.

Here's how...

1. Select the list that you want to use (it could also be from the table array you use for VLookup or HLookup. If it is, just select the list excluding the header which is the column one for VLookup table array or row one for HLookup table array). It is best if you can first sort your list in ascending order because the list taken in data validation will follow your actual list without sorting them for you.
   
2. With the list selected, click in the name box located to the left of the formula bar and type a name (the name has to be unique and shouldn't be separated if it consists of more than one word) and then press Enter.

1. Return to the other spreadsheet and select the cell(s) you want to create combo box.
2. With the cell(s) selected, go to Data tab and select Data Validation from Data Tools group (for Excel 2003 or earlier, go to Data menu and select Validation...).

1. On the Data Validation dialog box, go to Settings tab.
2. Select List from Allow combo box.

1. Type the name you have given for the list in step 2, starting with the equal sign (=) in the Source field (I used FruitList for my example).

Click OK or you can continue setting the Input Message and/or Error Alert tab if you want to.

You can combine the usage of this combo box with any lookup function or use it alone.

Create Email Template-Outlook

Sometimes, you may find that you will be sending emails of the same content again and again (maybe to send monthly report, etc...) and you'll find that you have to type same sentences for these emails again and again.

Try saving the email message as a template and later you can reuse it.

1. Compose new email as you usually do with normal emails. Put in the subject and if you are going to always send to the same recipient, you can put the recipient email addresses in the To, CC or BCC field.
2. Once complete, click the Office Button and select Save As

1. In the Save As dialog box, change the Save as type: to Outlook Template.
2. Name the file and select your file location if you want to save it in different location or just leave it in the default template location as it is.

For earlier version users, you must first disable the Use Microsoft Office Word 2003 to edit e-mail messages feature found in Tools > Options menu under the Mail Format tab of the Options dialog box.

Follow the steps 2 to 4 as stated above (slight difference in step 2 where you should click File menu instead of Office Button).

To use the template (same process for Outlook 2007 or earlier):

1. From Tools menu, go to Forms and select Choose Form... .

In the Choose Form dialog box, select User Templates in File System from Look In: combo box.

1. Select the template listed or click the Browse button if the template is in other location.
2. Click Open.

Now you can continue to add attachment(s) or amend the template as required.

Build your own Artificial Assistant

Virtual assistants are Artificial Intelligent based programs. They are a smart computer program that understands human natural languages through voice commands or text and performs tasks for the user.

Visual Studio Code is an integrated development platform for computer programming, with an emphasis on the Python programming language.

Step-1
Launch the application (VsCode) and click on the file menu, then select new project.
For this little script we are using python libraries:
SpeechRecognition is a library for performing speech recognition, with support for several engines and APIs, online and offline.
PyAudio provides Python bindings for PortAudio, the cross-platform audio I/O library. With PyAudio, you can easily use Python to play and record audio on a variety of platforms.
Pyttsx3 is a text-to-speech conversion library in Python. 
For the robot to listen to our voice/speech
`pip install speechRecognition`

For Python bindings for PortAudio

'pip install pyaudio'
To speak out, or text to speech
`pip install pyttsx3`
For advance control on browser
`pip install pywhatkit`
To get wikipedia data
`pip install wikipedia`
To get funny jokes
`pip install pyjokes`

Step-2

Paste the below Code:

--------------------------------

import speech_recognition as sr

import pyttsx3

import pywhatkit

import datetime

import wikipedia

import pyjokes

listener = sr.Recognizer()

engine = pyttsx3.init()

voices = engine.getProperty('voices')

engine.setProperty('voice', voices[1].id)

def talk(text):

    engine.say(text)

    engine.runAndWait()

def take_command():

    try:

        with sr.Microphone() as source:

            print('listening...')

            voice = listener.listen(source)

            command = listener.recognize_google(voice)

            command = command.lower()

            if 'Shainee' in command:

                command = command.replace('Shainee', '')

                print(command)

    except:

        pass

    return command

def run_Alexa():

    command = take_command()

    print(command)

    if 'play' in command:

        song = command.replace('play', '')

        talk('playing ' + song)

        pywhatkit.playonyt(song)

    elif 'time' in command:

        time = datetime.datetime.now().strftime('%I:%M %p')

        talk('Current time is ' + time)

    elif 'tell me about' in command:

        person = command.replace('tell me about', '')

        info = wikipedia.summary(person, 1)

        print(info)

        talk(info)

    elif 'date' in command:

        talk('sorry, I have a headache')

    elif 'are you single' in command:

        talk('I am in a relationship with wifi')

    elif 'joke' in command:

        talk(pyjokes.get_joke())

    else:

        talk('Please say the command again.')

while True:

    run_Alexa()

Step-3

Click Play Button

How to set up confidential mode and schedule emails in Gmail?

How to set up confidential mode and schedule emails in Gmail?

Gmail has introduced schedule  & Enable Confidential mode an email. This feature was very much needed. Email scheduling feature allows us to send emails later such as if you are composing an email on a Saturday evening because you would forget but want to send only during business hours on Sunday.

Steps:-

* Click on  Schedule Send

* Schedule Date & Time

Turn Confidential Mode On

* Click on Turn confidential mode on / off

* SET EXPIRATION (You can also send Google-generated passcodes via SMS for certain countries)