Hello @ui_baby You have to design steps to achieve your solution.
Connect to an Access database (Create and establish a connection string and pass them with proper credentials)
Find a record (For this you have to build a query based on your requirement. try to use a query manager and build a query based on your requirement and pass that query into a string and shoot with 2nd step.)
Put the if condition if result set if available based on the primary key then you pass if condition.
This 3rd step can achieve as follows:
a. Take query results in a temporary string variable.
b. user inStr() function to validate your query results.
c. If inStr pass then split the string and append your required value in the string.
e. now concatenate both strings. (This will be your final results)