WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:11.020 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.570><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:11.020 --> 00:00:11.030 align:start position:0%
 
 

00:00:11.030 --> 00:00:13.060 align:start position:0%
 
sometimes<00:00:11.930><c> you</c><00:00:12.080><c> may</c><00:00:12.200><c> decide</c><00:00:12.500><c> that</c><00:00:12.559><c> you</c><00:00:12.770><c> want</c>

00:00:13.060 --> 00:00:13.070 align:start position:0%
sometimes you may decide that you want
 

00:00:13.070 --> 00:00:15.540 align:start position:0%
sometimes you may decide that you want
to<00:00:13.160><c> add</c><00:00:13.460><c> or</c><00:00:13.790><c> modify</c><00:00:14.120><c> fields</c><00:00:14.870><c> in</c><00:00:14.960><c> your</c><00:00:15.110><c> tables</c>

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

00:00:15.550 --> 00:00:17.890 align:start position:0%
to add or modify fields in your tables
access<00:00:16.550><c> makes</c><00:00:16.790><c> it</c><00:00:16.940><c> easy</c><00:00:17.119><c> to</c><00:00:17.210><c> do</c><00:00:17.450><c> this</c><00:00:17.630><c> although</c>

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

00:00:17.900 --> 00:00:19.600 align:start position:0%
access makes it easy to do this although
there<00:00:18.470><c> are</c><00:00:18.619><c> some</c><00:00:18.860><c> important</c><00:00:19.310><c> things</c><00:00:19.460><c> that</c>

00:00:19.600 --> 00:00:19.610 align:start position:0%
there are some important things that
 

00:00:19.610 --> 00:00:22.150 align:start position:0%
there are some important things that
you'll<00:00:19.790><c> need</c><00:00:19.939><c> to</c><00:00:20.000><c> consider</c><00:00:20.590><c> there</c><00:00:21.590><c> are</c><00:00:21.619><c> three</c>

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

00:00:22.160 --> 00:00:23.800 align:start position:0%
you'll need to consider there are three
different<00:00:22.340><c> rules</c><00:00:22.700><c> that</c><00:00:22.880><c> you</c><00:00:23.060><c> can</c><00:00:23.090><c> apply</c><00:00:23.210><c> to</c>

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

00:00:23.810 --> 00:00:25.600 align:start position:0%
different rules that you can apply to
control<00:00:24.259><c> the</c><00:00:24.410><c> type</c><00:00:24.590><c> of</c><00:00:24.740><c> data</c><00:00:24.950><c> that</c><00:00:25.040><c> the</c><00:00:25.310><c> fields</c>

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

00:00:25.610 --> 00:00:28.260 align:start position:0%
control the type of data that the fields
can<00:00:25.759><c> accept</c><00:00:26.180><c> and</c><00:00:26.420><c> these</c><00:00:27.170><c> are</c><00:00:27.380><c> data</c><00:00:27.800><c> types</c>

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

00:00:28.270 --> 00:00:34.780 align:start position:0%
can accept and these are data types
character<00:00:29.270><c> limits</c><00:00:29.600><c> and</c><00:00:29.890><c> validation</c><00:00:30.890><c> rules</c><00:00:33.790><c> to</c>

00:00:34.780 --> 00:00:34.790 align:start position:0%
character limits and validation rules to
 

00:00:34.790 --> 00:00:36.130 align:start position:0%
character limits and validation rules to
get<00:00:34.879><c> started</c><00:00:35.330><c> make</c><00:00:35.570><c> sure</c><00:00:35.600><c> that</c><00:00:35.930><c> you</c><00:00:35.989><c> have</c><00:00:36.110><c> a</c>

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

00:00:36.140 --> 00:00:39.180 align:start position:0%
get started make sure that you have a
table<00:00:36.530><c> open</c><00:00:36.680><c> I'm</c><00:00:37.400><c> using</c><00:00:37.670><c> the</c><00:00:38.059><c> customers</c><00:00:38.660><c> table</c>

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

00:00:39.190 --> 00:00:41.680 align:start position:0%
table open I'm using the customers table
we're<00:00:40.190><c> going</c><00:00:40.340><c> to</c><00:00:40.610><c> scroll</c><00:00:40.940><c> all</c><00:00:41.210><c> the</c><00:00:41.269><c> way</c><00:00:41.420><c> to</c><00:00:41.510><c> the</c>

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

00:00:41.690 --> 00:00:43.690 align:start position:0%
we're going to scroll all the way to the
right<00:00:41.930><c> until</c><00:00:42.199><c> you</c><00:00:42.440><c> see</c><00:00:42.650><c> a</c><00:00:42.680><c> blank</c><00:00:43.130><c> field</c><00:00:43.460><c> that</c>

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

00:00:43.700 --> 00:00:46.540 align:start position:0%
right until you see a blank field that
says<00:00:43.880><c> click</c><00:00:44.329><c> to</c><00:00:44.360><c> add</c><00:00:44.540><c> and</c><00:00:45.160><c> when</c><00:00:46.160><c> you</c><00:00:46.250><c> click</c><00:00:46.430><c> on</c>

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

00:00:46.550 --> 00:00:48.250 align:start position:0%
says click to add and when you click on
it<00:00:46.610><c> you'll</c><00:00:46.850><c> see</c><00:00:47.059><c> a</c><00:00:47.090><c> list</c><00:00:47.420><c> of</c><00:00:47.630><c> all</c><00:00:47.780><c> of</c><00:00:47.809><c> the</c><00:00:48.050><c> data</c>

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

