Assign Password Data Type To A Specific Field In Access 2010

Applying various types of constraints over data W. C. Fields in Entree 2010 comes in handy, particularly when you need to restrict database users in specified chain. Applying Data types over fields plays vital role in manipulating data in a desired right smart, but way of assigning data type as password is bit disparate as you need to add input dissemble for it. In this post we bequeath show how to delegate parole data typecast to a specific field.

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

create table

Information technology volition create table namely Table1.

table 1

Right-click fresh created put over and click Designing 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 volition be changing Data Type of force field Word.

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

input mask

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

select passwordf

In real time pawl Finish to final stage the wizard.

click finish

You will see Password information type inserted as Stimulation Mask. Now close down the design view and bring through the changes made.

password 1

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

You throne also check dead our previously reviewed guides happening How to import XML file in Access & Exportation database to PDF document.