WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:08.970 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c>

00:00:08.970 --> 00:00:08.980 align:start position:0%
 
 

00:00:08.980 --> 00:00:11.140 align:start position:0%
 
sometimes<00:00:09.980><c> you</c><00:00:10.160><c> may</c><00:00:10.249><c> decide</c><00:00:10.580><c> that</c><00:00:10.639><c> you</c><00:00:10.849><c> want</c>

00:00:11.140 --> 00:00:11.150 align:start position:0%
sometimes you may decide that you want
 

00:00:11.150 --> 00:00:13.619 align:start position:0%
sometimes you may decide that you want
to<00:00:11.240><c> add</c><00:00:11.539><c> or</c><00:00:11.870><c> modify</c><00:00:12.200><c> fields</c><00:00:12.950><c> in</c><00:00:13.039><c> your</c><00:00:13.070><c> tables</c>

00:00:13.619 --> 00:00:13.629 align:start position:0%
to add or modify fields in your tables
 

00:00:13.629 --> 00:00:16.359 align:start position:0%
to add or modify fields in your tables
access<00:00:14.629><c> makes</c><00:00:14.839><c> it</c><00:00:14.990><c> easy</c><00:00:15.169><c> to</c><00:00:15.379><c> do</c><00:00:15.530><c> this</c><00:00:15.679><c> although</c>

00:00:16.359 --> 00:00:16.369 align:start position:0%
access makes it easy to do this although
 

00:00:16.369 --> 00:00:17.650 align:start position:0%
access makes it easy to do this although
there<00:00:16.550><c> are</c><00:00:16.699><c> some</c><00:00:16.880><c> important</c><00:00:17.390><c> things</c><00:00:17.539><c> that</c>

00:00:17.650 --> 00:00:17.660 align:start position:0%
there are some important things that
 

00:00:17.660 --> 00:00:20.200 align:start position:0%
there are some important things that
you'll<00:00:17.869><c> need</c><00:00:18.019><c> to</c><00:00:18.140><c> consider</c><00:00:18.640><c> there</c><00:00:19.640><c> are</c><00:00:19.880><c> three</c>

00:00:20.200 --> 00:00:20.210 align:start position:0%
you'll need to consider there are three
 

00:00:20.210 --> 00:00:21.580 align:start position:0%
you'll need to consider there are three
different<00:00:20.599><c> rules</c><00:00:20.779><c> that</c><00:00:21.050><c> you</c><00:00:21.140><c> can</c><00:00:21.170><c> apply</c><00:00:21.470><c> to</c>

00:00:21.580 --> 00:00:21.590 align:start position:0%
different rules that you can apply to
 

00:00:21.590 --> 00:00:23.679 align:start position:0%
different rules that you can apply to
control<00:00:22.340><c> the</c><00:00:22.490><c> type</c><00:00:22.670><c> of</c><00:00:22.820><c> data</c><00:00:23.029><c> that</c><00:00:23.119><c> the</c><00:00:23.300><c> fields</c>

00:00:23.679 --> 00:00:23.689 align:start position:0%
control the type of data that the fields
 

00:00:23.689 --> 00:00:26.339 align:start position:0%
control the type of data that the fields
can<00:00:23.839><c> accept</c><00:00:24.259><c> and</c><00:00:24.500><c> these</c><00:00:25.250><c> are</c><00:00:25.460><c> data</c><00:00:25.880><c> types</c>

00:00:26.339 --> 00:00:26.349 align:start position:0%
can accept and these are data types
 

00:00:26.349 --> 00:00:32.589 align:start position:0%
can accept and these are data types
character<00:00:27.349><c> limits</c><00:00:27.679><c> and</c><00:00:27.939><c> validation</c><00:00:28.939><c> rules</c><00:00:31.599><c> to</c>

00:00:32.589 --> 00:00:32.599 align:start position:0%
character limits and validation rules to
 

00:00:32.599 --> 00:00:33.940 align:start position:0%
character limits and validation rules to
get<00:00:32.750><c> started</c><00:00:33.140><c> make</c><00:00:33.379><c> sure</c><00:00:33.410><c> that</c><00:00:33.739><c> you</c><00:00:33.800><c> have</c><00:00:33.920><c> a</c>

00:00:33.940 --> 00:00:33.950 align:start position:0%
get started make sure that you have a
 

00:00:33.950 --> 00:00:36.990 align:start position:0%
get started make sure that you have a
table<00:00:34.340><c> open</c><00:00:34.520><c> I'm</c><00:00:35.239><c> using</c><00:00:35.480><c> the</c><00:00:35.899><c> customers</c><00:00:36.469><c> table</c>

00:00:36.990 --> 00:00:37.000 align:start position:0%
table open I'm using the customers table
 

00:00:37.000 --> 00:00:39.520 align:start position:0%
table open I'm using the customers table
we're<00:00:38.000><c> going</c><00:00:38.180><c> to</c><00:00:38.420><c> scroll</c><00:00:38.750><c> all</c><00:00:39.020><c> the</c><00:00:39.079><c> way</c><00:00:39.260><c> to</c><00:00:39.350><c> the</c>

00:00:39.520 --> 00:00:39.530 align:start position:0%
we're going to scroll all the way to the
 

00:00:39.530 --> 00:00:41.529 align:start position:0%
we're going to scroll all the way to the
right<00:00:39.770><c> until</c><00:00:40.129><c> you</c><00:00:40.190><c> see</c><00:00:40.460><c> a</c><00:00:40.489><c> blank</c><00:00:40.969><c> field</c><00:00:41.210><c> that</c>

00:00:41.529 --> 00:00:41.539 align:start position:0%
right until you see a blank field that
 

00:00:41.539 --> 00:00:44.380 align:start position:0%
right until you see a blank field that
says<00:00:41.690><c> click</c><00:00:42.170><c> to</c><00:00:42.199><c> add</c><00:00:42.500><c> and</c><00:00:43.000><c> when</c><00:00:44.000><c> you</c><00:00:44.059><c> click</c><00:00:44.270><c> on</c>

