WEBVTT
Kind: captions
Language: en

00:00:11.420 --> 00:00:13.549 align:start position:0%
 
sometimes<00:00:12.420><c> you</c><00:00:12.570><c> may</c><00:00:12.690><c> decide</c><00:00:12.990><c> that</c><00:00:13.049><c> you</c><00:00:13.320><c> want</c>

00:00:13.549 --> 00:00:13.559 align:start position:0%
sometimes you may decide that you want
 

00:00:13.559 --> 00:00:16.029 align:start position:0%
sometimes you may decide that you want
to<00:00:13.740><c> add</c><00:00:13.949><c> or</c><00:00:14.280><c> modify</c><00:00:14.639><c> fields</c><00:00:15.360><c> in</c><00:00:15.480><c> your</c><00:00:15.510><c> tables</c>

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

00:00:16.039 --> 00:00:18.380 align:start position:0%
to add or modify fields in your tables
access<00:00:17.039><c> makes</c><00:00:17.250><c> it</c><00:00:17.430><c> easy</c><00:00:17.610><c> to</c><00:00:17.730><c> do</c><00:00:17.970><c> this</c><00:00:18.150><c> although</c>

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

00:00:18.390 --> 00:00:20.179 align:start position:0%
access makes it easy to do this although
there<00:00:18.990><c> are</c><00:00:19.110><c> some</c><00:00:19.349><c> important</c><00:00:19.800><c> things</c><00:00:19.950><c> that</c>

00:00:20.179 --> 00:00:20.189 align:start position:0%
there are some important things that
 

00:00:20.189 --> 00:00:22.339 align:start position:0%
there are some important things that
you'll<00:00:20.310><c> need</c><00:00:20.430><c> to</c><00:00:20.490><c> consider</c><00:00:20.880><c> there</c><00:00:21.779><c> are</c><00:00:21.810><c> three</c>

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

00:00:22.349 --> 00:00:23.990 align:start position:0%
you'll need to consider there are three
different<00:00:22.710><c> rules</c><00:00:22.919><c> that</c><00:00:23.070><c> you</c><00:00:23.250><c> can</c><00:00:23.279><c> apply</c><00:00:23.430><c> to</c>

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

00:00:24.000 --> 00:00:25.790 align:start position:0%
different rules that you can apply to
control<00:00:24.449><c> the</c><00:00:24.599><c> type</c><00:00:24.779><c> of</c><00:00:24.960><c> data</c><00:00:25.169><c> that</c><00:00:25.259><c> the</c><00:00:25.410><c> fields</c>

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

00:00:25.800 --> 00:00:28.269 align:start position:0%
control the type of data that the fields
can<00:00:25.980><c> accept</c><00:00:26.369><c> and</c><00:00:26.610><c> these</c><00:00:27.180><c> are</c><00:00:27.390><c> data</c><00:00:27.809><c> types</c>

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

00:00:28.279 --> 00:00:32.359 align:start position:0%
can accept and these are data types
character<00:00:29.279><c> limits</c><00:00:29.610><c> and</c><00:00:29.869><c> validation</c><00:00:30.869><c> rules</c>

00:00:32.359 --> 00:00:32.369 align:start position:0%
character limits and validation rules
 

00:00:32.369 --> 00:00:34.400 align:start position:0%
character limits and validation rules
to<00:00:33.059><c> get</c><00:00:33.180><c> started</c><00:00:33.329><c> make</c><00:00:33.809><c> sure</c><00:00:33.840><c> that</c><00:00:34.199><c> you</c><00:00:34.260><c> have</c><00:00:34.379><c> a</c>

00:00:34.400 --> 00:00:34.410 align:start position:0%
to get started make sure that you have a
 

00:00:34.410 --> 00:00:37.280 align:start position:0%
to get started make sure that you have a
table<00:00:34.649><c> open</c><00:00:34.949><c> I'm</c><00:00:35.520><c> using</c><00:00:35.820><c> the</c><00:00:36.239><c> customers</c><00:00:36.809><c> table</c>

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

00:00:37.290 --> 00:00:39.740 align:start position:0%
table open I'm using the customers table
we're<00:00:38.250><c> going</c><00:00:38.399><c> to</c><00:00:38.670><c> scroll</c><00:00:39.000><c> all</c><00:00:39.210><c> the</c><00:00:39.329><c> way</c><00:00:39.480><c> to</c><00:00:39.600><c> the</c>

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

00:00:39.750 --> 00:00:41.750 align:start position:0%
we're going to scroll all the way to the
right<00:00:39.989><c> until</c><00:00:40.379><c> you</c><00:00:40.440><c> see</c><00:00:40.710><c> a</c><00:00:40.739><c> blank</c><00:00:41.190><c> field</c><00:00:41.519><c> that</c>

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

00:00:41.760 --> 00:00:44.840 align:start position:0%
right until you see a blank field that
says<00:00:41.940><c> click</c><00:00:42.390><c> to</c><00:00:42.420><c> add</c><00:00:42.600><c> and</c><00:00:43.460><c> when</c><00:00:44.460><c> you</c><00:00:44.519><c> click</c><00:00:44.730><c> on</c>

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

00:00:44.850 --> 00:00:46.549 align:start position:0%
says click to add and when you click on
it<00:00:44.910><c> you'll</c><00:00:45.120><c> see</c><00:00:45.210><c> a</c><00:00:45.360><c> list</c><00:00:45.719><c> of</c><00:00:45.899><c> all</c><00:00:46.079><c> of</c><00:00:46.110><c> the</c><00:00:46.350><c> data</c>

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

