WEBVTT
Kind: captions
Language: en

00:00:04.370 --> 00:00:06.789 align:start position:0%
 
[Music]

00:00:06.789 --> 00:00:06.799 align:start position:0%
[Music]
 

00:00:06.799 --> 00:00:09.530 align:start position:0%
[Music]
now<00:00:07.799><c> we're</c><00:00:08.069><c> going</c><00:00:08.220><c> to</c><00:00:08.309><c> populate</c><00:00:08.820><c> our</c><00:00:08.970><c> database</c>

00:00:09.530 --> 00:00:09.540 align:start position:0%
now we're going to populate our database
 

00:00:09.540 --> 00:00:11.570 align:start position:0%
now we're going to populate our database
now<00:00:10.170><c> all</c><00:00:10.380><c> that</c><00:00:10.590><c> really</c><00:00:10.740><c> means</c><00:00:11.099><c> is</c><00:00:11.340><c> that</c><00:00:11.370><c> we're</c>

00:00:11.570 --> 00:00:11.580 align:start position:0%
now all that really means is that we're
 

00:00:11.580 --> 00:00:13.820 align:start position:0%
now all that really means is that we're
entering<00:00:11.849><c> data</c><00:00:12.120><c> records</c><00:00:12.570><c> into</c><00:00:12.900><c> it</c><00:00:13.080><c> this</c><00:00:13.559><c> can</c>

00:00:13.820 --> 00:00:13.830 align:start position:0%
entering data records into it this can
 

00:00:13.830 --> 00:00:15.890 align:start position:0%
entering data records into it this can
be<00:00:13.950><c> done</c><00:00:14.160><c> a</c><00:00:14.190><c> few</c><00:00:14.519><c> ways</c><00:00:14.759><c> one</c><00:00:15.330><c> of</c><00:00:15.360><c> which</c><00:00:15.509><c> is</c><00:00:15.780><c> by</c>

00:00:15.890 --> 00:00:15.900 align:start position:0%
be done a few ways one of which is by
 

00:00:15.900 --> 00:00:18.109 align:start position:0%
be done a few ways one of which is by
entering<00:00:16.320><c> records</c><00:00:16.740><c> directly</c><00:00:17.250><c> into</c><00:00:17.550><c> a</c><00:00:17.609><c> table</c>

00:00:18.109 --> 00:00:18.119 align:start position:0%
entering records directly into a table
 

00:00:18.119 --> 00:00:20.269 align:start position:0%
entering records directly into a table
we'll<00:00:18.690><c> do</c><00:00:18.930><c> that</c><00:00:19.109><c> with</c><00:00:19.289><c> the</c><00:00:19.410><c> books</c><00:00:19.619><c> table</c><00:00:19.830><c> first</c>

00:00:20.269 --> 00:00:20.279 align:start position:0%
we'll do that with the books table first
 

00:00:20.279 --> 00:00:22.130 align:start position:0%
we'll do that with the books table first
so<00:00:20.789><c> we</c><00:00:20.939><c> can</c><00:00:21.090><c> start</c><00:00:21.300><c> entering</c><00:00:21.390><c> the</c><00:00:21.689><c> books</c><00:00:21.930><c> we</c>

00:00:22.130 --> 00:00:22.140 align:start position:0%
so we can start entering the books we
 

00:00:22.140 --> 00:00:25.189 align:start position:0%
so we can start entering the books we
have<00:00:22.289><c> to</c><00:00:22.320><c> sell</c><00:00:22.710><c> our</c><00:00:23.119><c> books</c><00:00:24.119><c> table</c><00:00:24.539><c> is</c><00:00:24.630><c> empty</c><00:00:25.019><c> it</c>

00:00:25.189 --> 00:00:25.199 align:start position:0%
have to sell our books table is empty it
 

00:00:25.199 --> 00:00:27.230 align:start position:0%
have to sell our books table is empty it
has<00:00:25.410><c> no</c><00:00:25.740><c> records</c><00:00:26.250><c> in</c><00:00:26.430><c> it</c><00:00:26.550><c> so</c><00:00:26.849><c> we're</c><00:00:26.970><c> going</c><00:00:27.150><c> to</c>

00:00:27.230 --> 00:00:27.240 align:start position:0%
has no records in it so we're going to
 

00:00:27.240 --> 00:00:30.410 align:start position:0%
has no records in it so we're going to
add<00:00:27.449><c> some</c><00:00:27.869><c> in</c><00:00:28.490><c> Access</c><00:00:29.490><c> you</c><00:00:29.730><c> enter</c><00:00:30.029><c> records</c>

00:00:30.410 --> 00:00:30.420 align:start position:0%
add some in Access you enter records
 

00:00:30.420 --> 00:00:32.930 align:start position:0%
add some in Access you enter records
into<00:00:30.630><c> a</c><00:00:30.689><c> table</c><00:00:31.140><c> and</c><00:00:31.230><c> datasheet</c><00:00:31.859><c> view</c><00:00:31.890><c> which</c><00:00:32.759><c> is</c>

00:00:32.930 --> 00:00:32.940 align:start position:0%
into a table and datasheet view which is
 

00:00:32.940 --> 00:00:35.630 align:start position:0%
into a table and datasheet view which is
how<00:00:33.059><c> the</c><00:00:33.120><c> table</c><00:00:33.360><c> opens</c><00:00:33.930><c> to</c><00:00:34.739><c> add</c><00:00:34.920><c> a</c><00:00:34.950><c> record</c><00:00:35.399><c> to</c>

00:00:35.630 --> 00:00:35.640 align:start position:0%
how the table opens to add a record to
 

00:00:35.640 --> 00:00:37.760 align:start position:0%
how the table opens to add a record to
an<00:00:35.760><c> empty</c><00:00:36.000><c> table</c><00:00:36.480><c> type</c><00:00:36.989><c> the</c><00:00:37.170><c> record</c><00:00:37.530><c> into</c><00:00:37.739><c> the</c>

00:00:37.760 --> 00:00:37.770 align:start position:0%
an empty table type the record into the
 

00:00:37.770 --> 00:00:41.720 align:start position:0%
an empty table type the record into the
row<00:00:38.070><c> with</c><00:00:38.460><c> the</c><00:00:38.550><c> asterisk</c><00:00:40.160><c> we</c><00:00:41.160><c> don't</c><00:00:41.370><c> need</c><00:00:41.579><c> to</c>

00:00:41.720 --> 00:00:41.730 align:start position:0%
row with the asterisk we don't need to
 

00:00:41.730 --> 00:00:43.970 align:start position:0%
row with the asterisk we don't need to
enter<00:00:42.030><c> anything</c><00:00:42.450><c> into</c><00:00:43.020><c> the</c><00:00:43.140><c> book</c><00:00:43.290><c> ID</c><00:00:43.500><c> field</c>

00:00:43.970 --> 00:00:43.980 align:start position:0%
enter anything into the book ID field
 

00:00:43.980 --> 00:00:46.279 align:start position:0%
enter anything into the book ID field
because<00:00:44.820><c> the</c><00:00:44.940><c> data</c><00:00:45.180><c> type</c><00:00:45.539><c> is</c><00:00:45.750><c> set</c><00:00:45.930><c> to</c><00:00:46.079><c> auto</c>

00:00:46.279 --> 00:00:46.289 align:start position:0%
because the data type is set to auto
 

00:00:46.289 --> 00:00:49.580 align:start position:0%
because the data type is set to auto
number<00:00:46.890><c> so</c><00:00:47.700><c> this</c><00:00:48.120><c> fields</c><00:00:48.750><c> will</c><00:00:48.930><c> assign</c><00:00:49.320><c> a</c>

00:00:49.580 --> 00:00:49.590 align:start position:0%
number so this fields will assign a
 

00:00:49.590 --> 00:01:02.439 align:start position:0%
number so this fields will assign a
unique<00:00:49.980><c> number</c><00:00:50.460><c> to</c><00:00:50.940><c> each</c><00:00:50.969><c> record</c><00:00:51.629><c> you</c><00:00:52.199><c> enter</c>

00:01:02.439 --> 00:01:02.449 align:start position:0%
 
 

00:01:02.449 --> 00:01:05.450 align:start position:0%
 
we<00:01:03.449><c> already</c><00:01:03.930><c> set</c><00:01:04.229><c> the</c><00:01:04.350><c> price</c><00:01:04.650><c> data</c><00:01:04.979><c> type</c><00:01:05.280><c> to</c>

00:01:05.450 --> 00:01:05.460 align:start position:0%
we already set the price data type to
 

00:01:05.460 --> 00:01:07.850 align:start position:0%
we already set the price data type to
currency<00:01:05.850><c> so</c><00:01:06.540><c> when</c><00:01:06.689><c> someone</c><00:01:07.080><c> enters</c><00:01:07.439><c> numbers</c>

00:01:07.850 --> 00:01:07.860 align:start position:0%
currency so when someone enters numbers
 

00:01:07.860 --> 00:01:09.890 align:start position:0%
currency so when someone enters numbers
here<00:01:08.310><c> it</c><00:01:08.460><c> appears</c><00:01:08.820><c> there's</c><00:01:09.360><c> a</c><00:01:09.420><c> dollar</c><00:01:09.659><c> amount</c>

00:01:09.890 --> 00:01:09.900 align:start position:0%
here it appears there's a dollar amount
 

