Technology - Part 7
iYogi

Home » Technology

Technology

How to Use a Microsoft Access Program

Microsoft Access is the database program which is included with Microsoft’s Office suite. Learning some basic steps will help you to begin to make databases, tables, reports, forms and queries. Once you become familiar with the program, you can start to learn advanced techniques, such as creating mail merges and many more. The following are the steps that you need to follow just to use Microsoft... Read More »

How to Add Figures in Microsoft Excel

With Excel you need not have to worry to add up several numbers of figures at a time. Move aside your calculator coz Excel has got tools which provides much easier way to perform mathematical operations rather than using a calculator. No matter if you don’t have any earlier experience and is new to Excel. All you have to do is to follow some very simple steps which will help you out in creating... Read More »
Tags: , , , 306 views

How to Create a Floating Bar Chart in Microsoft Excel 2003

Microsoft Excel is a spreadsheet program incorporated in the Microsoft Office suite that is used to collect and analyze data. One of the aspects of the data analysis is that this program can perform the automatic creation of graphs to see how various sets of data relate to each other. MS Excel has many standard graphs that can be selected depending on the relationships that you want to showcase.... Read More »

How to Cut & Paste From Excel to Microsoft Word

Microsoft Excel and Microsoft Word are programs which are created by Microsoft. Microsoft word was first released in 1983 under the name Multi-Tool Word for Xenix systems. . It is a component present in the Microsoft Office system. Not only this word is also sold as a standalone product and is also included in Microsoft Works Suite. Excel features a grid display with individual cells especially... Read More »

How to Restore Microsoft Excel to Its Defaults

When using Excel, you might sometimes throw off the settings and default template. Which means that no matter how often you close and reopen a new spreadsheet Excel is holding onto some of the previous settings? This sometimes becomes really annoying, especially when you’re trying your best to start a fresh spreadsheet and are used to the default settings. But to your rescue, restoring those... Read More »

How to Use JDBC to Connect to MS Excel

Java Database Connectivity or JDBC is a programming interface which is part of the Java programming language. It allows a software client to access databases or database-like files, such as spreadsheets, to conduct data retrieval and also storage in the database itself. The ability of JDBC to access formatted data such as spreadsheets comes from the ODBC (Open Database Connectivity) only which bridges... Read More »

Create a Make-Table Action Query in Microsoft Access

Microsoft Access is the database program which is incorporated with Microsoft’s Office suite. It is not as intuitive and user-friendly as the other Office programs, but Access offers a wide range of powerful features for creating databases and extracting data from them. Learning some basic steps will easily help you to begin to make databases, tables, reports, forms and queries and so on. Once... Read More »

How to Calculate a Present Value Using Microsoft Excel

It is one of the simplest tasks of calculating the present value of a potential investment using Microsoft excel. It just requires you to learn the syntax of the required formula and then follow the simple steps. In few steps you will be able to calculate the present value using Microsoft Excel easily and quickly. The following are the simple steps which you need to follow: Step 1: First you need... Read More »

How to Group and Outline Excel Data

Nowadays everywhere is computer even in our mobile phones and when you have to do work on computer the basic thing you need is Microsoft Office, In Microsoft Office and MS Excel is the main program which is important for all of us. Microsoft Excel is a very important program for our work in our jobs and business. There are different kinds of programs in MS Excel and you can use them for different... Read More »

How to Decide Which Datatype to Use in a Microsoft Access Table Field

By default, the datatype of Microsoft Access is Text. You can change it to other data types according to your needs but you should be aware of their properties and differences between them. The names of some of the datatypes are as: Text, number, currency, memo, date/time, Yes/No, hyperlink, OLE, Autonumber. Below are the descriptions of above mentioned datatypes, which will help you out to choose... Read More »

How to Manually Remove WinPro Antivirus 2007 Spyware

WinPro Antivirus 2007 is one of the spyware programs which get installed on the system may be for several reasons like-on click of a link of certain websites, Opening a spyware infected page etc. But once this spyware program is in your system it infects the system in a very speedy manner. So it’s better to remove this spyware program as soon as possible else you will be left with formatting the... Read More »

5 cool undervalued games

Gaming has gone to a completely new dimension. Earlier it was the two dimensional game Mario which gained huge popularity but gaming has gone through a long journey since then. Games coming now are not simply for playing but to feel the virtual world and be a part of it. Games these days are so addictive that people play them for hours and still don’t get bored. There are so many games in the market... Read More »

How to Create a Microsoft Access Field That Automatically Generates Numbers