00:00:46.559 --> 00:00:49.160 align:start position:0%
it you'll see a list of all of the data
types<00:00:46.829><c> that</c><00:00:46.980><c> you</c><00:00:47.129><c> can</c><00:00:47.160><c> choose</c><00:00:47.489><c> from</c><00:00:48.019><c> text</c><00:00:49.019><c> is</c>

00:00:49.160 --> 00:00:49.170 align:start position:0%
types that you can choose from text is
 

00:00:49.170 --> 00:00:51.530 align:start position:0%
types that you can choose from text is
the<00:00:49.470><c> default</c><00:00:49.769><c> option</c><00:00:50.010><c> and</c><00:00:50.370><c> this</c><00:00:51.030><c> is</c><00:00:51.180><c> the</c><00:00:51.329><c> type</c>

00:00:51.530 --> 00:00:51.540 align:start position:0%
the default option and this is the type
 

00:00:51.540 --> 00:00:53.600 align:start position:0%
the default option and this is the type
that<00:00:51.570><c> you'll</c><00:00:51.870><c> use</c><00:00:52.110><c> for</c><00:00:52.140><c> regular</c><00:00:52.649><c> text</c><00:00:53.100><c> such</c><00:00:53.579><c> as</c>

00:00:53.600 --> 00:00:53.610 align:start position:0%
that you'll use for regular text such as
 

00:00:53.610 --> 00:00:56.210 align:start position:0%
that you'll use for regular text such as
a<00:00:53.820><c> person's</c><00:00:53.970><c> name</c><00:00:54.510><c> or</c><00:00:54.750><c> address</c><00:00:55.199><c> you'll</c><00:00:56.010><c> also</c>

00:00:56.210 --> 00:00:56.220 align:start position:0%
a person's name or address you'll also
 

00:00:56.220 --> 00:00:57.979 align:start position:0%
a person's name or address you'll also
use<00:00:56.399><c> it</c><00:00:56.729><c> for</c><00:00:56.760><c> numbers</c><00:00:57.180><c> that</c><00:00:57.360><c> aren't</c><00:00:57.629><c> used</c><00:00:57.839><c> in</c>

00:00:57.979 --> 00:00:57.989 align:start position:0%
use it for numbers that aren't used in
 

00:00:57.989 --> 00:01:00.319 align:start position:0%
use it for numbers that aren't used in
calculations<00:00:58.500><c> like</c><00:00:59.070><c> a</c><00:00:59.100><c> phone</c><00:00:59.399><c> number</c><00:00:59.430><c> or</c><00:00:59.940><c> zip</c>

00:01:00.319 --> 00:01:00.329 align:start position:0%
calculations like a phone number or zip
 

00:01:00.329 --> 00:01:02.780 align:start position:0%
calculations like a phone number or zip
code<00:01:00.649><c> for</c><00:01:01.649><c> any</c><00:01:01.799><c> numbers</c><00:01:02.129><c> that</c><00:01:02.159><c> you</c><00:01:02.399><c> might</c><00:01:02.579><c> want</c>

00:01:02.780 --> 00:01:02.790 align:start position:0%
code for any numbers that you might want
 

00:01:02.790 --> 00:01:04.579 align:start position:0%
code for any numbers that you might want
to<00:01:02.850><c> do</c><00:01:02.969><c> calculations</c><00:01:03.210><c> with</c><00:01:03.839><c> you'll</c><00:01:04.259><c> need</c><00:01:04.470><c> to</c>

00:01:04.579 --> 00:01:04.589 align:start position:0%
to do calculations with you'll need to
 

00:01:04.589 --> 00:01:06.889 align:start position:0%
to do calculations with you'll need to
choose<00:01:04.830><c> number</c><00:01:05.190><c> for</c><00:01:06.090><c> example</c><00:01:06.450><c> we</c><00:01:06.600><c> would</c><00:01:06.720><c> use</c>

00:01:06.889 --> 00:01:06.899 align:start position:0%
choose number for example we would use
 

00:01:06.899 --> 00:01:08.719 align:start position:0%
choose number for example we would use
this<00:01:07.080><c> for</c><00:01:07.380><c> the</c><00:01:07.500><c> quantities</c><00:01:08.070><c> of</c><00:01:08.220><c> an</c><00:01:08.310><c> item</c><00:01:08.490><c> that</c>

00:01:08.719 --> 00:01:08.729 align:start position:0%
this for the quantities of an item that
 

00:01:08.729 --> 00:01:11.060 align:start position:0%
this for the quantities of an item that
we're<00:01:08.910><c> sold</c><00:01:09.210><c> if</c><00:01:09.509><c> you're</c><00:01:10.440><c> dealing</c><00:01:10.590><c> with</c><00:01:10.740><c> money</c>

00:01:11.060 --> 00:01:11.070 align:start position:0%
we're sold if you're dealing with money
 

00:01:11.070 --> 00:01:13.639 align:start position:0%
we're sold if you're dealing with money
then<00:01:11.460><c> you'll</c><00:01:11.640><c> choose</c><00:01:11.850><c> currency</c><00:01:12.360><c> and</c><00:01:12.720><c> if</c><00:01:13.530><c> you</c>

00:01:13.639 --> 00:01:13.649 align:start position:0%
then you'll choose currency and if you
 

00:01:13.649 --> 00:01:15.139 align:start position:0%
then you'll choose currency and if you
choose<00:01:13.800><c> date</c><00:01:14.100><c> and</c><00:01:14.280><c> time</c><00:01:14.460><c> then</c><00:01:14.820><c> when</c><00:01:15.030><c> you're</c>

00:01:15.139 --> 00:01:15.149 align:start position:0%
choose date and time then when you're
 

00:01:15.149 --> 00:01:16.639 align:start position:0%
choose date and time then when you're
editing<00:01:15.300><c> that</c><00:01:15.630><c> field</c><00:01:15.929><c> you'll</c><00:01:16.140><c> see</c><00:01:16.350><c> a</c><00:01:16.380><c> calendar</c>