00:01:09.900 --> 00:01:14.330 align:start position:0%
here it appears there's a dollar amount
if<00:01:10.500><c> I</c><00:01:10.890><c> try</c><00:01:11.159><c> to</c><00:01:11.189><c> enter</c><00:01:11.549><c> text</c><00:01:11.790><c> here</c><00:01:12.030><c> I</c><00:01:13.220><c> get</c><00:01:14.220><c> this</c>

00:01:14.330 --> 00:01:14.340 align:start position:0%
if I try to enter text here I get this
 

00:01:14.340 --> 00:01:16.520 align:start position:0%
if I try to enter text here I get this
message<00:01:14.640><c> it</c><00:01:15.000><c> lets</c><00:01:15.299><c> me</c><00:01:15.540><c> know</c><00:01:15.570><c> that</c><00:01:15.810><c> the</c><00:01:16.140><c> data</c><00:01:16.409><c> I</c>

00:01:16.520 --> 00:01:16.530 align:start position:0%
message it lets me know that the data I
 

00:01:16.530 --> 00:01:18.620 align:start position:0%
message it lets me know that the data I
interr<00:01:17.040><c> does</c><00:01:17.250><c> not</c><00:01:17.490><c> match</c><00:01:17.790><c> a</c><00:01:17.970><c> currency</c><00:01:18.450><c> data</c>

00:01:18.620 --> 00:01:18.630 align:start position:0%
interr does not match a currency data
 

00:01:18.630 --> 00:01:23.590 align:start position:0%
interr does not match a currency data
type<00:01:18.960><c> that</c><00:01:19.170><c> I</c><00:01:19.200><c> set</c><00:01:19.500><c> up</c>

00:01:23.590 --> 00:01:23.600 align:start position:0%
 
 

00:01:23.600 --> 00:01:39.140 align:start position:0%
 
I'm<00:01:24.600><c> going</c><00:01:25.020><c> to</c><00:01:25.170><c> add</c><00:01:25.350><c> one</c><00:01:25.860><c> more</c><00:01:25.890><c> record</c><00:01:26.760><c> I</c><00:01:38.150><c> want</c>

00:01:39.140 --> 00:01:39.150 align:start position:0%
I'm going to add one more record I want
 

00:01:39.150 --> 00:01:40.700 align:start position:0%
I'm going to add one more record I want
to<00:01:39.240><c> point</c><00:01:39.479><c> something</c><00:01:39.690><c> out</c><00:01:39.960><c> to</c><00:01:40.020><c> you</c><00:01:40.380><c> that</c><00:01:40.500><c> has</c>

00:01:40.700 --> 00:01:40.710 align:start position:0%
to point something out to you that has
 

00:01:40.710 --> 00:01:42.650 align:start position:0%
to point something out to you that has
to<00:01:40.890><c> do</c><00:01:41.040><c> with</c><00:01:41.160><c> formatting</c><00:01:41.700><c> if</c><00:01:42.000><c> you</c><00:01:42.420><c> look</c>

00:01:42.650 --> 00:01:42.660 align:start position:0%
to do with formatting if you look
 

00:01:42.660 --> 00:01:44.990 align:start position:0%
to do with formatting if you look
closely<00:01:43.229><c> you'll</c><00:01:43.979><c> notice</c><00:01:44.070><c> that</c><00:01:44.550><c> you</c><00:01:44.700><c> can't</c>

00:01:44.990 --> 00:01:45.000 align:start position:0%
closely you'll notice that you can't
 

00:01:45.000 --> 00:01:47.719 align:start position:0%
closely you'll notice that you can't
really<00:01:45.180><c> see</c><00:01:45.300><c> the</c><00:01:45.630><c> entire</c><00:01:45.990><c> title</c><00:01:46.470><c> so</c><00:01:47.369><c> I'm</c><00:01:47.430><c> going</c>

00:01:47.719 --> 00:01:47.729 align:start position:0%
really see the entire title so I'm going
 

00:01:47.729 --> 00:01:49.580 align:start position:0%
really see the entire title so I'm going
to<00:01:47.790><c> double</c><00:01:48.240><c> click</c><00:01:48.420><c> on</c><00:01:48.570><c> the</c><00:01:48.869><c> line</c><00:01:49.080><c> between</c><00:01:49.320><c> the</c>

00:01:49.580 --> 00:01:49.590 align:start position:0%
to double click on the line between the
 

00:01:49.590 --> 00:01:52.780 align:start position:0%
to double click on the line between the
two<00:01:49.770><c> fields</c><00:01:50.310><c> to</c><00:01:50.580><c> expand</c><00:01:51.060><c> my</c><00:01:51.360><c> title</c><00:01:51.810><c> fields</c>

00:01:52.780 --> 00:01:52.790 align:start position:0%
two fields to expand my title fields
 

00:01:52.790 --> 00:01:57.020 align:start position:0%
two fields to expand my title fields
that's<00:01:53.790><c> a</c><00:01:54.000><c> lot</c><00:01:54.300><c> better</c><00:01:55.490><c> now</c><00:01:56.490><c> we</c><00:01:56.550><c> should</c><00:01:56.850><c> make</c>

00:01:57.020 --> 00:01:57.030 align:start position:0%
that's a lot better now we should make
 

00:01:57.030 --> 00:01:59.660 align:start position:0%
that's a lot better now we should make
sure<00:01:57.300><c> the</c><00:01:57.509><c> info</c><00:01:57.990><c> that</c><00:01:58.200><c> will</c><00:01:58.470><c> be</c><00:01:58.619><c> entered</c><00:01:59.130><c> into</c>

00:01:59.660 --> 00:01:59.670 align:start position:0%
sure the info that will be entered into
 

00:01:59.670 --> 00:02:02.210 align:start position:0%
sure the info that will be entered into
the<00:01:59.850><c> fields</c><00:02:00.360><c> is</c><00:02:00.479><c> formatted</c><00:02:00.930><c> properly</c><00:02:01.190><c> so</c><00:02:02.190><c> that</c>

00:02:02.210 --> 00:02:02.220 align:start position:0%
the fields is formatted properly so that
 

00:02:02.220 --> 00:02:05.060 align:start position:0%
the fields is formatted properly so that
is<00:02:02.550><c> accurate</c><00:02:03.210><c> it</c><00:02:03.390><c> can</c><00:02:03.420><c> be</c><00:02:03.690><c> useful</c><00:02:03.869><c> later</c><00:02:04.259><c> this</c>

00:02:05.060 --> 00:02:05.070 align:start position:0%
is accurate it can be useful later this
 

00:02:05.070 --> 00:02:07.940 align:start position:0%
is accurate it can be useful later this
is<00:02:05.250><c> called</c><00:02:05.520><c> data</c><00:02:06.030><c> validation</c><00:02:06.750><c> and</c><00:02:06.990><c> it</c><00:02:07.619><c> is</c><00:02:07.740><c> done</c>

00:02:07.940 --> 00:02:07.950 align:start position:0%
is called data validation and it is done
 

00:02:07.950 --> 00:02:09.830 align:start position:0%
is called data validation and it is done
by<00:02:08.160><c> setting</c><00:02:08.429><c> the</c><00:02:08.550><c> field</c><00:02:08.670><c> properties</c><00:02:09.209><c> in</c>

00:02:09.830 --> 00:02:09.840 align:start position:0%
by setting the field properties in
 

00:02:09.840 --> 00:02:13.009 align:start position:0%
by setting the field properties in
design<00:02:10.590><c> view</c><00:02:11.090><c> you've</c><00:02:12.090><c> seen</c><00:02:12.390><c> this</c><00:02:12.570><c> view</c><00:02:12.810><c> before</c>

00:02:13.009 --> 00:02:13.019 align:start position:0%
design view you've seen this view before
 

00:02:13.019 --> 00:02:15.470 align:start position:0%
design view you've seen this view before
when<00:02:13.590><c> we</c><00:02:13.709><c> set</c><00:02:13.950><c> up</c><00:02:13.980><c> the</c><00:02:14.190><c> data</c><00:02:14.400><c> types</c><00:02:14.730><c> up</c><00:02:15.030><c> here</c>

00:02:15.470 --> 00:02:15.480 align:start position:0%
when we set up the data types up here
 

00:02:15.480 --> 00:02:17.449 align:start position:0%
when we set up the data types up here
and<00:02:15.690><c> now</c><00:02:16.320><c> we'll</c><00:02:16.530><c> be</c><00:02:16.650><c> setting</c><00:02:17.010><c> some</c><00:02:17.220><c> of</c><00:02:17.340><c> these</c>

00:02:17.449 --> 00:02:17.459 align:start position:0%
and now we'll be setting some of these
 

00:02:17.459 --> 00:02:19.130 align:start position:0%
and now we'll be setting some of these
properties<00:02:17.880><c> in</c><00:02:18.180><c> the</c><00:02:18.269><c> bottom</c><00:02:18.300><c> half</c><00:02:18.870><c> of</c><00:02:19.050><c> the</c>

00:02:19.130 --> 00:02:19.140 align:start position:0%
properties in the bottom half of the
 

00:02:19.140 --> 00:02:21.290 align:start position:0%
properties in the bottom half of the
window<00:02:19.290><c> we'll</c><00:02:20.220><c> start</c><00:02:20.550><c> with</c><00:02:20.730><c> the</c><00:02:20.820><c> validation</c>

00:02:21.290 --> 00:02:21.300 align:start position:0%
window we'll start with the validation
 

