iYogi

Home » Technology

Technology

How to Tune Up Windows Aero Glass

Microsoft really has gone too ahead of others in Windows Vista and Windows 7 by releasing the new Aero theme. Though this theme requires special configuration but it really is an eye candy for its users. You definitely can tease other users who do not have such theme or if their computer cannot support the Aero. The glossy look introduced by Microsoft as Aero has been adopted by many afterwards. This... Read More »

How To Create a MS Outlook Email From MS Excel

Microsoft Outlook is a personal information manager from Microsoft, which is available both as a separate application as well as a part of the Microsoft Office suite. The current version recently launched by Microsoft is Microsoft Outlook 2010 for Windows and 2011 for Mac. Although often used mainly as an e-mail application, it also includes few features which are not known much, such as a calendar,... Read More »

How To Use AutoSum in Microsoft Excel

The AutoSum function in Excel quickly calculates the total of a row or column of numbers and saves you from entering a formula manually. The AutoSum is very helpful in performing simple calculations. It saves a lot of time as well as from the complications that you may end up with. The following are the simple steps that you need to use AutoSum in Microsoft Excel. Microsoft excel is a spreadsheet... Read More »

How to do a Fast Fourier Transform (FFT) in Microsoft Excel

Fast Fourier Transform (FFT) is the easiest way to show the dominant frequencies in a signal. FFT is an efficient algorithm to compute the discrete Fourier Transform and in its inverse. There are many distinct FFT algorithms which involves a wide range of mathematics, which starts from simple complex-number arithmetic to group theory and number theory too. You also need Microsoft Excel with the Data... Read More »
Tags: , , , 9,288 views

How to Review the System Security Needs of a Computer

In order to go ahead with this topic one must be aware of the concepts of what computer security actually is? In simple terms Computer Security can be termed as the branch of computer technology which is applied to computers and networks. It is a collective process and mechanism to protect a system from unauthorized access. The main objective of computer security is to protect the information and... Read More »

How to Manually Remove Antivirus System Pro

Antivirus System Pro is a new innovative malware program by the hackers which make out itself as an antivirus program. It gets downloaded automatically with the open of various websites or from click on the pop-out ads of various websites and then ensue a fake scan on your PC. Once done the program gets access to your PC it will automatically start up with the start of the Window and will radically... Read More »

How to Get Free Antivirus for MacOS

Apple Inc. (formerly Apple Computer, Inc) developed a series of graphical user interface based Operating Systems for their Macintosh systems and named it Mac OS. Macintosh user’s experiences a high level of graphical user interface. Mac OS was first introduced in 1984 as system software. Mac OS is categorized into two families – Apple’s own code based Mac OS family and UNIX based Mac OS X operating... Read More »

How to Choose a Computer Network Hub

Hub is a device through which multiple computers can be connected on a network and can share information. It connects computers and as well as other devices like printer, scanner etc on a local area client/server network. Cable is the means to connect the network cards of each device one wants to connect to the ports on the hub. Different types of Hubs are available in the market, out of which Ethernet... Read More »
Tags: , , , , 645 views

How to Make a Histogram in Microsoft Excel

Microsoft Excel is used for financial matters has got all the functionalities needed for financial, accounting as well as statistical functions there by giving flexibility to the users to solve out any financial terms. Whether be it calculations, documentations or presentations, it’s a solution to all factors related to finance. It can generate pie diagram, bar diagram, histogram and many more.... Read More »

4 Tips to Connect Your Phone With Your PC

If you synchronize your phone with you PC then it is going to be the best way to transfer information, settings, and files. You can have all of them up to date and can access it at home and at work to. Maintain Your Appointments It sometime happens that you have made an appointment in your PC but have not synced it with your hone and so you missed it. You are sometime outside your home and have entered... Read More »

How To View Microsoft Access Relationships With the Relationship Builder

It’s really very confusing to keep track of many relationships that might occur in a very large database. Relationship in MS Access terms can be defined as one table being used in multiple tables in a database having common fields in more than one table which can involve primary and foreign key. Through Relationship builder you can have the clear picture of how the relationships between the tables... Read More »

How To Create MS Access Report by Selecting Indv Record

Microsoft Access is a part of Microsoft Office Suite and is available in the professional and higher editions of Office. The latest version of Microsoft Access is Access 2010 and this was released as an application in the new Office 2010 Suit in May 2010. Access has been the first choice for keeping databases and information for quite some time now and it serves as the backend of many database applications.... Read More »

How To Set or Change the Primary Key in a Microsoft Access Database