00:00:48.260 --> 00:00:51.040 align:start position:0%
it you'll see a list of all of the data
types<00:00:48.559><c> that</c><00:00:48.680><c> you</c><00:00:48.829><c> can</c><00:00:48.860><c> choose</c><00:00:49.219><c> from</c><00:00:50.050><c> short</c>

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

00:00:51.050 --> 00:00:53.560 align:start position:0%
types that you can choose from short
text<00:00:51.469><c> is</c><00:00:51.590><c> the</c><00:00:51.829><c> default</c><00:00:52.129><c> option</c><00:00:52.370><c> and</c><00:00:52.790><c> this</c><00:00:53.420><c> is</c>

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

00:00:53.570 --> 00:00:55.030 align:start position:0%
text is the default option and this is
the<00:00:53.719><c> type</c><00:00:53.899><c> that</c><00:00:53.930><c> you'll</c><00:00:54.230><c> use</c><00:00:54.500><c> for</c><00:00:54.530><c> regular</c>

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

00:00:55.040 --> 00:00:57.580 align:start position:0%
the type that you'll use for regular
text<00:00:55.670><c> such</c><00:00:55.940><c> as</c><00:00:55.969><c> a</c><00:00:56.180><c> person's</c><00:00:56.329><c> name</c><00:00:56.870><c> or</c><00:00:57.079><c> address</c>

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

00:00:57.590 --> 00:00:59.680 align:start position:0%
text such as a person's name or address
you'll<00:00:58.489><c> also</c><00:00:58.700><c> use</c><00:00:58.879><c> it</c><00:00:59.210><c> for</c><00:00:59.239><c> numbers</c><00:00:59.660><c> that</c>

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

00:00:59.690 --> 00:01:01.869 align:start position:0%
you'll also use it for numbers that
aren't<00:01:00.110><c> used</c><00:01:00.320><c> in</c><00:01:00.469><c> calculations</c><00:01:00.980><c> like</c><00:01:01.520><c> a</c><00:01:01.579><c> phone</c>

00:01:01.869 --> 00:01:01.879 align:start position:0%
aren't used in calculations like a phone
 

00:01:01.879 --> 00:01:04.719 align:start position:0%
aren't used in calculations like a phone
number<00:01:02.090><c> or</c><00:01:02.270><c> zip</c><00:01:02.809><c> code</c><00:01:03.220><c> for</c><00:01:04.220><c> any</c><00:01:04.369><c> numbers</c><00:01:04.699><c> that</c>

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

00:01:04.729 --> 00:01:06.310 align:start position:0%
number or zip code for any numbers that
you<00:01:04.970><c> might</c><00:01:05.149><c> want</c><00:01:05.360><c> to</c><00:01:05.420><c> do</c><00:01:05.539><c> calculations</c><00:01:06.200><c> with</c>

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

00:01:06.320 --> 00:01:09.100 align:start position:0%
you might want to do calculations with
you'll<00:01:06.860><c> need</c><00:01:06.890><c> to</c><00:01:07.160><c> choose</c><00:01:07.430><c> number</c><00:01:07.759><c> for</c><00:01:08.750><c> example</c>

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

00:01:09.110 --> 00:01:10.870 align:start position:0%
you'll need to choose number for example
we<00:01:09.259><c> would</c><00:01:09.380><c> use</c><00:01:09.560><c> this</c><00:01:09.740><c> for</c><00:01:09.800><c> the</c><00:01:10.190><c> quantities</c><00:01:10.729><c> of</c>

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

00:01:10.880 --> 00:01:13.180 align:start position:0%
we would use this for the quantities of
an<00:01:10.970><c> item</c><00:01:11.149><c> that</c><00:01:11.450><c> we're</c><00:01:11.600><c> sold</c><00:01:11.869><c> if</c><00:01:12.190><c> you're</c>

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

00:01:13.190 --> 00:01:14.620 align:start position:0%
an item that we're sold if you're
dealing<00:01:13.340><c> with</c><00:01:13.490><c> money</c><00:01:13.820><c> then</c><00:01:14.180><c> you'll</c><00:01:14.390><c> choose</c>

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

00:01:14.630 --> 00:01:17.350 align:start position:0%
dealing with money then you'll choose
currency<00:01:15.260><c> and</c><00:01:15.470><c> if</c><00:01:16.430><c> you</c><00:01:16.549><c> choose</c><00:01:16.729><c> date</c><00:01:17.000><c> and</c><00:01:17.180><c> time</c>

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

00:01:17.360 --> 00:01:18.820 align:start position:0%
currency and if you choose date and time
then<00:01:17.750><c> when</c><00:01:17.930><c> you're</c><00:01:18.049><c> editing</c><00:01:18.200><c> that</c><00:01:18.560><c> field</c>

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

00:01:18.830 --> 00:01:20.710 align:start position:0%
then when you're editing that field
you'll<00:01:19.040><c> see</c><00:01:19.250><c> a</c><00:01:19.280><c> calendar</c><00:01:19.549><c> icon</c><00:01:20.119><c> which</c><00:01:20.390><c> you</c><00:01:20.420><c> can</c>

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

00:01:20.720 --> 00:01:23.380 align:start position:0%
you'll see a calendar icon which you can
click<00:01:20.990><c> to</c><00:01:21.020><c> select</c><00:01:21.380><c> a</c><00:01:21.619><c> date</c><00:01:21.820><c> but</c><00:01:22.820><c> in</c><00:01:23.030><c> this</c><00:01:23.150><c> case</c>

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

