A vertical Lookup or most commonly known as a VLOOKUP is one of the most popular Lookup functions. It will search vertically across row headings and return the information from that row that is being searched. Your lookup value MUST be in the leftmost column but it doesn’t necessarily have to be in Column A; it just must be the leftmost column of your table array. To find the column that has your search result, you simply start counting the columns in the table array from left to right! Continue Reading »
Are you getting tired on always grabbing the mouse when you are working in Excel? Especially, when the mouse just isn’t behaving – you know, sometimes you are just having a “bad mouse” day!
Well, even though Microsoft Excel 2010 seems very mouse driven, you can still use the keyboard to perform some of the actions that you need. I am sure that you are familiar with the old standards of Ctrl + N to get a new workbook, Ctrl + S to save a workbook, and Ctrl + O to open a workbook, just to name a few. Continue Reading »
To continue with the Edit Relationships Dialog box, the next area for discussion is the Cascade Updates section.
Continue Reading »
In one of my earlier blog posts about creating Relationships between tables, you saw the Edit Relationship Dialog Box. I want to take a moment to discuss this Edit Relationship Dialog Box in a little more detail. It did look like this.
Continue Reading »
Microsoft Access is a relational database system. That simply means that in the one file you can have multiple tables, forms, queries, and reports. It is pretty much like when you were back in junior high school and you kept all of your notes in a three-ringed binder with different sections for each of your individual classes. Access has a navigation pane on the left side that acts as a separator of each type of object. Continue Reading »
Microsoft PowerPoint 2010 has an awesome new way of displaying your pictures for any type of sales presentation. Everyone is aware of how images add to the presentation; as text alone won’t keep the audience’s attention anymore. We live in a very visual world. A picture is definitely worth a thousand words. But now, we have become complacent about the images that are in the presentations. They just seem to be the all the same. The image may change but it is still usually in the shape of a rectangle, the most common shape for jpegs. Is there something new we can do to improve our presentations and make them pop? Absolutely! In PowerPoint 2010, we can take an ordinary picture such as the one shown below and really make unique and interesting graphics. Let me show you how! Continue Reading »
In our databases we often want to be able to include relevant material with our records. For example, if you are in a health related field, you might want to include the latest information about a particular drug or the latest study about a particular medical ailment. Up to now, what you had to do was to either retype a short summary of the article or you could create a hyperlink data type to store the URL of the article on the web. In an employee database, you might want to also store the resumes with the applications. Now in Access 2010 and in Access 2007, you can use the new data type field of attachment to do this. This is where you can attach any type of file or multiple files to a particular record: a word document, an Excel worksheet, a chart, or an image to name a few. In the Employee table of your database, you may want to include the resumes of perspective employees. You can do this by simply adding the field of resume as an attachment data type in design view of your table. Continue Reading »
How many times have you had to create an expression on a form to place the name field? For good table design in previous versions of Access, you had one text field for last name and another text field for first name. But when you wanted to have the complete name in one field, you had to build a form and then create an unbound text box to place the concatenated field. Well, now in Access 2010 there is a new data type called calculated. And it does allow you to concatenate two fields that are in the same table into a new separate field that can be seen in the datasheet view. The only concession that it has is that the new field must be created based on two or more fields within the same table. Let me show you how easy it is to do that. Continue Reading »
With so much collaboration in today’s business world, we often assign two or more people to the same project. In previous versions of Access, you had to enter separate records for each person to that project. Not anymore! Access has now included a multivalue field in the database. Is it hard to set up? Not at all. For example, in your database you already have a table listing the employees. You will want to create a separate table for your projects. In this projects table, you will have the fields of Project Id, Project Name, Description, Due Date, and Employees.
Continue Reading »
How many times have you sat in meetings looking at a series of boring bulleted slides like the one below? After a while they all start to look the same. Isn’t there a way to make your bulleted slides more interesting, so that they help hold people’s interest for a little longer? Absolutely! In PowerPoint 2007 and PowerPoint 2010 there is a feature called SmartArt. It helps jazz up your PowerPoint presentation and can actually convey more information than you can get from a simple bulleted list. Continue Reading »