New Posts
Home / Computer 4 Beginners / How to Organize Access Records

How to Organize Access Records

How to Organize Access Records.

In this lesson, we will learn about Organizing Access Records. Most of the text formatting options you want to use within your table and apply on the records. However, there are very basic formatting tools available in access when you can avail into your table directly in the sheet view.

access Records

Formatting Columns.

Let’s go Ahead and open the Access.

You can find formatting options under the Home tab on the right-hand side. However, these might not function quite you expect if you have experience making your document something like excel.

home tab

Click on the field and click on formatting toolbar and apply any command.

If you select entire column then apply any command from formatting toolbar. The entire column will be affected.

It does not matter in the table it will apply to everything.

I have to define entire formatting toolbar command by command.

setting of fields

Sorting Table Data.

A common task with any table of data has sorted the contents to bring relevant records to the top.

On the home tab of the ribbon, we have the group called sort and filters and it has all the tools we need.

Open table any table where numbers are available like below image.

 sort

I can use sort by right-clicking on the column.

 ase and desc

The right side of the column there drop down the list I can also sort.

 atoz

When you sort there is a little tiny arrow top of the header. Which indicates sort is applied this particular column here.

I can sort out with the numbers and alphabetic also.

 Remove Sorting.

Go to ribbon on Home tab.

Remove sort.

 remove filter

 Filtering Table Data in Access Records.

The filtering options on the table allow you to limit the number of records on the screen only those records interests

Just like sorting this allows you to quickly the information need.

Let’s take the example from below the table.

Home tab.

Sort & Filters.

Suppose I need those persons who live in Chana for doing that first you click on country field o chine.

Then Selection clicks on Equal “China”.

set equal to

 show result

You can also notice from bottom record navigation which tells there are 19 records are available.

There is a button filtered visually indicator if you click on it. Then unfiltered records will be seen I mean all records.

 record navigation

Click on the country column, you will see filter icon, click on it you will see the following image.

In the following image, you will see additional options I can go with the text filters we have the same options as we saw previously plus the couple more I can also go through the select individual country so, here I can select any country example I select here the United States.

 apply filtration on record

 see result

Hit ok

 see total result

You notice in above image two countries have been filtered one is China and second in the United States.

 To apply filter more than one column at the same time.

1.       People live in China and United States.

2.       Last Name is Dixon.

Countries settings already we have made. Now right click on Last name column drop-down menu and turn off select all, means un-check everybody, only apply check mark on Dixon, Ok.

 apply filter

Now we see the table we have three people. Last name and country.

 see result of apply filter

Turn on and Turn off.

Click on Toggle Filter.

 toggle filter

 Searching and Replacing Values.

No Text editing environment would be completing without easy way search to the text and make replacements. Access has not the exception we can use the same replace tools might be familiar with other office programs.

1.       Open table.

2.       At the bottom of the table, there is search box. Type any text which you want to search.

 Searching and replacing values

2nd way.

On the Home Tab.

find

replace

Find: To find any text.

Replace: for Replacing the text.

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Access Database relationships

How to use Microsoft Access Database Relationships.

How to use Microsoft Access Database Relationships. In this article, we will learn Access Database …