00:01:23.390 --> 00:01:25.960 align:start position:0%
click to select a date but in this case
I<00:01:23.600><c> just</c><00:01:23.630><c> want</c><00:01:24.020><c> a</c><00:01:24.140><c> simple</c><00:01:24.590><c> yes</c><00:01:24.860><c> or</c><00:01:25.010><c> no</c><00:01:25.070><c> answer</c><00:01:25.520><c> so</c>

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

00:01:25.970 --> 00:01:29.020 align:start position:0%
I just want a simple yes or no answer so
I'll<00:01:26.270><c> choose</c><00:01:26.600><c> this</c><00:01:26.900><c> one</c><00:01:26.960><c> and</c><00:01:27.460><c> this</c><00:01:28.460><c> adds</c><00:01:28.700><c> a</c>

00:01:29.020 --> 00:01:29.030 align:start position:0%
I'll choose this one and this adds a
 

00:01:29.030 --> 00:01:31.990 align:start position:0%
I'll choose this one and this adds a
checkbox<00:01:29.509><c> for</c><00:01:29.720><c> each</c><00:01:29.960><c> record</c><00:01:30.610><c> then</c><00:01:31.610><c> you</c><00:01:31.850><c> can</c>

00:01:31.990 --> 00:01:32.000 align:start position:0%
checkbox for each record then you can
 

00:01:32.000 --> 00:01:34.210 align:start position:0%
checkbox for each record then you can
type<00:01:32.180><c> in</c><00:01:32.360><c> the</c><00:01:32.450><c> name</c><00:01:32.479><c> of</c><00:01:32.810><c> your</c><00:01:32.900><c> field</c><00:01:33.200><c> I'm</c><00:01:33.770><c> going</c>

00:01:34.210 --> 00:01:34.220 align:start position:0%
type in the name of your field I'm going
 

00:01:34.220 --> 00:01:39.010 align:start position:0%
type in the name of your field I'm going
to<00:01:34.310><c> name</c><00:01:34.460><c> it</c><00:01:34.490><c> add</c><00:01:34.759><c> to</c><00:01:35.180><c> mailing</c><00:01:35.330><c> list</c><00:01:37.869><c> then</c><00:01:38.869><c> I'll</c>

00:01:39.010 --> 00:01:39.020 align:start position:0%
to name it add to mailing list then I'll
 

00:01:39.020 --> 00:01:43.929 align:start position:0%
to name it add to mailing list then I'll
resize<00:01:39.530><c> this</c><00:01:39.829><c> field</c><00:01:42.100><c> now</c><00:01:43.100><c> we</c><00:01:43.159><c> can</c><00:01:43.490><c> just</c><00:01:43.700><c> check</c>

00:01:43.929 --> 00:01:43.939 align:start position:0%
resize this field now we can just check
 

00:01:43.939 --> 00:01:45.609 align:start position:0%
resize this field now we can just check
each<00:01:44.150><c> customer</c><00:01:44.720><c> who</c><00:01:44.869><c> wants</c><00:01:45.140><c> to</c><00:01:45.229><c> be</c><00:01:45.350><c> on</c><00:01:45.380><c> our</c>

00:01:45.609 --> 00:01:45.619 align:start position:0%
each customer who wants to be on our
 

00:01:45.619 --> 00:01:48.760 align:start position:0%
each customer who wants to be on our
mailing<00:01:45.890><c> list</c><00:01:45.920><c> and</c><00:01:46.340><c> you</c><00:01:47.110><c> can</c><00:01:48.110><c> also</c><00:01:48.350><c> click</c><00:01:48.740><c> and</c>

00:01:48.760 --> 00:01:48.770 align:start position:0%
mailing list and you can also click and
 

00:01:48.770 --> 00:01:50.620 align:start position:0%
mailing list and you can also click and
drag<00:01:48.979><c> the</c><00:01:49.340><c> name</c><00:01:49.549><c> to</c><00:01:49.820><c> move</c><00:01:49.970><c> the</c><00:01:50.150><c> field</c><00:01:50.329><c> wherever</c>

00:01:50.620 --> 00:01:50.630 align:start position:0%
drag the name to move the field wherever
 

00:01:50.630 --> 00:01:54.700 align:start position:0%
drag the name to move the field wherever
you<00:01:50.869><c> like</c><00:01:51.079><c> if</c><00:01:52.810><c> you</c><00:01:53.810><c> decide</c><00:01:54.170><c> that</c><00:01:54.200><c> you</c><00:01:54.470><c> need</c><00:01:54.680><c> a</c>

00:01:54.700 --> 00:01:54.710 align:start position:0%
you like if you decide that you need a
 

00:01:54.710 --> 00:01:56.620 align:start position:0%
you like if you decide that you need a
different<00:01:54.890><c> data</c><00:01:55.430><c> type</c><00:01:55.670><c> for</c><00:01:55.880><c> a</c><00:01:55.939><c> field</c><00:01:56.180><c> then</c><00:01:56.600><c> you</c>

00:01:56.620 --> 00:01:56.630 align:start position:0%
different data type for a field then you
 

00:01:56.630 --> 00:01:58.929 align:start position:0%
different data type for a field then you
can<00:01:56.930><c> just</c><00:01:57.079><c> select</c><00:01:57.259><c> it</c><00:01:57.590><c> and</c><00:01:57.740><c> then</c><00:01:58.310><c> go</c><00:01:58.549><c> to</c><00:01:58.610><c> the</c>

