USU  ››  Programs for business automation  ››  Program for clinic  ››  Instructions for the medical program  ›› 

Searching for words in a table

Before you learn how searching for words in a table works, first take a look at the sorting methods.

Search by first letters

Now let's start learning how to quickly find the desired row in the table. When working with large amounts of data, the task constantly arises: find the words in the table. For such a search, we will not need any special input fields where you would enter the text you are looking for. Everything is much easier and more convenient!

For example, we will look for the right person in the employee directory "by name" . Therefore, we first sort the data by the ' FULL NAME ' column and stand on the first row of the table.

And now we just start typing the name of the person we are looking for on the keyboard. Enter ' and ', then ' to '. Even though we enter ' and ' in lowercase, and in the table ' Ivanova Olga ' is written with a capital letter, the program immediately moves the focus to it.

This is called ' quick first letter search ' or ' context search '. Even if thousands of employees are entered in the table, the program will instantly find the right person as you enter characters.

Similar values when searching by first characters

If there are similar values in the table, for example, ' Ivanova ' and ' Ivannikov ', then after entering the first four letters ' Ivan ', the focus will first go to the employee who will be located closer, and when entering the fifth character, the program will already show the required person . If we write ' n ' as the fifth character, the program will display ' Ivannikov '. It turns out that the search on the first characters compares the values in the table to match the search text sequentially when entering each character.

Why might the search not work?

The search may not work if you are trying to press letters in one language, and a completely different language is active in the Windows operating system in the lower right corner.

Search by part of value

If you know only a part of the value you are looking for, which can occur not only at the beginning of a phrase, but also in the middle, then see here how to search by part of a word .

Full table search

You can also search the entire table .

See below for other helpful topics:

• Sort table
• Fast filtering
• Table search
• Selecting a value from the directory
• Input field
• Improve program performance
• To the begining

• Download the program with interactive training