00:01:16.639 --> 00:01:16.649 align:start position:0%
editing that field you'll see a calendar
 

00:01:16.649 --> 00:01:18.710 align:start position:0%
editing that field you'll see a calendar
icon<00:01:17.220><c> which</c><00:01:17.490><c> you</c><00:01:17.640><c> can</c><00:01:17.820><c> click</c><00:01:18.090><c> to</c><00:01:18.119><c> select</c><00:01:18.479><c> a</c>

00:01:18.710 --> 00:01:18.720 align:start position:0%
icon which you can click to select a
 

00:01:18.720 --> 00:01:21.050 align:start position:0%
icon which you can click to select a
date<00:01:18.899><c> but</c><00:01:19.710><c> in</c><00:01:19.920><c> this</c><00:01:20.009><c> case</c><00:01:20.250><c> I</c><00:01:20.490><c> just</c><00:01:20.520><c> want</c><00:01:20.729><c> a</c>

00:01:21.050 --> 00:01:21.060 align:start position:0%
date but in this case I just want a
 

00:01:21.060 --> 00:01:23.480 align:start position:0%
date but in this case I just want a
simple<00:01:21.479><c> yes</c><00:01:21.750><c> or</c><00:01:21.899><c> no</c><00:01:21.960><c> answer</c><00:01:22.409><c> so</c><00:01:22.860><c> I'll</c><00:01:23.159><c> choose</c>

00:01:23.480 --> 00:01:23.490 align:start position:0%
simple yes or no answer so I'll choose
 

00:01:23.490 --> 00:01:26.090 align:start position:0%
simple yes or no answer so I'll choose
this<00:01:23.789><c> one</c><00:01:23.850><c> and</c><00:01:24.179><c> this</c><00:01:24.840><c> adds</c><00:01:25.050><c> a</c><00:01:25.380><c> checkbox</c><00:01:25.890><c> for</c>

00:01:26.090 --> 00:01:26.100 align:start position:0%
this one and this adds a checkbox for
 

00:01:26.100 --> 00:01:28.550 align:start position:0%
this one and this adds a checkbox for
each<00:01:26.340><c> record</c><00:01:26.780><c> then</c><00:01:27.780><c> you</c><00:01:27.810><c> can</c><00:01:28.170><c> type</c><00:01:28.350><c> in</c><00:01:28.530><c> the</c>

00:01:28.550 --> 00:01:28.560 align:start position:0%
each record then you can type in the
 

00:01:28.560 --> 00:01:30.469 align:start position:0%
each record then you can type in the
name<00:01:28.649><c> of</c><00:01:28.860><c> your</c><00:01:29.130><c> field</c><00:01:29.369><c> I'm</c><00:01:29.610><c> going</c><00:01:30.179><c> to</c><00:01:30.270><c> name</c><00:01:30.450><c> it</c>

00:01:30.469 --> 00:01:30.479 align:start position:0%
name of your field I'm going to name it
 

00:01:30.479 --> 00:01:33.450 align:start position:0%
name of your field I'm going to name it
add<00:01:30.750><c> to</c><00:01:31.170><c> mailing</c><00:01:31.319><c> list</c>

00:01:33.450 --> 00:01:33.460 align:start position:0%
add to mailing list
 

00:01:33.460 --> 00:01:37.700 align:start position:0%
add to mailing list
then<00:01:34.150><c> I'll</c><00:01:34.330><c> resize</c><00:01:34.840><c> this</c><00:01:35.110><c> field</c>

00:01:37.700 --> 00:01:37.710 align:start position:0%
 
 

00:01:37.710 --> 00:01:39.830 align:start position:0%
 
now<00:01:38.040><c> we</c><00:01:38.100><c> can</c><00:01:38.430><c> just</c><00:01:38.460><c> check</c><00:01:38.910><c> each</c><00:01:39.060><c> customer</c><00:01:39.690><c> who</c>

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

00:01:39.840 --> 00:01:43.040 align:start position:0%
now we can just check each customer who
wants<00:01:40.080><c> to</c><00:01:40.110><c> be</c><00:01:40.290><c> on</c><00:01:40.440><c> our</c><00:01:40.560><c> mailing</c><00:01:40.680><c> list</c><00:01:40.860><c> and</c><00:01:42.050><c> you</c>

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

00:01:43.050 --> 00:01:44.930 align:start position:0%
wants to be on our mailing list and you
can<00:01:43.170><c> also</c><00:01:43.290><c> click</c><00:01:43.620><c> and</c><00:01:43.740><c> drag</c><00:01:43.950><c> the</c><00:01:44.310><c> name</c><00:01:44.520><c> to</c><00:01:44.790><c> move</c>

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

00:01:44.940 --> 00:01:47.720 align:start position:0%
can also click and drag the name to move
the<00:01:45.090><c> field</c><00:01:45.270><c> wherever</c><00:01:45.570><c> you</c><00:01:45.840><c> like</c><00:01:46.050><c> if</c><00:01:46.730><c> you</c>

00:01:47.720 --> 00:01:47.730 align:start position:0%
the field wherever you like if you
 

00:01:47.730 --> 00:01:49.340 align:start position:0%
the field wherever you like if you
decide<00:01:48.090><c> that</c><00:01:48.120><c> you</c><00:01:48.390><c> need</c><00:01:48.600><c> a</c><00:01:48.630><c> different</c><00:01:49.140><c> data</c>

00:01:49.340 --> 00:01:49.350 align:start position:0%
decide that you need a different data
 

