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 …
The action query in Access is a different thing from the normal query we create, called a “select” query. The latter simply selects data and shows the result. But an action query edits data, or even deletes it. And the key thing one needs to …
Just as there can be subforms and subreports within an Access form or report, there can be a subquery within a query. As the term implies, a “query within a query” allows the main query to be more specific, or complex. It sometimes requires a …
When putting together a complex document in Word, a section break can help us put together documents such as a book or manual, where one sometimes has to create multiple headers and footers, or allow for single columns, then multiple, then single again. A section …
In PowerPoint, themes are an important part of the presentation. Even if nobody directly notices them, they are as necessary to the slide deck as the foundation for a house. Consistent appearance throughout the show improves understandability, and its professional look. Creating a theme is …
SkillForge SkillSheet Microsoft Access 2010/13/16 Keyboard Shortcuts Click here to download the PDF version. Frequently Used Shortcuts In order to… Press Select the active tab of the ribbon and activate KeyTips Alt or F10 (to move to a different tab, use KeyTips or the …