Online PC Support

OPS Technical Solutions : +1(833)-522-1003


How to Create a Microsoft Access Field for Notes and Text

Microsoft Office is an office suite of inter related desktop applications, servers and different services for The Microsoft Windows and Mac OS X operating systems, its introduced by Microsoft in 1989, initially a marketing term for a bundled set of applications the first version of Office contained Microsoft Word, Microsoft Excel and Microsoft PowerPoint, over the years MS Office applications have grown substantially closer with shared features and then in 1993 the Microsoft Office Professional was released which added Microsoft Access 1.1 and then Microsoft Access v2 as, Microsoft Windows v3.1 with 4 MB of Ram required, 6 MB Ram recommended, 8 MB of available hard disk space required, 14 MB hard disk space recommended the product shipped on seven 1.44 MB diskettes the manual shows a 1993 copyright date.

Originally this software worked well with relatively small databases but testing showed that some circumstances caused data corruption for example file sizes over 10 MB proved problematic and the getting started manual warns about a number of circumstances where obsolete device drivers or incorrect configurations can cause data loss, with the phasing out of Windows 95, 98 and ME improved network reliability and Microsoft having released 8 service packs for the Jet Database Engine the reliability of Access databases has been improved and it supports both more data and a larger number of users.

With Microsoft Office 95, MS Access 7 became part of the Microsoft Office Professional Suite, joining Microsoft Excel, Word and PowerPoint and transitioning from Access Basic to Visual Basic for applications since then Microsoft has released new versions of Microsoft Access with each release of Microsoft Office, this includes Access 97, Access 2000, Access 2002, and Access 2003. Access 2007 and now Access 2010, the most significant transition was from the Access 97 to the Access 2000 format which is not backward compatible with earlier versions of Access at the time of this writing all newer versions of MS Access support the Access 2000 format, new features were added to the Access 2002 format which can be used by Access 2002, 2003, 2007 and 2010.

To create a Microsoft Access Field for Notes and Text you can follow below steps

Step 1:

Firstly open your table in design view then click in the row directly below the field where you want to position your new field.

Step 2:

You can now click on the Insert row icon from the toolbar or you can use Insert row from the Insert menu then a new row appears

Step 3:

When a new row appears, then name your field and click in the Data Type column immediately to the right after that you will see an arrow appears

Step 4:

After an arrow appears just click on the arrow and a menu or datatypes appears, now just select Text and you can save your table.

This article will help you to create a Microsoft Access Field for Notes and Text.

Microsoft: 240 million copies of Windows 7 sold

In its first year, Microsoft’s Windows 7 has sold more than 240 million copies, thereby making it the fastest selling operating system and helping the software giant in recording profits despite the recent dip in the sales growth of computers.

Despite the fact that Apple Inc’s OS X and Linux based operating systems have won some market share in the past few years, Microsoft still controls almost 90 per cent of the world’s 1.4 billion personal computers, and is now expecting more and more customers to upgrade to Windows 7.

Microsoft’s most lucrative customers, which are about 89 per cent of companies, are planning to use Windows 7, according to Tami Reller, chief financial officer of Microsoft’s Windows unit. In adopting new operating systems, companies tend to lag behind consumers as they have to go through more testing to make sure that they mesh with the existing software.

In the last fiscal year, Microsoft had reported record sales of $62.5 billion, which was a 7.5% increase from the previous year, majorly powered by Windows. Providing more than one-fourth of overall sales and just over half of its profit, the Windows unit is still Microsoft’s core.

In the next few days, Microsoft is expected to report higher fiscal first quarter earnings, but Windows sales (that closely track PC sales) may disappoint investors to some degree.

According to a research from IDC, PC Sales rose only by 11 per cent in the July to September period, as compared to the statistical figure of 22 percent in the three months before that. This was so because back to school shoppers appeared to hold off on big purchases.

Despite these numbers, there is no denying that the new Windows 7 operating system is a huge hit, and it looks set to continue Microsoft’s 90 per cent plus hold on the operating system market. Apart from that, its server and tools business, which sells the services and software that run companies’ computing systems, is now a giant in its own right, despite the profit margins being about half of those in the Windows unit.

Microsoft executives are of the opinion that the future is of cloud computing, which describes the provision of software, data storage and services over the internet.

This drastic change may be a potential threat to Microsoft, as it represents a shift away from software installed on computers towards a more fluid scenario. This in turn brings forth a valid point – why should one pay for and install MS Office when Google Docs can be used for free over the Internet?

