Category Archives: Tutorials
General MS Office / Windows
These are shortcuts you can use for various tasks in Office or Windows. Ctrl + A Selects all items in the current window/document Ctrl + C Copies the highlighted text/item Ctrl + P Opens the Print dialog Ctrl + V … Continue reading
Excel Tips and Tricks
Excel Keyboard Shortcuts Excel 97 http://www.keyxl.com/aaa76cc/6/Microsoft-Excel-spreadsheet-keyboard-shortcuts.htm Excel 2000 http://www.microsoft.com/enable/products/KeyboardSearch_Excel2000.aspx Excel 2002 http://www.microsoft.com/enable/products/KeyboardSearch_Excel2002.aspx Excel 2003 http://office.microsoft.com/en-us/excel/HP052037811033.aspx Excel 2007 http://www.keyxl.com/aaa33ef/136/Microsoft-Excel-Software-keyboard-shortcuts.htm
Why you should not store calculated information in the tables
The question has been asked many times before and it will be asked many times in the future: “I have calculations on my form but they aren’t saving to the table and I need them to be saved, why aren’t … Continue reading
How to use queries to get your lookup values
Many times people will make the mistake of using lookups at table level instead of using them only at a form level. One of the big problems with this is that it obscures the way lookups actually work. The idea … Continue reading