00:01:49.350 --> 00:01:50.990 align:start position:0%
decide that you need a different data
type<00:01:49.590><c> for</c><00:01:49.800><c> a</c><00:01:49.830><c> field</c><00:01:50.100><c> then</c><00:01:50.490><c> you</c><00:01:50.700><c> can</c><00:01:50.850><c> just</c>

00:01:50.990 --> 00:01:51.000 align:start position:0%
type for a field then you can just
 

00:01:51.000 --> 00:01:53.719 align:start position:0%
type for a field then you can just
select<00:01:51.180><c> it</c><00:01:51.510><c> and</c><00:01:51.660><c> then</c><00:01:52.380><c> go</c><00:01:52.590><c> to</c><00:01:52.650><c> the</c><00:01:52.979><c> fields</c><00:01:53.430><c> tab</c>

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

00:01:53.729 --> 00:01:56.650 align:start position:0%
select it and then go to the fields tab
and<00:01:54.030><c> click</c><00:01:54.870><c> the</c><00:01:55.020><c> data</c><00:01:55.229><c> type</c><00:01:55.500><c> drop-down</c><00:01:55.920><c> arrow</c>

00:01:56.650 --> 00:01:56.660 align:start position:0%
and click the data type drop-down arrow
 

00:01:56.660 --> 00:01:59.390 align:start position:0%
and click the data type drop-down arrow
I'm<00:01:57.660><c> going</c><00:01:57.930><c> to</c><00:01:57.990><c> change</c><00:01:58.260><c> this</c><00:01:58.500><c> to</c><00:01:58.680><c> text</c><00:01:59.160><c> so</c><00:01:59.369><c> I</c>

00:01:59.390 --> 00:01:59.400 align:start position:0%
I'm going to change this to text so I
 

00:01:59.400 --> 00:02:01.040 align:start position:0%
I'm going to change this to text so I
can<00:01:59.580><c> add</c><00:01:59.729><c> additional</c><00:01:59.910><c> information</c><00:02:00.330><c> in</c><00:02:00.930><c> this</c>

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

00:02:01.050 --> 00:02:03.830 align:start position:0%
can add additional information in this
field<00:02:01.910><c> some</c><00:02:02.910><c> of</c><00:02:03.030><c> our</c><00:02:03.150><c> customers</c><00:02:03.570><c> want</c><00:02:03.780><c> to</c>

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

00:02:03.840 --> 00:02:06.200 align:start position:0%
field some of our customers want to
receive<00:02:04.140><c> our</c><00:02:04.260><c> weekly</c><00:02:04.590><c> newsletter</c><00:02:05.010><c> but</c><00:02:05.820><c> others</c>

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

00:02:06.210 --> 00:02:07.609 align:start position:0%
receive our weekly newsletter but others
just<00:02:06.479><c> want</c><00:02:06.690><c> to</c><00:02:06.780><c> hear</c><00:02:06.930><c> about</c><00:02:07.020><c> our</c><00:02:07.140><c> special</c>

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

00:02:07.619 --> 00:02:10.370 align:start position:0%
just want to hear about our special
events<00:02:08.300><c> now</c><00:02:09.300><c> you</c><00:02:09.360><c> should</c><00:02:09.570><c> be</c><00:02:09.660><c> very</c><00:02:09.989><c> careful</c>

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

00:02:10.380 --> 00:02:12.380 align:start position:0%
events now you should be very careful
about<00:02:10.410><c> changing</c><00:02:11.070><c> the</c><00:02:11.160><c> data</c><00:02:11.280><c> type</c><00:02:11.610><c> because</c><00:02:12.270><c> it</c>

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

00:02:12.390 --> 00:02:14.120 align:start position:0%
about changing the data type because it
is<00:02:12.510><c> possible</c><00:02:12.989><c> to</c><00:02:13.020><c> lose</c><00:02:13.320><c> some</c><00:02:13.560><c> of</c><00:02:13.650><c> your</c><00:02:13.770><c> data</c><00:02:13.920><c> if</c>

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

00:02:14.130 --> 00:02:16.880 align:start position:0%
is possible to lose some of your data if
you<00:02:14.220><c> change</c><00:02:14.459><c> it</c><00:02:14.550><c> to</c><00:02:14.670><c> the</c><00:02:14.760><c> wrong</c><00:02:14.910><c> type</c><00:02:15.270><c> in</c><00:02:15.890><c> some</c>

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

00:02:16.890 --> 00:02:18.410 align:start position:0%
you change it to the wrong type in some
fields<00:02:17.250><c> you</c><00:02:17.370><c> may</c><00:02:17.520><c> want</c><00:02:17.730><c> to</c><00:02:17.790><c> narrow</c><00:02:18.000><c> down</c><00:02:18.270><c> the</c>

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

00:02:18.420 --> 00:02:20.270 align:start position:0%
fields you may want to narrow down the
data<00:02:18.450><c> even</c><00:02:18.989><c> further</c><00:02:19.260><c> by</c><00:02:19.620><c> adding</c><00:02:19.800><c> a</c><00:02:20.040><c> character</c>

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

00:02:20.280 --> 00:02:22.910 align:start position:0%
data even further by adding a character
limit<00:02:20.790><c> and</c><00:02:20.940><c> you</c><00:02:21.420><c> can</c><00:02:21.540><c> only</c><00:02:21.750><c> do</c><00:02:22.050><c> this</c><00:02:22.200><c> with</c><00:02:22.470><c> text</c>

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

00:02:22.920 --> 00:02:25.430 align:start position:0%
limit and you can only do this with text
fields<00:02:23.340><c> for</c><00:02:24.150><c> example</c><00:02:24.180><c> we</c><00:02:24.720><c> want</c><00:02:24.930><c> all</c><00:02:25.110><c> of</c><00:02:25.320><c> the</c>

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