00:01:58.929 --> 00:01:58.939 align:start position:0%
can just select it and then go to the
 

00:01:58.939 --> 00:02:02.350 align:start position:0%
can just select it and then go to the
fields<00:01:59.390><c> tab</c><00:01:59.720><c> and</c><00:02:00.700><c> click</c><00:02:01.700><c> the</c><00:02:01.729><c> data</c><00:02:02.060><c> type</c>

00:02:02.350 --> 00:02:02.360 align:start position:0%
fields tab and click the data type
 

00:02:02.360 --> 00:02:05.530 align:start position:0%
fields tab and click the data type
drop-down<00:02:02.750><c> arrow</c><00:02:03.729><c> I'm</c><00:02:04.729><c> going</c><00:02:04.970><c> to</c><00:02:05.060><c> change</c><00:02:05.299><c> this</c>

00:02:05.530 --> 00:02:05.540 align:start position:0%
drop-down arrow I'm going to change this
 

00:02:05.540 --> 00:02:06.940 align:start position:0%
drop-down arrow I'm going to change this
to<00:02:05.600><c> text</c><00:02:06.200><c> so</c><00:02:06.409><c> I</c><00:02:06.439><c> can</c><00:02:06.619><c> add</c><00:02:06.770><c> additional</c>

00:02:06.940 --> 00:02:06.950 align:start position:0%
to text so I can add additional
 

00:02:06.950 --> 00:02:09.759 align:start position:0%
to text so I can add additional
information<00:02:07.820><c> in</c><00:02:07.969><c> this</c><00:02:08.090><c> field</c><00:02:08.530><c> some</c><00:02:09.530><c> of</c><00:02:09.560><c> our</c>

00:02:09.759 --> 00:02:09.769 align:start position:0%
information in this field some of our
 

00:02:09.769 --> 00:02:11.199 align:start position:0%
information in this field some of our
customers<00:02:10.190><c> want</c><00:02:10.429><c> to</c><00:02:10.459><c> receive</c><00:02:10.519><c> our</c><00:02:10.910><c> weekly</c>

00:02:11.199 --> 00:02:11.209 align:start position:0%
customers want to receive our weekly
 

00:02:11.209 --> 00:02:13.539 align:start position:0%
customers want to receive our weekly
newsletter<00:02:11.630><c> but</c><00:02:12.410><c> others</c><00:02:12.829><c> just</c><00:02:13.100><c> want</c><00:02:13.310><c> to</c><00:02:13.400><c> hear</c>

00:02:13.539 --> 00:02:13.549 align:start position:0%
newsletter but others just want to hear
 

00:02:13.549 --> 00:02:15.880 align:start position:0%
newsletter but others just want to hear
about<00:02:13.610><c> our</c><00:02:13.850><c> special</c><00:02:14.239><c> events</c><00:02:14.630><c> now</c><00:02:15.620><c> you</c><00:02:15.680><c> should</c>

00:02:15.880 --> 00:02:15.890 align:start position:0%
about our special events now you should
 

00:02:15.890 --> 00:02:17.620 align:start position:0%
about our special events now you should
be<00:02:15.920><c> very</c><00:02:16.010><c> careful</c><00:02:16.519><c> about</c><00:02:16.850><c> changing</c><00:02:17.180><c> the</c><00:02:17.480><c> data</c>

00:02:17.620 --> 00:02:17.630 align:start position:0%
be very careful about changing the data
 

00:02:17.630 --> 00:02:19.869 align:start position:0%
be very careful about changing the data
type<00:02:17.930><c> because</c><00:02:18.590><c> it</c><00:02:18.709><c> is</c><00:02:18.829><c> possible</c><00:02:19.310><c> to</c><00:02:19.340><c> lose</c><00:02:19.670><c> some</c>

00:02:19.869 --> 00:02:19.879 align:start position:0%
type because it is possible to lose some
 

00:02:19.879 --> 00:02:21.010 align:start position:0%
type because it is possible to lose some
of<00:02:19.910><c> your</c><00:02:20.000><c> data</c><00:02:20.270><c> if</c><00:02:20.450><c> you</c><00:02:20.540><c> change</c><00:02:20.780><c> it</c><00:02:20.870><c> to</c><00:02:20.930><c> the</c>

00:02:21.010 --> 00:02:21.020 align:start position:0%
of your data if you change it to the
 

00:02:21.020 --> 00:02:22.740 align:start position:0%
of your data if you change it to the
wrong<00:02:21.200><c> type</c>

00:02:22.740 --> 00:02:22.750 align:start position:0%
wrong type
 

00:02:22.750 --> 00:02:24.930 align:start position:0%
wrong type
in<00:02:22.830><c> some</c><00:02:23.830><c> fields</c><00:02:24.190><c> you</c><00:02:24.310><c> may</c><00:02:24.460><c> want</c><00:02:24.670><c> to</c><00:02:24.730><c> narrow</c>

00:02:24.930 --> 00:02:24.940 align:start position:0%
in some fields you may want to narrow
 

00:02:24.940 --> 00:02:26.970 align:start position:0%
in some fields you may want to narrow
down<00:02:25.210><c> the</c><00:02:25.360><c> data</c><00:02:25.390><c> even</c><00:02:25.750><c> further</c><00:02:26.200><c> by</c><00:02:26.560><c> adding</c><00:02:26.740><c> a</c>

