Transistor active mode
Refer to this site. The page clearly takes you through the working of transistor as a switch, along with regions of operation of transistor in detail. You can then try reading the parameters of BC547 and see how your LED turn on circuit needs to be configured. You can always ask question when you don't understand something specific, and not a generic question. 

Some more links 1, 2, 3.