You got it bass ackwards:With a 'large-format' camera the aperture could be fully open and the whole object from one inch to eternity will be sharp.
You increase the depth of field (and sharpness) with distance, amount of light and optics, for example. A good tripod is always beneficial.
If the aperture were fully open, you would have limited depth of field. If it were closed down, then you would have maximum depth of field. Depth of field is controlled by F stop and image size or to put it in another way, F stop and distance from the object. You are right about the tripod.