Hotkeys/Shortcut keys of Microsoft Access.

Shortcut keys of Microsoft Access.

Crtl+N : Open new Database.
Ctrl+O: Open existing Database.
Alt+F4: Quit MS access.
Ctrl+p: Print current or selected object.
S: Open the page setup dialog box from print preview.
P: Open Print dialog box from print preview.
C or Esc:Cancel print preview.
Ctrl+S /Shift+F12/Alt +Shift+F2: Save data base.
AltF2/F12: Open the save as dialog box.
F4 / Alt+Down Arrow:Open combo box.
F9: Refresh the contents of a look up field.
Down Arrow: move down one line.
Page Down: Move down one page.
Up Arrow: Move up one line.
Page Up:Move Up one page.
Tab: Exit combo box or list box.
Ctrl+F: Open find tab and replace box.
Ctrl+H: Open replace tab in the find and replace dialog box.
Shift+F4: Find the next occurrence of the text specified in the find and replace dialog box when the dialog box is closed.

Read More

Shortcut Keys of MS Excel/ Microsoft Office tricks.

F2 : Edit the selected cell.
F5: Go to a specific cell .
F7: Spell check selected text and /or document.
F11: Create Chart
Ctrl+Shift+; : Enter the current time.
Ctrl+; :Enter the current date.
Alt+shift+F1: Insert new worksheet.
Shift+F3: Open the excel formula window.
Shift+F5: Bring up search box.
Ctrl+A: select all contents of the worksheet.
Ctrl+B: Bold highlighted Selection.
Ctrl+I : Italic highlighted Selection.
Ctrl+K: Insert link.
Ctrl+U: Underline highlighted  selection.
Ctrl+5: Strike through highlighted selection.
Ctrl+P: Bring up the print dialogue box to bring printing.
Ctrl+Z: Undo last action.
Ctrl+F9: Minimize current window.
Ctrl+F10: Maximize current window.
Ctrl+F6: Switch between open work books/windows.
Ctrl+Page down: Move between Excel worksheets in the same excel document.
Ctrl+Tab: move between two or more excel files.
Alt+=: Create a formula to sum all of the above cells.
Ctrl+'  : Insert the value of the above cell into the cell currently selected.
Ctrl+shift+! : Format number in comma format.
Ctrl+Shift+$ : Format number in currency format.
Ctrl+Shift+# : Format number in date format.
Crtl+Shift+% : Format number in percentage format.
Crtl+Shift+^ : Format number in scientific format.
Crtl+Shift+@ : Format number in time format.
Crtr+Arrow key : move to next section.
Ctrl+Space: Select the entire colum.
Shift +Space : Select entire row.

Read More

First 10 users of Facebook Social Networking Site !!! Facts

Here are First Ten people who joined first Facebook!!

 1. Mark Zuckerberg

2. Chris Hughes - Hughes cofounded Facebook and was college roommates with Zuckerberg.

3. Dustin Moskovitz - Moskovitz cofounded Facebook and was college roommates with Zuckerberg.

4. Arie Hasit - Hasit was the first non-founder to sign up for Facebook.
He was friends with early members David Hammer and Colin Jackson. Hammer knew Facebook cofounder Chris Hughes directly so its likely all three were friends.

5.  Marcel Georgés Laverdet II* - While Laverdet has one of the earliest IDs, it's not certain that he was one of the first 20 to sign up for the site. Some engineers who worked at Facebook saw some early IDs were open and snagged them for themselves.

6. Soleio Cuervo - Cuervo was friends with early Facebook member Marcel George Laverdet.

7. Chris Putnam - Putnam was, however, friends with early Facebooker Marcel George Laverdet. Putnam and Marcel both got jobs at Facebook by creating hacks and pranks on the social site. These hacks caught theattention of cofounder Dustin Moskovitz, who contacted Putnam. The two kept in touch and when Putnam moved to Silicon Valley, Moskovitz offered him an interview at Facebook.
 
8. Andrew McCollum - McCollum was a Harvard student who was in Mark Zuckerberg's CS161: Operating Systems class.
 
9. Colin Kelly - Kelly was a Harvard student who was friends with David Hammer and Colin Jackson. Both knew many early Facebookers and it's likely all of them were acquaintances.

