We are Access Experts. Call Us Today! 773-809-5456

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

How To Do An Autofill In Microsoft Excel

How to set your Application Title and Icon

How to Set a Trusted Location

How to Set a Startup Form

How to Open the Field List in Form’s Design View

How to Hide the Navigation Pane