00:02:21.300 --> 00:02:24.229 align:start position:0%
window we'll start with the validation
rule<00:02:21.590><c> we'll</c><00:02:22.590><c> set</c><00:02:22.920><c> it</c><00:02:22.950><c> up</c><00:02:23.250><c> so</c><00:02:23.700><c> that</c><00:02:23.850><c> the</c><00:02:23.940><c> price</c>

00:02:24.229 --> 00:02:24.239 align:start position:0%
rule we'll set it up so that the price
 

00:02:24.239 --> 00:02:26.270 align:start position:0%
rule we'll set it up so that the price
must<00:02:24.630><c> be</c><00:02:24.750><c> greater</c><00:02:25.110><c> than</c><00:02:25.200><c> zero</c><00:02:25.560><c> because</c><00:02:26.130><c> we're</c>

00:02:26.270 --> 00:02:26.280 align:start position:0%
must be greater than zero because we're
 

00:02:26.280 --> 00:02:28.940 align:start position:0%
must be greater than zero because we're
not<00:02:26.370><c> giving</c><00:02:26.760><c> books</c><00:02:26.970><c> away</c><00:02:27.200><c> now</c><00:02:28.200><c> the</c><00:02:28.260><c> validation</c>

00:02:28.940 --> 00:02:28.950 align:start position:0%
not giving books away now the validation
 

00:02:28.950 --> 00:02:31.130 align:start position:0%
not giving books away now the validation
text<00:02:29.280><c> is</c><00:02:29.579><c> what</c><00:02:29.910><c> you</c><00:02:30.060><c> want</c><00:02:30.269><c> to</c><00:02:30.390><c> appear</c><00:02:30.780><c> for</c><00:02:31.019><c> your</c>

00:02:31.130 --> 00:02:31.140 align:start position:0%
text is what you want to appear for your
 

00:02:31.140 --> 00:02:33.020 align:start position:0%
text is what you want to appear for your
user<00:02:31.470><c> when</c><00:02:32.190><c> they</c><00:02:32.220><c> enter</c><00:02:32.670><c> something</c>

00:02:33.020 --> 00:02:33.030 align:start position:0%
user when they enter something
 

00:02:33.030 --> 00:02:36.140 align:start position:0%
user when they enter something
incorrectly<00:02:33.680><c> so</c><00:02:34.680><c> if</c><00:02:34.829><c> they</c><00:02:35.010><c> were</c><00:02:35.160><c> to</c><00:02:35.340><c> enter</c><00:02:35.519><c> 0</c>

00:02:36.140 --> 00:02:36.150 align:start position:0%
incorrectly so if they were to enter 0
 

00:02:36.150 --> 00:02:38.630 align:start position:0%
incorrectly so if they were to enter 0
for<00:02:36.299><c> the</c><00:02:36.660><c> price</c><00:02:36.989><c> we</c><00:02:37.350><c> want</c><00:02:37.799><c> a</c><00:02:37.920><c> message</c><00:02:38.190><c> to</c><00:02:38.430><c> pop</c>

00:02:38.630 --> 00:02:38.640 align:start position:0%
for the price we want a message to pop
 

00:02:38.640 --> 00:02:42.949 align:start position:0%
for the price we want a message to pop
up<00:02:38.880><c> that</c><00:02:39.060><c> says</c><00:02:40.130><c> must</c><00:02:41.130><c> be</c><00:02:41.400><c> a</c><00:02:41.579><c> dollar</c><00:02:42.209><c> value</c>

00:02:42.949 --> 00:02:42.959 align:start position:0%
up that says must be a dollar value
 

00:02:42.959 --> 00:02:51.020 align:start position:0%
up that says must be a dollar value
higher<00:02:43.950><c> than</c><00:02:45.079><c> $0</c><00:02:49.010><c> the</c><00:02:50.010><c> required</c><00:02:50.519><c> field</c>

00:02:51.020 --> 00:02:51.030 align:start position:0%
higher than $0 the required field
 

00:02:51.030 --> 00:02:54.050 align:start position:0%
higher than $0 the required field
property<00:02:51.690><c> is</c><00:02:51.900><c> set</c><00:02:52.140><c> to</c><00:02:52.350><c> know</c><00:02:52.590><c> by</c><00:02:52.829><c> default</c><00:02:53.060><c> but</c>

00:02:54.050 --> 00:02:54.060 align:start position:0%
property is set to know by default but
 

00:02:54.060 --> 00:02:56.660 align:start position:0%
property is set to know by default but
in<00:02:54.209><c> this</c><00:02:54.420><c> case</c><00:02:54.720><c> it</c><00:02:54.989><c> must</c><00:02:55.260><c> be</c><00:02:55.410><c> set</c><00:02:55.650><c> to</c><00:02:55.829><c> yes</c><00:02:56.160><c> so</c>

00:02:56.660 --> 00:02:56.670 align:start position:0%
in this case it must be set to yes so
 

00:02:56.670 --> 00:02:59.210 align:start position:0%
in this case it must be set to yes so
that<00:02:56.850><c> a</c><00:02:56.970><c> user</c><00:02:57.239><c> has</c><00:02:57.360><c> to</c><00:02:57.900><c> enter</c><00:02:57.930><c> a</c><00:02:58.320><c> price</c><00:02:58.799><c> for</c>

00:02:59.210 --> 00:02:59.220 align:start position:0%
that a user has to enter a price for
 

00:02:59.220 --> 00:03:01.759 align:start position:0%
that a user has to enter a price for
each<00:02:59.459><c> book</c><00:02:59.820><c> in</c><00:02:59.970><c> our</c><00:03:00.090><c> store</c><00:03:00.480><c> they</c><00:03:01.200><c> will</c><00:03:01.350><c> never</c>

00:03:01.759 --> 00:03:01.769 align:start position:0%
each book in our store they will never
 

00:03:01.769 --> 00:03:07.340 align:start position:0%
each book in our store they will never
be<00:03:02.040><c> allowed</c><00:03:02.370><c> to</c><00:03:02.400><c> not</c><00:03:03.000><c> enter</c><00:03:03.570><c> a</c><00:03:03.630><c> price</c><00:03:06.350><c> let's</c>

00:03:07.340 --> 00:03:07.350 align:start position:0%
be allowed to not enter a price let's
 

00:03:07.350 --> 00:03:08.840 align:start position:0%
be allowed to not enter a price let's
take<00:03:07.560><c> a</c><00:03:07.590><c> look</c><00:03:07.950><c> at</c><00:03:08.040><c> the</c><00:03:08.130><c> default</c><00:03:08.340><c> field</c>

00:03:08.840 --> 00:03:08.850 align:start position:0%
take a look at the default field
 

00:03:08.850 --> 00:03:11.300 align:start position:0%
take a look at the default field
properties<00:03:09.390><c> for</c><00:03:09.600><c> a</c><00:03:09.630><c> field</c><00:03:10.049><c> that</c><00:03:10.230><c> has</c><00:03:10.500><c> a</c><00:03:10.799><c> text</c>

00:03:11.300 --> 00:03:11.310 align:start position:0%
properties for a field that has a text
 

00:03:11.310 --> 00:03:15.590 align:start position:0%
properties for a field that has a text
data<00:03:11.579><c> type</c><00:03:12.829><c> field</c><00:03:13.829><c> size</c><00:03:14.400><c> refers</c><00:03:15.150><c> to</c><00:03:15.180><c> how</c><00:03:15.570><c> many</c>

00:03:15.590 --> 00:03:15.600 align:start position:0%
data type field size refers to how many
 

00:03:15.600 --> 00:03:18.680 align:start position:0%
data type field size refers to how many
characters<00:03:16.380><c> the</c><00:03:16.680><c> user</c><00:03:16.950><c> can</c><00:03:17.190><c> type</c><00:03:17.400><c> in</c><00:03:17.670><c> for</c><00:03:18.570><c> the</c>

00:03:18.680 --> 00:03:18.690 align:start position:0%
characters the user can type in for the
 

00:03:18.690 --> 00:03:21.380 align:start position:0%
characters the user can type in for the
category<00:03:19.230><c> field</c><00:03:19.590><c> we</c><00:03:20.130><c> don't</c><00:03:20.370><c> know</c><00:03:20.730><c> how</c><00:03:21.060><c> long</c><00:03:21.329><c> a</c>

00:03:21.380 --> 00:03:21.390 align:start position:0%
category field we don't know how long a
 

00:03:21.390 --> 00:03:24.530 align:start position:0%
category field we don't know how long a
category<00:03:22.170><c> name</c><00:03:22.470><c> may</c><00:03:23.160><c> be</c><00:03:23.459><c> so</c><00:03:24.120><c> we'll</c><00:03:24.299><c> leave</c><00:03:24.480><c> it</c>

00:03:24.530 --> 00:03:24.540 align:start position:0%
category name may be so we'll leave it
 

00:03:24.540 --> 00:03:27.160 align:start position:0%
category name may be so we'll leave it
set<00:03:24.959><c> to</c><00:03:24.989><c> the</c><00:03:25.140><c> default</c><00:03:25.410><c> to</c><00:03:25.799><c> 255</c><00:03:26.760><c> characters</c>

00:03:27.160 --> 00:03:27.170 align:start position:0%
set to the default to 255 characters
 

00:03:27.170 --> 00:03:30.259 align:start position:0%
set to the default to 255 characters
which<00:03:28.170><c> is</c><00:03:28.320><c> probably</c><00:03:28.859><c> way</c><00:03:29.250><c> more</c><00:03:29.280><c> characters</c>

00:03:30.259 --> 00:03:30.269 align:start position:0%
which is probably way more characters
 

