Setting up dependencies, or task relationships, is an integral part of working in Project. But many newer users ask, Which relationship should I use, and What are these “lag” and “lead” things about? The choice of dependencies, as well as using the two other items, …
The use of table relationships in Access allows tables to cooperate in the use of data, but table joins, while they look similar, serve a different purpose. The relationships, which allow coordination while organizing data, nevertheless don’t directly affect, say, the results of a query. …
The Cost Tables feature in Microsoft Project reflects a point which is particular to this program—it is, basically, time-sensitive. Since a business project takes a minimum, usually, of several weeks to run, the project must take time into account. And, no pun intended on this …
One of the more abstruse points of procedure in Access involves the three so-called normal forms. What, exactly, are they? If you think “guidelines”, or “protocols”, you’d be in the ballpark. When building a database, especially a relational database, there are some “streamlinings” which allow …
The good news is, the import and export processes in Access—and in general—are two sides of the same coin. And there really isn’t any bad news, other than making sure the data are set up in a way that Access can understand—namely, something row-and-column-ish when …
SkillForge SkillSheet Microsoft Project 2010/13/16 Keyboard Shortcuts Click here to download the PDF version. Navigate Views and Windows In order to… Press Activate the Control menu ALT+SPACEBAR Activate the entry bar to edit text in a field F2 Activate the menu bar F10 or ALT …
When preparing business presentations using PowerPoint, one needs to make really sure the show has a coherent, consistent appearance. Themes are an easy way to do this. Because the brain is wired to start understanding and working with pictures from infancy, keeping the graphic elements …
The process of setting up a cross-reference in Word, frankly, can take a little time to get comfortable with. So don’t worry if you need a couple run-throughs. The recipe goes like this: First, create a bookmark (there are a couple other things you can …
There’s a quirky thing about Microsoft Project, having to do with resources—more specifically, Cost resources. The other two types, Work and Material, are pretty easy to understand and use, but Cost takes a little bit of extra work to make do its thing. A Work …
When setting up reports in Access, we’re trying to learn something which wasn’t in the original data. Something calculated, derived, or otherwise figured out from the existing information. It’s fairly easy to do, though there are a few steps. After determining the requirement—a sales tax …