How to Use Autofilter in MS Excel

Microsoft Excel or MS Excel as popularly known is a spreadsheet application by Microsoft for the operating systems of Windows and Mac OS X. It is normally used for making calculations, presenting numerical data, comparing trends and features of various tools to assist in these purposes. It is often considered the standard application for the spreadsheet software. Not only does it keep the users well organized in their presentation of facts and figures, it is a rather versatile application. Although understanding and learning every feature of the Excel application can be frustrating and intimidating, it does prove to be a boon in the long run.

Instructions to use Autofilter in MS Excel

One of the many important features of Excel is that of the Autofilter which is a very useful tool as it can take a vast spreadsheet and reduce it to only essential data. Following are the instructions to use this facility in MS Excel.

Step 1: Once you are finished with creating your data, look back at it to decide which rows or columns you want to sort out. These rows or columns need to be highlighted and then select the ‘Data’ option from the main menu. After clicking on ‘Data’, select ‘Filter’ from the options and click on ‘Autofilter’.

Step 2: Now in each title box, you would have drop down arrows. To filter your data according to that column, each of those arrows can be clicked. Everything that you would click on will become the only data visible.

Step 3: Now when you go to the required cell and click on the arrow on it, then click on the first option in the list in the ‘Autofilter’ column. This will result in displaying only that data which matches.

Step 4: The arrow in this cell would now be blue, which tells you that the spreadsheet has been filtered by that particular column’s data.

Step 5: Additional filters can now be applied. You can continue the same procedure with other title cells too, and get only that data which is required. All the arrows would change their color to blue, indicating the filtered data.

Step 6: After the filters have been applied, you can now go back to the original data by removing all the autofilters. One way to remove them is to go back to the ‘Data’ option, click on the ‘Filter’ option and remove the check mark by clicking on ‘Autofilter’. This would remove the check boxes and restore all the data. Another way to restore the data is by proceeding with one column at a time, by clicking on the arrow and selecting ‘All’.

An additional thing to be kept in mind is that even if the document is saved as filtered, the data hasn’t been lost. It has merely become invisible and can be restored anytime by following the last step above. The Autofilter option thus proves to be an extremely helpful tool in Excel which filters for only specific data that may otherwise result in wastage of time if searched manually.

How to Setup Apache SSL

Apache is basically an HTTP or a Web server which became one of the first web servers to obtain 100M website millstone. Apache is developed and maintained by open community under name known as Apache Software Foundation. The application is designed and compatible for multiple platforms like Unix, Linux, Novell Netware, Mac OS X, Microsoft Windows, etc.

Apache server is bundled up with various tools to make server management flexible and secure. SSL is a one protocol which is required to make any server more secure and robust.

Secure Socket Layer (SSL), has been widely used to secure web        transaction and browsing safer. You can’t even imagine that how many online transactions are monitored daily though SSL.

It is the most widely used protocol which offers privacy and security over client-server model. In the following section, I am going to discuss some basic steps to setup or configure SSL on Apache.

Before setting up SSL on Apache, you need make sure that have the latest version of Apache 2.0 source code. It is easily available on Apache web site.


The first ever step for installing SSL over Apache server is to install and configure Apache 2.0 web server and then create a user and a group with the name of ‘apache’. It is also very important to choose the appropriate Apache module for complete functionality of SSL. For SSL compatibility you need to enable mod_ssl and mod_setevnif modules to provide compatibility with Internet explorer.


Once the SSL configuration is done and required modules are enabled, you need to install Apache in the required directory.


After the server installation, you need to provide basic configuration as sample content. This step has to be performing before running Apace for the first time.

Make a sample web data as it will be utilized via SSL/TLS:

Example: make su umask 022 make install chown -R root:sys /usr/local/apache2

After this, you need to change the Apache configuration file, which is normally found under/usr/local/apache2/conf/httpd.conf, to a new configuration.

How to Reload Norton AntiVirus

Norton AntiVirus is a software developed and distributed by Symantec Corporation used to detect and remove malware and viruses from your computer for a period as long as you have a subscription. It has other features such as e-mail spam filtering and phishing protection.

You can find the product as a download, as a box copy, and as OEM software. You can run Norton AntiVirus either on Microsoft Windows or on Mac OS X.