00:03:30.269 --> 00:03:33.360 align:start position:0%
which is probably way more characters
than<00:03:30.600><c> we'll</c><00:03:30.750><c> ever</c><00:03:30.780><c> use</c><00:03:31.410><c> but</c><00:03:31.860><c> you</c><00:03:32.220><c> never</c><00:03:32.430><c> know</c>

00:03:33.360 --> 00:03:33.370 align:start position:0%
than we'll ever use but you never know
 

00:03:33.370 --> 00:03:36.150 align:start position:0%
than we'll ever use but you never know
I<00:03:33.510><c> also</c><00:03:34.510><c> want</c><00:03:34.930><c> to</c><00:03:34.959><c> set</c><00:03:35.200><c> up</c><00:03:35.230><c> a</c><00:03:35.379><c> validation</c><00:03:35.920><c> rule</c>

00:03:36.150 --> 00:03:36.160 align:start position:0%
I also want to set up a validation rule
 

00:03:36.160 --> 00:03:39.780 align:start position:0%
I also want to set up a validation rule
for<00:03:36.430><c> category</c><00:03:36.849><c> I</c><00:03:37.560><c> want</c><00:03:38.560><c> the</c><00:03:38.709><c> database</c><00:03:39.190><c> user</c><00:03:39.519><c> to</c>

00:03:39.780 --> 00:03:39.790 align:start position:0%
for category I want the database user to
 

00:03:39.790 --> 00:03:41.580 align:start position:0%
for category I want the database user to
have<00:03:39.819><c> to</c><00:03:40.239><c> enter</c><00:03:40.569><c> one</c><00:03:40.930><c> of</c><00:03:41.110><c> the</c><00:03:41.200><c> categories</c>

00:03:41.580 --> 00:03:41.590 align:start position:0%
have to enter one of the categories
 

00:03:41.590 --> 00:03:44.670 align:start position:0%
have to enter one of the categories
that's<00:03:42.129><c> used</c><00:03:42.430><c> at</c><00:03:42.610><c> the</c><00:03:42.730><c> store</c><00:03:43.019><c> I'll</c><00:03:44.019><c> use</c><00:03:44.530><c> the</c>

00:03:44.670 --> 00:03:44.680 align:start position:0%
that's used at the store I'll use the
 

00:03:44.680 --> 00:03:48.210 align:start position:0%
that's used at the store I'll use the
expression<00:03:45.250><c> builder</c><00:03:45.400><c> to</c><00:03:45.730><c> do</c><00:03:45.879><c> this</c><00:03:47.220><c> the</c>

00:03:48.210 --> 00:03:48.220 align:start position:0%
expression builder to do this the
 

00:03:48.220 --> 00:03:50.280 align:start position:0%
expression builder to do this the
validation<00:03:48.970><c> rule</c><00:03:49.150><c> starts</c><00:03:49.660><c> with</c><00:03:49.810><c> an</c><00:03:49.930><c> equal</c>

00:03:50.280 --> 00:03:50.290 align:start position:0%
validation rule starts with an equal
 

00:03:50.290 --> 00:03:52.890 align:start position:0%
validation rule starts with an equal
sign<00:03:50.590><c> we'll</c><00:03:51.549><c> place</c><00:03:51.849><c> quotation</c><00:03:52.120><c> marks</c><00:03:52.810><c> around</c>

00:03:52.890 --> 00:03:52.900 align:start position:0%
sign we'll place quotation marks around
 

00:03:52.900 --> 00:03:55.559 align:start position:0%
sign we'll place quotation marks around
each<00:03:53.290><c> category</c><00:03:54.099><c> name</c><00:03:54.370><c> which</c><00:03:55.180><c> will</c><00:03:55.330><c> tell</c>

00:03:55.559 --> 00:03:55.569 align:start position:0%
each category name which will tell
 

00:03:55.569 --> 00:03:57.660 align:start position:0%
each category name which will tell
access<00:03:56.140><c> that</c><00:03:56.500><c> it</c><00:03:56.620><c> needs</c><00:03:56.890><c> to</c><00:03:57.040><c> check</c><00:03:57.370><c> the</c>

00:03:57.660 --> 00:03:57.670 align:start position:0%
access that it needs to check the
 

00:03:57.670 --> 00:03:59.820 align:start position:0%
access that it needs to check the
entered<00:03:58.090><c> data</c><00:03:58.120><c> to</c><00:03:58.989><c> make</c><00:03:59.200><c> sure</c><00:03:59.260><c> it</c><00:03:59.590><c> matches</c>

00:03:59.820 --> 00:03:59.830 align:start position:0%
entered data to make sure it matches
 

00:03:59.830 --> 00:04:01.710 align:start position:0%
entered data to make sure it matches
exactly<00:04:00.160><c> one</c><00:04:00.879><c> of</c><00:04:00.910><c> the</c><00:04:01.030><c> choices</c><00:04:01.569><c> we</c><00:04:01.599><c> have</c>

00:04:01.710 --> 00:04:01.720 align:start position:0%
exactly one of the choices we have
 

00:04:01.720 --> 00:04:06.240 align:start position:0%
exactly one of the choices we have
inside<00:04:02.379><c> the</c><00:04:02.530><c> quotation</c><00:04:03.040><c> marks</c><00:04:04.650><c> so</c><00:04:05.650><c> if</c><00:04:05.829><c> someone</c>

00:04:06.240 --> 00:04:06.250 align:start position:0%
inside the quotation marks so if someone
 

00:04:06.250 --> 00:04:08.520 align:start position:0%
inside the quotation marks so if someone
enters<00:04:06.430><c> something</c><00:04:06.880><c> in</c><00:04:07.150><c> lowercase</c><00:04:07.569><c> or</c><00:04:08.200><c> a</c>

00:04:08.520 --> 00:04:08.530 align:start position:0%
enters something in lowercase or a
 

00:04:08.530 --> 00:04:11.250 align:start position:0%
enters something in lowercase or a
category<00:04:09.190><c> that's</c><00:04:09.220><c> not</c><00:04:09.640><c> in</c><00:04:09.910><c> the</c><00:04:10.060><c> list</c><00:04:10.090><c> it</c><00:04:10.720><c> won't</c>

00:04:11.250 --> 00:04:11.260 align:start position:0%
category that's not in the list it won't
 

00:04:11.260 --> 00:04:14.520 align:start position:0%
category that's not in the list it won't
accept<00:04:11.560><c> the</c><00:04:11.709><c> data</c><00:04:12.660><c> this</c><00:04:13.660><c> helps</c><00:04:14.019><c> cut</c><00:04:14.230><c> down</c><00:04:14.260><c> on</c>

00:04:14.520 --> 00:04:14.530 align:start position:0%
accept the data this helps cut down on
 

00:04:14.530 --> 00:04:18.360 align:start position:0%
accept the data this helps cut down on
data<00:04:14.890><c> entry</c><00:04:14.980><c> mistakes</c><00:04:16.560><c> I'm</c><00:04:17.560><c> inserting</c><00:04:18.010><c> or</c>

00:04:18.360 --> 00:04:18.370 align:start position:0%
data entry mistakes I'm inserting or
 

00:04:18.370 --> 00:04:21.330 align:start position:0%
data entry mistakes I'm inserting or
between<00:04:19.060><c> each</c><00:04:19.299><c> word</c><00:04:19.630><c> which</c><00:04:20.290><c> simply</c><00:04:20.799><c> means</c><00:04:20.829><c> I'm</c>

00:04:21.330 --> 00:04:21.340 align:start position:0%
between each word which simply means I'm
 

00:04:21.340 --> 00:04:23.219 align:start position:0%
between each word which simply means I'm
giving<00:04:21.639><c> access</c><00:04:22.120><c> lots</c><00:04:22.419><c> of</c><00:04:22.630><c> options</c><00:04:23.080><c> to</c><00:04:23.110><c> choose</c>

00:04:23.219 --> 00:04:23.229 align:start position:0%
giving access lots of options to choose
 

00:04:23.229 --> 00:04:24.060 align:start position:0%
giving access lots of options to choose
from

00:04:24.060 --> 00:04:24.070 align:start position:0%
from
 

00:04:24.070 --> 00:04:26.580 align:start position:0%
from
I'm<00:04:24.160><c> telling</c><00:04:25.000><c> access</c><00:04:25.539><c> this</c><00:04:25.900><c> field</c><00:04:26.229><c> must</c>

00:04:26.580 --> 00:04:26.590 align:start position:0%
I'm telling access this field must
 

00:04:26.590 --> 00:04:30.570 align:start position:0%
I'm telling access this field must
include<00:04:26.860><c> fiction</c><00:04:27.520><c> or</c><00:04:27.810><c> nonfiction</c><00:04:28.810><c> or</c><00:04:29.580><c> kids</c>

00:04:30.570 --> 00:04:30.580 align:start position:0%
include fiction or nonfiction or kids
 

00:04:30.580 --> 00:04:36.670 align:start position:0%
include fiction or nonfiction or kids
and<00:04:31.000><c> so</c><00:04:31.330><c> forth</c>

00:04:36.670 --> 00:04:36.680 align:start position:0%
 
 

00:04:36.680 --> 00:04:40.480 align:start position:0%
 
now<00:04:37.280><c> so</c><00:04:38.240><c> users</c><00:04:38.750><c> know</c><00:04:39.020><c> what</c><00:04:39.470><c> we</c><00:04:39.650><c> expect</c><00:04:40.190><c> of</c><00:04:40.340><c> them</c>

