How to Create a Yes/No, On/Off or True/False Microsoft Access Field

Video Transcript

"Hi, my name is Dave Andrews, and today, I'm going to show you how to create a Yes/No Field in Microsoft Access. Let's open Access, and open up a data base. I'm going to open My Data Base 3. If you get a security warning, just click Open. In the Tables subsection, right click on a table, and say Design View. Here I have a table that's already been created. I'm going to create a Yes/No Field for this table. A Yes/No Field, can hold values Yes or No, True or False. Let's call our table, My Yes/No,and in the data type, just select Yes/No. A Yes/No Field is either on or off, True/False, Yes or No. It's that easy. Close your table in the Design Field. Let's say Yes. Now, open up your table to Add Data,and as you can see, the My Yes/No field, has been converted into check boxes. A check means Yes, an off means No. It's that easy to create a Yes/No field. My name is Dave Andrews, and I've just showed you how to create a Yes/No field in Microsoft Access."