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 …
Microsoft Project was designed with the idea that one might need to set up subprojects, or projects within projects. Think of a set of manuals, or a company-wide reworking of hardware and software, or a movie (such as Peter Jackson’s “Lord of the Rings” trilogy). …
A fundamental aspect of Access databases is the setup of relationships between tables. It’s usually the nature of business databases to have them. So the actual creation of the relationship isn’t hard to do. But there are a couple of not-so-obvious things the user needs …
When Excel 2007 was introduced, the PivotTable Field List included a “Filter” area, where one could drop a field to use as a filter (for example, year, brand name, size, etc. from a block of sales data). If the user filtered for one year, or …
One small but important feature in MS Project is the Auto versus Manual Scheduling popup. It’s in the Status Bar at bottom. Here’s how it works: Manual Scheduling allows the user to control start date, finish date, and therefore, duration. And the program will not …