00:04:40.480 --> 00:04:40.490 align:start position:0%
now so users know what we expect of them
 

00:04:40.490 --> 00:04:42.490 align:start position:0%
now so users know what we expect of them
we<00:04:40.850><c> have</c><00:04:41.090><c> to</c><00:04:41.240><c> set</c><00:04:41.449><c> the</c><00:04:41.479><c> validation</c><00:04:42.139><c> text</c><00:04:42.350><c> to</c>

00:04:42.490 --> 00:04:42.500 align:start position:0%
we have to set the validation text to
 

00:04:42.500 --> 00:04:47.920 align:start position:0%
we have to set the validation text to
read<00:04:43.000><c> must</c><00:04:44.000><c> be</c><00:04:44.240><c> fiction</c><00:04:45.220><c> nonfiction</c><00:04:46.220><c> and</c><00:04:47.210><c> so</c>

00:04:47.920 --> 00:04:47.930 align:start position:0%
read must be fiction nonfiction and so
 

00:04:47.930 --> 00:04:57.879 align:start position:0%
read must be fiction nonfiction and so
on<00:04:55.000><c> this</c><00:04:56.000><c> text</c><00:04:56.509><c> is</c><00:04:56.630><c> what</c><00:04:56.810><c> our</c><00:04:56.990><c> user</c><00:04:57.350><c> will</c><00:04:57.620><c> see</c>

00:04:57.879 --> 00:04:57.889 align:start position:0%
on this text is what our user will see
 

00:04:57.889 --> 00:04:59.800 align:start position:0%
on this text is what our user will see
if<00:04:58.160><c> they</c><00:04:58.280><c> enter</c><00:04:58.550><c> a</c><00:04:58.580><c> category</c><00:04:58.880><c> that</c><00:04:59.360><c> doesn't</c>

00:04:59.800 --> 00:04:59.810 align:start position:0%
if they enter a category that doesn't
 

00:04:59.810 --> 00:05:02.170 align:start position:0%
if they enter a category that doesn't
match<00:05:00.020><c> what</c><00:05:00.380><c> we</c><00:05:00.530><c> have</c><00:05:00.740><c> told</c><00:05:00.979><c> access</c><00:05:01.580><c> to</c><00:05:01.729><c> accept</c>

00:05:02.170 --> 00:05:02.180 align:start position:0%
match what we have told access to accept
 

00:05:02.180 --> 00:05:04.330 align:start position:0%
match what we have told access to accept
just<00:05:03.020><c> like</c><00:05:03.259><c> when</c><00:05:03.440><c> we</c><00:05:03.470><c> set</c><00:05:03.740><c> the</c><00:05:03.860><c> price</c><00:05:04.130><c> to</c><00:05:04.280><c> be</c>

00:05:04.330 --> 00:05:04.340 align:start position:0%
just like when we set the price to be
 

00:05:04.340 --> 00:05:07.600 align:start position:0%
just like when we set the price to be
greater<00:05:04.669><c> than</c><00:05:04.880><c> zero</c><00:05:05.150><c> earlier</c><00:05:06.070><c> so</c><00:05:07.070><c> all</c><00:05:07.340><c> of</c><00:05:07.520><c> the</c>

00:05:07.600 --> 00:05:07.610 align:start position:0%
greater than zero earlier so all of the
 

00:05:07.610 --> 00:05:09.879 align:start position:0%
greater than zero earlier so all of the
settings<00:05:08.030><c> here</c><00:05:08.300><c> look</c><00:05:08.479><c> good</c><00:05:08.690><c> I'll</c><00:05:09.050><c> save</c><00:05:09.680><c> my</c>

00:05:09.879 --> 00:05:09.889 align:start position:0%
settings here look good I'll save my
 

00:05:09.889 --> 00:05:14.140 align:start position:0%
settings here look good I'll save my
changes<00:05:11.860><c> ok</c><00:05:12.860><c> as</c><00:05:13.400><c> soon</c><00:05:13.460><c> as</c><00:05:13.729><c> we</c><00:05:13.850><c> enter</c>

00:05:14.140 --> 00:05:14.150 align:start position:0%
changes ok as soon as we enter
 

00:05:14.150 --> 00:05:16.600 align:start position:0%
changes ok as soon as we enter
nonfiction<00:05:14.810><c> in</c><00:05:15.169><c> our</c><00:05:15.289><c> category</c><00:05:15.889><c> field</c><00:05:16.130><c> earlier</c>

00:05:16.600 --> 00:05:16.610 align:start position:0%
nonfiction in our category field earlier
 

00:05:16.610 --> 00:05:19.450 align:start position:0%
nonfiction in our category field earlier
before<00:05:17.419><c> setting</c><00:05:18.169><c> our</c><00:05:18.289><c> field</c><00:05:18.620><c> properties</c><00:05:19.250><c> I</c>

00:05:19.450 --> 00:05:19.460 align:start position:0%
before setting our field properties I
 

00:05:19.460 --> 00:05:21.760 align:start position:0%
before setting our field properties I
received<00:05:20.030><c> this</c><00:05:20.210><c> message</c><00:05:20.720><c> saying</c><00:05:20.960><c> data</c>

00:05:21.760 --> 00:05:21.770 align:start position:0%
received this message saying data
 

00:05:21.770 --> 00:05:24.120 align:start position:0%
received this message saying data
integrity<00:05:22.280><c> rules</c><00:05:23.150><c> have</c><00:05:23.600><c> been</c><00:05:23.690><c> changed</c>

00:05:24.120 --> 00:05:24.130 align:start position:0%
integrity rules have been changed
 

00:05:24.130 --> 00:05:26.740 align:start position:0%
integrity rules have been changed
existing<00:05:25.130><c> data</c><00:05:25.400><c> may</c><00:05:25.610><c> not</c><00:05:25.639><c> be</c><00:05:25.850><c> valid</c><00:05:26.419><c> for</c><00:05:26.449><c> new</c>

00:05:26.740 --> 00:05:26.750 align:start position:0%
existing data may not be valid for new
 

00:05:26.750 --> 00:05:29.620 align:start position:0%
existing data may not be valid for new
rules<00:05:27.050><c> by</c><00:05:27.979><c> clicking</c><00:05:28.460><c> yes</c><00:05:28.729><c> I</c><00:05:29.000><c> can</c><00:05:29.270><c> choose</c><00:05:29.479><c> to</c>

00:05:29.620 --> 00:05:29.630 align:start position:0%
rules by clicking yes I can choose to
 

00:05:29.630 --> 00:05:31.150 align:start position:0%
rules by clicking yes I can choose to
have<00:05:29.780><c> my</c><00:05:29.960><c> data</c><00:05:30.199><c> test</c><00:05:30.620><c> sent</c><00:05:30.860><c> with</c><00:05:30.949><c> the</c><00:05:31.039><c> new</c>

00:05:31.150 --> 00:05:31.160 align:start position:0%
have my data test sent with the new
 

00:05:31.160 --> 00:05:36.100 align:start position:0%
have my data test sent with the new
rules<00:05:31.460><c> so</c><00:05:32.300><c> I'm</c><00:05:32.690><c> going</c><00:05:33.020><c> to</c><00:05:33.080><c> do</c><00:05:33.229><c> that</c><00:05:34.360><c> now</c><00:05:35.360><c> let's</c>

00:05:36.100 --> 00:05:36.110 align:start position:0%
rules so I'm going to do that now let's
 

00:05:36.110 --> 00:05:39.760 align:start position:0%
rules so I'm going to do that now let's
get<00:05:36.289><c> back</c><00:05:36.470><c> to</c><00:05:36.620><c> entering</c><00:05:36.949><c> records</c><00:05:37.400><c> I</c><00:05:38.620><c> want</c><00:05:39.620><c> to</c>

00:05:39.760 --> 00:05:39.770 align:start position:0%
get back to entering records I want to
 

00:05:39.770 --> 00:05:41.469 align:start position:0%
get back to entering records I want to
show<00:05:39.949><c> you</c><00:05:40.009><c> how</c><00:05:40.280><c> the</c><00:05:40.340><c> validation</c><00:05:40.970><c> rule</c><00:05:41.150><c> works</c>

00:05:41.469 --> 00:05:41.479 align:start position:0%
show you how the validation rule works
 

00:05:41.479 --> 00:05:45.520 align:start position:0%
show you how the validation rule works
so<00:05:42.080><c> for</c><00:05:42.289><c> category</c><00:05:42.830><c> I'll</c><00:05:43.310><c> enter</c><00:05:43.849><c> cooking</c><00:05:44.810><c> when</c>

00:05:45.520 --> 00:05:45.530 align:start position:0%
so for category I'll enter cooking when
 

00:05:45.530 --> 00:05:49.180 align:start position:0%
so for category I'll enter cooking when
it<00:05:45.650><c> really</c><00:05:45.979><c> should</c><00:05:46.010><c> be</c><00:05:46.400><c> food</c><00:05:47.349><c> see</c><00:05:48.349><c> I</c><00:05:48.620><c> get</c><00:05:49.160><c> a</c>

00:05:49.180 --> 00:05:49.190 align:start position:0%
it really should be food see I get a
 

00:05:49.190 --> 00:05:51.339 align:start position:0%
it really should be food see I get a
message<00:05:49.490><c> it</c><00:05:49.760><c> tells</c><00:05:49.970><c> me</c><00:05:50.120><c> I</c><00:05:50.180><c> must</c><00:05:50.449><c> enter</c><00:05:50.720><c> one</c><00:05:51.169><c> of</c>