00:00:44.380 --> 00:00:44.390 align:start position:0%
says click to add and when you click on
 

00:00:44.390 --> 00:00:46.029 align:start position:0%
says click to add and when you click on
it<00:00:44.449><c> you'll</c><00:00:44.660><c> see</c><00:00:44.750><c> a</c><00:00:44.899><c> list</c><00:00:45.260><c> of</c><00:00:45.410><c> all</c><00:00:45.620><c> of</c><00:00:45.770><c> the</c><00:00:45.890><c> data</c>

00:00:46.029 --> 00:00:46.039 align:start position:0%
it you'll see a list of all of the data
 

00:00:46.039 --> 00:00:48.849 align:start position:0%
it you'll see a list of all of the data
types<00:00:46.370><c> that</c><00:00:46.520><c> you</c><00:00:46.670><c> can</c><00:00:46.820><c> choose</c><00:00:47.000><c> from</c><00:00:47.859><c> short</c>

00:00:48.849 --> 00:00:48.859 align:start position:0%
types that you can choose from short
 

00:00:48.859 --> 00:00:51.490 align:start position:0%
types that you can choose from short
text<00:00:49.309><c> is</c><00:00:49.430><c> the</c><00:00:49.670><c> default</c><00:00:49.969><c> option</c><00:00:50.449><c> and</c><00:00:50.539><c> this</c><00:00:51.350><c> is</c>

00:00:51.490 --> 00:00:51.500 align:start position:0%
text is the default option and this is
 

00:00:51.500 --> 00:00:52.959 align:start position:0%
text is the default option and this is
the<00:00:51.649><c> type</c><00:00:51.829><c> that</c><00:00:51.859><c> you'll</c><00:00:52.160><c> use</c><00:00:52.430><c> for</c><00:00:52.460><c> regular</c>

00:00:52.959 --> 00:00:52.969 align:start position:0%
the type that you'll use for regular
 

00:00:52.969 --> 00:00:55.509 align:start position:0%
the type that you'll use for regular
text<00:00:53.570><c> such</c><00:00:53.870><c> as</c><00:00:53.899><c> a</c><00:00:54.109><c> person's</c><00:00:54.260><c> name</c><00:00:54.800><c> or</c><00:00:55.010><c> address</c>

00:00:55.509 --> 00:00:55.519 align:start position:0%
text such as a person's name or address
 

00:00:55.519 --> 00:00:57.639 align:start position:0%
text such as a person's name or address
you'll<00:00:56.480><c> also</c><00:00:56.690><c> use</c><00:00:56.870><c> it</c><00:00:57.199><c> for</c><00:00:57.230><c> numbers</c><00:00:57.620><c> that</c>

00:00:57.639 --> 00:00:57.649 align:start position:0%
you'll also use it for numbers that
 

00:00:57.649 --> 00:00:59.860 align:start position:0%
you'll also use it for numbers that
aren't<00:00:58.100><c> used</c><00:00:58.309><c> in</c><00:00:58.460><c> calculations</c><00:00:58.969><c> like</c><00:00:59.510><c> a</c><00:00:59.570><c> phone</c>

00:00:59.860 --> 00:00:59.870 align:start position:0%
aren't used in calculations like a phone
 

00:00:59.870 --> 00:01:02.830 align:start position:0%
aren't used in calculations like a phone
number<00:01:00.079><c> or</c><00:01:00.260><c> zip</c><00:01:00.800><c> code</c><00:01:01.210><c> for</c><00:01:02.210><c> any</c><00:01:02.359><c> numbers</c><00:01:02.690><c> that</c>

00:01:02.830 --> 00:01:02.840 align:start position:0%
number or zip code for any numbers that
 

00:01:02.840 --> 00:01:04.270 align:start position:0%
number or zip code for any numbers that
you<00:01:02.960><c> might</c><00:01:03.140><c> want</c><00:01:03.350><c> to</c><00:01:03.410><c> do</c><00:01:03.530><c> calculations</c><00:01:04.190><c> with</c>

00:01:04.270 --> 00:01:04.280 align:start position:0%
you might want to do calculations with
 

00:01:04.280 --> 00:01:07.090 align:start position:0%
you might want to do calculations with
you'll<00:01:04.850><c> need</c><00:01:04.909><c> to</c><00:01:05.150><c> choose</c><00:01:05.420><c> number</c><00:01:05.750><c> for</c><00:01:06.740><c> example</c>

00:01:07.090 --> 00:01:07.100 align:start position:0%
you'll need to choose number for example
 

00:01:07.100 --> 00:01:08.859 align:start position:0%
you'll need to choose number for example
we<00:01:07.250><c> would</c><00:01:07.369><c> use</c><00:01:07.549><c> this</c><00:01:07.729><c> for</c><00:01:07.790><c> the</c><00:01:08.180><c> quantities</c><00:01:08.720><c> of</c>

00:01:08.859 --> 00:01:08.869 align:start position:0%
we would use this for the quantities of
 

00:01:08.869 --> 00:01:11.170 align:start position:0%
we would use this for the quantities of
an<00:01:08.960><c> item</c><00:01:09.229><c> that</c><00:01:09.380><c> we're</c><00:01:09.560><c> sold</c><00:01:09.860><c> if</c><00:01:10.180><c> you're</c>

00:01:11.170 --> 00:01:11.180 align:start position:0%
an item that we're sold if you're
 

00:01:11.180 --> 00:01:12.640 align:start position:0%
an item that we're sold if you're
dealing<00:01:11.330><c> with</c><00:01:11.479><c> money</c><00:01:11.810><c> then</c><00:01:12.170><c> you'll</c><00:01:12.380><c> choose</c>

00:01:12.640 --> 00:01:12.650 align:start position:0%
dealing with money then you'll choose
 

00:01:12.650 --> 00:01:15.340 align:start position:0%
dealing with money then you'll choose
currency<00:01:13.250><c> and</c><00:01:13.460><c> if</c><00:01:14.420><c> you</c><00:01:14.540><c> choose</c><00:01:14.750><c> date</c><00:01:14.990><c> and</c><00:01:15.170><c> time</c>

