Online PC Support

OPS Technical Solutions : +1 315-226-4249


How to Create a Delete Action Query in Microsoft Access

Microsoft Access is a very useful tools that is used to modify, insert and delete records in database. If you are familiar with computer then creating a form is quite simple and pleasant experience.  MS Access also offers a very user friendly and intuitive environment for its users. Creating a database will be very easy if you are using MS access. You can create Delete Action query in MS Access, after creating this query you can automatically delete a group of records from one or several tables. If you are planning to throw a CD away, you can delete the entire database from the CD. Microsoft Acce4ss allows four types of queries and the delete action query is one of them.

In this article we will tell you how to create a delete action query. You just have to follow the instructions given below.


The first step is to open the MS Access, double click the icon on the desktop.


Now you will have to create a new query containing the tables you want to delete records from. You can delete records from table containing relationships also by this query.


Now you have to click the arrow beside query type from the query design view, after that click delete query. After clicking that query, you will see a new window with list of tables and a grid.


Next step is to locating the tables from which you want to delete records. To do so, just drag the asterisk from these tables to the design grid. After that, just drag the fields that you want to use to the design grid. To explain this step we can give you an example of the CD; if you want to delete all records for Country and Western Music from your CD collection, you might drag a field named Genre to the grid.


Now you will see the criteria cell, in the criteria cell, just type the criteria that you want to delete. Now next step is to open the view menu and in the view menu, select datasheet view to view the records that will be deleted.


After performing all the steps given above, just open the view menu and choose design view to return to the query. You can make any changes if needed.


Now to delete the records; you just have to click “run” on the toolbar. Before you exit try to save the settings you have done to the database.

After performing the steps given above, you will create a delete action query in MS Access. Delete action query is very helpful for deleting records in tables in database. Delete action is one of the queries in database like update and edit. While doing so, keep one point in mind like you can stop the query by pressing Ctrl+Brk. This command used by Windows users generally.

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 but if you are going to get a new games DVD which you have never tried then I don’t think that is a good idea. You might end up paying a good amount for the CD and finally you will discover that it was not worth buying. Before buying a new game one should always check the reviews of latest games online and should check if it matches your gaming style. In this post I will mention the names of 5 games which actually rated as poor based on the features, options and player reviews.

Ghostbusters: It is a comedy role playing game which is based on the film named Ghostbusters. This film was released in year 1984 and was a big success but the game hasn’t done well at all. This game is developed by Dandy Peterson, Lynn Willis and Greg Stafford. This game misses on the main intricacies and doesn’t help the player in getting apt to the game. The instruction levels are poor and even the graphics. It definitely is not a good choice to go for and has been rated poor in all time games history.

The Neverhood: The Neverhood is a 1996 PC CD Rom adventure video game developed by animator DougNapel and was released by DreamWorks Studios. This game features clay motion graphics and music scored by composer Terry Scott Taylor. It received nice reviews but it was not a commercial hit. In this game Klaymen is the protagonist and the game follows his adventures in The Neverhood. It is like solving puzzles and getting out of difficult situations in order to find the Neverhood’s mysteries. He is curious and cheerful being, he saves the creator of the Neverhood from his deep sleep and ruins evil klogg’s plan. It did not feature the previous releases like distinctive clay motion design techniques; the game is a variation on air hockey only played with guns instead of mallets.

Command & Conquer: Command & Conquer is also known as Tiberian Dawn. It is a 1995 real time strategy computer game created by Westwood Studios for MS DOS and Published by Virgin Interactive. Command &Conquer was the first of twelve games to date to be released under the Command & Conquer label including a prequel and five sequels. You can download this game by C & C franchise’s official website. In this game the player requires to construct a base and then acquire a flow of resources in order to find the ongoing production of different forces to assault and conquer the opponent’s base. It features about 50 different units and structures and all structures are available for the players to build a construction yard building which can either be already developed on the battlefield.

Wizard 8: It’s the 8 and final title in the wizardry series of computer role playing games by Sir-Tech, in this game player’s aim is to collect the three aircrafts mentioned in the story and to place each on its pedestal in the final zone. It allows mounting to the Cosmic Circle becoming a god. This game received generally good reviews but failed to increase the size of the franchise’s fan base. Wizard 8 has failed to attract much attention at its release.

No one Lives Forever: It is an action adventure hybrid stayed on the shops for months before people caught on about its level of freshness and fun. No one Lives Forever combines the humor and silly villains from 1960’s spy movies with tactical action played from a first person perspective. You can assume the role of Cate Archer The Operative, who has to take down a criminal organization with weapons, gadgets and mostly savior faire.