00:02:26.970 --> 00:02:26.980 align:start position:0%
down the data even further by adding a
 

00:02:26.980 --> 00:02:29.130 align:start position:0%
down the data even further by adding a
character<00:02:27.430><c> limit</c><00:02:27.610><c> and</c><00:02:27.880><c> you</c><00:02:28.360><c> can</c><00:02:28.480><c> only</c><00:02:28.690><c> do</c><00:02:28.990><c> this</c>

00:02:29.130 --> 00:02:29.140 align:start position:0%
character limit and you can only do this
 

00:02:29.140 --> 00:02:32.130 align:start position:0%
character limit and you can only do this
with<00:02:29.200><c> text</c><00:02:29.860><c> fields</c><00:02:30.280><c> for</c><00:02:31.150><c> example</c><00:02:31.210><c> we</c><00:02:31.720><c> want</c><00:02:31.960><c> all</c>

00:02:32.130 --> 00:02:32.140 align:start position:0%
with text fields for example we want all
 

00:02:32.140 --> 00:02:33.630 align:start position:0%
with text fields for example we want all
of<00:02:32.350><c> the</c><00:02:32.440><c> states</c><00:02:32.740><c> to</c><00:02:32.920><c> be</c><00:02:33.010><c> formatted</c><00:02:33.370><c> the</c><00:02:33.610><c> same</c>

00:02:33.630 --> 00:02:33.640 align:start position:0%
of the states to be formatted the same
 

00:02:33.640 --> 00:02:36.360 align:start position:0%
of the states to be formatted the same
way<00:02:34.180><c> so</c><00:02:34.750><c> we're</c><00:02:35.020><c> only</c><00:02:35.200><c> using</c><00:02:35.590><c> the</c><00:02:35.950><c> two-letter</c>

00:02:36.360 --> 00:02:36.370 align:start position:0%
way so we're only using the two-letter
 

00:02:36.370 --> 00:02:38.670 align:start position:0%
way so we're only using the two-letter
state<00:02:36.820><c> abbreviations</c><00:02:37.570><c> if</c><00:02:38.230><c> some</c><00:02:38.530><c> of</c><00:02:38.620><c> the</c>

00:02:38.670 --> 00:02:38.680 align:start position:0%
state abbreviations if some of the
 

00:02:38.680 --> 00:02:41.130 align:start position:0%
state abbreviations if some of the
records<00:02:38.980><c> say</c><00:02:39.160><c> in</c><00:02:39.430><c> c</c><00:02:39.820><c> and</c><00:02:40.030><c> others</c><00:02:40.660><c> say</c><00:02:40.900><c> North</c>

00:02:41.130 --> 00:02:41.140 align:start position:0%
records say in c and others say North
 

00:02:41.140 --> 00:02:43.500 align:start position:0%
records say in c and others say North
Carolina<00:02:41.590><c> then</c><00:02:42.040><c> access</c><00:02:42.610><c> won't</c><00:02:42.880><c> know</c><00:02:43.120><c> to</c><00:02:43.180><c> group</c>

00:02:43.500 --> 00:02:43.510 align:start position:0%
Carolina then access won't know to group
 

00:02:43.510 --> 00:02:45.449 align:start position:0%
Carolina then access won't know to group
them<00:02:43.690><c> together</c><00:02:43.840><c> which</c><00:02:44.620><c> means</c><00:02:44.890><c> our</c><00:02:45.040><c> sorts</c>

00:02:45.449 --> 00:02:45.459 align:start position:0%
them together which means our sorts
 

00:02:45.459 --> 00:02:47.370 align:start position:0%
them together which means our sorts
filters<00:02:45.970><c> and</c><00:02:46.180><c> queries</c><00:02:46.540><c> may</c><00:02:46.720><c> not</c><00:02:46.900><c> work</c><00:02:47.110><c> right</c>

00:02:47.370 --> 00:02:47.380 align:start position:0%
filters and queries may not work right
 

00:02:47.380 --> 00:02:50.699 align:start position:0%
filters and queries may not work right
in<00:02:47.820><c> the</c><00:02:48.820><c> fields</c><00:02:49.180><c> tab</c><00:02:49.390><c> find</c><00:02:49.870><c> the</c><00:02:50.080><c> field</c><00:02:50.380><c> size</c>

00:02:50.699 --> 00:02:50.709 align:start position:0%
in the fields tab find the field size
 

00:02:50.709 --> 00:02:54.570 align:start position:0%
in the fields tab find the field size
box<00:02:51.150><c> the</c><00:02:52.150><c> default</c><00:02:52.540><c> field</c><00:02:52.930><c> size</c><00:02:53.230><c> is</c><00:02:53.580><c> 255</c>

00:02:54.570 --> 00:02:54.580 align:start position:0%
box the default field size is 255
 

00:02:54.580 --> 00:02:56.729 align:start position:0%
box the default field size is 255
characters<00:02:54.880><c> but</c><00:02:55.720><c> I'm</c><00:02:55.930><c> going</c><00:02:56.140><c> to</c><00:02:56.260><c> change</c><00:02:56.560><c> it</c><00:02:56.709><c> to</c>

00:02:56.729 --> 00:02:56.739 align:start position:0%
characters but I'm going to change it to
 

00:02:56.739 --> 00:03:00.420 align:start position:0%
characters but I'm going to change it to
two<00:02:57.100><c> and</c><00:02:58.680><c> you</c><00:02:59.680><c> may</c><00:02:59.800><c> get</c><00:02:59.950><c> a</c><00:02:59.980><c> warning</c><00:03:00.040><c> message</c>