00:01:15.340 --> 00:01:15.350 align:start position:0%
currency and if you choose date and time
 

00:01:15.350 --> 00:01:16.810 align:start position:0%
currency and if you choose date and time
then<00:01:15.740><c> when</c><00:01:15.920><c> you're</c><00:01:16.040><c> editing</c><00:01:16.189><c> that</c><00:01:16.579><c> field</c>

00:01:16.810 --> 00:01:16.820 align:start position:0%
then when you're editing that field
 

00:01:16.820 --> 00:01:18.700 align:start position:0%
then when you're editing that field
you'll<00:01:17.030><c> see</c><00:01:17.240><c> a</c><00:01:17.270><c> calendar</c><00:01:17.540><c> icon</c><00:01:18.110><c> which</c><00:01:18.380><c> you</c><00:01:18.530><c> can</c>

00:01:18.700 --> 00:01:18.710 align:start position:0%
you'll see a calendar icon which you can
 

00:01:18.710 --> 00:01:21.340 align:start position:0%
you'll see a calendar icon which you can
click<00:01:18.950><c> to</c><00:01:19.009><c> select</c><00:01:19.490><c> a</c><00:01:19.610><c> date</c><00:01:19.810><c> but</c><00:01:20.810><c> in</c><00:01:20.990><c> this</c><00:01:21.110><c> case</c>

00:01:21.340 --> 00:01:21.350 align:start position:0%
click to select a date but in this case
 

00:01:21.350 --> 00:01:23.950 align:start position:0%
click to select a date but in this case
I<00:01:21.590><c> just</c><00:01:21.619><c> want</c><00:01:21.829><c> a</c><00:01:22.130><c> simple</c><00:01:22.430><c> yes</c><00:01:22.850><c> or</c><00:01:23.000><c> no</c><00:01:23.060><c> answer</c><00:01:23.180><c> so</c>

00:01:23.950 --> 00:01:23.960 align:start position:0%
I just want a simple yes or no answer so
 

00:01:23.960 --> 00:01:25.270 align:start position:0%
I just want a simple yes or no answer so
I'll<00:01:24.259><c> choose</c><00:01:24.560><c> this</c><00:01:24.890><c> one</c>

00:01:25.270 --> 00:01:25.280 align:start position:0%
I'll choose this one
 

00:01:25.280 --> 00:01:28.590 align:start position:0%
I'll choose this one
and<00:01:25.540><c> this</c><00:01:26.540><c> adds</c><00:01:26.750><c> a</c><00:01:27.110><c> checkbox</c><00:01:27.590><c> for</c><00:01:27.799><c> each</c><00:01:28.040><c> record</c>

00:01:28.590 --> 00:01:28.600 align:start position:0%
and this adds a checkbox for each record
 

00:01:28.600 --> 00:01:30.910 align:start position:0%
and this adds a checkbox for each record
then<00:01:29.600><c> you</c><00:01:29.630><c> can</c><00:01:29.990><c> type</c><00:01:30.170><c> in</c><00:01:30.320><c> the</c><00:01:30.439><c> name</c><00:01:30.470><c> of</c><00:01:30.649><c> your</c>

00:01:30.910 --> 00:01:30.920 align:start position:0%
then you can type in the name of your
 

00:01:30.920 --> 00:01:33.160 align:start position:0%
then you can type in the name of your
field<00:01:31.189><c> I'm</c><00:01:31.759><c> going</c><00:01:32.000><c> to</c><00:01:32.240><c> name</c><00:01:32.450><c> it</c><00:01:32.479><c> add</c><00:01:32.750><c> to</c>

00:01:33.160 --> 00:01:33.170 align:start position:0%
field I'm going to name it add to
 

00:01:33.170 --> 00:01:40.830 align:start position:0%
field I'm going to name it add to
mailing<00:01:33.320><c> list</c><00:01:36.280><c> then</c><00:01:37.280><c> I'll</c><00:01:37.430><c> resize</c><00:01:37.939><c> this</c><00:01:38.210><c> field</c>

00:01:40.830 --> 00:01:40.840 align:start position:0%
 
 

00:01:40.840 --> 00:01:43.630 align:start position:0%
 
now<00:01:41.840><c> we</c><00:01:41.899><c> can</c><00:01:42.229><c> just</c><00:01:42.470><c> check</c><00:01:42.710><c> each</c><00:01:42.920><c> customer</c><00:01:43.490><c> who</c>

00:01:43.630 --> 00:01:43.640 align:start position:0%
now we can just check each customer who
 

00:01:43.640 --> 00:01:46.840 align:start position:0%
now we can just check each customer who
wants<00:01:43.880><c> to</c><00:01:43.939><c> be</c><00:01:44.090><c> on</c><00:01:44.119><c> our</c><00:01:44.360><c> mailing</c><00:01:44.630><c> list</c><00:01:44.659><c> and</c><00:01:45.850><c> you</c>

00:01:46.840 --> 00:01:46.850 align:start position:0%
wants to be on our mailing list and you
 

00:01:46.850 --> 00:01:48.730 align:start position:0%
wants to be on our mailing list and you
can<00:01:46.969><c> also</c><00:01:47.090><c> click</c><00:01:47.420><c> and</c><00:01:47.540><c> drag</c><00:01:47.750><c> the</c><00:01:48.110><c> name</c><00:01:48.320><c> to</c><00:01:48.590><c> move</c>

00:01:48.730 --> 00:01:48.740 align:start position:0%
can also click and drag the name to move
 

00:01:48.740 --> 00:01:51.410 align:start position:0%
can also click and drag the name to move
the<00:01:48.890><c> field</c><00:01:49.100><c> wherever</c><00:01:49.369><c> you</c><00:01:49.640><c> like</c>

00:01:51.410 --> 00:01:51.420 align:start position:0%
the field wherever you like
 

00:01:51.420 --> 00:01:53.810 align:start position:0%
the field wherever you like
if<00:01:51.560><c> you</c><00:01:52.560><c> decide</c><00:01:52.920><c> that</c><00:01:52.950><c> you</c><00:01:53.250><c> need</c><00:01:53.430><c> a</c><00:01:53.610><c> different</c>

00:01:53.810 --> 00:01:53.820 align:start position:0%
if you decide that you need a different
 

00:01:53.820 --> 00:01:55.820 align:start position:0%
if you decide that you need a different
datatype<00:01:54.420><c> for</c><00:01:54.450><c> a</c><00:01:54.689><c> field</c><00:01:54.930><c> then</c><00:01:55.350><c> you</c><00:01:55.530><c> can</c><00:01:55.680><c> just</c>

00:01:55.820 --> 00:01:55.830 align:start position:0%
datatype for a field then you can just
 

00:01:55.830 --> 00:01:58.460 align:start position:0%
datatype for a field then you can just
select<00:01:56.009><c> it</c><00:01:56.340><c> and</c><00:01:56.490><c> then</c><00:01:57.090><c> go</c><00:01:57.330><c> to</c><00:01:57.390><c> the</c><00:01:57.720><c> fields</c><00:01:58.140><c> tab</c>

00:01:58.460 --> 00:01:58.470 align:start position:0%
select it and then go to the fields tab
 

00:01:58.470 --> 00:02:02.469 align:start position:0%
select it and then go to the fields tab
and<00:01:59.479><c> click</c><00:02:00.479><c> the</c><00:02:00.509><c> data</c><00:02:00.840><c> type</c><00:02:01.110><c> drop-down</c><00:02:01.500><c> arrow</c>

00:02:02.469 --> 00:02:02.479 align:start position:0%
and click the data type drop-down arrow
 

00:02:02.479 --> 00:02:05.179 align:start position:0%
and click the data type drop-down arrow
I'm<00:02:03.479><c> going</c><00:02:03.720><c> to</c><00:02:03.810><c> change</c><00:02:04.049><c> this</c><00:02:04.290><c> to</c><00:02:04.500><c> text</c><00:02:04.770><c> so</c><00:02:05.159><c> I</c>

00:02:05.179 --> 00:02:05.189 align:start position:0%
I'm going to change this to text so I
 

00:02:05.189 --> 00:02:06.830 align:start position:0%
I'm going to change this to text so I
can<00:02:05.399><c> add</c><00:02:05.549><c> additional</c><00:02:05.700><c> information</c><00:02:06.119><c> in</c><00:02:06.720><c> this</c>

00:02:06.830 --> 00:02:06.840 align:start position:0%
can add additional information in this
 

00:02:06.840 --> 00:02:09.199 align:start position:0%
can add additional information in this
field<00:02:07.280><c> some</c><00:02:08.280><c> of</c><00:02:08.399><c> our</c><00:02:08.550><c> customers</c><00:02:08.970><c> want</c><00:02:09.179><c> to</c>

00:02:09.199 --> 00:02:09.209 align:start position:0%
field some of our customers want to
 

00:02:09.209 --> 00:02:11.570 align:start position:0%
field some of our customers want to
receive<00:02:09.509><c> our</c><00:02:09.630><c> weekly</c><00:02:09.840><c> newsletter</c><00:02:10.380><c> but</c><00:02:11.160><c> others</c>

00:02:11.570 --> 00:02:11.580 align:start position:0%
receive our weekly newsletter but others
 

00:02:11.580 --> 00:02:12.979 align:start position:0%
receive our weekly newsletter but others
just<00:02:11.880><c> want</c><00:02:11.940><c> to</c><00:02:12.150><c> hear</c><00:02:12.300><c> about</c><00:02:12.390><c> our</c><00:02:12.510><c> special</c>

00:02:12.979 --> 00:02:12.989 align:start position:0%
just want to hear about our special
 

00:02:12.989 --> 00:02:15.440 align:start position:0%
just want to hear about our special
events<00:02:13.380><c> now</c><00:02:14.370><c> you</c><00:02:14.430><c> should</c><00:02:14.640><c> be</c><00:02:14.730><c> very</c><00:02:14.760><c> careful</c>

00:02:15.440 --> 00:02:15.450 align:start position:0%
events now you should be very careful
 

00:02:15.450 --> 00:02:17.390 align:start position:0%
events now you should be very careful
about<00:02:15.540><c> changing</c><00:02:16.170><c> the</c><00:02:16.260><c> data</c><00:02:16.440><c> type</c><00:02:16.709><c> because</c><00:02:17.370><c> it</c>

00:02:17.390 --> 00:02:17.400 align:start position:0%
about changing the data type because it
 

00:02:17.400 --> 00:02:19.190 align:start position:0%
about changing the data type because it
is<00:02:17.580><c> possible</c><00:02:18.090><c> to</c><00:02:18.209><c> lose</c><00:02:18.390><c> some</c><00:02:18.630><c> of</c><00:02:18.660><c> your</c><00:02:18.750><c> data</c><00:02:19.019><c> if</c>

00:02:19.190 --> 00:02:19.200 align:start position:0%
is possible to lose some of your data if
 

00:02:19.200 --> 00:02:22.190 align:start position:0%
is possible to lose some of your data if
you<00:02:19.290><c> change</c><00:02:19.560><c> it</c><00:02:19.650><c> to</c><00:02:19.709><c> the</c><00:02:19.800><c> wrong</c><00:02:19.980><c> type</c><00:02:20.310><c> in</c><00:02:21.200><c> some</c>

00:02:22.190 --> 00:02:22.200 align:start position:0%
you change it to the wrong type in some
 

00:02:22.200 --> 00:02:23.600 align:start position:0%
you change it to the wrong type in some
fields<00:02:22.560><c> you</c><00:02:22.650><c> may</c><00:02:22.800><c> want</c><00:02:23.010><c> to</c><00:02:23.069><c> narrow</c><00:02:23.370><c> down</c><00:02:23.550><c> the</c>

00:02:23.600 --> 00:02:23.610 align:start position:0%
fields you may want to narrow down the
 

00:02:23.610 --> 00:02:25.580 align:start position:0%
fields you may want to narrow down the
data<00:02:23.730><c> even</c><00:02:24.300><c> further</c><00:02:24.540><c> by</c><00:02:24.900><c> adding</c><00:02:25.260><c> a</c><00:02:25.319><c> character</c>

00:02:25.580 --> 00:02:25.590 align:start position:0%
data even further by adding a character
 

00:02:25.590 --> 00:02:28.220 align:start position:0%
data even further by adding a character
limit<00:02:26.069><c> and</c><00:02:26.250><c> you</c><00:02:26.700><c> can</c><00:02:26.819><c> only</c><00:02:27.030><c> do</c><00:02:27.330><c> this</c><00:02:27.510><c> with</c><00:02:27.750><c> text</c>

00:02:28.220 --> 00:02:28.230 align:start position:0%
limit and you can only do this with text
 

00:02:28.230 --> 00:02:31.039 align:start position:0%
limit and you can only do this with text
fields<00:02:28.760><c> for</c><00:02:29.760><c> example</c><00:02:30.120><c> we</c><00:02:30.299><c> want</c><00:02:30.540><c> all</c><00:02:30.720><c> of</c><00:02:30.780><c> the</c>

00:02:31.039 --> 00:02:31.049 align:start position:0%
fields for example we want all of the
 

00:02:31.049 --> 00:02:33.320 align:start position:0%
fields for example we want all of the
states<00:02:31.350><c> to</c><00:02:31.440><c> be</c><00:02:31.530><c> formatted</c><00:02:31.950><c> the</c><00:02:32.190><c> same</c><00:02:32.489><c> way</c><00:02:32.760><c> so</c>

00:02:33.320 --> 00:02:33.330 align:start position:0%
states to be formatted the same way so
 

00:02:33.330 --> 00:02:35.390 align:start position:0%
states to be formatted the same way so
we're<00:02:33.630><c> only</c><00:02:33.810><c> using</c><00:02:34.170><c> the</c><00:02:34.530><c> two-letter</c><00:02:34.950><c> state</c>

00:02:35.390 --> 00:02:35.400 align:start position:0%
we're only using the two-letter state
 

00:02:35.400 --> 00:02:37.759 align:start position:0%
we're only using the two-letter state
abbreviations<00:02:36.150><c> if</c><00:02:36.870><c> some</c><00:02:37.110><c> of</c><00:02:37.200><c> the</c><00:02:37.290><c> records</c><00:02:37.560><c> say</c>

00:02:37.759 --> 00:02:37.769 align:start position:0%
abbreviations if some of the records say
 

00:02:37.769 --> 00:02:40.640 align:start position:0%
abbreviations if some of the records say
in<00:02:38.010><c> C</c><00:02:38.400><c> and</c><00:02:38.670><c> others</c><00:02:39.239><c> say</c><00:02:39.510><c> North</c><00:02:39.750><c> Carolina</c><00:02:40.170><c> then</c>

00:02:40.640 --> 00:02:40.650 align:start position:0%
in C and others say North Carolina then
 

00:02:40.650 --> 00:02:42.440 align:start position:0%
in C and others say North Carolina then
access<00:02:41.190><c> won't</c><00:02:41.489><c> know</c><00:02:41.700><c> to</c><00:02:41.760><c> group</c><00:02:42.090><c> them</c><00:02:42.269><c> together</c>

00:02:42.440 --> 00:02:42.450 align:start position:0%
access won't know to group them together
 

00:02:42.450 --> 00:02:44.750 align:start position:0%
access won't know to group them together
which<00:02:43.200><c> means</c><00:02:43.470><c> our</c><00:02:43.620><c> sorts</c><00:02:44.069><c> filters</c><00:02:44.549><c> and</c>

00:02:44.750 --> 00:02:44.760 align:start position:0%
which means our sorts filters and
 

00:02:44.760 --> 00:02:47.750 align:start position:0%
which means our sorts filters and
queries<00:02:45.120><c> may</c><00:02:45.330><c> not</c><00:02:45.480><c> work</c><00:02:45.720><c> right</c><00:02:45.930><c> in</c><00:02:46.400><c> the</c><00:02:47.400><c> fields</c>

00:02:47.750 --> 00:02:47.760 align:start position:0%
queries may not work right in the fields
 

00:02:47.760 --> 00:02:51.110 align:start position:0%
queries may not work right in the fields
tab<00:02:47.970><c> find</c><00:02:48.450><c> the</c><00:02:48.600><c> field</c><00:02:48.959><c> size</c><00:02:49.290><c> box</c><00:02:49.730><c> the</c><00:02:50.730><c> default</c>

00:02:51.110 --> 00:02:51.120 align:start position:0%
tab find the field size box the default
 

00:02:51.120 --> 00:02:54.500 align:start position:0%
tab find the field size box the default
field<00:02:51.510><c> size</c><00:02:51.810><c> is</c><00:02:52.190><c> 255</c><00:02:53.190><c> characters</c><00:02:53.489><c> but</c><00:02:54.330><c> I'm</c>

00:02:54.500 --> 00:02:54.510 align:start position:0%
field size is 255 characters but I'm
 

00:02:54.510 --> 00:02:58.400 align:start position:0%
field size is 255 characters but I'm
going<00:02:54.750><c> to</c><00:02:54.780><c> change</c><00:02:55.080><c> it</c><00:02:55.290><c> to</c><00:02:55.319><c> two</c><00:02:56.390><c> and</c><00:02:57.390><c> you</c><00:02:58.260><c> may</c>

00:02:58.400 --> 00:02:58.410 align:start position:0%
going to change it to two and you may
 

00:02:58.410 --> 00:03:00.080 align:start position:0%
going to change it to two and you may
get<00:02:58.560><c> a</c><00:02:58.590><c> warning</c><00:02:58.650><c> message</c><00:02:59.040><c> here</c><00:02:59.430><c> so</c><00:02:59.790><c> if</c><00:02:59.970><c> you're</c>

00:03:00.080 --> 00:03:00.090 align:start position:0%
get a warning message here so if you're
 