How to Play a CD or DVD in Windows Media Center

This article walks you through the steps to play a CD or a DVD in Windows Media Center. Windows Media Center became one of the popular softwares after it was added in the Ultimate and Home Premium editions of Windows Vista. After including it in Window Vista, Microsoft is now providing Windows Media Center, loaded with new and improved features, with other updated Window releases like Windows 7 Business and Enterprise editions.

You can use Windows Media Center to play not just data and audio CDs but also data and video DVDs. This includes both commercial DVDs and CDs you bought and DVDs and CDs that you burned yourself using CD/DVD burning software.

To Play a DVD

The basis requirement before you play a DVD is that you need to have a DVD drive and a suited DVD decoder. You need to install them on your computer before you can play DVD. When you install Windows Media Center (WMC) a compatible DVD decoder automatically installs with that on your computer.

Once you have fulfilled all the requirements, you can play a DVD through the following steps:

1. Place the DVD that you need to play in the DVD drive of your computer.

Note: The DVD main title menu should display automatically. If it does not, from the start menu, search and click on ‘TV + Movies’ and later select the ‘Play DVD’. You can even use the navigation buttons on the Windows Media Center remote control as an alternative if you do not want to use the computer mouse.

2. Once the DVD title menu opens, select the DVD that you want to play using the navigation buttons on the remote.

3. Select the Play button to play DVD.

4. If you wish to skip to the subsequent divisions on your DVD, you can use the ‘Next’ button on the transport controls on your remote or can move the computer mouse and select the ‘Next’ button.

5. If you wish to go back to the preceding division on your DVD, you can use the ‘Previous’ button on the transport controls on your remote or can move the computer mouse and select the ‘Previous’ button.

6. Use the ‘Stop’ button on the transport controls on your remote to stop the DVD or move the mouse and select the ‘Stop’ button.

To Play an Audio CD

1. Place the audio CD in the CD ROM drive on your computer.

Once computer starts to read the audio CD, it starts to play.

2. You can use the ‘Next’ button from the transport controls on your remote to play the next track on the CD or use the computer mouse and select the ‘Next’ button.

3. If you wish to play a previous track on your CD, you can use the ‘Previous’ button on the transport controls on your remote or move computer mouse and select the ‘Previous’ button.

4. You can select the View Queue, if you want to view all tracks on the CD.

5. If you wish to change the playback order of the CD, select the Shuffle, Repeat, or select both Shuffle and Repeat buttons.

6. To stop audio CD from playing, press the ‘Stop’ button from the on the transport controls on your remote or move the mouse and then select the ‘Stop’ button.

How to Burn DVD Without Any Paid Software

With amounts of information, needed for normal computer operation, being so big, and growing every day your HDD becomes full in no time. With every game nowadays bigger than 5GB and HD movie collections reaching 100GB, even modern terabyte disk can be overrun in no time. If information is not valuable to you, solution is easy – put it into the Recycle bin. But What if you want to keep it? Well, then you burn it on either CD (for small amounts of data – up to 700MB), or DVD (more than 4GB or more than 8GB, depending on what DVD you have bought). Few years ago, you would have to buy additional software to have full control over what to write and how to write it on the disk. Now, if you have Windows 7 – you don’t need anything else.

How to burn a disk using Live File System (LFS)

There are two standards supported by Windows 7. The live file system disk can be played on computers running Windows XP or later, and some more advanced consumer electronics devices. Its compatibility is not guaranteed, but as it is faster to burn, it is still good for data backups of any type of files, that you will use only on PC. It is simple to backup to DVD using this FS. When you insert the blank disk, Windows Explorer will pop up so called “AutoPlay” dialog. Click on “Burn Files to disk using Windows Explorer”, write your title. Select “Like a USB flash drive” – this selects LFS for burning, and then, after the disk format is completed, you will be taken to a window where you can put your files. Simply copy them to the empty windows the normal way you copy files using Windows Explorer. This completes the operation – yes, it is as simple as that. You may need to close the session after writing is finished – check our site for short how-to on that.

How to burn a disk using Mastered Format file system (MFFS)

