Can SPs access a single Table? Multiple Tables?

Yes and Yes.