A common factor in all programs office is the function “Search for and replace” Y Access is no exception. If you have already used it in word or in Excel It will not be difficult for you to handle it.
In fact, you can access it from the shortcut Ctrl+B. But in order for you to get the most out of this tool, you will need know what it is for and what are the advantages of using it.
In the paragraphs that follow you will find all the information related to this function and the step by step that you must do to execute it without errors. Check out.
Access search function What is it for and what are the benefits of using it?
In Like Access, the tool that allows you to search within all elements for specific information is very valuable.. This generates an improvement in the rate of queries, so the time it takes to find a piece of information in a large database is very short. Even you can search in any format the field was generated in, you can also choose concordances. You will also be able to do this task within the entire table or in a specific field.
You can even choose whether to do the search in a form or in several tables of the database. As you can see, search and replace it is a multifaceted tool that helps you find what you need in a matter of seconds. Best of all, you don’t need modify the database to carry out this task, so any user can run it.
Learn step by step how to search and replace data in a database
The steps you will need to do are:
Search
When you want to search for data in a database, you should proceed like this:
- Login to Access and position yourself in the table in which you want to do the search. Then open in the Datasheet view.
- Yes you need to search for a certain field in a column you must click on that area.
- After press the Home tablocated in the upper bar and then select the box Search. If you prefer you can access this easier by pressing the shortcut on the keyboard Ctrl+B.
- A search window called Search for and replace. Inside the box select the tab Search.
- In the search space type the text of the field you want to find.
- If you press the dropdown menu next to the option Search in You can choose if you want to do it in the field in the entire table or in another column. Remember that by default the function will search in the column that you have located at the beginning.
- If you need to extend the search criteria, you will have to use the option Coincide and enter more accurate data.
- Let activated the box Find the formatted fields to avoid having problems with the masks and then click on Search so that the system throws you all the results.
In case you need to search for the information in an open form, you can execute the search in this way:
- Locate yourself in the form in which you want to search with the Form View or Design View.
- Now go to the tab Start and click the option Search to open the search dialog (you can press Ctrl+B if you want to do it faster).
- Select the Search tab y indicates the value of the specific lookup.
- Depending on where you want to search you can change the options Search in.
- If you click find next you can explore the system results.
On the other hand, for users with advanced programming knowledge the DBusq command exists. This function is used especially with the language Visual Basic (VBA) for apps.
The syntax of this command can be summarized as:
- DBusq
Replace
In case you need to replace a found value with another, you will have to follow this step by step:
- As in the previous procedure, you must place yourself in the table where you go to replace the data in mode Datasheet view.
- Click on the column in which you want to do the task search for and replace.
- use the shortcut Ctrl+B or go to File, Archive and then click Search to open the box Search for and replace.
- Instead of pressing the tab Search inside the box, this time use the tab Replace. Thus, In addition to the search process, the option to replace existing data is included.
- Now fill in the blank with the information you need Search and then write in the box Replace by with a replacement string of your choice.
- The lists Search in, Search Y Coincide they determine the criteria of your search for their subsequent substitution in a more precise way. You can also decide if the system should be case sensitive or if it should search for formatted fields by checking the boxes.
- You can go exploring find next until you find the specific field you need. Once you find it you will have to click on Replace.
- if you want to do it with all the fields of the table You can choose replace all.
Keep in mind that this process is finalfor what your want undo changes generated you will have to redo the search and generate a replace in Wrong Way.
edit record
If you’re looking to edit a record, you’ll need to consider these steps:
- First you must find and open the table where the record to be edited is located given Data sheet.
- You can search for the specific record using the navigation buttons located at the bottom of the table. You will find it with a thin line icon that is part of the interface and is called in its left corner Record.
- With the arrows they will indicate whether to go to the first, next, last or previous record
- you can even use the search box located next to it. To do this, you will have to specify the name of the record.
Also you can use the Go To search box. In this, a drop-down list will be displayed with the name of each of the elements that integrate it. Is a very effective tool if you know exactly which record you are going to edit.
The guide you will have to follow is this:
- once you find it check the field you want to modify and look at the first cell to the left of the record
- it will appear to you a small icon in the shape of a pencil. This tells you that you can make modifications in the field without problems.
- Fill in the field with the new data.
- Don’t forget to save the changesfor this you will have to press outside the line of the field in which you are.
Facebook Comments
Disqus