Assign Password Data Type To A Specific Field In Access 2010

Applying different types of constraints over data fields in Access 2010 comes in handy, especially when you need to restrict database users in specified range. Applying Data types over fields plays vital role in manipulating data in a desired way, but way of assigning data type as password is bit different as you need to add input mask for it. In this post we will show how to assign password data type to a specific field.

To begin with, launch Access 2010 and create a new table, navigate to Create tab and click Table.

It will create table namely Table1.

table 1

Right-click newly created table and click Design View.

design view 1

Now enter appropriate table name and click OK.

save as 1

Start entering table field names; Login Name and Password. Now we will be changing Data Type of field Password.

login design view

Select the Password field and under field properties, from Input Mask, click small button at the end of the field, a message box will pop-up asking for saving the table first, click Yes to start a input mask wizard.

input mask

In wizard, from list of Input Mask, click Password and click Next to continue.

select passwordf

Now click Finish to end the wizard.

click finish

You will see Password data type inserted as Input Mask. Now close down the design view and save the changes made.

password 1

Open the table in datasheet view and start entering the login details and Password. On entering password, you will see asterisks concealing the password text.

login details

You can also check out our previously reviewed guides on How to import XML file in Access & Export database to PDF document.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *