How to Write a True & False Test for MS Access

You can control the way Access stores its fields.

Microsoft Excel provides a number of different data formats, making it easier to create the tables and queries you need. The yes/no field format in Microsoft Access allows you to specify whether a particular field is true or false. For instance, you can use this format within an employee table to specify a true or false condition for salaried vs. hourly workers. This simple yet powerful formula makes it easy to create a query that pulls out salaried employees based on the contents of a particular field.

Instructions

1. Log on to your computer and open Microsoft Access. Open the table you want to add the true/false field to.

2. Right-click the table and choose "Design View" to see a list of the existing fields. Highlight an existing field if you want to limit the choices to yes or no. Otherwise, place your cursor at the bottom of the list of fields to create a new field for your data.

3. Type the name of the field. Click the "Data Type" column and change the setting to "Yes/No."

4. Go to the "Format" tab and change the setting to "True/False." Click the "Save" button to save the changes you have made to the table. This is the button that looks like a diskette.