00:02:25.440 --> 00:02:27.740 align:start position:0%
fields for example we want all of the
states<00:02:25.739><c> to</c><00:02:25.860><c> be</c><00:02:25.950><c> formatted</c><00:02:26.370><c> the</c><00:02:26.610><c> same</c><00:02:26.880><c> way</c><00:02:27.150><c> so</c>

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

00:02:27.750 --> 00:02:29.810 align:start position:0%
states to be formatted the same way so
we're<00:02:28.050><c> only</c><00:02:28.230><c> using</c><00:02:28.590><c> the</c><00:02:28.950><c> two-letter</c><00:02:29.370><c> state</c>

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

00:02:29.820 --> 00:02:32.180 align:start position:0%
we're only using the two-letter state
abbreviations<00:02:30.570><c> if</c><00:02:31.290><c> some</c><00:02:31.530><c> of</c><00:02:31.620><c> the</c><00:02:31.709><c> records</c><00:02:31.980><c> say</c>

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

00:02:32.190 --> 00:02:35.060 align:start position:0%
abbreviations if some of the records say
in<00:02:32.430><c> C</c><00:02:32.820><c> and</c><00:02:33.090><c> others</c><00:02:33.690><c> say</c><00:02:33.930><c> North</c><00:02:34.170><c> Carolina</c><00:02:34.590><c> then</c>

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

00:02:35.070 --> 00:02:36.860 align:start position:0%
in C and others say North Carolina then
access<00:02:35.610><c> won't</c><00:02:35.910><c> know</c><00:02:36.150><c> to</c><00:02:36.209><c> group</c><00:02:36.510><c> them</c><00:02:36.690><c> together</c>

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

00:02:36.870 --> 00:02:39.199 align:start position:0%
access won't know to group them together
which<00:02:37.650><c> means</c><00:02:37.830><c> our</c><00:02:38.070><c> sorts</c><00:02:38.489><c> filters</c><00:02:38.970><c> and</c>

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

00:02:39.209 --> 00:02:41.960 align:start position:0%
which means our sorts filters and
queries<00:02:39.540><c> may</c><00:02:39.750><c> not</c><00:02:39.900><c> work</c><00:02:40.140><c> right</c><00:02:40.380><c> in</c><00:02:40.650><c> the</c><00:02:41.640><c> fields</c>

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

00:02:41.970 --> 00:02:45.140 align:start position:0%
queries may not work right in the fields
tab<00:02:42.209><c> find</c><00:02:42.660><c> the</c><00:02:42.840><c> field</c><00:02:43.200><c> size</c><00:02:43.530><c> box</c><00:02:43.920><c> the</c><00:02:44.760><c> default</c>

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

00:02:45.150 --> 00:02:48.530 align:start position:0%
tab find the field size box the default
field<00:02:45.540><c> size</c><00:02:45.810><c> is</c><00:02:46.190><c> 255</c><00:02:47.190><c> characters</c><00:02:47.489><c> but</c><00:02:48.330><c> I'm</c>

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

00:02:48.540 --> 00:02:51.170 align:start position:0%
field size is 255 characters but I'm
going<00:02:48.750><c> to</c><00:02:48.810><c> change</c><00:02:49.170><c> it</c><00:02:49.320><c> to</c><00:02:49.350><c> 2</c>

00:02:51.170 --> 00:02:51.180 align:start position:0%
going to change it to 2
 

00:02:51.180 --> 00:02:53.240 align:start position:0%
going to change it to 2
and<00:02:51.390><c> you</c><00:02:52.079><c> may</c><00:02:52.230><c> get</c><00:02:52.379><c> a</c><00:02:52.409><c> warning</c><00:02:52.470><c> message</c><00:02:52.769><c> here</c>

00:02:53.240 --> 00:02:53.250 align:start position:0%
and you may get a warning message here
 

00:02:53.250 --> 00:02:54.949 align:start position:0%
and you may get a warning message here
so<00:02:53.610><c> if</c><00:02:53.790><c> you're</c><00:02:53.909><c> sure</c><00:02:54.150><c> you</c><00:02:54.269><c> want</c><00:02:54.480><c> to</c><00:02:54.540><c> change</c><00:02:54.780><c> the</c>

00:02:54.949 --> 00:02:54.959 align:start position:0%
so if you're sure you want to change the
 

00:02:54.959 --> 00:02:58.009 align:start position:0%
so if you're sure you want to change the
field<00:02:55.170><c> size</c><00:02:55.379><c> click</c><00:02:55.799><c> yes</c><00:02:56.069><c> in</c><00:02:56.959><c> this</c><00:02:57.959><c> case</c>

00:02:58.009 --> 00:02:58.019 align:start position:0%
field size click yes in this case
 

00:02:58.019 --> 00:02:59.990 align:start position:0%
field size click yes in this case
setting<00:02:58.650><c> a</c><00:02:58.739><c> character</c><00:02:59.159><c> limit</c><00:02:59.310><c> isn't</c><00:02:59.730><c> quite</c>

00:02:59.990 --> 00:03:00.000 align:start position:0%
setting a character limit isn't quite
 

00:03:00.000 --> 00:03:01.759 align:start position:0%
setting a character limit isn't quite
good<00:03:00.209><c> enough</c><00:03:00.420><c> because</c><00:03:00.840><c> somebody</c><00:03:01.349><c> could</c><00:03:01.530><c> still</c>

00:03:01.759 --> 00:03:01.769 align:start position:0%
good enough because somebody could still
 