It may be the case that you had to uninstall the Norton AntiVirus from your computer after it got infected by a virus or you had to clean up the C drive itself or a failure of hardware had occurred or you have upgraded your computer or purchased a new computer. Whatever be the reason, now the matter is that you want to reload it on your computer so that you can keep your computer protected from any malicious programs. No worry! You can do it for free in most cases.

Let me tell you how you can do it. Just follow the instructions given below and you will find that you can reload Norton Antivirus program very easily on your computer.

Step 1: First off all you need to remove any existing versions of Norton Antivirus from your computer; otherwise you will not be able to install Norton Antivirus on your computer. To uninstall any existing version of Norton Antivirus from your computer, press the Start button on the taskbar of your desktop. Select Control panel from the menu. Then choose Add/Remove Programs option from the list. A list of the programs installed on your computer will appear from which choose Norton Antivirus and highlight it by clicking. A Remove button listed beside Norton Antivirus will come. Clicking this button will start uninstalling Norton Antivirus from your computer. Follow the on screen instruction for a smooth removal of the program.

Step 2: you need to restart your computer after the Norton Antivirus removal is finished so that the changes may take effect.

Step 3: Now you will have to insert the product CD in the computer disk drive. If you do not have the product CD then you will have to download the installation files of the product from the Symantec website. Install the Norton Antivirus program on your computer by following the on screen instructions that will come during the installation process, just as you did it first time after purchasing the product. If you have installed Norton Antivirus on your computer by inserting the CD you will find the product key printed on the CD case. But, if you have purchased the product via the online store, you will find the product key in your online Norton account.

Step 4: Before the installation process starts a window will appear asking you for the product key. All you need to do is to enter the product activation key and follow the instructions until the installation process is completed.

Step 5: You will have to restart your computer.

How to intall Mac OS X along with Ubuntu?

If you want to use your desktop or laptop with DUAL operating systems like Ubuntu and Mac OS X then it is possible. You can install OS X with Ubuntu. It’s really good way to learn Ubuntu Linux OS and still be able to enjoy with a quick booting to OS X.

To install Ubuntu along with Mac OS X first get the latest version of Ubuntu from the Internet, which are freely available for everyone, as Ubuntu Linux is open source Operating System. Once you download the image burn it to a CD or disk using some disk utility softwares. If you burn the CD slowly then it will increases bootableness. Now you have Ubuntu CD with you, so you need to clean out your Mac PC.

Step1: Make enough free space on your Mac system for Ubuntu. You can use Boot Camp Assistant to create hard disk partition very easily, without erasing any of your data and applications. But still it is good practice to take back up of your data of your whole system either on CD/DVD drive or on USB pen drive. So, if in case any lose of data you can restore it easily. You can also add partitions using Leopard’s DiskUtility. So you can allocate the free space using such Linux tools for installing Ubuntu, but you can create real partition while installing Ubuntu on your Mac system. I you need to reinstall Mac OS X then it can be done with the help of Disk Utility from the Mac OS X itself to partition the disk and manually creating partition for Mac OS X. Leave some space unformatted.

Step 2: Now, before you start installation install the rEFT for synchronizing the partitions. If you can’t see rEFT booth menu after starting your Mac system, then it indicates that rEFT is not installed properly, so you have to reinstall it. Once Ubuntu is installed you can uninstall rEFT.

Step 3: Now, insert the Ubuntu CD into your computer and restart it. In rEFT menu choose to boot from Linux CD. When installer asks you for partition option, choose “Guided – use largest continuous Free Space” option.
Step 4: While creating partition just make sure that bootable partition is the first one and do not swap your data otherwise Mac system will try to booth from the swap partition.

Step 5: When you click on “Ready to install” it will start installation automatically. Once installation is done restart the system and then Sync the Master Boot Record.

Step 6: After this, shut down your Mac and restart after some time. Uninstall rEFT if you want, or you can use it to select the operating system each time, when system boots. And if you uninstall it then you can boot into Ubuntu with Mac’s native boot loader by holding the Option key at start-up and choosing the disk entitled “Windows”.

To access Ubuntu partition from Mac OSX, install “Mac OS X Ext2 Filesystem” and to access Mac partition from Ubuntu install hfsplus and hfsutils.

Enjoy Ubuntu on Mac OS X, dual operating system!!!

Call Now: +1 833-522-1003
Call Now: +1 833-522-1003
Call Now: +1 833-522-1003