00:03:00.420 --> 00:03:00.430 align:start position:0%
two and you may get a warning message
 

00:03:00.430 --> 00:03:02.130 align:start position:0%
two and you may get a warning message
here<00:03:00.850><c> so</c><00:03:01.209><c> if</c><00:03:01.360><c> you're</c><00:03:01.510><c> sure</c><00:03:01.720><c> you</c><00:03:01.870><c> want</c><00:03:02.050><c> to</c>

00:03:02.130 --> 00:03:02.140 align:start position:0%
here so if you're sure you want to
 

00:03:02.140 --> 00:03:05.910 align:start position:0%
here so if you're sure you want to
change<00:03:02.380><c> the</c><00:03:02.560><c> field</c><00:03:02.770><c> size</c><00:03:02.980><c> click</c><00:03:03.400><c> yes</c><00:03:03.640><c> in</c><00:03:04.920><c> this</c>

00:03:05.910 --> 00:03:05.920 align:start position:0%
change the field size click yes in this
 

00:03:05.920 --> 00:03:07.680 align:start position:0%
change the field size click yes in this
case<00:03:05.980><c> setting</c><00:03:06.610><c> a</c><00:03:06.700><c> character</c><00:03:07.120><c> limit</c><00:03:07.270><c> isn't</c>

00:03:07.680 --> 00:03:07.690 align:start position:0%
case setting a character limit isn't
 

00:03:07.690 --> 00:03:09.479 align:start position:0%
case setting a character limit isn't
quite<00:03:07.959><c> good</c><00:03:07.989><c> enough</c><00:03:08.200><c> because</c><00:03:08.800><c> somebody</c><00:03:09.310><c> could</c>

00:03:09.479 --> 00:03:09.489 align:start position:0%
quite good enough because somebody could
 

00:03:09.489 --> 00:03:11.370 align:start position:0%
quite good enough because somebody could
still<00:03:09.730><c> type</c><00:03:10.000><c> a</c><00:03:10.209><c> two</c><00:03:10.450><c> letter</c><00:03:10.630><c> code</c><00:03:10.959><c> that's</c><00:03:11.290><c> not</c>

00:03:11.370 --> 00:03:11.380 align:start position:0%
still type a two letter code that's not
 

00:03:11.380 --> 00:03:15.360 align:start position:0%
still type a two letter code that's not
a<00:03:11.530><c> real</c><00:03:11.890><c> state</c><00:03:12.250><c> for</c><00:03:12.850><c> example</c><00:03:13.270><c> in</c><00:03:13.480><c> X</c><00:03:14.040><c> to</c><00:03:15.040><c> prevent</c>

00:03:15.360 --> 00:03:15.370 align:start position:0%
a real state for example in X to prevent
 

00:03:15.370 --> 00:03:16.740 align:start position:0%
a real state for example in X to prevent
that<00:03:15.489><c> we</c><00:03:15.730><c> need</c><00:03:15.910><c> to</c><00:03:16.000><c> be</c><00:03:16.120><c> a</c><00:03:16.150><c> lot</c><00:03:16.420><c> more</c><00:03:16.450><c> specific</c>

00:03:16.740 --> 00:03:16.750 align:start position:0%
that we need to be a lot more specific
 

00:03:16.750 --> 00:03:18.780 align:start position:0%
that we need to be a lot more specific
about<00:03:17.260><c> what</c><00:03:17.410><c> types</c><00:03:17.860><c> of</c><00:03:18.010><c> input</c><00:03:18.370><c> this</c><00:03:18.520><c> field</c>

00:03:18.780 --> 00:03:18.790 align:start position:0%
about what types of input this field
 

00:03:18.790 --> 00:03:20.970 align:start position:0%
about what types of input this field
will<00:03:18.940><c> accept</c><00:03:19.390><c> and</c><00:03:19.600><c> we'll</c><00:03:20.200><c> do</c><00:03:20.380><c> that</c><00:03:20.530><c> by</c><00:03:20.770><c> adding</c>

00:03:20.970 --> 00:03:20.980 align:start position:0%
will accept and we'll do that by adding
 

00:03:20.980 --> 00:03:24.330 align:start position:0%
will accept and we'll do that by adding
a<00:03:21.250><c> validation</c><00:03:21.910><c> rule</c><00:03:22.150><c> in</c><00:03:22.440><c> the</c><00:03:23.440><c> fields</c><00:03:23.739><c> tab</c><00:03:23.980><c> go</c>

00:03:24.330 --> 00:03:24.340 align:start position:0%
a validation rule in the fields tab go
 

00:03:24.340 --> 00:03:26.220 align:start position:0%
a validation rule in the fields tab go
to<00:03:24.370><c> the</c><00:03:24.610><c> validation</c><00:03:24.750><c> command</c><00:03:25.750><c> on</c><00:03:25.930><c> the</c><00:03:26.020><c> far</c>

00:03:26.220 --> 00:03:26.230 align:start position:0%
to the validation command on the far
 

00:03:26.230 --> 00:03:30.830 align:start position:0%
to the validation command on the far
right<00:03:26.500><c> and</c><00:03:27.060><c> select</c><00:03:28.060><c> field</c><00:03:28.510><c> validation</c><00:03:28.810><c> rule</c>

00:03:30.830 --> 00:03:30.840 align:start position:0%
right and select field validation rule
 