00:05:51.339 --> 00:05:51.349 align:start position:0%
message it tells me I must enter one of
 

00:05:51.349 --> 00:05:54.219 align:start position:0%
message it tells me I must enter one of
the<00:05:51.410><c> following</c><00:05:51.740><c> options</c><00:05:52.570><c> I'll</c><00:05:53.570><c> go</c><00:05:53.870><c> ahead</c><00:05:53.990><c> and</c>

00:05:54.219 --> 00:05:54.229 align:start position:0%
the following options I'll go ahead and
 

00:05:54.229 --> 00:05:58.870 align:start position:0%
the following options I'll go ahead and
correct<00:05:54.530><c> this</c><00:05:57.220><c> let's</c><00:05:58.220><c> take</c><00:05:58.400><c> a</c><00:05:58.430><c> look</c><00:05:58.699><c> at</c><00:05:58.789><c> the</c>

00:05:58.870 --> 00:05:58.880 align:start position:0%
correct this let's take a look at the
 

00:05:58.880 --> 00:06:01.750 align:start position:0%
correct this let's take a look at the
customers<00:05:59.330><c> table</c><00:05:59.800><c> now</c><00:06:00.800><c> sometimes</c><00:06:01.340><c> you</c><00:06:01.550><c> may</c>

00:06:01.750 --> 00:06:01.760 align:start position:0%
customers table now sometimes you may
 

00:06:01.760 --> 00:06:03.339 align:start position:0%
customers table now sometimes you may
have<00:06:01.940><c> to</c><00:06:02.000><c> enter</c><00:06:02.300><c> data</c><00:06:02.510><c> into</c><00:06:02.780><c> tables</c><00:06:03.050><c> that</c>

00:06:03.339 --> 00:06:03.349 align:start position:0%
have to enter data into tables that
 

00:06:03.349 --> 00:06:05.710 align:start position:0%
have to enter data into tables that
already<00:06:03.889><c> have</c><00:06:04.130><c> a</c><00:06:04.159><c> lot</c><00:06:04.580><c> of</c><00:06:04.610><c> data</c><00:06:05.030><c> records</c><00:06:05.510><c> in</c>

00:06:05.710 --> 00:06:05.720 align:start position:0%
already have a lot of data records in
 

00:06:05.720 --> 00:06:08.080 align:start position:0%
already have a lot of data records in
them<00:06:05.960><c> you</c><00:06:06.710><c> can</c><00:06:06.889><c> see</c><00:06:07.130><c> that</c><00:06:07.280><c> I've</c><00:06:07.400><c> already</c><00:06:07.580><c> added</c>

00:06:08.080 --> 00:06:08.090 align:start position:0%
them you can see that I've already added
 

00:06:08.090 --> 00:06:10.570 align:start position:0%
them you can see that I've already added
some<00:06:08.360><c> records</c><00:06:08.750><c> to</c><00:06:08.870><c> this</c><00:06:08.990><c> table</c><00:06:09.470><c> I</c><00:06:09.650><c> can</c><00:06:10.430><c> see</c>

00:06:10.570 --> 00:06:10.580 align:start position:0%
some records to this table I can see
 

00:06:10.580 --> 00:06:12.670 align:start position:0%
some records to this table I can see
that<00:06:10.669><c> it's</c><00:06:10.849><c> populated</c><00:06:11.270><c> with</c><00:06:11.449><c> 10</c><00:06:11.750><c> records</c><00:06:12.289><c> by</c>

00:06:12.670 --> 00:06:12.680 align:start position:0%
that it's populated with 10 records by
 

00:06:12.680 --> 00:06:15.760 align:start position:0%
that it's populated with 10 records by
taking<00:06:13.099><c> a</c><00:06:13.190><c> quick</c><00:06:13.460><c> glance</c><00:06:13.599><c> but</c><00:06:14.599><c> I</c><00:06:14.900><c> can</c><00:06:15.199><c> also</c><00:06:15.440><c> see</c>

00:06:15.760 --> 00:06:15.770 align:start position:0%
taking a quick glance but I can also see
 

00:06:15.770 --> 00:06:17.680 align:start position:0%
taking a quick glance but I can also see
the<00:06:15.860><c> number</c><00:06:16.039><c> of</c><00:06:16.220><c> records</c><00:06:16.760><c> here</c><00:06:17.060><c> at</c><00:06:17.090><c> the</c><00:06:17.330><c> bottom</c>

00:06:17.680 --> 00:06:17.690 align:start position:0%
the number of records here at the bottom
 

00:06:17.690 --> 00:06:20.740 align:start position:0%
the number of records here at the bottom
left<00:06:17.720><c> side</c><00:06:18.289><c> of</c><00:06:18.470><c> the</c><00:06:18.560><c> table</c><00:06:19.240><c> this</c><00:06:20.240><c> is</c><00:06:20.300><c> a</c><00:06:20.479><c> record</c>

00:06:20.740 --> 00:06:20.750 align:start position:0%
left side of the table this is a record
 

00:06:20.750 --> 00:06:23.620 align:start position:0%
left side of the table this is a record
navigation<00:06:21.560><c> I</c><00:06:21.800><c> can</c><00:06:22.639><c> choose</c><00:06:22.880><c> to</c><00:06:22.909><c> go</c><00:06:23.180><c> back</c><00:06:23.210><c> to</c>

00:06:23.620 --> 00:06:23.630 align:start position:0%
navigation I can choose to go back to
 

00:06:23.630 --> 00:06:29.890 align:start position:0%
navigation I can choose to go back to
the<00:06:23.750><c> first</c><00:06:26.110><c> previous/next</c><00:06:28.000><c> or</c><00:06:29.000><c> last</c><00:06:29.449><c> record</c>

00:06:29.890 --> 00:06:29.900 align:start position:0%
the first previous/next or last record
 

00:06:29.900 --> 00:06:34.270 align:start position:0%
the first previous/next or last record
or<00:06:30.550><c> create</c><00:06:31.550><c> a</c><00:06:31.580><c> new</c><00:06:31.699><c> record</c><00:06:32.090><c> from</c><00:06:32.449><c> here</c><00:06:32.690><c> I</c><00:06:33.280><c> can</c>

00:06:34.270 --> 00:06:34.280 align:start position:0%
or create a new record from here I can
 

00:06:34.280 --> 00:06:36.279 align:start position:0%
or create a new record from here I can
also<00:06:34.490><c> create</c><00:06:34.849><c> a</c><00:06:35.270><c> new</c><00:06:35.300><c> record</c><00:06:35.630><c> from</c><00:06:35.900><c> the</c><00:06:36.050><c> home</c>

00:06:36.279 --> 00:06:36.289 align:start position:0%
also create a new record from the home
 

00:06:36.289 --> 00:06:39.790 align:start position:0%
also create a new record from the home
tab<00:06:36.710><c> by</c><00:06:37.460><c> clicking</c><00:06:37.490><c> on</c><00:06:38.090><c> noon</c><00:06:38.539><c> in</c><00:06:38.900><c> the</c><00:06:39.409><c> records</c>

00:06:39.790 --> 00:06:39.800 align:start position:0%
tab by clicking on noon in the records
 

00:06:39.800 --> 00:06:40.980 align:start position:0%
tab by clicking on noon in the records
group

00:06:40.980 --> 00:06:40.990 align:start position:0%
group
 

00:06:40.990 --> 00:06:52.760 align:start position:0%
group
now<00:06:41.590><c> all</c><00:06:41.800><c> I</c><00:06:41.830><c> have</c><00:06:42.069><c> to</c><00:06:42.160><c> do</c><00:06:42.310><c> is</c><00:06:42.430><c> enter</c><00:06:42.610><c> my</c><00:06:42.729><c> data</c>

00:06:52.760 --> 00:06:52.770 align:start position:0%
 
 

00:06:52.770 --> 00:06:55.200 align:start position:0%
 
sometimes<00:06:53.770><c> you'll</c><00:06:53.979><c> need</c><00:06:54.009><c> to</c><00:06:54.280><c> edit</c><00:06:54.699><c> a</c><00:06:54.789><c> record</c>

00:06:55.200 --> 00:06:55.210 align:start position:0%
sometimes you'll need to edit a record
 

00:06:55.210 --> 00:06:57.330 align:start position:0%
sometimes you'll need to edit a record
that<00:06:55.330><c> already</c><00:06:55.750><c> exists</c><00:06:56.139><c> in</c><00:06:56.229><c> the</c><00:06:56.289><c> table</c><00:06:56.680><c> for</c>

00:06:57.330 --> 00:06:57.340 align:start position:0%
that already exists in the table for
 

00:06:57.340 --> 00:06:59.850 align:start position:0%
that already exists in the table for
example<00:06:57.599><c> let's</c><00:06:58.599><c> say</c><00:06:58.960><c> one</c><00:06:59.229><c> of</c><00:06:59.259><c> our</c><00:06:59.380><c> customers</c>

00:06:59.850 --> 00:06:59.860 align:start position:0%
example let's say one of our customers
 

00:06:59.860 --> 00:07:01.409 align:start position:0%
example let's say one of our customers
has<00:07:00.009><c> gotten</c><00:07:00.250><c> married</c><00:07:00.550><c> and</c><00:07:00.819><c> I</c><00:07:00.910><c> need</c><00:07:01.090><c> to</c><00:07:01.240><c> change</c>