00:03:01.769 --> 00:03:03.920 align:start position:0%
good enough because somebody could still
type<00:03:02.040><c> a</c><00:03:02.250><c> two</c><00:03:02.489><c> letter</c><00:03:02.700><c> code</c><00:03:02.790><c> that's</c><00:03:03.329><c> not</c><00:03:03.540><c> a</c><00:03:03.569><c> real</c>

00:03:03.920 --> 00:03:03.930 align:start position:0%
type a two letter code that's not a real
 

00:03:03.930 --> 00:03:07.429 align:start position:0%
type a two letter code that's not a real
state<00:03:04.290><c> for</c><00:03:04.980><c> example</c><00:03:05.069><c> in</c><00:03:05.640><c> X</c><00:03:06.090><c> to</c><00:03:06.989><c> prevent</c><00:03:07.290><c> that</c>

00:03:07.429 --> 00:03:07.439 align:start position:0%
state for example in X to prevent that
 

00:03:07.439 --> 00:03:09.199 align:start position:0%
state for example in X to prevent that
we<00:03:07.650><c> need</c><00:03:07.859><c> to</c><00:03:07.950><c> be</c><00:03:08.040><c> a</c><00:03:08.069><c> lot</c><00:03:08.370><c> more</c><00:03:08.400><c> specific</c><00:03:08.670><c> about</c>

00:03:09.199 --> 00:03:09.209 align:start position:0%
we need to be a lot more specific about
 

00:03:09.209 --> 00:03:10.880 align:start position:0%
we need to be a lot more specific about
what<00:03:09.569><c> types</c><00:03:09.810><c> of</c><00:03:09.989><c> input</c><00:03:10.319><c> this</c><00:03:10.439><c> field</c><00:03:10.709><c> will</c>

00:03:10.880 --> 00:03:10.890 align:start position:0%
what types of input this field will
 

00:03:10.890 --> 00:03:13.280 align:start position:0%
what types of input this field will
accept<00:03:11.310><c> and</c><00:03:11.549><c> we'll</c><00:03:12.239><c> do</c><00:03:12.420><c> that</c><00:03:12.569><c> by</c><00:03:12.810><c> adding</c><00:03:13.019><c> a</c>

00:03:13.280 --> 00:03:13.290 align:start position:0%
accept and we'll do that by adding a
 

00:03:13.290 --> 00:03:16.220 align:start position:0%
accept and we'll do that by adding a
validation<00:03:13.980><c> rule</c><00:03:14.189><c> in</c><00:03:14.430><c> the</c><00:03:15.269><c> fields</c><00:03:15.599><c> tab</c><00:03:15.810><c> go</c><00:03:16.200><c> to</c>

00:03:16.220 --> 00:03:16.230 align:start position:0%
validation rule in the fields tab go to
 

00:03:16.230 --> 00:03:18.349 align:start position:0%
validation rule in the fields tab go to
the<00:03:16.439><c> validation</c><00:03:16.609><c> command</c><00:03:17.609><c> on</c><00:03:17.760><c> the</c><00:03:17.879><c> far</c><00:03:17.909><c> right</c>

00:03:18.349 --> 00:03:18.359 align:start position:0%
the validation command on the far right
 

00:03:18.359 --> 00:03:22.550 align:start position:0%
the validation command on the far right
and<00:03:18.530><c> select</c><00:03:19.530><c> field</c><00:03:20.159><c> validation</c><00:03:20.849><c> rule</c>

00:03:22.550 --> 00:03:22.560 align:start position:0%
and select field validation rule
 

00:03:22.560 --> 00:03:24.949 align:start position:0%
and select field validation rule
here<00:03:23.489><c> I'm</c><00:03:23.640><c> going</c><00:03:23.910><c> to</c><00:03:24.000><c> type</c><00:03:24.239><c> each</c><00:03:24.480><c> state</c>

00:03:24.949 --> 00:03:24.959 align:start position:0%
here I'm going to type each state
 

00:03:24.959 --> 00:03:27.350 align:start position:0%
here I'm going to type each state
abbreviation<00:03:25.590><c> in</c><00:03:25.770><c> quotation</c><00:03:26.310><c> marks</c><00:03:26.610><c> and</c><00:03:26.790><c> I'm</c>

00:03:27.350 --> 00:03:27.360 align:start position:0%
abbreviation in quotation marks and I'm
 

00:03:27.360 --> 00:03:30.280 align:start position:0%
abbreviation in quotation marks and I'm
separating<00:03:27.930><c> each</c><00:03:28.110><c> one</c><00:03:28.500><c> with</c><00:03:28.800><c> the</c><00:03:28.920><c> word</c><00:03:29.099><c> or</c><00:03:29.340><c> and</c>

00:03:30.280 --> 00:03:30.290 align:start position:0%
separating each one with the word or and
 

00:03:30.290 --> 00:03:34.699 align:start position:0%
separating each one with the word or and
this<00:03:31.290><c> may</c><00:03:31.500><c> take</c><00:03:31.709><c> a</c><00:03:31.770><c> while</c><00:03:33.200><c> so</c><00:03:34.200><c> this</c><00:03:34.349><c> expression</c>

00:03:34.699 --> 00:03:34.709 align:start position:0%
this may take a while so this expression
 

00:03:34.709 --> 00:03:37.940 align:start position:0%
this may take a while so this expression
is<00:03:35.069><c> just</c><00:03:35.489><c> looking</c><00:03:35.880><c> for</c><00:03:36.120><c> exact</c><00:03:36.599><c> matches</c><00:03:37.080><c> but</c><00:03:37.739><c> if</c>

00:03:37.940 --> 00:03:37.950 align:start position:0%
is just looking for exact matches but if
 

00:03:37.950 --> 00:03:39.860 align:start position:0%
is just looking for exact matches but if
you<00:03:38.069><c> want</c><00:03:38.310><c> you</c><00:03:38.520><c> can</c><00:03:38.640><c> create</c><00:03:38.910><c> validation</c><00:03:39.630><c> rules</c>