00:03:30.840 --> 00:03:33.300 align:start position:0%
right and select field validation rule
here<00:03:31.840><c> I'm</c><00:03:31.989><c> going</c><00:03:32.260><c> to</c><00:03:32.410><c> type</c><00:03:32.620><c> each</c><00:03:32.830><c> state</c>

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

00:03:33.310 --> 00:03:35.699 align:start position:0%
here I'm going to type each state
abbreviation<00:03:33.940><c> in</c><00:03:34.120><c> quotation</c><00:03:34.660><c> marks</c><00:03:34.690><c> and</c><00:03:35.140><c> I'm</c>

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

00:03:35.709 --> 00:03:38.630 align:start position:0%
abbreviation in quotation marks and I'm
separating<00:03:36.280><c> each</c><00:03:36.370><c> one</c><00:03:36.850><c> with</c><00:03:37.150><c> the</c><00:03:37.269><c> word</c><00:03:37.450><c> or</c><00:03:37.690><c> and</c>

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

00:03:38.640 --> 00:03:43.740 align:start position:0%
separating each one with the word or and
this<00:03:39.640><c> may</c><00:03:39.850><c> take</c><00:03:40.060><c> a</c><00:03:40.120><c> while</c><00:03:42.239><c> so</c><00:03:43.239><c> this</c><00:03:43.420><c> expression</c>

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

00:03:43.750 --> 00:03:46.949 align:start position:0%
this may take a while so this expression
is<00:03:44.110><c> just</c><00:03:44.500><c> looking</c><00:03:44.860><c> for</c><00:03:45.130><c> exact</c><00:03:45.610><c> matches</c><00:03:46.120><c> but</c><00:03:46.750><c> if</c>

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

00:03:46.959 --> 00:03:48.870 align:start position:0%
is just looking for exact matches but if
you<00:03:47.080><c> want</c><00:03:47.320><c> you</c><00:03:47.530><c> can</c><00:03:47.709><c> create</c><00:03:47.920><c> validation</c><00:03:48.670><c> rules</c>

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

00:03:48.880 --> 00:03:50.759 align:start position:0%
you want you can create validation rules
using<00:03:49.239><c> the</c><00:03:49.360><c> same</c><00:03:49.630><c> syntax</c><00:03:49.959><c> as</c><00:03:50.260><c> that</c><00:03:50.440><c> we</c><00:03:50.530><c> talked</c>

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

00:03:50.769 --> 00:03:53.250 align:start position:0%
using the same syntax as that we talked
about<00:03:50.920><c> in</c><00:03:51.220><c> the</c><00:03:51.340><c> query</c><00:03:51.610><c> lessons</c><00:03:52.030><c> for</c><00:03:52.840><c> example</c>

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

00:03:53.260 --> 00:03:55.110 align:start position:0%
about in the query lessons for example
you<00:03:53.440><c> could</c><00:03:53.560><c> use</c><00:03:53.620><c> the</c><00:03:53.980><c> like</c><00:03:54.190><c> syntax</c><00:03:54.519><c> to</c><00:03:54.940><c> set</c><00:03:55.090><c> a</c>

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

00:03:55.120 --> 00:03:57.060 align:start position:0%
you could use the like syntax to set a
validation<00:03:55.630><c> rule</c><00:03:55.780><c> that</c><00:03:56.200><c> only</c><00:03:56.410><c> allows</c><00:03:56.769><c> text</c>

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

00:03:57.070 --> 00:03:59.640 align:start position:0%
validation rule that only allows text
that<00:03:57.370><c> ends</c><00:03:57.610><c> with</c><00:03:57.700><c> cake</c><00:03:58.000><c> or</c><00:03:58.480><c> if</c><00:03:59.290><c> you're</c><00:03:59.470><c> using</c>

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

00:03:59.650 --> 00:04:01.800 align:start position:0%
that ends with cake or if you're using
numerical<00:04:00.220><c> values</c><00:04:00.610><c> you</c><00:04:01.030><c> could</c><00:04:01.150><c> use</c><00:04:01.420><c> greater</c>

00:04:01.800 --> 00:04:01.810 align:start position:0%
numerical values you could use greater
 

00:04:01.810 --> 00:04:03.360 align:start position:0%
numerical values you could use greater
than<00:04:02.110><c> to</c><00:04:02.500><c> make</c><00:04:02.620><c> sure</c><00:04:02.769><c> that</c><00:04:02.950><c> none</c><00:04:03.190><c> of</c><00:04:03.220><c> our</c>

00:04:03.360 --> 00:04:03.370 align:start position:0%
than to make sure that none of our
 

00:04:03.370 --> 00:04:07.560 align:start position:0%
than to make sure that none of our
quantities<00:04:03.880><c> are</c><00:04:04.060><c> negative</c><00:04:06.299><c> when</c><00:04:07.299><c> you're</c><00:04:07.420><c> done</c>

00:04:07.560 --> 00:04:07.570 align:start position:0%
quantities are negative when you're done
 

00:04:07.570 --> 00:04:09.950 align:start position:0%
quantities are negative when you're done
click<00:04:07.989><c> OK</c>

00:04:09.950 --> 00:04:09.960 align:start position:0%
click OK
 

00:04:09.960 --> 00:04:12.300 align:start position:0%
click OK
whenever<00:04:10.960><c> you</c><00:04:11.080><c> create</c><00:04:11.260><c> a</c><00:04:11.470><c> validation</c><00:04:12.100><c> rule</c>

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