00:07:01.409 --> 00:07:01.419 align:start position:0%
has gotten married and I need to change
 

00:07:01.419 --> 00:07:02.159 align:start position:0%
has gotten married and I need to change
her<00:07:01.630><c> name</c>

00:07:02.159 --> 00:07:02.169 align:start position:0%
her name
 

00:07:02.169 --> 00:07:04.980 align:start position:0%
her name
I<00:07:02.460><c> could</c><00:07:03.460><c> take</c><00:07:03.759><c> time</c><00:07:04.000><c> to</c><00:07:04.270><c> look</c><00:07:04.389><c> through</c><00:07:04.449><c> every</c>

00:07:04.980 --> 00:07:04.990 align:start position:0%
I could take time to look through every
 

00:07:04.990 --> 00:07:06.809 align:start position:0%
I could take time to look through every
single<00:07:05.319><c> record</c><00:07:05.470><c> to</c><00:07:05.740><c> find</c><00:07:05.919><c> this</c><00:07:06.160><c> one</c><00:07:06.430><c> customer</c>

00:07:06.809 --> 00:07:06.819 align:start position:0%
single record to find this one customer
 

00:07:06.819 --> 00:07:09.390 align:start position:0%
single record to find this one customer
but<00:07:07.569><c> what</c><00:07:07.720><c> if</c><00:07:07.840><c> I</c><00:07:07.930><c> had</c><00:07:08.199><c> thousands</c><00:07:08.860><c> of</c><00:07:08.949><c> records</c>

00:07:09.390 --> 00:07:09.400 align:start position:0%
but what if I had thousands of records
 

00:07:09.400 --> 00:07:12.600 align:start position:0%
but what if I had thousands of records
it<00:07:09.940><c> would</c><00:07:10.810><c> be</c><00:07:10.990><c> much</c><00:07:11.319><c> much</c><00:07:11.620><c> easier</c><00:07:12.220><c> to</c><00:07:12.400><c> use</c><00:07:12.580><c> a</c>

00:07:12.600 --> 00:07:12.610 align:start position:0%
it would be much much easier to use a
 

00:07:12.610 --> 00:07:14.879 align:start position:0%
it would be much much easier to use a
find<00:07:13.060><c> feature</c><00:07:13.419><c> to</c><00:07:13.810><c> finds</c><00:07:14.110><c> and</c><00:07:14.410><c> replace</c><00:07:14.680><c> an</c>

00:07:14.879 --> 00:07:14.889 align:start position:0%
find feature to finds and replace an
 

00:07:14.889 --> 00:07:18.960 align:start position:0%
find feature to finds and replace an
entry<00:07:15.780><c> from</c><00:07:16.780><c> the</c><00:07:16.900><c> Home</c><00:07:17.169><c> tab</c><00:07:17.310><c> click</c><00:07:18.310><c> on</c><00:07:18.400><c> finds</c>

00:07:18.960 --> 00:07:18.970 align:start position:0%
entry from the Home tab click on finds
 

00:07:18.970 --> 00:07:22.350 align:start position:0%
entry from the Home tab click on finds
in<00:07:19.419><c> the</c><00:07:19.479><c> finds</c><00:07:19.900><c> group</c><00:07:20.430><c> the</c><00:07:21.430><c> finds</c><00:07:21.759><c> and</c><00:07:22.060><c> Replace</c>

00:07:22.350 --> 00:07:22.360 align:start position:0%
in the finds group the finds and Replace
 

00:07:22.360 --> 00:07:25.740 align:start position:0%
in the finds group the finds and Replace
dialog<00:07:22.930><c> box</c><00:07:23.259><c> appears</c><00:07:24.060><c> type</c><00:07:25.060><c> in</c><00:07:25.300><c> what</c><00:07:25.570><c> you</c><00:07:25.720><c> want</c>

00:07:25.740 --> 00:07:25.750 align:start position:0%
dialog box appears type in what you want
 

00:07:25.750 --> 00:07:31.920 align:start position:0%
dialog box appears type in what you want
to<00:07:26.080><c> find</c><00:07:26.380><c> here</c><00:07:27.070><c> I</c><00:07:28.380><c> want</c><00:07:29.380><c> to</c><00:07:29.500><c> find</c><00:07:30.030><c> Williams</c><00:07:31.030><c> so</c>

00:07:31.920 --> 00:07:31.930 align:start position:0%
to find here I want to find Williams so
 

00:07:31.930 --> 00:07:35.100 align:start position:0%
to find here I want to find Williams so
I<00:07:31.960><c> can</c><00:07:32.349><c> change</c><00:07:32.590><c> Kiara</c><00:07:33.280><c> Williams</c><00:07:34.000><c> to</c><00:07:34.599><c> Kiara</c>

00:07:35.100 --> 00:07:35.110 align:start position:0%
I can change Kiara Williams to Kiara
 

00:07:35.110 --> 00:07:37.800 align:start position:0%
I can change Kiara Williams to Kiara
Rogers<00:07:35.889><c> so</c><00:07:36.550><c> I'll</c><00:07:36.759><c> click</c><00:07:37.120><c> on</c><00:07:37.180><c> the</c><00:07:37.419><c> replace</c><00:07:37.750><c> tab</c>

00:07:37.800 --> 00:07:37.810 align:start position:0%
Rogers so I'll click on the replace tab
 

00:07:37.810 --> 00:07:43.410 align:start position:0%
Rogers so I'll click on the replace tab
and<00:07:38.620><c> type</c><00:07:39.310><c> in</c><00:07:39.520><c> Rogers</c><00:07:40.229><c> beside</c><00:07:41.229><c> replace</c><00:07:41.860><c> width</c>

00:07:43.410 --> 00:07:43.420 align:start position:0%
and type in Rogers beside replace width
 

00:07:43.420 --> 00:07:48.170 align:start position:0%
and type in Rogers beside replace width
[Music]

00:07:48.170 --> 00:07:48.180 align:start position:0%
 
 

00:07:48.180 --> 00:07:51.410 align:start position:0%
 
this<00:07:48.990><c> down</c><00:07:49.290><c> here</c><00:07:49.710><c> shows</c><00:07:50.070><c> the</c><00:07:50.430><c> last</c><00:07:50.670><c> field</c><00:07:51.120><c> I</c>

00:07:51.410 --> 00:07:51.420 align:start position:0%
this down here shows the last field I
 

00:07:51.420 --> 00:07:53.360 align:start position:0%
this down here shows the last field I
was<00:07:51.570><c> in</c><00:07:51.990><c> happens</c><00:07:52.500><c> to</c><00:07:52.590><c> be</c><00:07:52.740><c> the</c><00:07:52.860><c> customer</c><00:07:53.250><c> ID</c>

00:07:53.360 --> 00:07:53.370 align:start position:0%
was in happens to be the customer ID
 

00:07:53.370 --> 00:07:55.790 align:start position:0%
was in happens to be the customer ID
field<00:07:53.640><c> and</c><00:07:54.300><c> then</c><00:07:54.900><c> I'm</c><00:07:55.020><c> searching</c><00:07:55.470><c> the</c><00:07:55.500><c> whole</c>

00:07:55.790 --> 00:07:55.800 align:start position:0%
field and then I'm searching the whole
 

00:07:55.800 --> 00:07:58.400 align:start position:0%
field and then I'm searching the whole
field<00:07:56.280><c> for</c><00:07:56.730><c> a</c><00:07:56.760><c> match</c><00:07:57.120><c> and</c><00:07:57.450><c> that</c><00:07:57.930><c> I</c><00:07:58.020><c> want</c><00:07:58.290><c> to</c>

00:07:58.400 --> 00:07:58.410 align:start position:0%
field for a match and that I want to
 

00:07:58.410 --> 00:08:00.920 align:start position:0%
field for a match and that I want to
search<00:07:58.650><c> all</c><00:07:58.890><c> records</c><00:07:59.370><c> in</c><00:07:59.490><c> the</c><00:07:59.610><c> table</c><00:08:00.000><c> and</c><00:08:00.810><c> I</c>

00:08:00.920 --> 00:08:00.930 align:start position:0%
search all records in the table and I
 

00:08:00.930 --> 00:08:02.510 align:start position:0%
search all records in the table and I
don't<00:08:00.960><c> want</c><00:08:01.410><c> to</c><00:08:01.470><c> search</c><00:08:01.770><c> the</c><00:08:01.980><c> customer</c><00:08:02.340><c> ID</c>

00:08:02.510 --> 00:08:02.520 align:start position:0%
don't want to search the customer ID
 

00:08:02.520 --> 00:08:04.970 align:start position:0%
don't want to search the customer ID
field<00:08:02.670><c> for</c><00:08:03.300><c> this</c><00:08:03.450><c> information</c><00:08:03.690><c> so</c><00:08:04.620><c> I'm</c><00:08:04.680><c> going</c>

00:08:04.970 --> 00:08:04.980 align:start position:0%
field for this information so I'm going
 

00:08:04.980 --> 00:08:06.560 align:start position:0%
field for this information so I'm going
to<00:08:05.010><c> click</c><00:08:05.250><c> the</c><00:08:05.370><c> drop</c><00:08:05.610><c> down</c><00:08:05.640><c> arrow</c><00:08:06.180><c> and</c><00:08:06.330><c> choose</c>

00:08:06.560 --> 00:08:06.570 align:start position:0%
to click the drop down arrow and choose
 

