E-MAIL

E-mail is the transmission of messages and files via a computer network.

An e-mail program allows you to create, send, receive, forward, store, print, and delete e-mail messages.

VLOOKUP Function in Microsoft Excel

VLOOKUP function

This article describes the formula syntax and usage of the VLOOKUP function in Microsoft Excel.

Description

You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. For example, suppose that you have a list of employees contained in the range A2:C10. The employees' ID numbers are stored in the first column of the range, as shown in the following illustration.

If you know the employee's ID number, you can use the VLOOKUP function to return either the department or the name of that employee. To obtain the name of employee number 38, you can use the formula =VLOOKUP(38, A2:C10, 3, FALSE). This formula searches for the value 38 in the first column of the range A2:C10, and then returns the value that is contained in the third column of the range and on the same row as the lookup value ("Axel Delgado").

The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.

Remarks

• When searching text values in the first column of table_array, ensure that the data in the first column of table_array does not contain leading spaces, trailing spaces, inconsistent use of straight ( ' or " ) and curly ( ‘ or “) quotation marks, or nonprinting characters. In these cases, VLOOKUP might return an incorrect or unexpected value.

• When searching number or date values, ensure that the data in the first column of table_array is not stored as text values. In this case, VLOOKUP might return an incorrect or unexpected value.
• If range_lookup is FALSE and lookup_value is text, you can use the wildcard characters — the question mark (?) and asterisk (*) — in lookup_value. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) preceding the character.

Source : http://office.microsoft.com/en-001/excel-help/vlookup-function-HP010343011.aspx

MICROSOFT ACCESS 2007 2010

Topics Covered :

• Create a table
• Queries
• Constructing Form
• Constructing reports and labels 

Part 1

Part 2

Part 3

Part 4

 

 

  

Adding Navigation in Access

 

 

 How to add SWITCHBOARD

 

 Adding Labels and Buttons

 

 

MATERIAL RELATED TO CLASS....

COMPUTER APPLICATION (EPPD1063)

What is a computer?

Hardware and Software

 

Hardware

 

Hardware refers to the physical elements of a computer. This is also sometime called the machinery or the equipment of the computer. Examples of hardware in a computer are the keyboard, the monitor, the mouse and the processing unit. However, most of a computer's hardware cannot be seen; in other words, it is not an external element of the computer, but rather an internal one, surrounded by the computer's casing (tower). A computer's hardware is comprised of many different parts, but perhaps the most important of these is the motherboard. The motherboard is made up of even more parts that power and control the computer.

In contrast to software, hardware is a physical entity. Hardware and software are interconnected, without software, the hardware of a computer would have no function. However, without the creation of hardware to perform tasks directed by software via the central processing unit, software would be useless. 

Hardware is limited to specifically designed tasks that are, taken independently, very simple. Software implements algorithms (problem solutions) that allow the computer to complete much more complex tasks.

 

Software

 

Software, commonly known as programs, consists of all the electronic instructions that tell the hardware how to perform a task. These instructions come from a software developer in the form that will be accepted by the platform (operating system + CPU) that they are based on. For example, a program that is designed for the Windows operating system will only work for that specific operating system. Compatibility of software will vary as the design of the software and the operating system differ. Software that is designed for Windows XP may experience a compatibility issue when running under Windows 2000 or NT.

Software is capable of performing many tasks, as opposed to hardware which only perform mechanical tasks that they are designed for. Software is the electronic instructions that tells the computer to perform a task. Practical computer systems divide software systems into two major classes:

• System software: Helps run computer hardware and computer system itself. System software includes operating systems, device drivers, diagnostic tools and more. System software is almost always pre-installed on your computer.
• Application software: Allows users to accomplish one or more tasks. Includes word processing, web browsing and almost any other task for which you might install software. (Some application software is pre-installed on most computer systems.)

Software is generally created (written) in a high-level programming language, one that is (more or less) readable by people. These high-level instructions are converted into "machine language" instructions, represented in binary code, before the hardware can "run the code". When you install software, it is generally already in this machine language, binary, form. 

Firmware

Firmware is a very specific, low-level program for the hardware that allows it to accomplish some specific task. Firmware programs are (relatively) permanent, i.e., difficult or impossible to change. From the higher-level view of software, firmware is just part of the hardware, although it provides some functionality beyond that of simple hardware. 

Firmware is part of devices (or device components) such as a video card, sound card, disk drive and even the motherboard. The AMIBIOS image to the right is from a Baby AT Motherboard. 

Link :

http://cs.sru.edu/~mullins/cpsc100book/module02_introduction/module02-03_introduction.html