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 arrow keys) Open the Home tab Alt+H Open the Tell me box on the ribbon Alt+Q, then enter the search term Display the shortcut menu for the selected item Shift+F10 Move the focus to a different pane of the window F6 Open an existing database Ctrl+O or Ctrl+F12 Show or hide the Navigation Pane F11 Show [...]
About adminThis author has not yet filled in any details.
So far admin has created 115 blog entries.
In this tutorial, you will learn how to colorize a black and white photo in Photoshop. Want to learn more about Photoshop? Visit our Photoshop Training Classes page to enroll in one of our live, instructor-led Photoshop classes. You'll learn about Photoshop from an experienced instructor while being able to ask questions and discuss projects you are working on. https://youtu.be/Obg_WkmwH4o
Announcing Our New Tableau Training Classes Companies around the world are collecting more data than ever - about their customers, their sales and many other aspects of their business. With all of this data, though, the problem becomes how to analyze, make sense of it - and more importantly - make sound business decisions based on it. Business Intelligence tools have increased in popularity in the last few years to help companies do just that. One of the tools that is particularly popular currently is Tableau. Tableau offers five products currently: Tableau Desktop (both Personal and Professional Editions), Tableau Server, Tableau [...]
https://youtu.be/jI5mOFZKsZ0 In this free tutorial, you'll learn about the new templates that come with Adobe Photoshop CC 2017 that can make starting a web, photo or print project easier and faster. For more Photoshop training visit our Photoshop Training page.
https://youtu.be/Jm5IjiDEhpo In this free tutorial, you'll learn about the new settings to control individual (left/right) eyes using the Face-Aware Liquify tool in Adobe Photoshop CC 2017. Learn more about Photoshop in our Photoshop training courses.
https://youtu.be/UnFSgNTtDG8 In this Adobe InDesign tutorial you'll learn how to merge multiple image files into Adobe InDesign to create form letters, postcards or other custom InDesign documents that use custom images for each page in the document. To learn more, visit our InDesign Training Course page to see our InDesign Training classes.
QlikView is without a doubt one of my most favorite programs to teach. The capabilities for modeling and visualizing data are just amazing. But for all of QlikView’s shine and wonder, it’s not without its shortcomings. I really shouldn’t say “shortcomings”, but there are a few areas that could use a bit of improvement. Take, for instance, moving objects around the report space. Normally, an object possesses a title bar (or “caption”, as QlikView likes to call it) and you can simply click and hold the caption bar and move the object. The problem arises when a designer hides the caption [...]
With so many features packed inside each Microsoft application, it’s easy to overlook some that can really add value to your daily workflow. Below is a list of some of the features you may have never noticed but will quickly become part of your daily routine. Styles Styles are not only a great time-saver, but they form the basis of a variety of other Word features. Styles allow you to assign in bulk a variety of different formatting attributes, like font size, style, color, alignment, line spacing, borders, shades, indentation, etc… The list is quite voluminous. Once styles are applied to [...]
If you’re used to changing the way currency values are displayed in Excel, you might want to exercise the same choices when viewing costs in Microsoft Project. Although changing the look of costs can be done in Project, it’s not as immediately obvious as to how. […]
We spend so much time trying to make things run as quickly and efficiently as possible, but sometimes we just can’t help ourselves when it comes to self-promotion. QlikView loves making things go fast; starting QlikView is another story. As if we were unaware that we had elected to launch QlikView, a several second “commercial” in the form of a splash screen has to tell us that we are one of the lucky ones. As much as I enjoy using QlikView, I find the startup splash screen to be a bit of a nuisance. The good news is, there is a [...]
One of the most asked questions of beginning, and sometimes seasoned, pivot table users is “How do I hide the entries in a pivot table whose totals equal zero?” On first blush, this seems like an easy feat, but users quickly discover that it’s not as easy as predicted. There are ways to sort the source data and then exclude the entries with zero values, but that task of sorting and filtering the source data would have to be performed each time the source data is updated. This is not an appealing prospect. There is actually a very easy way to [...]
Suppose you want to display a list of items in a text object and you want that list to appear as a bulleted list. If your list is hard coded (i.e. USA, Canada, Mexico), then you could simply type the character that represents a bullet, like an asterisk, and have your list in no time flat. Our example will have a bit of static text at the beginning followed by the bullet list. The static text will read as follows: “Last Year’s Sales and Suppliers for” We will follow up the text with a carriage return to ensure the bullet list [...]
When working with tasks in a project, it is common practice to display a duration as an estimate. Displaying an estimated duration prepares the viewer for possible changes in scheduling. An estimated duration takes the form of a question mark placed after the declared duration. The issue is that some project viewers fail to notice the question mark; then when durations are updated, project viewers wonder why things have changed. One way to ensure that people’s attention is drawn to the estimated durations is to change the color of the Gantt bars to reflect an estimated status. There is no built-in [...]
When adding an expression to a list box, one of the common complaints is that the numbers displayed are devoid of any number formatting. This is especially frustrating when displaying large numbers without commas to ease readability. What most beginning report developers try is to format the values with the Number tools in the list box’s properties. […]
If you are an Excel user who likes to create charts, design dashboards, or just likes to play with neat toys in Excel, this tutorial is going to be right up your alley. Excel contains (in a super-secret place) a hidden camera. “But why would I need a hidden camera in a spreadsheet program?” I’m glad you asked. If you have ever created a chart on one sheet, but you need the chard displayed simultaneously on a different sheet, and you don’t want to make two of the same thing, the camera tool will solve this problem. First thing’s first; we [...]
Keyboard shortcuts are a great way to improve the speed at which documents are built, regardless of the application. It seems like there is a keyboard shortcut for just about every feature Excel contains; and there may be that one guru in the office that knows them all. But most of us fall somewhere between Guru and Labrador retriever (hopefully, closer to the former.) The good news is that it’s not an “all or nothing” proposition when it comes to keyboard shortcuts. Knowing just a few of the most productive keyboard shortcuts will serve you far better than knowing none at [...]
While developing a report, you may be loading thousands if not millions of records during the execution of your script. If you are making edits to your script, and require a reload of the data to test your script changes, you may find yourself spending more time waiting than actually developing. If a sample of the data is sufficient for testing purposes, you can limit the number of records returned by using the FIRST prefix. The FIRST prefix is placed directly before the LOAD statement in the script followed by the number of records you wish to load. For example: [Main Table]: FIRST 10000 [...]
Because QVD files load SO MUCH FASTER than the original data sources (i.e. Excel, Access, TXT, etc...), you may wish to save all of your tables to QVD files. There are a couple compelling reasons to do this: You wish to develop your report in an offline state while retaining access to a relatively recent copy of the data. You wish to save all of your dimensional tables for reuse by other reports, and you want those tables to be optimized for fast reloads. To accomplish this task, perform the follow steps: 1. Add a sheet to your script and give [...]
https://youtu.be/1JZKsmZjDiU In this tutorial, you'll see how to arrange windows on the desktop side-by-side using the Windows snap feature. You'll also see how to split windows across your screen when using multiple monitors.
https://youtu.be/Qg6sDPqke0g In this tutorial, you'll see how to subtract two dates from one another in Microsoft Excel using the DATEDIF function. The DATEDIF function allows you to calculate the difference between two dates and return a variety of values, including days, weeks, months or years. Learn more about Excel in our Microsoft Excel Training classes.
https://youtu.be/5a3j9-nvDf0 In this tutorial, you'll see how to create a report in Crystal Reports using data from an excel worksheet. This video will demonstrate the different methods for connecting to Microsoft Excel data from Crystal Reports and covers using both Excel 2003 and prior as well as Excel 2007, Excel 2010 and Excel 2013. For more Crystal Reports training see our Crystal Reports Training classes.
It’s every chart maker’s dream to have dynamically changing titles (well, that and a coffee table that looks like a giant floppy disk. Seriously; Google that one if you haven’t seen it. It’s pretty cool.) Any-hoo… To have a chart’s title change based on data you are, or are not, filtering by is a real boon to understanding the story that the chart is trying to tell. Take the following example: The reader of the chart can look at survey data for four categories all at once as a combined assessment, or they can filter by a specific category and evaluate [...]
When applying a template to a report, it’s often preferred to “peek” inside the template to see what it has to offer prior to applying it to your report; to “take it for a test drive”, as it were. If you have a vast template library, and many templates are similarly named, it can be of great benefit to see a preview of what you will receive if applied. The Template Expert provides just such a preview. For those who prefer to create their own templates, and possibly add them to the library, the preview feature may not display if certain [...]
If you are creating a list of choices for a parameter drop-down list, you can acquire the choices from several sources: Manually enter the choices in the list (static and least exciting of all of the options) Append a unique list of choices derived from a field in the database (static) Point to a database field for available existing choices (dynamic) Import items from a text file (static) Each of the options has their pros and cons. If you are trying to generate a list that is unlikely to change (like a list of states in the USA) and you need [...]
Suppose you want your QlikView report to automatically reload its data based on a schedule. The manual process would be for you to open the report, click the RELOAD button, and then close the file. If you team up the QlikView report with the Windows Scheduler, you can have this reload take place without human intervention. Step 1 – Create a Batch File Open Notepad and enter the following text: — For users running the 64bit edition of QlikView — “C:\Program Files\QlikView\QV.EXE” /R “C:\MyQVData\MyQVFile.qvw” — For users running the 32bit edition of QlikView — “C:\Program Files (x86)\QlikView\QV.EXE” /R “C:\MyQVData\MyQVFile.qvw” (Change “C:\MyQVData\MyQVFile.qvw” [...]
Crystal Reports uses a three-pass reporting method to generate reports. A pass is a process that Crystal Reports uses each time the data is read and manipulated. Depending on the complexity of the report Crystal Reports may make 1, 2, or 3 passes over the data. This feature allows for complex reporting and formula manipulation. […]
Script Editor <F5> or <Ctrl> + R Runs load script <CTRL> + <Shift> + R Partial reload <Ctrl> + T Shows model diagram <Ctrl> + E Opens table editor for LOAD INLINE statements (cursor should be placed inside statement) <Ctrl> + Q + Q Inserts script that generates several dummy tables <Ctrl> + K + C Comments blocks of script <Ctrl> + K + U Uncomments blocks of script <Ctrl> + F Allows search within the script in the debugger window […]
If you have ever looked for the watermark feature in Crystal Reports, you no doubt walked away smothered in soul-crushing despair wondering how Life could be so cruel. True, there is no official tool in Crystal Reports that adds a watermark to a report, but that doesn’t mean it can’t be done. Adding a watermark just takes a bit of creativity and a handful of mouse click and keystrokes. The trick is to add a subsection and underlay the following sections in the report. The steps are as follows: […]
If there has ever been a more “You’ve got your chocolate in my peanut butter!” moment, it’s the blending of Conditional Formatting with the Subtotals tool in Excel. If you have ever used the Subtotals tool to group information you have probable been impressed with its ability to group data by some changing event (like States) and have those groups aggregated and then structured into a collapsible outline. Before Subtotals After Subtotals But the one shortfall when it comes to the Subtotals tool is that there are no built-in artistic styles that can be applied to give the list a bit [...]
The goal of every QlikView developer is to do as little work as possible. When you notice that you are writing the same instructions in multiple app scripts, the notion of re-use is a red flag that flies with great fervor. QlikView’s Include statement provide just such an ability. The advantages of re-using scripts between multiple apps has several advantages: Complex scripts can be used by multiple people with superficial knowledge of the script’s logic. Include files ensure business process consistency when performing similar actions across multiple apps. Include files expedite script maintenance because the script need only be updated once [...]