MFFS has one main advantage over LFS – disks written using it, are playable on every standard DVD or CD player, as they comply with international standards set for such disks. It must be written all at once, you can not add files once you finish burning, but if you need disk that will surely work on a DVD player – this is your choice. Operations to write in MFFS are exactly the same as in previous mode, except that you must choose “With a CD/DVD player” instead of “Like USB flash drive” in mode selection box. You are then presented with the same empty Explorer window – copy and paste your files as normal. Bear in mind that you can not use this disk to write additional files once burn process is completed, so plan your burn and put everything you need written on this disk.

How to Restore Files from a Backup

Losing vital data from the personal computers due to hacks or virus attacks is one common fear that torments every computer user. Saving all your data, during such attacks is the main criterion that every computer user looks up to. As a result, it gets extremely essential to take the back up of all your files, programs and system settings. Well, all you really need to do is simply create the system image (the exact copy of your desired drive) which mainly contains the copies of Windows, files, programs and system settings. This system image is then after stored separately in a distinctive location, away from your original files, programs and system settings. Well, in order to restore all your lost content, you can simply use this system image which contains the back up of all your essential data.

In case your system uses the Windows Backup system for taking the back up of all your vital files, you can also create a system image every time your back up is taken. These back up files can be then saved in a CD, DVD, USB flash drive or in a hard drive. However by default, the system image, takes the back up of only the drive within which the Windows system is installed. Well, you can also take the back up of the other drives manually, in order to save all your data. Follow the steps below in order to take the back up of all the other drives in your computer.

Taking the back up of all your essential settings, files and programs

Click on the Start button and then open the Control Panel.  Now click on the System and Maintenance option which includes the Backup and Restore option within. Open the Backup and Restore option.
Click on the Create a System Image option provided in the left pane. Now follow the steps as provided within the wizard. If you are asked for a confirmation or administrator password, simply offer back the needed details.Saving the different versions of all the System Images.

Every time you take a system image for the desired drives, you will be saving them in a different version. Well, you can save these system images in your external hard drives, internal drives, CDs, DVDs, etc. Also, in case if your drive runs short of enough space for storing the new system image, then it automatically deletes the older system images.

You can also store your system images in your network location. However, you can only store the latest system image of your computer in your network location. Usually, these system images are stored in the given format: drive\WindowsImageBackup\computer name\. Well, every time you take the system image for your computer, it will over write the previous version. But if you want to save the existing image and also create a new system image, you simply need to do copy the previous one into a different location using the following steps.

How to Create a System Repair Disc

A System repair disc does not come with the computer or Windows 7, however the CD image might have been saved somewhere in the system. The users are expected to burn a CD so that they are equipped with external resource for system recovery just in case. An external system recovery tool, such as the system repair CD is just like a last line of defense, when everything seems to go wrong the recovery disc could be the last man standing.

Importance of a system repair CD

Computer systems are very fragile, regardless of the make and brand, as the minute changes to the system files could make or break the entire system. This is why troubleshooting utilities and recovery tools are equally important aspects of system maintenance. Having a System repair disc becomes invaluable only when the system fails. But it might be just a bit late to recognize the importance of a system repair disc.

It’s only a matter of minutes

How long does it take to create a System recovery disc, most would agree that, not more than few minutes. ‘Create a system repair disc’ link is given at the left pane of the ‘Backup and restore’ page under the ‘System and Maintenance option in the main control panel. Administrator password might be required to proceed, but the overall CD burning process does not take long. If the guidelines for creating the repair CD are not followed properly, the whole exercise may look complicated.

Is Windows 7 installation disc required?

There may be instances where the system may require insertion of Windows 7 installation CD. This is because the system does not have the necessary data to be written onto the System repair disc. If such message is prompted at the click of ‘create a system repair disc’ link, there is no other way around but to insert a Windows 7 installation disc.

How useful is a System Repair CD

System repair CD is not something to be used day in, day out. In fact the less usage the disc is consider as a best alternative, as it will only be used upon critical system failures. If unfortunately such failures occur, a system repair CD might turn to be the last hope. So having a system recovery disc is always useful, especially when there are no other external means of system recovery.

Ease of recovery using the disc

Recovery process from a system repair disc is quite straightforward; it’s no more than just inserting the disc and restarting the computer. However the computer has to be configured to boot from the disc with BIOS settings.
Everything from creating a repair disc to using it in critical situations has been made easy on latest Windows systems. It’s just about following simple instructions. Nevertheless creating a system repair disc or a recovery procedure from such a CD should never be taken lightly.

Call Now: +1 315-226-4249
Call Now: +1 315-226-4249
Call Now: +1 315-226-4249