00:04:12.310 --> 00:04:14.280 align:start position:0%
whenever you create a validation rule
it's<00:04:12.730><c> important</c><00:04:13.180><c> to</c><00:04:13.270><c> create</c><00:04:13.600><c> a</c><00:04:13.630><c> validation</c>

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

00:04:14.290 --> 00:04:16.890 align:start position:0%
it's important to create a validation
message<00:04:14.890><c> and</c><00:04:15.130><c> this</c><00:04:15.880><c> option</c><00:04:16.060><c> is</c><00:04:16.330><c> also</c><00:04:16.630><c> under</c>

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

00:04:16.900 --> 00:04:20.400 align:start position:0%
message and this option is also under
the<00:04:17.019><c> validation</c><00:04:17.590><c> command</c><00:04:18.930><c> this</c><00:04:19.930><c> message</c><00:04:20.230><c> will</c>

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

00:04:20.410 --> 00:04:22.140 align:start position:0%
the validation command this message will
pop<00:04:20.620><c> up</c><00:04:20.650><c> whenever</c><00:04:21.010><c> somebody</c><00:04:21.489><c> tries</c><00:04:21.760><c> to</c><00:04:21.790><c> type</c>

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

00:04:22.150 --> 00:04:23.520 align:start position:0%
pop up whenever somebody tries to type
in<00:04:22.330><c> something</c><00:04:22.600><c> that</c><00:04:22.750><c> doesn't</c><00:04:22.900><c> follow</c><00:04:23.380><c> the</c>

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

00:04:23.530 --> 00:04:25.830 align:start position:0%
in something that doesn't follow the
validation<00:04:24.220><c> rule</c><00:04:24.430><c> the</c><00:04:25.240><c> message</c><00:04:25.570><c> should</c>

00:04:25.830 --> 00:04:25.840 align:start position:0%
validation rule the message should
 

00:04:25.840 --> 00:04:27.570 align:start position:0%
validation rule the message should
briefly<00:04:26.260><c> describe</c><00:04:26.710><c> the</c><00:04:26.740><c> rule</c><00:04:27.040><c> so</c><00:04:27.340><c> that</c><00:04:27.370><c> the</c>

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

00:04:27.580 --> 00:04:28.650 align:start position:0%
briefly describe the rule so that the
user<00:04:27.760><c> can</c><00:04:27.880><c> then</c><00:04:28.060><c> make</c><00:04:28.390><c> the</c><00:04:28.540><c> necessary</c>

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

00:04:28.660 --> 00:04:31.200 align:start position:0%
user can then make the necessary
Corrections<00:04:29.560><c> in</c><00:04:29.770><c> this</c><00:04:30.670><c> case</c><00:04:30.880><c> I'll</c><00:04:31.060><c> just</c>

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

00:04:31.210 --> 00:04:32.670 align:start position:0%
Corrections in this case I'll just
mention<00:04:31.420><c> that</c><00:04:31.690><c> it</c><00:04:31.810><c> needs</c><00:04:31.990><c> to</c><00:04:32.110><c> be</c><00:04:32.230><c> a</c><00:04:32.260><c> two</c><00:04:32.500><c> letter</c>

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

00:04:32.680 --> 00:04:37.620 align:start position:0%
mention that it needs to be a two letter
abbreviation<00:04:35.910><c> now</c><00:04:36.910><c> you</c><00:04:36.970><c> won't</c><00:04:37.240><c> need</c><00:04:37.360><c> to</c><00:04:37.420><c> add</c><00:04:37.600><c> a</c>

00:04:37.620 --> 00:04:37.630 align:start position:0%
abbreviation now you won't need to add a
 

00:04:37.630 --> 00:04:39.510 align:start position:0%
abbreviation now you won't need to add a
character<00:04:37.900><c> limit</c><00:04:38.440><c> or</c><00:04:38.530><c> validation</c><00:04:39.130><c> rule</c><00:04:39.310><c> to</c>

00:04:39.510 --> 00:04:39.520 align:start position:0%
character limit or validation rule to
 

00:04:39.520 --> 00:04:41.700 align:start position:0%
character limit or validation rule to
all<00:04:39.760><c> of</c><00:04:39.940><c> your</c><00:04:40.060><c> fields</c><00:04:40.420><c> but</c><00:04:40.990><c> you</c><00:04:41.110><c> can</c><00:04:41.260><c> add</c><00:04:41.410><c> one</c>

00:04:41.700 --> 00:04:41.710 align:start position:0%
all of your fields but you can add one
 

00:04:41.710 --> 00:04:43.230 align:start position:0%
all of your fields but you can add one
or<00:04:41.950><c> both</c><00:04:42.130><c> of</c><00:04:42.190><c> them</c><00:04:42.460><c> whenever</c><00:04:42.730><c> you</c><00:04:42.910><c> want</c><00:04:43.090><c> to</c>

00:04:43.230 --> 00:04:43.240 align:start position:0%
or both of them whenever you want to
 

00:04:43.240 --> 00:04:44.940 align:start position:0%
or both of them whenever you want to
control<00:04:43.600><c> the</c><00:04:43.780><c> types</c><00:04:44.050><c> of</c><00:04:44.230><c> information</c><00:04:44.380><c> that</c>

00:04:44.940 --> 00:04:44.950 align:start position:0%
control the types of information that
 

00:04:44.950 --> 00:04:47.970 align:start position:0%
control the types of information that
your<00:04:45.070><c> field</c><00:04:45.340><c> will</c><00:04:45.520><c> accept</c>