00:03:00.090 --> 00:03:01.550 align:start position:0%
get a warning message here so if you're
sure<00:03:00.329><c> you</c><00:03:00.450><c> want</c><00:03:00.480><c> to</c><00:03:00.720><c> change</c><00:03:00.989><c> the</c><00:03:01.170><c> field</c><00:03:01.350><c> size</c>

00:03:01.550 --> 00:03:01.560 align:start position:0%
sure you want to change the field size
 

00:03:01.560 --> 00:03:05.300 align:start position:0%
sure you want to change the field size
click<00:03:02.010><c> yes</c><00:03:02.250><c> in</c><00:03:03.560><c> this</c><00:03:04.560><c> case</c><00:03:04.620><c> setting</c><00:03:05.220><c> a</c>

00:03:05.300 --> 00:03:05.310 align:start position:0%
click yes in this case setting a
 

00:03:05.310 --> 00:03:07.009 align:start position:0%
click yes in this case setting a
character<00:03:05.730><c> limit</c><00:03:06.000><c> isn't</c><00:03:06.150><c> quite</c><00:03:06.570><c> good</c><00:03:06.600><c> enough</c>

00:03:07.009 --> 00:03:07.019 align:start position:0%
character limit isn't quite good enough
 

00:03:07.019 --> 00:03:09.050 align:start position:0%
character limit isn't quite good enough
because<00:03:07.440><c> somebody</c><00:03:07.950><c> could</c><00:03:08.100><c> still</c><00:03:08.370><c> type</c><00:03:08.609><c> a</c><00:03:08.820><c> two</c>

00:03:09.050 --> 00:03:09.060 align:start position:0%
because somebody could still type a two
 

00:03:09.060 --> 00:03:11.449 align:start position:0%
because somebody could still type a two
letter<00:03:09.269><c> code</c><00:03:09.359><c> that's</c><00:03:09.900><c> not</c><00:03:09.989><c> a</c><00:03:10.140><c> real</c><00:03:10.500><c> state</c><00:03:10.859><c> for</c>

00:03:11.449 --> 00:03:11.459 align:start position:0%
letter code that's not a real state for
 

00:03:11.459 --> 00:03:14.630 align:start position:0%
letter code that's not a real state for
example<00:03:11.880><c> in</c><00:03:12.120><c> X</c><00:03:12.650><c> to</c><00:03:13.650><c> prevent</c><00:03:13.980><c> that</c><00:03:14.130><c> we</c><00:03:14.190><c> need</c><00:03:14.549><c> to</c>

00:03:14.630 --> 00:03:14.640 align:start position:0%
example in X to prevent that we need to
 

00:03:14.640 --> 00:03:16.490 align:start position:0%
example in X to prevent that we need to
be<00:03:14.730><c> a</c><00:03:14.760><c> lot</c><00:03:15.060><c> more</c><00:03:15.090><c> specific</c><00:03:15.359><c> about</c><00:03:15.900><c> what</c><00:03:16.230><c> types</c>

00:03:16.490 --> 00:03:16.500 align:start position:0%
be a lot more specific about what types
 

00:03:16.500 --> 00:03:18.199 align:start position:0%
be a lot more specific about what types
of<00:03:16.650><c> input</c><00:03:17.010><c> this</c><00:03:17.130><c> field</c><00:03:17.400><c> will</c><00:03:17.579><c> accept</c><00:03:18.000><c> and</c>

00:03:18.199 --> 00:03:18.209 align:start position:0%
of input this field will accept and
 

00:03:18.209 --> 00:03:20.539 align:start position:0%
of input this field will accept and
we'll<00:03:18.810><c> do</c><00:03:18.989><c> that</c><00:03:19.019><c> by</c><00:03:19.200><c> adding</c><00:03:19.590><c> a</c><00:03:19.859><c> validation</c>

00:03:20.539 --> 00:03:20.549 align:start position:0%
we'll do that by adding a validation
 

00:03:20.549 --> 00:03:23.210 align:start position:0%
we'll do that by adding a validation
rule<00:03:20.760><c> in</c><00:03:21.060><c> the</c><00:03:22.049><c> fields</c><00:03:22.380><c> tab</c><00:03:22.590><c> go</c><00:03:22.950><c> to</c><00:03:22.980><c> the</c>

00:03:23.210 --> 00:03:23.220 align:start position:0%
rule in the fields tab go to the
 

00:03:23.220 --> 00:03:25.509 align:start position:0%
rule in the fields tab go to the
validation<00:03:23.390><c> command</c><00:03:24.390><c> on</c><00:03:24.540><c> the</c><00:03:24.630><c> far</c><00:03:24.660><c> right</c><00:03:25.109><c> and</c>

00:03:25.509 --> 00:03:25.519 align:start position:0%
validation command on the far right and
 

00:03:25.519 --> 00:03:30.590 align:start position:0%
validation command on the far right and
select<00:03:26.519><c> field</c><00:03:27.120><c> validation</c><00:03:27.450><c> rule</c><00:03:29.450><c> here</c><00:03:30.450><c> I'm</c>

00:03:30.590 --> 00:03:30.600 align:start position:0%
select field validation rule here I'm
 

00:03:30.600 --> 00:03:32.720 align:start position:0%
select field validation rule here I'm
going<00:03:30.870><c> to</c><00:03:30.959><c> type</c><00:03:31.260><c> each</c><00:03:31.470><c> state</c><00:03:31.920><c> abbreviation</c><00:03:32.579><c> in</c>

00:03:32.720 --> 00:03:32.730 align:start position:0%
going to type each state abbreviation in
 

00:03:32.730 --> 00:03:34.970 align:start position:0%
going to type each state abbreviation in
quotation<00:03:33.269><c> marks</c><00:03:33.299><c> and</c><00:03:33.780><c> I'm</c><00:03:34.350><c> separating</c><00:03:34.890><c> each</c>

00:03:34.970 --> 00:03:34.980 align:start position:0%
quotation marks and I'm separating each
 