Primary key of a relational table is that key which identifies each and every record in a table uniquely. It can be either a normal attribute whose uniqueness is taken for guaranteed like SSN (Social Security Number) etc or can be generated or made available by the DBMS (Database Management System) like GUID (Globally Unique Identifier) in Microsoft SQL Server. It may consist of a single as well as... Read More »

How to Define a Many-to-Many Relationship in Microsoft Access

In a “many to many” relationship, you can record data in table, that can relate to many records in the other table. The following are the simple steps that are to be followed to establish a many to many relationship in Microsoft access. Microsoft Office Access, earlier known as Microsoft Access, is a pseudo-relational database management system from Microsoft that combines the relational Microsoft... Read More »

How to Inter Connect Your Computers Through a Network

Before we go into the details of networking we should first understand why it is important to have a network between the computers at home and what all devices and peripherals are required to set up the network. In simplest terms Network is connecting two or more computers together so that they can share data among each other and also access the shared resources on the network. Example of data can... Read More »
Tags: , , , , 438 views

Download Microsoft Security Essentials 1.0

Microsoft Security Essentials is freely downloadable software from Microsoft. It provides a real-time protection for Home PC’s against the virus, spyware and other malicious software. Microsoft Security Essentials 1.0 has a modified easy-to-use interface, but scan speed is less as the earlier versions. When it comes to detecting a malware, it can’t keep track with the newer antivirus product.... Read More »

Download-Emsisoft Emergency Kit 1.0.0.22

Cyber world is in continuous threat with increasing virus attacks and hackers. There are number of virus and malware roaming on internet and trying to enter into any network or computer. It can come into your computer through any medium like a floppy drive, CD Drive, Pen drive, email etc. So you should be very careful while using such sources. The best way is to keep an antivirus application on your... Read More »

8 Tips for Computer Management at Work

You all use a computer at work and you may take it at home and you might even have a pictures of your loved ones on the computer desktop, the computer though is not yours, it’s important to realize that your company owns that computer, they have the right to install patches and updates on a regular basis, by doing so they can make sure your computer and the network run as smoothly as possible. In... Read More »

How to enable conference calls in Windows Phone 7

Smartphone is a new age gadget with lots of useful features and functions. Earlier this gadget was related to corporate and professional world where they had to use the various functions like net meeting, mail and other functions but in recent times Smartphone has reached the masses.  Microsoft has entered into the Smartphone market with Windows mobile and they re-branded the venture with Windows... Read More »

How to Remove Lines in a MS Access Repor

In the Microsoft Access, report lines are included when the Access report wizard utility is used to generate the report. If the report wizard is used it is faster than the manual report design, however you can also create the reports manually. The access reports can be created more efficiently through the report wizard but even the Access report wizard inserts lines and cannot be instructed to omit... Read More »
Tags: , , , 1,846 views

How to Disable Norton’s System Works & Antivirus

Norton System Works is a discontinued system utility suite by Symantec, it expanded the tools found from Norton Utilities but added other Symantec’s software titles, primarily antivirus and later backup software for the high end versions. Norton Protected Desktop Solution, it is an application suite built similar to Norton System Works but includes different set of tools to enable support of DOS,... Read More »

How to Set Up Antivirus for Windows XP

The need for the best antivirus for Windows XP is complicated because with the widespread use of Windows based machines in the world, it is no surprise that there are so many computer virus threats reported for this operating system on an alarmingly regular basis, it is a known fact that computer viruses are created primarily to affect Windows users since there just so many of them. If you want to... Read More »

How to Create a Microsoft Access Field for Hyperlinks

MS Access stores all database tablets, queries, reports, forms, macros and modules in the Access Jet database as a simple file. For query development MS Access offers a Query Designer a graphical user interface that allows users to build queries without knowledge of the SQL programming language, in the Query Designer users can show the data sources of the query and select the field  they want returned... Read More »
Tags: , , , , 533 views

How to Spot XP Antivirus(virus) on Your Computer

Windows XP is an operating system that was created by Microsoft for use on personal computers, including Home and Business Desktops, laptops and media centers, MS XP was released in August 2001 and it is the most famous version of Microsoft Windows, it’s based on installed user base, the name XP is short for experience. Windows XP was the substitution to both Windows 2000 and Windows Me and it was... Read More »

How to Set up a Wireless Network

Nowadays setting up a wireless network within home/small organizations have become the preference of almost all the people. The reason behind this likings is wireless network allow them flexibility to work on their laptops in their comfortable place/position within the range of the wireless network. It also cut cost any less messy as compared to wired networks. But only likings is not enough, coz... Read More »