MS ACCESS as a tool in data comparison

MS ACCESS can be used to compare the data from two tables. This technique offers a solution for those who want to find content differences between two tables in excel, text or other file format. Using SQL Joins,  it will show record changes from one table to the other. New records that were added and old records that were deleted can be easily compared. In addition to comparing differences, there is another feature that will link the changes from your source data file.  

This can be done by following the steps below:

(1)     Open MS ACCESS (Start – All programs – Microsoft Office)

(2)     Click File à New à Blank Database

(3)     Upload the data/table in MS ACCESS by clicking TABLES à NEW

      

(4)     Choose Link Table if you want to link the changes from your external file table to MS Access database.

(5)     Click Queries à New. Then select from the options given. 

(6)     By choosing Design view, you can customize your query by filling up the table and changing the Join properties (View à Join Properties) or using an SQL statement (View à SQL View). The other four query wizard options can also be used.

 

(7)     Click Query à Run. Then save the Query.

(8)     You can also match a Query to a table and a Query to a Query.

Compare SAP ABAP Programs: Splitscreen Editor - SE39

For every revision in our program, we usually want to compare and observe the changes applied to the original program. Most of the time, or should I say as a best practice, we create a copy of the original program into a temporary program name. This will ensure that we do not mess up the original program for every revision that we are doing. Note that even a small change in the program can affect the whole system or subsystems connected to it.

Sometimes a running program is not enough basis for us to conclude that the program will run perfectly. With T-code SE39 - Splitscreen Editor you can display the source texts of two ABAP programs or two methods of ABAP classes next to each other or you can compare them. Changes in the program will be highlighted so we can easily recognize and decide if these changes are correct and necessary. Also, most programmers are inserting temporary codes in the program for the sake of doing a test analysis or proving something. Then at the end of coding, we usually forget to remove those unnecessary codes or “dead codes”. It may not affect the program itself but it can be a confusion to the next programmer who will read the codes. Using this Split Screen Editor, we can easily detect programs that are added to the original program.

To compare a program in the current system with one in another system, choose Compare different systems from the initial screen of the splitscreen editor. A field appears on the screen in which you can enter the RFC destination of the R/3 System containing the required program.

Information Technology Wizard: Unleash the storm: New BlackBerry Storm 3

Information Technology Wizard: Unleash the storm: New BlackBerry Storm 3: "The new Blackberry Storm 3 is an eye-candy for every gadget lovers.Mark up your calendar! September 2011 is the most awaited release of this..."

Unleash the storm: New BlackBerry Storm 3

The new Blackberry Storm 3 is an eye-candy for every gadget lovers.

Mark up your calendar! September 2011 is the most awaited release of this new and exciting Blackberry Storm 3.

With its cutting edge features, expect that it will penetrate the market with a bang.

The upcoming Blackberry Storm 3 has a bigger  display resolution  as compared to Blackberry Storm 2. It even surpasses Blackberry Tours’ 460 x 320 pixels and 65000 colors.   Blackberry Storm 3 promises sharper images at a pixel size of 800 x 480.

This powerful phone boasts  1.2 GHz processor , 512MB RAM, and  8GB internal memory storage which is still expandable up to 32 GB by its MicroSD card. Moreover, Blackberry Storm 3 uses the latest Blackberry OS 6.1.

	BlackBerry Storm 2	BlackBerry Storm 3
Network	GSM 850 / 900 / 1800 / 1900	GSM 850 / 900 / 1800 / 1900
	HSDPA 2100	Tri-band UMTS and HSDPA 14.4 Mbit/s with HSUPA 5.76 Mbit/s.
Announced	2009, October
Status	Available. Released 2009, November	September 2011 release
Type	3.3 inch TFT capacitive touchscreen, 65K colors	3.7-inch capacitive touchscreen
Size	360 x 480 pixels, 3.25 inches	800x480 pixels
	- Accelerometer sensor for auto-rotate	accelerometer, magnetometer, microSD card slot and proximity sensor
Processor		1.2Ghz processor  and 512MB of RAM
Internal	2 GB	8GB
Card slot	microSD, up to 16GB, buy memory	microSD slot expandable upto 32GB
Bluetooth	Yes, v2.1 with A2DP	Bluetooth 2.1 with EDR.
Camera	3.15 MP, 2048x1536 pixels, autofocus, LED flash	5-megapixel camera with LED Flash, 2592 х 1944 Pixels, Auto focus
Video	720p video recording	720p video recording
OS	BlackBerry OS 5	Latest BlackBerry OS 6.1, with 3G mobile hotspot feature.
	Standard battery, Li-Ion 1400 mAh	1230mAh battery