00:03:34.980 --> 00:03:38.720 align:start position:0%
quotation marks and I'm separating each
one<00:03:35.489><c> with</c><00:03:35.760><c> the</c><00:03:35.910><c> word</c><00:03:36.060><c> or</c><00:03:36.299><c> and</c><00:03:37.250><c> this</c><00:03:38.250><c> may</c><00:03:38.459><c> take</c><00:03:38.670><c> a</c>

00:03:38.720 --> 00:03:38.730 align:start position:0%
one with the word or and this may take a
 

00:03:38.730 --> 00:03:41.470 align:start position:0%
one with the word or and this may take a
while

00:03:41.470 --> 00:03:41.480 align:start position:0%
 
 

00:03:41.480 --> 00:03:44.360 align:start position:0%
 
so<00:03:42.480><c> this</c><00:03:42.660><c> expression</c><00:03:42.990><c> is</c><00:03:43.350><c> just</c><00:03:43.770><c> looking</c><00:03:44.160><c> for</c>

00:03:44.360 --> 00:03:44.370 align:start position:0%
so this expression is just looking for
 

00:03:44.370 --> 00:03:46.910 align:start position:0%
so this expression is just looking for
exact<00:03:44.850><c> matches</c><00:03:45.150><c> but</c><00:03:46.050><c> if</c><00:03:46.230><c> you</c><00:03:46.350><c> want</c><00:03:46.590><c> you</c><00:03:46.800><c> can</c>

00:03:46.910 --> 00:03:46.920 align:start position:0%
exact matches but if you want you can
 

00:03:46.920 --> 00:03:48.860 align:start position:0%
exact matches but if you want you can
create<00:03:47.130><c> validation</c><00:03:47.910><c> rules</c><00:03:48.120><c> using</c><00:03:48.390><c> the</c><00:03:48.600><c> same</c>

00:03:48.860 --> 00:03:48.870 align:start position:0%
create validation rules using the same
 

00:03:48.870 --> 00:03:50.600 align:start position:0%
create validation rules using the same
syntax<00:03:49.200><c> as</c><00:03:49.530><c> that</c><00:03:49.680><c> we</c><00:03:49.770><c> talked</c><00:03:50.010><c> about</c><00:03:50.130><c> in</c><00:03:50.490><c> the</c>

00:03:50.600 --> 00:03:50.610 align:start position:0%
syntax as that we talked about in the
 

00:03:50.610 --> 00:03:52.880 align:start position:0%
syntax as that we talked about in the
query<00:03:50.850><c> lessons</c><00:03:51.270><c> for</c><00:03:52.080><c> example</c><00:03:52.530><c> you</c><00:03:52.680><c> could</c><00:03:52.860><c> use</c>

00:03:52.880 --> 00:03:52.890 align:start position:0%
query lessons for example you could use
 

00:03:52.890 --> 00:03:55.220 align:start position:0%
query lessons for example you could use
the<00:03:53.220><c> like</c><00:03:53.430><c> syntax</c><00:03:53.970><c> to</c><00:03:54.180><c> set</c><00:03:54.360><c> a</c><00:03:54.390><c> validation</c><00:03:55.020><c> rule</c>

00:03:55.220 --> 00:03:55.230 align:start position:0%
the like syntax to set a validation rule
 

00:03:55.230 --> 00:03:56.960 align:start position:0%
the like syntax to set a validation rule
that<00:03:55.410><c> only</c><00:03:55.680><c> allows</c><00:03:56.010><c> text</c><00:03:56.460><c> that</c><00:03:56.610><c> ends</c><00:03:56.850><c> with</c>

00:03:56.960 --> 00:03:56.970 align:start position:0%
that only allows text that ends with
 

00:03:56.970 --> 00:03:59.870 align:start position:0%
that only allows text that ends with
cake<00:03:57.270><c> or</c><00:03:57.930><c> if</c><00:03:58.560><c> you're</c><00:03:58.710><c> using</c><00:03:58.740><c> numerical</c><00:03:59.460><c> values</c>

00:03:59.870 --> 00:03:59.880 align:start position:0%
cake or if you're using numerical values
 

00:03:59.880 --> 00:04:02.000 align:start position:0%
cake or if you're using numerical values
you<00:04:00.270><c> could</c><00:04:00.420><c> use</c><00:04:00.660><c> greater</c><00:04:01.050><c> than</c><00:04:01.380><c> to</c><00:04:01.740><c> make</c><00:04:01.860><c> sure</c>

00:04:02.000 --> 00:04:02.010 align:start position:0%
you could use greater than to make sure
 

00:04:02.010 --> 00:04:05.550 align:start position:0%
you could use greater than to make sure
that<00:04:02.190><c> none</c><00:04:02.430><c> of</c><00:04:02.460><c> our</c><00:04:02.640><c> quantities</c><00:04:03.120><c> are</c><00:04:03.330><c> negative</c>

00:04:05.550 --> 00:04:05.560 align:start position:0%
that none of our quantities are negative
 

00:04:05.560 --> 00:04:10.330 align:start position:0%
that none of our quantities are negative
when<00:04:06.560><c> you're</c><00:04:06.680><c> done</c><00:04:06.830><c> click</c><00:04:07.250><c> okay</c><00:04:09.100><c> whenever</c><00:04:10.100><c> you</c>

00:04:10.330 --> 00:04:10.340 align:start position:0%
when you're done click okay whenever you
 

00:04:10.340 --> 00:04:12.430 align:start position:0%
when you're done click okay whenever you
create<00:04:10.580><c> a</c><00:04:10.700><c> validation</c><00:04:11.210><c> rule</c><00:04:11.390><c> it's</c><00:04:11.990><c> important</c>

00:04:12.430 --> 00:04:12.440 align:start position:0%
create a validation rule it's important
 

00:04:12.440 --> 00:04:15.100 align:start position:0%
create a validation rule it's important
to<00:04:12.500><c> create</c><00:04:12.680><c> a</c><00:04:12.890><c> validation</c><00:04:13.550><c> message</c><00:04:14.150><c> and</c><00:04:14.360><c> this</c>