10. Mark Kaganovich - Kaganovich was a Harvard student who was also friends with early Facebook. David Hammer(20 earliest member)Although Hammer joined Facebook after Kaganovich, Hammer knew at least 7 of the earliest.

Read More

Best Trick to Add facebook Fan page to Blogger/How to

Today's post is about a trick to add Facebook fan page to your blogger. Being a blogger  its very important to increase the traffic in as much as possible ways.. Facebook is of the most popular social medium used globally. Hence its one of the best way you can use to drive traffic to your blog and market your products.
 
Check out below that how you can add Facebook fan page on the blog in few simple steps.

1. Sign in your Facebook account and enter social plugins page or just  Click Here.

2.  Now enter your Facebook fan page link in it as show in image

3. After entering the name, you can uncheck the Show Steam and click on Get Code, a set of code will be pop up now select the option  IFRAME as show below.

 4. Now go to your blogger dashboard ,select layout and then click on Add Gadget  and select HTML/Java Script and paste  the codes you got from above step 3 and save them.

5. You can arrange where ever you want by dragging it to the desired position and  finally save the arrangement. You are done with it.

6. Now check out your blog for the result.

Read More

Program to check whether the given string is a Palindrome

Hello friends..

Writing a program is a common thing if you are a CS students and in the beginning its very difficult some times  to write the programs .. Hence  we thought to share some basic programs  which is quit useful for you all while writing assignments or practicals.

 Here sharing  a program to check whether the given string is a Palindrome .  If you are thinking what is it then  Palindrome is a string, which when read in both forward and backward way is same.
Example: radar, madam, pop, lol, Malayalam

#include
#include
int main(){
char string1[20 ];
int i, length;
int flag = 0;
printf("Enter a string: \n");
scanf("%s" , string1);
length = strlen(str ing1);
for(i=0;i<length ;i++){
if(string1 [i] != string1[le ngth-i-1]) {
flag = 1;
break;
}
}
if (flag){
printf("%s is not a palindrome \n", string1);
}
else{
printf("%s is a palindrome \n", string1);
}
return 0;
}

Output:

Enter a string: radar
"radar"is a palindrome

Explanation with example for making it easy to understand.

To check if a string is a palindrome or not, a string needs to be compared with the reverse of itself.
Consider a palindrome string:"radar",
---------- ---------- -------
index: 0 1 2 3 4
value: r a d a r
---------- ---------- -------

To compare it with the reverse of itself, the following logic is used:
0th character in the char array, string1 is same as 4th character in the same string.
1st character is same as 3rd character.
2nd character is same as 2nd character.

i'th character is same as 'length-i- 1'th character.
If any one of the above condition fails, flag is set to true(1), which implies that the string is not a palindrome .
By default, the value of flag is false(0). Hence, if all the conditions are satisfied, the string is a palindrome .

Read More

Inventors of Social Networking Sites and Software

Hello friends

 Here sharing some of the inventors of social networking sites and other related software's.

1. Sir Tim Berners-Lee – World Wide Web

2. Vint Cerf And Bob Kahn – TCP/IP

3. Larry Page and Sergey Brin – Google Inc.

4. David Filo and Jerry Yang – Yahoo! Inc.

5. Bill Gates – Microsoft

6. Steven Paul Jobs – Apple Inc.

7. Mark Zuckerberg – Facebook

8. Chad Hurley and Steve Chen – YouTube

9. Linus Torvalds – Linux

10. Jack Dorsey – Twitter

11. Kevin Rose – Digg

12. Bram Cohen – BitTorrent

13. Mike Morhaime – Blizzard Entertainment

14. Jimmy Wales – Wikipedia

15. Jeff Preston Bezos – Amazon

16. Shawn Fanning – Napster, Rupture

17. Pierre Omidyar – eBay

18. Jack Ma – Alibaba

19. Craig Newmark – Craigslist

20. Matt Mullenweg – WordPress

21. Thomas Anderson – MySpace

22. Garrett Camp – StumbleUpon

23. Jon Postel – Internet Pioneer

24. Caterina Fake – Flickr

25. Marc Andreessen – Netscape

Read More

Inventors of Computer Hardware's/Grab knowledge

Hello friends,

  Here sharing some of the inventors name of computer hardware's,  i guess its useful for you all....

1:Key board— Herman Hollerith, first keypunch devices in 1930’s

