MS Access -- best strategy for boolean value in table and interface

Hi all -- looking for some quick input on good strategies for capturing Boolean values in an MS Access table along with corresponding ease-of-development with the front end. I know the question seems easy but I don't like the yes/no check in the table (is this really how it's done?) and I'm used to seeing numbers. I'm thinking the most straightforward strategy is to use a Long datatype and then tie an option group to it at the form level -- then I can populate with integers based on each value and I can control the default to either one or the other and presumably avoid null values as well. From an upsizing standpoint -- when I upsize, what does MSSQL use as integers to distinguish between true and false -- (-1) and (0), or something else? Just trying to make sure I make the right design decisions now and avoid headaches later. Thanks --