Software applications have taken all the load of office tasks. Days are gone when people used to sit on noisy typewriters and do the work but now everything is replaced with computers. Now there is no need of huge file rooms or messy tables full of file and folders. You can save your tasks and important data in the hard drives of your computer or on the organizations server. No need to burn your eyes... Read More »

How to Group and Outline Data in Microsoft Excel 2003

Microsoft Excel has achieved the level of acceptance among users which cannot be shaken by any other spreadsheet application. You learn Excel the more you work on it. It is just like a new language. Just like we learn a new language by using it more and more, similarly the more we work on Excel the more we learn and we see the awesome features present in it. In this post I will discuss a feature called... Read More »
Tags: , , , 567 views

How to Add and Edit Comments Using Microsoft Excel 2000

Microsoft is in the market for years and has been catering to the computing needs at its best. It is the biggest developer of Operating Systems and numerous other useful applications. The most widely used office application in this world is Microsoft’s Office suit which consists of various applications used for Word editing, Spreadsheet calculations, Database management, Presentation etc. If we... Read More »

How to Delete MS Antivirus Security Center

Microsoft Security Essential is security software which is distributed with most of the Microsoft Windows operating systems free of cost. Currently it is being distributed with Windows XP, Windows Vista and Windows 7 operating system and it is not compatible with any of the older Windows operating systems. This can be termed as the replacement of Windows Live OneCare and it provides security from... Read More »

How to Build an Employee Database With Microsoft Access

Microsoft Access is software that helps Microsoft users to create and manage databases. Even without much computer experience it is relatively easy to use. It can even function as a very powerful small-database management tool with which you can do a great deal of database processing if you really want to learn how to program with it. Access also comes with options of templates that make getting started... Read More »

How to Insert a Picture, Graph or Microsoft Office Document into an Access Database

In an Access database you can insert a picture, sound, video file, and graph or Microsoft Office document. For that you must first create an OLE Object datatype field and then you will be able to insert your “objects” (sounds, pictures and so on) into the field. However these instructions apply only to MS Access 97. The following are the steps that you need to follow. Part 1: first you... Read More »

How to Avoid Unauthorized Deletion of Microsoft Excel Files

Microsoft is believed to be the most dominant as well as proving Office suites by the users as well as through the market point of view. One of the Products is Microsoft Excel that comes bundled with Microsoft Office and delivers an outstanding and promising performance with its flexibility, multitalented, adaptable and handy features. It can perform all type of tasks whether it is creating a company’s... Read More »

How to Install Antivirus Software on an Already Infected PC

Virus attack is the biggest threat in the cyber world now-a-days. It attaches itself with any file or mail and then makes multiple copies on your computer and spread over the internet. The major effect of a virus on your computer is the poor performance. Virus eats high amount of system resources and does let required applications to work properly. If the virus is more fatal then it can also lead... Read More »

Web Attacks can be Vital for Client Reputation

There has been a substantial increase in number of internet based attacks in recent time and most of these attacks are mainly launched prior to or during the ongoing litigation. Focus or target of such attacks is either to obtain crucial information for the lawsuit or to harm the competitor. To avoid detection and identification attackers use fake pages of free websites like Facebook or anonymous... Read More »
Tags: , , , , 278 views

How to Interpret Data Using MS Excel

MS Excel in one of the very powerful office application tools for data representation and interpretation. It is a spreadsheet application and gives us an organized way to manage data for all small and medium businesses. There are various in-built tools, like charts, graphs, tables, and calculation, present in MS Excel which helps us for data mining and processing in efficient manner. Using MS Excel,... Read More »

How to Network Computers Using a Hub

Network is a logical or physical arrangement of computer to share data and resources. We need to have some network devices to build a computer network and these devices can be anything like a router, switch or a hub. A hub is a device which is used to connect multiple computers in one network. The most common type of hub is an Ethernet hub. Here are some of the simple steps to make a network using... Read More »
Tags: , , , , , 617 views

How to Uninstall the Norton Antivirus Firewall

Symantec is a leading antivirus and security software manufacturer which has been providing computer and network security to home and business users for quite a long time. Symantec’s major security brand is known as Norton. Norton internet security is packaged software which comes with firewall and antivirus security. Firewall is basically a program which is used to monitor the networking and internet... Read More »

How to Remove Smart Antivirus

Smart Antivirus is a type of rogue spyware or a malicious program which infects your computer and work as Trojan on your computer. It is very important to remove this threat from your computer the moment it is detected. The main functionality of this program is that, it generates false security threat messages and pop-up messages on your computer and it also suggest and offer you to purchase Smart... Read More »