These tips, tricks, and shortcuts are for Microsoft Access.

Display the Ampersand (&) in an Access Database Label or Text Box

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 && [...]

By | June 21st, 2015|Access Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on Display the Ampersand (&) in an Access Database Label or Text Box

RIGHT-click from the Keyboard, NOT the Mouse

Would you like to be able to bring up a context sensitive menu ([RIGHT] click) using a key on the keyboard rather than using the mouse? Press the Menu Key or press Shift+F10 – the result is a context-sensitive menu. If you have the MENU key then it is generally located to the right of [...]

By | March 9th, 2014|Access Tips, Excel Tips, Office 2007 Tips, Office 2010 Tips, Office 2013, Outlook Tips, PowerPoint Tips, Publisher Tips, Word Tips|Comments Off on RIGHT-click from the Keyboard, NOT the Mouse

ACCESS PARAMETER QUERIES

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, [...]

By | December 10th, 2013|Access Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on ACCESS PARAMETER QUERIES

ACCESS QUERIES – WILDCARDS

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 [...]

By | December 10th, 2013|Access Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Office 2013|Comments Off on ACCESS QUERIES – WILDCARDS