Snap To Grid Under Size/Space, when you move the control, Access aligns the upper-left corner of a control to the grid. To Grid Select the control, then goto Sizing & Ordering group -> Align, Access immediately moves the control’s upper left corner to the nearest grid point.
Read more →Form Wizard or Quick Create can be used to create Access forms quickly, that can then be tweaked as per the user preferences. However Application Part forms, a new feature in Access 2010, supply a few buttons with the macros already incorporated – ex. a button with
Read more →There is a new control in Access 2010 – the Navigation Control. This is based on the old Switchboard Manager idea in previous Access releases. The navigation control is used to create a navigational interface similar to websites that mostly have buttons running along the top and
Read more →With layered objects on a Powerpoint slide, press Tab to cycle through the objects on the slide, until Powerpoint selects the object you need.
Read more →In case you are wondering how to put OneNote to work for you.. http://www.techrepublic.com/blog/10things/10-tips-for-using-onenote-to-keep-your-good-ideas-from-getting-away/3193?tag=nl.e056
Read more →FirstDay: DateSerial(Year([Testdate]),Month([Testdate]),1) LastDay: DateSerial(Year([Testdate]),Month([Testdate])+1,0) PrevMth_FirstDay: DateSerial(Year([Testdate]),Month([Testdate])-1,1) PrevMth_LastDay: DateSerial(Year([Testdate]),Month([Testdate]),0) NextMth_FirstDay: DateSerial(Year([Testdate]),Month([Testdate])+1,1) NextMth_LastDay: DateSerial(Year([Testdate]),Month([Testdate])+2,0)
Read more →By Jody Gilbert November 17, 2009, 2:11 PM PST Takeaway: You don’t need to get distracted by the mechanics of presenting a slide show. Learn just a few shortcuts and you can focus on your audience and your message instead. How do you feel about standing in
Read more →If you know your formula is correct, and it is okay for the column being used in the division to have a zero, (and you don’t want your end user to think your spreadsheet is wrong), then your formula should use the IF statement. Ex. If A2/B2=0
Read more →Microsoft is in our lives more than we realize.. http://www.techrepublic.com/blog/window-on-windows/i-dont-know-why-or-how-you-would-say-good-bye-to-microsoft/6086?tag=nl.e064
Read more →Mailmerge is a super tool and the whole process can even be automated further using VBA. However, here we are going to take the menu route. Further, this is an example only of the steps that can be taken – you can choose the option that suits
Read more →