00:04:15.100 --> 00:04:15.110 align:start position:0%
to create a validation message and this
 

00:04:15.110 --> 00:04:16.840 align:start position:0%
to create a validation message and this
option<00:04:15.470><c> is</c><00:04:15.590><c> also</c><00:04:15.620><c> under</c><00:04:16.160><c> the</c><00:04:16.250><c> validation</c>

00:04:16.840 --> 00:04:16.850 align:start position:0%
option is also under the validation
 

00:04:16.850 --> 00:04:19.870 align:start position:0%
option is also under the validation
command<00:04:18.130><c> this</c><00:04:19.130><c> message</c><00:04:19.489><c> will</c><00:04:19.670><c> pop</c><00:04:19.850><c> up</c>

00:04:19.870 --> 00:04:19.880 align:start position:0%
command this message will pop up
 

00:04:19.880 --> 00:04:21.580 align:start position:0%
command this message will pop up
whenever<00:04:20.270><c> somebody</c><00:04:20.750><c> tries</c><00:04:20.989><c> to</c><00:04:21.020><c> type</c><00:04:21.410><c> in</c>

00:04:21.580 --> 00:04:21.590 align:start position:0%
whenever somebody tries to type in
 

00:04:21.590 --> 00:04:22.780 align:start position:0%
whenever somebody tries to type in
something<00:04:21.860><c> that</c><00:04:22.010><c> doesn't</c><00:04:22.160><c> follow</c><00:04:22.670><c> the</c>

00:04:22.780 --> 00:04:22.790 align:start position:0%
something that doesn't follow the
 

00:04:22.790 --> 00:04:25.120 align:start position:0%
something that doesn't follow the
validation<00:04:23.480><c> rule</c><00:04:23.690><c> the</c><00:04:24.500><c> message</c><00:04:24.830><c> should</c>

00:04:25.120 --> 00:04:25.130 align:start position:0%
validation rule the message should
 

00:04:25.130 --> 00:04:26.830 align:start position:0%
validation rule the message should
briefly<00:04:25.520><c> describe</c><00:04:25.970><c> the</c><00:04:26.000><c> rule</c><00:04:26.300><c> so</c><00:04:26.600><c> that</c><00:04:26.630><c> the</c>

00:04:26.830 --> 00:04:26.840 align:start position:0%
briefly describe the rule so that the
 

00:04:26.840 --> 00:04:27.910 align:start position:0%
briefly describe the rule so that the
user<00:04:27.020><c> can</c><00:04:27.290><c> then</c><00:04:27.320><c> make</c><00:04:27.650><c> the</c><00:04:27.770><c> necessary</c>

00:04:27.910 --> 00:04:27.920 align:start position:0%
user can then make the necessary
 

00:04:27.920 --> 00:04:30.460 align:start position:0%
user can then make the necessary
Corrections<00:04:28.820><c> in</c><00:04:29.030><c> this</c><00:04:29.900><c> case</c><00:04:30.110><c> I'll</c><00:04:30.290><c> just</c>

00:04:30.460 --> 00:04:30.470 align:start position:0%
Corrections in this case I'll just
 

00:04:30.470 --> 00:04:31.930 align:start position:0%
Corrections in this case I'll just
mention<00:04:30.650><c> that</c><00:04:30.980><c> it</c><00:04:31.070><c> needs</c><00:04:31.250><c> to</c><00:04:31.340><c> be</c><00:04:31.400><c> a</c><00:04:31.520><c> two</c><00:04:31.760><c> letter</c>

00:04:31.930 --> 00:04:31.940 align:start position:0%
mention that it needs to be a two letter
 

00:04:31.940 --> 00:04:35.279 align:start position:0%
mention that it needs to be a two letter
abbreviation

00:04:35.279 --> 00:04:35.289 align:start position:0%
 
 

00:04:35.289 --> 00:04:37.299 align:start position:0%
 
now<00:04:36.289><c> you</c><00:04:36.349><c> won't</c><00:04:36.559><c> need</c><00:04:36.770><c> to</c><00:04:36.830><c> add</c><00:04:37.009><c> a</c><00:04:37.039><c> character</c>

00:04:37.299 --> 00:04:37.309 align:start position:0%
now you won't need to add a character
 

00:04:37.309 --> 00:04:39.429 align:start position:0%
now you won't need to add a character
limit<00:04:37.699><c> or</c><00:04:37.939><c> validation</c><00:04:38.360><c> rule</c><00:04:38.689><c> to</c><00:04:38.899><c> all</c><00:04:39.139><c> of</c><00:04:39.319><c> your</c>

00:04:39.429 --> 00:04:39.439 align:start position:0%
limit or validation rule to all of your
 

00:04:39.439 --> 00:04:41.559 align:start position:0%
limit or validation rule to all of your
fields<00:04:39.709><c> but</c><00:04:40.369><c> you</c><00:04:40.520><c> can</c><00:04:40.639><c> add</c><00:04:40.789><c> one</c><00:04:41.089><c> or</c><00:04:41.119><c> both</c><00:04:41.509><c> of</c>

00:04:41.559 --> 00:04:41.569 align:start position:0%
fields but you can add one or both of
 

00:04:41.569 --> 00:04:43.029 align:start position:0%
fields but you can add one or both of
them<00:04:41.839><c> whenever</c><00:04:42.110><c> you</c><00:04:42.289><c> want</c><00:04:42.469><c> to</c><00:04:42.649><c> control</c><00:04:42.979><c> the</c>

00:04:43.029 --> 00:04:43.039 align:start position:0%
them whenever you want to control the
 

00:04:43.039 --> 00:04:44.709 align:start position:0%
them whenever you want to control the
types<00:04:43.429><c> of</c><00:04:43.610><c> information</c><00:04:43.789><c> that</c><00:04:44.209><c> your</c><00:04:44.449><c> field</c>

00:04:44.709 --> 00:04:44.719 align:start position:0%
types of information that your field
 

00:04:44.719 --> 00:04:47.349 align:start position:0%
types of information that your field
will<00:04:44.929><c> accept</c>