2:Transistor— John Bardeen, Walter Brattain & Wiliam Shockley ( 1947-48)

3:RAM— An Wang and Jay Forrester (1951)

4:Trackball— Tom Cranston and Fred Longstaff (1952)

5:Hard Disk— IBM , The IBM Model 350 Disk File (1956 )

6:Integrated Circuit— Jack Kilby & Robert Noyce( 1958)

7:Computer Mouse — Douglas Engelbart (1964)

8:Laser printer— Gary Starkweather at XEROX in1969.

9:Floppy Disk— Alan Shugart &IBM( 1970)

10:Microprocess­or— Faggin, Hoff & Mazor – Intel 4004 (1971)

Read More

New Important full forms/abbreviations related to internet Terms.

Hello  friends,

Sharing some of the  full forms, which we come across in our life daily while using internet.you may find it interesting and useful  while attending interviews or writing any aptitudes or even when any one ask you about that.

FM – Frequency Modulation

SIM – Subscriber Identity Module
 
RIM – Removable Identity Module

GSM – Global System For Mobile
 
LAN – Local Area Network

WAN – Wide Area Network

RTF – Rich Text Format

MAN – Metropolitan Area Network

URL – Uniform Resource Locator

ISP – Inter Net Service Provide

@– At The Rate Of

DVD – Digital Versatile Disk

CD – Compact Disk

EDGE – Enhanced Data for GSM Evolution

GPRS – General Packet Radio Service

FDM – Frequency Division Multiplexing

SDR – Software Defined Radio

ATM – Asynchronous Transfer Mode

DCA – Dynamic Channel Allocation

FCA – Fixed Channel Allocation

AMPS – Advance Mobile Phone System

IMTS – Improved Mobile Telephone System

CDMA – Code Division Multiple Access

MTSO – Mobile Telephone Switching Office

HTTP – Hypertext Transfer Protocol

FIDI – Fiber Distributed Data Interface

ISDN – Integrated Services Digital Network

PSTN – Public Switched Telephone Network

CSMA – Carrier Sense Multiple Access

RADAR – Radio Detection And Ranging

SONET – Synchronous Optical Fiber Network

DAMPS – Digital Advanced Mobile Phone System

WWW – World Wide Web

IP – Internet Protocol

TCP – Transmission Control Protocol

HTML – Hyper Text Markup Language

USB – Universal Serial Bus

PAN - Personal Area Network

TDM - Time Division Multiplexing.

Read More

Hack OR Delete Administrator Password Of Computer without Software.

Friends,

Many times we We forget our own passwords  and some times we need  to use admin privileges on others Computer we usually face a problem of  Admin password , so today my post is regarding that how you can delete the password without any software.

 Trick 1.

Boot up with DOS and delete the sam.exe and sam.log files from Windows\system3 2\config in your hard
drive. Now when you boot up in NT the password on your built-in administrator
account which will be blank (i.e No password). This solution works only if your hard drives FAT kind.

Trick 2.

*Put your hard disk of your computer in any other PC .
*Boot that computer and use your hard disk as a secondary hard disk(Don't boot as primary hard disk).
*Then open that drive in which the victim’s window(or your window) is installed. 
*Go to location windows ->system32->configure
*And delete SAM.exe and SAM.log
*Now remove hard disk and put in your computer.
*And boot your computer

Read More

Abbreviation/Full Forms of Major IT companies.

Friends , Do you know the full forms of the major IT industries? if No, then  here this post is gonna help you to update yourself about that which is quit useful when you undergo any aptitude test or interviews.

GOOGLE :- Global Organization Of Oriented Group Language of Earth

APPLE:- Asian Passenger Payload Experiment

HP :- Hewlett-Packard

IBM:- International Business Machines Corporation

HCL:-Hindustan Computer Limited

WIPRO:- Western India Product Limited


GE:-General Electronics

INFOSYS:-Information System

TCS:- Tata Consultancy Services

AOL:- American Online

BPL:- British Process Laboratory

INTEL:- Integrated Electronics

CISCO:- Computer Information System Company

DELL:- Michael DELL

SONY:-Sound Of New York

AMD:- Advance micro devices

LENOVO:- LE(Legend),NOVO(New)

COMPAQ:- Compatibility And Quality

Read More