00:03:39.860 --> 00:03:39.870 align:start position:0%
you want you can create validation rules
 

00:03:39.870 --> 00:03:41.720 align:start position:0%
you want you can create validation rules
using<00:03:40.230><c> the</c><00:03:40.319><c> same</c><00:03:40.590><c> syntax</c><00:03:40.920><c> as</c><00:03:41.280><c> that</c><00:03:41.430><c> we</c><00:03:41.519><c> talked</c>

00:03:41.720 --> 00:03:41.730 align:start position:0%
using the same syntax as that we talked
 

00:03:41.730 --> 00:03:44.240 align:start position:0%
using the same syntax as that we talked
about<00:03:41.880><c> in</c><00:03:42.209><c> the</c><00:03:42.330><c> query</c><00:03:42.569><c> lessons</c><00:03:43.019><c> for</c><00:03:43.830><c> example</c>

00:03:44.240 --> 00:03:44.250 align:start position:0%
about in the query lessons for example
 

00:03:44.250 --> 00:03:46.100 align:start position:0%
about in the query lessons for example
you<00:03:44.400><c> could</c><00:03:44.550><c> use</c><00:03:44.610><c> the</c><00:03:44.940><c> like</c><00:03:45.180><c> syntax</c><00:03:45.510><c> to</c><00:03:45.930><c> set</c><00:03:46.080><c> a</c>

00:03:46.100 --> 00:03:46.110 align:start position:0%
you could use the like syntax to set a
 

00:03:46.110 --> 00:03:48.050 align:start position:0%
you could use the like syntax to set a
validation<00:03:46.620><c> rule</c><00:03:46.769><c> that</c><00:03:47.160><c> only</c><00:03:47.519><c> allows</c><00:03:47.760><c> text</c>

00:03:48.050 --> 00:03:48.060 align:start position:0%
validation rule that only allows text
 

00:03:48.060 --> 00:03:50.420 align:start position:0%
validation rule that only allows text
that<00:03:48.360><c> ends</c><00:03:48.599><c> with</c><00:03:48.690><c> cake</c><00:03:48.989><c> or</c><00:03:49.290><c> if</c><00:03:50.069><c> you're</c><00:03:50.250><c> using</c>

00:03:50.420 --> 00:03:50.430 align:start position:0%
that ends with cake or if you're using
 

00:03:50.430 --> 00:03:52.580 align:start position:0%
that ends with cake or if you're using
numerical<00:03:51.030><c> values</c><00:03:51.390><c> you</c><00:03:51.810><c> could</c><00:03:51.989><c> use</c><00:03:52.200><c> greater</c>

00:03:52.580 --> 00:03:52.590 align:start position:0%
numerical values you could use greater
 

00:03:52.590 --> 00:03:54.170 align:start position:0%
numerical values you could use greater
than<00:03:52.890><c> to</c><00:03:53.280><c> make</c><00:03:53.400><c> sure</c><00:03:53.550><c> that</c><00:03:53.730><c> none</c><00:03:53.970><c> of</c><00:03:54.000><c> our</c>

00:03:54.170 --> 00:03:54.180 align:start position:0%
than to make sure that none of our
 

00:03:54.180 --> 00:03:57.289 align:start position:0%
than to make sure that none of our
quantities<00:03:54.690><c> are</c><00:03:54.870><c> negative</c><00:03:56.060><c> when</c><00:03:57.060><c> you're</c><00:03:57.180><c> done</c>

00:03:57.289 --> 00:03:57.299 align:start position:0%
quantities are negative when you're done
 

00:03:57.299 --> 00:03:59.339 align:start position:0%
quantities are negative when you're done
click<00:03:57.750><c> OK</c>

00:03:59.339 --> 00:03:59.349 align:start position:0%
click OK
 

00:03:59.349 --> 00:04:01.289 align:start position:0%
click OK
whenever<00:04:00.129><c> you</c><00:04:00.249><c> create</c><00:04:00.430><c> a</c><00:04:00.640><c> validation</c><00:04:01.120><c> rule</c>

00:04:01.289 --> 00:04:01.299 align:start position:0%
whenever you create a validation rule
 

00:04:01.299 --> 00:04:03.479 align:start position:0%
whenever you create a validation rule
it's<00:04:01.900><c> important</c><00:04:02.349><c> to</c><00:04:02.439><c> create</c><00:04:02.590><c> a</c><00:04:02.799><c> validation</c>

00:04:03.479 --> 00:04:03.489 align:start position:0%
it's important to create a validation
 

00:04:03.489 --> 00:04:05.879 align:start position:0%
it's important to create a validation
message<00:04:04.060><c> and</c><00:04:04.299><c> this</c><00:04:04.840><c> option</c><00:04:05.049><c> is</c><00:04:05.290><c> also</c><00:04:05.469><c> under</c>

00:04:05.879 --> 00:04:05.889 align:start position:0%
message and this option is also under
 

00:04:05.889 --> 00:04:08.759 align:start position:0%
message and this option is also under
the<00:04:05.980><c> validation</c><00:04:06.549><c> command</c><00:04:07.260><c> this</c><00:04:08.260><c> message</c><00:04:08.590><c> will</c>

00:04:08.759 --> 00:04:08.769 align:start position:0%
the validation command this message will
 

00:04:08.769 --> 00:04:10.470 align:start position:0%
the validation command this message will
pop<00:04:08.950><c> up</c><00:04:08.980><c> whenever</c><00:04:09.370><c> somebody</c><00:04:09.849><c> tries</c><00:04:10.090><c> to</c><00:04:10.120><c> type</c>

