Make life easier for your Access users by building a parameter query that lets them search for specific text. Instead of fumbling around with wildcard characters, they can just enter the search ...

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.