Hello,
I am brand new to database design so please forgive beginner questions.
I am using Access 2016 "Contacts" template. The built in Search function on the Form view of the database seems to default to searching only the "name" columns of the data table.
Is there a way to reassign the search function to a different data column? I want the search function to search in the "notes" column of the data table and yield search results of contact forms that contain the search term in the notes column.
I hope the question is clear. Thanks in advance.