Will a bigger sprocket on the front give you more acceleration?

A smaller front sprocket will give you more acceleration. This is because the smaller front sprocket will make the wheel turn faster for each revolution of the pedals, which will give you more power to get you moving. A bigger front sprocket will require more effort to pedal, but will give you a higher top speed.