Microsoft Teams, the messaging/meeting/hub program, allows us to centralize a few things we had to do “à la carte” before. By gathering stuff in one place, we can save time and effort. After we install it, one of the main things is to set up …
The resource calendar in Project lets us take the resources’ non-work time into account. There are religious, working-two-jobs, and a few other reasons why this might come into play. So once the project calendar is established, we can create a variation of it as a …
The Select Case statement in Visual Basic for Applications sometimes “competes” with the If…Then…Else statement, because the two can both be used for testing information. When we want to find out about more than one thing, condition, or what have you, we sometimes need to …
There are a few important and helpful things to watch out for in Access reports. They spring from the fact that, unlike most other database components, reports often have to stand on their own. So their formatting and layout have to be more complete and …
In this free Excel PowerPivot webinar, Excel Instructor Seth Bonder explains how to add PowerPivot functionality into Excel, how to create a data model and much more. To learn more about PowerPivot, or to enroll in one of our PowerPivot classes, please visit our Excel …
Dealing with errors in VBA code, especially in Access, is a vital part of setting up procedures. If nothing else, an error-handler can give the user a better idea of what’s glitching, if something does. And having a message box come up to give the …
Calculated fields are a really big help in Access; they let us derive data from existing information. And they’re flexible, too. If one of the source items changes, the calculation updates immediately, just like an Excel formula. But some people aren’t aware you can add …
The Organizer is one of the lesser-known features in Project. And it’s a shame that this one is overlooked. It can be a major help in both building templates and making already-built elements easily available. One common example is calendars. If you build a company …
A template in Project, as in most other programs, is a blank form. We fill in the spaces, as on a tax form or license application. The more complex the job, the more complex the form. So when we’re managing a project, any help we …
The idea of the split form in Access is rather like its cousin in Project. We set up a view with the “big picture” or large-scale view in one portion of the window (usually the top), and details in the bottom. Sometimes vice versa, but …