Lomonox

What is Query MS ACCESS

All of the queries that you have created to this point have been variations of “select” queries. Select que-ries are used to display data but do not actually change the data in any way.

Queries, in contrast, are used to change the data in existing tables or make new tables based on the querys results set. The primary advantage of action queries is that they allow you to modify a large number of records without having to write Visual Basic programs. Access provides four different types of action que-ries:

1. Make table— creates a new table based on the results set of the query;
2. Append— similar to a make-table query, except that the results set of the query is appended to an existing table;
3. Update— allows the values of one or more fields in the result set to be modified; and,
4. Delete— deletes all the records in the results set from the underlying table.

Go to link Download

Tutorial Access your SamrtPhone Anywhere in the World

Every now and then we all need help and support from our friends or technical persons and for this we need to give them access to our computer or laptop.

Go to link Download

Vista to Windows 7 Upgrades Kill Access to OEM Recovery Applications

Users that upgrade Windows Vista OEM computers to Windows 7 might find that the recovery applications set in place by the original equipment manufacturer are no longer accessible.

This scenario is valid for some OEM machines that were acquired with Windows Vista pre-installed, the Redmond company explained. OEMs, in certain cases, will preload the Windows Recovery Environment inside the operating system. In this regard, users would be able to benefit from the System Recovery Options right in the graphical user interface (UI) and help topics.

“You have a computer that is preinstalled with Windows Vista by the computer manufacturer. After you upgrade from Windows Vista to Windows 7 on this computer, you notice that manufacturer-specific recovery applications are no longer available on the System Recovery Options menu,” Microsoft explained.

It is not uncommon for OEMs to customize the System Recovery Options. Original Equipment Manufacturers will in fact tailor Windows platforms to their specific needs, and always present custom build copies of the operating system along with their new computers. In this context, the Windows RE tools are customized in accordance with different OEMs. Customers will only be aware of the fact that Windows will come with manufacturer-specific recovery applications included by default. The general rule is that the apps will be offered through the Windows RE tools menu.

Upgrading from Windows Vista to Windows 7 is an action capable of cutting off access to OEM recovery apps. “When these systems are upgraded to Windows 7, the manufacturer-preloaded Windows RE option will be replaced with a Windows 7-compatible Windows RE,” the software giant added.

There is no hot fix or update from Microsoft to resolve this issue. The Redmond company only recommends that in order “to obtain the manufacturer-specific recovery applications for Windows 7, contact your computer manufacturer.”

Via : SOFTPEDIA

Go to link Download