MS Access is the product of  MS office suite which helps the user with its ample sources available. It was earlier known Microsoft Access only, but it has been renamed to Microsoft Office Access. It is actually a pseudo relational database management system which combines with Jet database Engine along with GUI {Graphical User Interface}.  It also supports the software development tools and is the program that can be used to simple applications like application soft ware and small scale software. It is mainly used by the data architecture and Software developers. MS Access is supported by Visual Basic for development of applications and OOP {Object Oriented Programming} which serves a reference to the variety of objects like Data Access Objects {DAO}. There are many editions of Microsoft office in which the MS Access falls like MS Office Professional, MS Office Home edition & MS Office Student edition etc.

It also contains data types where in you can access and use different data types to work on a particular field. Like if you are interested prepare a table on the topic of banking or currency exchange. You can approach it to use the data type in order to change the field name and give it the name of “Currency” rather using data type option which you can find on the toolbar.

Well, the dilemma that prevails is how can one change the data type in MS Access? Is the process quite tough or a headlong approach will find us a way out?

The answer to the above questions say is a set of instructions which will guide you through and help you climb the way out of it.


Step one

Click on the “Start” menu for the windows based operating system. You can then click on the “All programs” tab in order to find out the folder of “Microsoft Office”. In the folder of the latter click on the “Microsoft Access” option to open it. A window of MS Access will prompted, where in you will be required to the view type of it. Click on the “Design view” tab and your table opens in the opted view format.

Step two

In the field of the table, find out or locate the field which data type you long to change.

Step three

A Data type field will appear to the adjacent right of the field name whose data type you have opted to change. An arrow will appear and then you will be required to choose further.

Step four

From the list of data types enlisted when you click on the arrow, you can then choose your desired data type and click on it to apply it.  For example, if you desire that your field name to be for currency evaluation, then from the list you can access the “Currency” tab and access it.

Thus, changing of data type is not only an easier job to tackle with but also a way in which you can give your desired field name a new data type to make it more precise.