These tips, tricks, and shortcuts are for Microsoft Access.
It you need to use the ampersand (&) in a label or text box in a Microsoft Access database, it will display as an underscore (_). For example, you type and want to display “Sales & Marketing” but you get “Sales _ Marketing”. To display the & symbol: Double up the & - “Sales && [...]
When you use a particular query often, but need to change the criteria each time, you should look at the Parameter Query. Rather than having to edit the query’s criteria each time you need different data, you add the Parameter query. This lets you run the query without having to manually adjust the criteria. Instead, [...]
To locate a specific item when you cannot remember exactly how it is spelled, try using a wildcard character in a query. Wildcards are special characters that can stand in for unknown characters in a text value and are handy for locating multiple items with similar, but not identical data. Here are some examples [...]