First of all I'd like to say welcome to you.
Now how big and deep is the box? Some veggies requires deep soil. Cukes and such take alot of space..and I mean alot.
You'll need to get rid of the sand and use topsoil and compost mix. I'm in
zone 4 and grow quite alot...although some have to be planted as
seedlings(tomatoes,
peppers, cukes, pumpkins, celery)
You can grow your tomatoes and
peppers in planter pots, as well as small onions and lettuce. Not sure what Cannelleni beans are... I grow bush beans here from
seed.
potatoes, corn, carrots and radish are from
seed as well. I'm not sure how long your
growing season is...