Access Database Yes / No Data Type
Finally let’s look at the Access Database Yes/No data type. This is the simplest data type – It stores binary (0 or 1) values.
There are three different formatting options for the Access Database Yes/No data type:
- First formatting option is “YES / NO”
- A second formatting option one is “TRUE / FALSE” and
- The final formatting option is “ON / OFF”
The best use of a Access Yes/No data type is to answer questions that have a Yes or No answer. Anything more complicated than a yes or no value, consider a larger data type like a Byte or Integer.