00:04:10.470 --> 00:04:10.480 align:start position:0%
pop up whenever somebody tries to type
 

00:04:10.480 --> 00:04:11.879 align:start position:0%
pop up whenever somebody tries to type
in<00:04:10.689><c> something</c><00:04:10.959><c> that</c><00:04:11.109><c> doesn't</c><00:04:11.260><c> follow</c><00:04:11.739><c> the</c>

00:04:11.879 --> 00:04:11.889 align:start position:0%
in something that doesn't follow the
 

00:04:11.889 --> 00:04:14.099 align:start position:0%
in something that doesn't follow the
validation<00:04:12.579><c> rule</c><00:04:12.790><c> the</c><00:04:13.510><c> message</c><00:04:13.840><c> should</c>

00:04:14.099 --> 00:04:14.109 align:start position:0%
validation rule the message should
 

00:04:14.109 --> 00:04:15.839 align:start position:0%
validation rule the message should
briefly<00:04:14.530><c> describe</c><00:04:14.980><c> the</c><00:04:15.010><c> rule</c><00:04:15.310><c> so</c><00:04:15.609><c> that</c><00:04:15.639><c> the</c>

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

00:04:15.849 --> 00:04:16.920 align:start position:0%
briefly describe the rule so that the
user<00:04:16.030><c> can</c><00:04:16.299><c> then</c><00:04:16.329><c> make</c><00:04:16.660><c> the</c><00:04:16.780><c> necessary</c>

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

00:04:16.930 --> 00:04:19.379 align:start position:0%
user can then make the necessary
Corrections<00:04:17.829><c> in</c><00:04:18.039><c> this</c><00:04:18.820><c> case</c><00:04:19.030><c> I'll</c><00:04:19.209><c> just</c>

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

00:04:19.389 --> 00:04:20.819 align:start position:0%
Corrections in this case I'll just
mention<00:04:19.570><c> that</c><00:04:19.870><c> it</c><00:04:19.989><c> needs</c><00:04:20.139><c> to</c><00:04:20.229><c> be</c><00:04:20.320><c> a</c><00:04:20.410><c> two</c><00:04:20.680><c> letter</c>

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

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

00:04:23.879 --> 00:04:23.889 align:start position:0%
 
 

00:04:23.889 --> 00:04:25.619 align:start position:0%
 
now<00:04:24.490><c> you</c><00:04:24.550><c> won't</c><00:04:24.819><c> need</c><00:04:24.969><c> to</c><00:04:25.030><c> add</c><00:04:25.210><c> a</c><00:04:25.240><c> character</c>

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

00:04:25.629 --> 00:04:27.659 align:start position:0%
now you won't need to add a character
limit<00:04:25.930><c> or</c><00:04:26.139><c> validation</c><00:04:26.740><c> rule</c><00:04:26.919><c> to</c><00:04:27.129><c> all</c><00:04:27.340><c> of</c><00:04:27.550><c> your</c>

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

00:04:27.669 --> 00:04:29.790 align:start position:0%
limit or validation rule to all of your
fields<00:04:27.909><c> but</c><00:04:28.599><c> you</c><00:04:28.719><c> can</c><00:04:28.870><c> add</c><00:04:29.020><c> one</c><00:04:29.319><c> or</c><00:04:29.349><c> both</c><00:04:29.740><c> of</c>

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

00:04:29.800 --> 00:04:31.260 align:start position:0%
fields but you can add one or both of
them<00:04:30.069><c> whenever</c><00:04:30.340><c> you</c><00:04:30.520><c> want</c><00:04:30.699><c> to</c><00:04:30.849><c> control</c><00:04:31.210><c> the</c>

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

00:04:31.270 --> 00:04:32.939 align:start position:0%
them whenever you want to control the
types<00:04:31.659><c> of</c><00:04:31.870><c> information</c><00:04:32.110><c> that</c><00:04:32.439><c> your</c><00:04:32.680><c> field</c>

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

00:04:32.949 --> 00:04:39.390 align:start position:0%
types of information that your field
will<00:04:33.129><c> accept</c><00:04:36.000><c> like</c><00:04:37.000><c> what</c><00:04:37.180><c> you</c><00:04:37.330><c> just</c><00:04:37.360><c> saw</c><00:04:38.400><c> radix</c>

00:04:39.390 --> 00:04:39.400 align:start position:0%
will accept like what you just saw radix
 

00:04:39.400 --> 00:04:43.050 align:start position:0%
will accept like what you just saw radix
add<00:04:39.909><c> a</c><00:04:39.969><c> comment</c><00:04:40.300><c> subscribe</c><00:04:41.050><c> to</c><00:04:41.319><c> our</c><00:04:41.590><c> chin</c><00:04:42.060><c> the</c>

00:04:43.050 --> 00:04:43.060 align:start position:0%
add a comment subscribe to our chin the
 

00:04:43.060 --> 00:04:47.159 align:start position:0%
add a comment subscribe to our chin the
freedom<00:04:43.509><c> to</c><00:04:43.629><c> learn</c><00:04:44.430><c> what</c><00:04:45.430><c> you</c><00:04:45.639><c> want</c><00:04:46.139><c> when</c><00:04:47.139><c> you</c>

00:04:47.159 --> 00:04:47.169 align:start position:0%
freedom to learn what you want when you
 

00:04:47.169 --> 00:04:53.710 align:start position:0%
freedom to learn what you want when you
want<00:04:49.169><c> absolutely</c><00:04:50.169><c> free</c>

00:04:53.710 --> 00:04:53.720 align:start position:0%
 
 

00:04:53.720 --> 00:04:57.320 align:start position:0%
 
GCF<00:04:54.720><c> learn</c><00:04:55.290><c> free.org</c>