How to Limit Data in a Microsoft Access Field to Certain Values

Video Transcript

"Hi, my name is Dave Andrews and today I'm going to show you how to limit data in a Microsoft access field to certain values. Let's open up Microsoft access and open up a data base. I'm going to select my data base three as I open. If you get a security warning, just press the open button. Now let's create a new table and design view. First create an id field and give it the auto number type. Right click on id to make it a primary key for your table. Now let's create a field that we're going to limit. Call it my text and just give it a data type of text. Down here in this area in validation rule, click on the low three dots and let's add an equal sign, space, a quotation mark and just say, David. What we're saying is that this field must be equal to David. Say, okay and let's say, save as table II. Close your table. Now let's reopen table II in a editing mode and for my text, let's type something not David. Let's say, William. It gives you an error message, saying that what you type is prohibited. Let's clear out William and type David. As you notice, it took that value. It's that easy to limit field in Microsoft access. My name is Dave Andrews and I've just showed you how to limit fields in Microsoft access to certain values."