Microsoft Access, one of the most famous software applications from the family of Microsoft tools has emerged as one of the most widely used applications in corporate sectors and homes alike. MS Access helps to store data in its own format that is based on the Access Jet Database Engine. Data architects and software developers alike can use the application to develop application software. Simple applications can also be built by what are known as ‘power users’. With the help of its tools, users can not only create queries, forms, reports and tables but also import data and provide links to other application software. MS Access is simple enough for end users to create their own forms, queries, reports, setting formats, laying out fields and groupings.

The use of tables in MS Access has had wide applications across countries and sectors. It is an object that is used to store data. Every table consists of information about any particular subject. A table contains fields or columns which store different kinds of data. This data could be the name of an individual or a group, or an address. The records or rows of a table contain all the information about any particular instance of a subject. For example, all required information about a company.

Instructions to change the Order of Fields in a Microsoft Access Table

Tables can be inserted in a program, text can be formatted, fonts can be changed and rows and columns can be modified and deleted. Apart from these functions, Access also provides a solution to people who are willing to change the order of fields. Certain steps can be followed, in this respect, which are listed as a step by step procedure, mentioned below.

Step one

Open the MS Access application and then open your database file from the available list of folders

Step two

To open database view, press the F11 key.

Step three

From the view, click on the Table tab. This would result in a display of a list of tables.

Step four

Choose the table you want to work on. Then click on OK and this would open the table.

Step five

Locate the particular field which you want to relocate. The field label or name needs to be selected.

Step Six

The column is to be dragged to its new location, and then release the cursor.

Step Seven

Now the column or the field would be at its new location and the order is changed.

Although a database is made up of various ‘tables’ in MS Access, each table is a collection of records. It is what one would think as a database. It would be more convenient to drag those fields to the beginning of the table if you typically work with them more than the others. This kind of arrangement reduces your scrolling. Also, by dragging and dropping, the fields can be moved back to their original placement or to any other placement.