00:08:06.570 --> 00:08:09.470 align:start position:0%
to click the drop down arrow and choose
a<00:08:06.810><c> search</c><00:08:07.170><c> of</c><00:08:07.380><c> customers</c><00:08:07.920><c> table</c><00:08:08.490><c> to</c><00:08:09.000><c> find</c><00:08:09.240><c> this</c>

00:08:09.470 --> 00:08:09.480 align:start position:0%
a search of customers table to find this
 

00:08:09.480 --> 00:08:14.780 align:start position:0%
a search of customers table to find this
information<00:08:11.690><c> click</c><00:08:12.690><c> find</c><00:08:13.200><c> next</c><00:08:13.740><c> to</c><00:08:14.310><c> find</c><00:08:14.610><c> the</c>

00:08:14.780 --> 00:08:14.790 align:start position:0%
information click find next to find the
 

00:08:14.790 --> 00:08:17.780 align:start position:0%
information click find next to find the
information<00:08:14.880><c> and</c><00:08:15.570><c> then</c><00:08:16.500><c> replace</c><00:08:16.980><c> to</c><00:08:17.460><c> make</c><00:08:17.640><c> the</c>

00:08:17.780 --> 00:08:17.790 align:start position:0%
information and then replace to make the
 

00:08:17.790 --> 00:08:23.900 align:start position:0%
information and then replace to make the
change<00:08:21.980><c> sometimes</c><00:08:22.980><c> you</c><00:08:23.130><c> may</c><00:08:23.280><c> want</c><00:08:23.310><c> to</c><00:08:23.580><c> copy</c>

00:08:23.900 --> 00:08:23.910 align:start position:0%
change sometimes you may want to copy
 

00:08:23.910 --> 00:08:27.500 align:start position:0%
change sometimes you may want to copy
and<00:08:24.210><c> paste</c><00:08:24.480><c> a</c><00:08:24.690><c> record</c><00:08:25.550><c> let's</c><00:08:26.550><c> go</c><00:08:26.730><c> back</c><00:08:27.150><c> to</c><00:08:27.420><c> the</c>

00:08:27.500 --> 00:08:27.510 align:start position:0%
and paste a record let's go back to the
 

00:08:27.510 --> 00:08:30.920 align:start position:0%
and paste a record let's go back to the
books<00:08:27.720><c> table</c><00:08:28.850><c> it's</c><00:08:29.850><c> common</c><00:08:30.330><c> to</c><00:08:30.450><c> have</c><00:08:30.630><c> more</c>

00:08:30.920 --> 00:08:30.930 align:start position:0%
books table it's common to have more
 

00:08:30.930 --> 00:08:32.690 align:start position:0%
books table it's common to have more
than<00:08:31.080><c> one</c><00:08:31.290><c> volume</c><00:08:31.770><c> of</c><00:08:31.920><c> a</c><00:08:32.010><c> particular</c><00:08:32.280><c> book</c>

00:08:32.690 --> 00:08:32.700 align:start position:0%
than one volume of a particular book
 

00:08:32.700 --> 00:08:35.960 align:start position:0%
than one volume of a particular book
like<00:08:33.390><c> state</c><00:08:34.080><c> parks</c><00:08:34.530><c> Volume</c><00:08:34.890><c> one</c><00:08:35.100><c> and</c><00:08:35.520><c> state</c>

00:08:35.960 --> 00:08:35.970 align:start position:0%
like state parks Volume one and state
 

00:08:35.970 --> 00:08:40.340 align:start position:0%
like state parks Volume one and state
parks<00:08:36.360><c> volumes</c><00:08:36.780><c> two</c><00:08:38.210><c> to</c><00:08:39.210><c> copy</c><00:08:39.540><c> a</c><00:08:39.750><c> record</c>

00:08:40.340 --> 00:08:40.350 align:start position:0%
parks volumes two to copy a record
 

00:08:40.350 --> 00:08:44.750 align:start position:0%
parks volumes two to copy a record
select<00:08:40.980><c> the</c><00:08:41.310><c> record</c><00:08:42.950><c> right-click</c><00:08:43.950><c> and</c><00:08:44.280><c> select</c>

00:08:44.750 --> 00:08:44.760 align:start position:0%
select the record right-click and select
 

00:08:44.760 --> 00:08:49.210 align:start position:0%
select the record right-click and select
copy<00:08:46.220><c> now</c><00:08:47.220><c> select</c><00:08:47.790><c> the</c><00:08:47.940><c> new</c><00:08:48.060><c> record</c>

00:08:49.210 --> 00:08:49.220 align:start position:0%
copy now select the new record
 

00:08:49.220 --> 00:08:53.840 align:start position:0%
copy now select the new record
right-click<00:08:50.220><c> and</c><00:08:50.580><c> select</c><00:08:51.330><c> paste</c><00:08:52.550><c> now</c><00:08:53.550><c> all</c><00:08:53.820><c> I</c>

00:08:53.840 --> 00:08:53.850 align:start position:0%
right-click and select paste now all I
 

00:08:53.850 --> 00:08:57.920 align:start position:0%
right-click and select paste now all I
have<00:08:54.090><c> to</c><00:08:54.120><c> do</c><00:08:54.420><c> is</c><00:08:54.600><c> make</c><00:08:54.900><c> this</c><00:08:55.140><c> volume</c><00:08:55.680><c> two</c><00:08:56.930><c> now</c>

00:08:57.920 --> 00:08:57.930 align:start position:0%
have to do is make this volume two now
 

00:08:57.930 --> 00:09:00.020 align:start position:0%
have to do is make this volume two now
you<00:08:57.990><c> know</c><00:08:58.350><c> how</c><00:08:58.710><c> to</c><00:08:58.740><c> work</c><00:08:59.190><c> with</c><00:08:59.370><c> records</c><00:08:59.820><c> in</c><00:08:59.940><c> a</c>

00:09:00.020 --> 00:09:00.030 align:start position:0%
you know how to work with records in a
 

00:09:00.030 --> 00:09:02.570 align:start position:0%
you know how to work with records in a
table<00:09:00.240><c> itself</c><00:09:00.840><c> and</c><00:09:01.170><c> you</c><00:09:01.830><c> can</c><00:09:02.040><c> see</c><00:09:02.070><c> that</c><00:09:02.460><c> you</c>

00:09:02.570 --> 00:09:02.580 align:start position:0%
table itself and you can see that you
 

00:09:02.580 --> 00:09:05.030 align:start position:0%
table itself and you can see that you
have<00:09:02.850><c> to</c><00:09:03.030><c> be</c><00:09:03.150><c> careful</c><00:09:03.720><c> and</c><00:09:04.020><c> how</c><00:09:04.500><c> data</c><00:09:04.800><c> is</c>

00:09:05.030 --> 00:09:05.040 align:start position:0%
have to be careful and how data is
 

00:09:05.040 --> 00:09:07.100 align:start position:0%
have to be careful and how data is
entered<00:09:05.190><c> into</c><00:09:05.640><c> a</c><00:09:05.670><c> database</c><00:09:05.850><c> because</c><00:09:06.720><c> you</c><00:09:06.810><c> only</c>

00:09:07.100 --> 00:09:07.110 align:start position:0%
entered into a database because you only
 

00:09:07.110 --> 00:09:09.200 align:start position:0%
entered into a database because you only
get<00:09:07.470><c> out</c><00:09:07.740><c> of</c><00:09:07.890><c> the</c><00:09:07.980><c> database</c><00:09:08.250><c> what</c><00:09:08.880><c> you</c><00:09:09.000><c> put</c>

00:09:09.200 --> 00:09:09.210 align:start position:0%
get out of the database what you put
 

00:09:09.210 --> 00:09:16.310 align:start position:0%
get out of the database what you put
into<00:09:09.330><c> it</c><00:09:12.890><c> like</c><00:09:13.890><c> what</c><00:09:14.070><c> you</c><00:09:14.220><c> just</c><00:09:14.250><c> saw</c><00:09:15.320><c> greatest</c>

00:09:16.310 --> 00:09:16.320 align:start position:0%
into it like what you just saw greatest
 

00:09:16.320 --> 00:09:19.680 align:start position:0%
into it like what you just saw greatest
add<00:09:16.800><c> a</c><00:09:16.860><c> comment</c><00:09:17.190><c> subscribe</c><00:09:17.940><c> to</c><00:09:18.240><c> our</c><00:09:18.480><c> Channel</c>

00:09:19.680 --> 00:09:19.690 align:start position:0%
add a comment subscribe to our Channel
 

00:09:19.690 --> 00:09:21.690 align:start position:0%
add a comment subscribe to our Channel
the<00:09:19.960><c> freedom</c><00:09:20.410><c> to</c><00:09:20.530><c> learn</c>

00:09:21.690 --> 00:09:21.700 align:start position:0%
the freedom to learn
 

00:09:21.700 --> 00:09:26.430 align:start position:0%
the freedom to learn
what<00:09:22.330><c> you</c><00:09:22.540><c> want</c><00:09:23.010><c> when</c><00:09:24.010><c> you</c><00:09:24.040><c> want</c><00:09:25.440><c> absolutely</c>

00:09:26.430 --> 00:09:26.440 align:start position:0%
what you want when you want absolutely
 

00:09:26.440 --> 00:09:30.600 align:start position:0%
what you want when you want absolutely
free

00:09:30.600 --> 00:09:30.610 align:start position:0%
 
 

00:09:30.610 --> 00:09:34.240 align:start position:0%
 
GCF<00:09:31.610><c> learn</c><00:09:32.210><c> free.org</c>