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 …
When we create a project plan, summary tasks are like the main points in a term paper outline. They mark off the highest-level things we need to do in the project. They’re the main stages or phases we look at. So they’re a useful tool …
Project allows for things like calculated fields and other custom data. It holds some fields “in reserve” aside from the ones set up for task names, durations, etc. This way, users can insert data the program couldn’t know about in advance. (I mentioned custom text …
The parameter query, while easy to set up, actually depends on a sort of quirk in the program, as we’ll see. But regardless, it’s a very powerful feature; it allows many variations on one question in a database. Ranges of dates, differences in spelling, and …