WEBVTT
Kind: captions
Language: en

00:00:00.740 --> 00:00:11.130 align:start position:0%
 
[Music]

00:00:11.130 --> 00:00:11.140 align:start position:0%
 
 

00:00:11.140 --> 00:00:13.930 align:start position:0%
 
we've<00:00:12.140><c> already</c><00:00:12.380><c> looked</c><00:00:12.680><c> at</c><00:00:12.889><c> how</c><00:00:13.010><c> tables</c><00:00:13.580><c> store</c>

00:00:13.930 --> 00:00:13.940 align:start position:0%
we've already looked at how tables store
 

00:00:13.940 --> 00:00:16.240 align:start position:0%
we've already looked at how tables store
information<00:00:14.300><c> in</c><00:00:14.630><c> a</c><00:00:14.750><c> database</c><00:00:14.900><c> but</c><00:00:15.410><c> you're</c><00:00:16.040><c> not</c>

00:00:16.240 --> 00:00:16.250 align:start position:0%
information in a database but you're not
 

00:00:16.250 --> 00:00:17.650 align:start position:0%
information in a database but you're not
always<00:00:16.460><c> going</c><00:00:16.790><c> to</c><00:00:16.850><c> be</c><00:00:17.000><c> entering</c><00:00:17.360><c> data</c>

00:00:17.650 --> 00:00:17.660 align:start position:0%
always going to be entering data
 

00:00:17.660 --> 00:00:20.290 align:start position:0%
always going to be entering data
directly<00:00:18.200><c> into</c><00:00:18.619><c> a</c><00:00:18.650><c> table</c><00:00:19.070><c> much</c><00:00:19.850><c> of</c><00:00:20.029><c> the</c><00:00:20.119><c> time</c>

00:00:20.290 --> 00:00:20.300 align:start position:0%
directly into a table much of the time
 

00:00:20.300 --> 00:00:22.450 align:start position:0%
directly into a table much of the time
you're<00:00:20.540><c> going</c><00:00:20.689><c> to</c><00:00:20.779><c> be</c><00:00:20.900><c> using</c><00:00:21.290><c> forms</c><00:00:21.740><c> instead</c><00:00:22.099><c> a</c>

00:00:22.450 --> 00:00:22.460 align:start position:0%
you're going to be using forms instead a
 

00:00:22.460 --> 00:00:24.460 align:start position:0%
you're going to be using forms instead a
form<00:00:23.330><c> gives</c><00:00:23.599><c> you</c><00:00:23.720><c> a</c><00:00:23.750><c> more</c><00:00:24.050><c> user-friendly</c>

00:00:24.460 --> 00:00:24.470 align:start position:0%
form gives you a more user-friendly
 

00:00:24.470 --> 00:00:27.010 align:start position:0%
form gives you a more user-friendly
interface<00:00:25.310><c> for</c><00:00:25.550><c> entering</c><00:00:25.940><c> data</c><00:00:26.119><c> and</c><00:00:26.420><c> they</c>

00:00:27.010 --> 00:00:27.020 align:start position:0%
interface for entering data and they
 

00:00:27.020 --> 00:00:28.359 align:start position:0%
interface for entering data and they
make<00:00:27.199><c> sure</c><00:00:27.410><c> that</c><00:00:27.590><c> the</c><00:00:27.710><c> data</c><00:00:27.860><c> goes</c><00:00:28.130><c> exactly</c>

00:00:28.359 --> 00:00:28.369 align:start position:0%
make sure that the data goes exactly
 

00:00:28.369 --> 00:00:30.730 align:start position:0%
make sure that the data goes exactly
where<00:00:28.789><c> it</c><00:00:29.060><c> needs</c><00:00:29.270><c> to</c><00:00:29.360><c> and</c><00:00:29.960><c> sometimes</c><00:00:30.410><c> the</c><00:00:30.590><c> data</c>

00:00:30.730 --> 00:00:30.740 align:start position:0%
where it needs to and sometimes the data
 

00:00:30.740 --> 00:00:32.770 align:start position:0%
where it needs to and sometimes the data
just<00:00:31.010><c> goes</c><00:00:31.250><c> to</c><00:00:31.430><c> one</c><00:00:31.609><c> table</c><00:00:31.820><c> but</c><00:00:32.330><c> other</c><00:00:32.480><c> times</c>

00:00:32.770 --> 00:00:32.780 align:start position:0%
just goes to one table but other times
 

00:00:32.780 --> 00:00:34.540 align:start position:0%
just goes to one table but other times
it<00:00:32.960><c> could</c><00:00:33.110><c> be</c><00:00:33.290><c> several</c><00:00:33.770><c> different</c><00:00:33.890><c> tables</c><00:00:34.370><c> and</c>

00:00:34.540 --> 00:00:34.550 align:start position:0%
it could be several different tables and
 

00:00:34.550 --> 00:00:36.580 align:start position:0%
it could be several different tables and
a<00:00:34.910><c> form</c><00:00:35.210><c> can</c><00:00:35.420><c> keep</c><00:00:35.629><c> track</c><00:00:35.900><c> of</c><00:00:35.960><c> that</c><00:00:36.230><c> so</c><00:00:36.530><c> you</c>

00:00:36.580 --> 00:00:36.590 align:start position:0%
a form can keep track of that so you
 

00:00:36.590 --> 00:00:39.640 align:start position:0%
a form can keep track of that so you
don't<00:00:36.920><c> have</c><00:00:37.100><c> to</c><00:00:37.870><c> right</c><00:00:38.870><c> now</c><00:00:39.019><c> we're</c><00:00:39.199><c> looking</c><00:00:39.320><c> at</c>

00:00:39.640 --> 00:00:39.650 align:start position:0%
don't have to right now we're looking at
 

00:00:39.650 --> 00:00:41.860 align:start position:0%
don't have to right now we're looking at
the<00:00:39.920><c> customers</c><00:00:40.489><c> form</c><00:00:40.820><c> that</c><00:00:41.059><c> was</c><00:00:41.180><c> created</c><00:00:41.630><c> for</c>

00:00:41.860 --> 00:00:41.870 align:start position:0%
the customers form that was created for
 

00:00:41.870 --> 00:00:44.170 align:start position:0%
the customers form that was created for
our<00:00:42.050><c> database</c><00:00:42.260><c> and</c><00:00:42.710><c> this</c><00:00:43.399><c> gives</c><00:00:43.610><c> us</c><00:00:43.790><c> an</c><00:00:43.940><c> easy</c>

00:00:44.170 --> 00:00:44.180 align:start position:0%
our database and this gives us an easy
 

00:00:44.180 --> 00:00:46.420 align:start position:0%
our database and this gives us an easy
way<00:00:44.300><c> of</c><00:00:44.660><c> adding</c><00:00:44.840><c> or</c><00:00:45.230><c> changing</c><00:00:45.260><c> information</c><00:00:46.010><c> in</c>

00:00:46.420 --> 00:00:46.430 align:start position:0%
way of adding or changing information in
 

00:00:46.430 --> 00:00:49.030 align:start position:0%
way of adding or changing information in
the<00:00:46.550><c> customers</c><00:00:47.030><c> table</c><00:00:47.440><c> the</c><00:00:48.440><c> difference</c><00:00:48.860><c> is</c>

00:00:49.030 --> 00:00:49.040 align:start position:0%
the customers table the difference is
 

00:00:49.040 --> 00:00:51.250 align:start position:0%
the customers table the difference is
here<00:00:49.610><c> we</c><00:00:49.730><c> can</c><00:00:49.910><c> just</c><00:00:50.120><c> focus</c><00:00:50.270><c> on</c><00:00:50.570><c> one</c><00:00:50.840><c> record</c><00:00:51.020><c> at</c>

00:00:51.250 --> 00:00:51.260 align:start position:0%
here we can just focus on one record at
 

00:00:51.260 --> 00:00:53.319 align:start position:0%
here we can just focus on one record at
a<00:00:51.350><c> time</c><00:00:51.380><c> and</c><00:00:51.800><c> there</c><00:00:52.579><c> are</c><00:00:52.700><c> also</c><00:00:52.910><c> some</c>

00:00:53.319 --> 00:00:53.329 align:start position:0%
a time and there are also some
 

00:00:53.329 --> 00:00:55.540 align:start position:0%
a time and there are also some
specialized<00:00:53.960><c> tools</c><00:00:54.290><c> like</c><00:00:54.590><c> drop-down</c><00:00:55.070><c> boxes</c>

00:00:55.540 --> 00:00:55.550 align:start position:0%
specialized tools like drop-down boxes
 

00:00:55.550 --> 00:00:57.700 align:start position:0%
specialized tools like drop-down boxes
and<00:00:55.910><c> buttons</c><00:00:56.180><c> for</c><00:00:56.570><c> saving</c><00:00:57.020><c> deleting</c><00:00:57.530><c> and</c>

00:00:57.700 --> 00:00:57.710 align:start position:0%
and buttons for saving deleting and
 

00:00:57.710 --> 00:00:59.270 align:start position:0%
and buttons for saving deleting and
printing

00:00:59.270 --> 00:00:59.280 align:start position:0%
printing
 

00:00:59.280 --> 00:01:01.670 align:start position:0%
printing
we<00:00:59.880><c> can</c><00:01:00.000><c> use</c><00:01:00.180><c> a</c><00:01:00.210><c> drop-down</c><00:01:00.750><c> box</c><00:01:00.810><c> to</c><00:01:01.290><c> find</c><00:01:01.530><c> an</c>

00:01:01.670 --> 00:01:01.680 align:start position:0%
we can use a drop-down box to find an
 

00:01:01.680 --> 00:01:04.130 align:start position:0%
we can use a drop-down box to find an
existing<00:01:01.920><c> customer</c><00:01:02.310><c> and</c><00:01:02.730><c> we</c><00:01:03.450><c> could</c><00:01:03.630><c> also</c><00:01:03.780><c> type</c>

00:01:04.130 --> 00:01:04.140 align:start position:0%
existing customer and we could also type
 

00:01:04.140 --> 00:01:07.130 align:start position:0%
existing customer and we could also type
a<00:01:04.290><c> last</c><00:01:04.500><c> name</c><00:01:04.739><c> to</c><00:01:04.949><c> jump</c><00:01:05.190><c> to</c><00:01:05.339><c> a</c><00:01:05.370><c> record</c><00:01:05.730><c> and</c><00:01:06.140><c> when</c>

00:01:07.130 --> 00:01:07.140 align:start position:0%
a last name to jump to a record and when
 

00:01:07.140 --> 00:01:08.630 align:start position:0%
a last name to jump to a record and when
we<00:01:07.290><c> click</c><00:01:07.530><c> on</c><00:01:07.620><c> the</c><00:01:07.740><c> name</c><00:01:07.920><c> their</c><00:01:08.220><c> information</c>

00:01:08.630 --> 00:01:08.640 align:start position:0%
we click on the name their information
 

00:01:08.640 --> 00:01:10.820 align:start position:0%
we click on the name their information
will<00:01:08.910><c> appear</c><00:01:09.030><c> in</c><00:01:09.479><c> these</c><00:01:09.720><c> fields</c><00:01:10.260><c> where</c><00:01:10.530><c> we</c><00:01:10.560><c> can</c>

00:01:10.820 --> 00:01:10.830 align:start position:0%
will appear in these fields where we can
 

00:01:10.830 --> 00:01:13.109 align:start position:0%
will appear in these fields where we can
then<00:01:10.920><c> edit</c><00:01:11.190><c> it</c>

00:01:13.109 --> 00:01:13.119 align:start position:0%
then edit it
 

00:01:13.119 --> 00:01:14.370 align:start position:0%
then edit it
and<00:01:13.390><c> I'm</c><00:01:13.479><c> just</c><00:01:13.630><c> going</c><00:01:13.810><c> to</c><00:01:13.840><c> change</c><00:01:14.079><c> this</c>

00:01:14.370 --> 00:01:14.380 align:start position:0%
and I'm just going to change this
 

00:01:14.380 --> 00:01:16.539 align:start position:0%
and I'm just going to change this
customers<00:01:14.859><c> address</c>

00:01:16.539 --> 00:01:16.549 align:start position:0%
customers address
 

00:01:16.549 --> 00:01:18.639 align:start position:0%
customers address
now<00:01:17.149><c> some</c><00:01:17.420><c> fields</c><00:01:17.780><c> may</c><00:01:17.899><c> have</c><00:01:18.079><c> a</c><00:01:18.109><c> validation</c>

00:01:18.639 --> 00:01:18.649 align:start position:0%
now some fields may have a validation
 

00:01:18.649 --> 00:01:20.649 align:start position:0%
now some fields may have a validation
rule<00:01:18.859><c> that</c><00:01:19.250><c> limits</c><00:01:19.310><c> the</c><00:01:19.759><c> type</c><00:01:19.969><c> of</c><00:01:20.000><c> data</c><00:01:20.359><c> that</c>

00:01:20.649 --> 00:01:20.659 align:start position:0%
rule that limits the type of data that
 

00:01:20.659 --> 00:01:23.080 align:start position:0%
rule that limits the type of data that
can<00:01:20.810><c> be</c><00:01:20.840><c> entered</c><00:01:21.229><c> for</c><00:01:21.890><c> example</c><00:01:22.369><c> here</c><00:01:22.880><c> the</c>

00:01:23.080 --> 00:01:23.090 align:start position:0%
can be entered for example here the
 

00:01:23.090 --> 00:01:25.060 align:start position:0%
can be entered for example here the
state<00:01:23.390><c> needs</c><00:01:23.630><c> to</c><00:01:23.750><c> be</c><00:01:23.929><c> a</c><00:01:23.960><c> two</c><00:01:24.350><c> letter</c><00:01:24.560><c> postal</c>

00:01:25.060 --> 00:01:25.070 align:start position:0%
state needs to be a two letter postal
 

00:01:25.070 --> 00:01:27.279 align:start position:0%
state needs to be a two letter postal
code<00:01:25.280><c> and</c><00:01:25.460><c> if</c><00:01:26.119><c> I</c><00:01:26.210><c> try</c><00:01:26.450><c> to</c><00:01:26.509><c> type</c><00:01:26.750><c> anything</c><00:01:26.990><c> else</c>

00:01:27.279 --> 00:01:27.289 align:start position:0%
code and if I try to type anything else
 

00:01:27.289 --> 00:01:29.529 align:start position:0%
code and if I try to type anything else
a<00:01:27.560><c> window</c><00:01:28.130><c> will</c><00:01:28.280><c> pop</c><00:01:28.310><c> up</c><00:01:28.490><c> with</c><00:01:28.700><c> instructions</c>

00:01:29.529 --> 00:01:29.539 align:start position:0%
a window will pop up with instructions
 

00:01:29.539 --> 00:01:34.000 align:start position:0%
a window will pop up with instructions
on<00:01:29.689><c> how</c><00:01:29.750><c> to</c><00:01:29.929><c> fill</c><00:01:30.170><c> it</c><00:01:30.289><c> out</c><00:01:30.380><c> correctly</c>

00:01:34.000 --> 00:01:34.010 align:start position:0%
 
 

00:01:34.010 --> 00:01:36.850 align:start position:0%
 
I'll<00:01:34.040><c> change</c><00:01:34.310><c> this</c><00:01:34.490><c> back</c><00:01:34.730><c> to</c><00:01:34.760><c> NC</c>

00:01:36.850 --> 00:01:36.860 align:start position:0%
I'll change this back to NC
 

00:01:36.860 --> 00:01:40.480 align:start position:0%
I'll change this back to NC
and<00:01:36.950><c> when</c><00:01:37.340><c> you're</c><00:01:37.460><c> done</c><00:01:37.610><c> you</c><00:01:37.820><c> can</c><00:01:37.970><c> click</c><00:01:38.210><c> Save</c>

00:01:40.480 --> 00:01:40.490 align:start position:0%
 
 

00:01:40.490 --> 00:01:42.490 align:start position:0%
 
there's<00:01:41.000><c> also</c><00:01:41.180><c> a</c><00:01:41.360><c> button</c><00:01:41.810><c> to</c><00:01:41.930><c> create</c><00:01:42.049><c> a</c><00:01:42.350><c> new</c>

00:01:42.490 --> 00:01:42.500 align:start position:0%
there's also a button to create a new
 

00:01:42.500 --> 00:01:44.770 align:start position:0%
there's also a button to create a new
record<00:01:42.890><c> which</c><00:01:43.369><c> automatically</c><00:01:44.030><c> clears</c><00:01:44.479><c> all</c><00:01:44.750><c> of</c>

00:01:44.770 --> 00:01:44.780 align:start position:0%
record which automatically clears all of
 

00:01:44.780 --> 00:01:46.390 align:start position:0%
record which automatically clears all of
the<00:01:44.930><c> fields</c><00:01:45.049><c> so</c><00:01:45.530><c> we</c><00:01:45.560><c> can</c><00:01:45.770><c> type</c><00:01:45.950><c> in</c><00:01:46.100><c> a</c><00:01:46.190><c> new</c>

00:01:46.390 --> 00:01:46.400 align:start position:0%
the fields so we can type in a new
 

00:01:46.400 --> 00:01:49.030 align:start position:0%
the fields so we can type in a new
customers<00:01:46.880><c> information</c><00:01:47.500><c> so</c><00:01:48.500><c> if</c><00:01:48.650><c> you</c><00:01:48.770><c> wanted</c>

00:01:49.030 --> 00:01:49.040 align:start position:0%
customers information so if you wanted
 

00:01:49.040 --> 00:01:50.770 align:start position:0%
customers information so if you wanted
to<00:01:49.100><c> you</c><00:01:49.400><c> could</c><00:01:49.670><c> do</c><00:01:49.850><c> most</c><00:01:50.090><c> of</c><00:01:50.210><c> these</c><00:01:50.330><c> things</c><00:01:50.600><c> by</c>

00:01:50.770 --> 00:01:50.780 align:start position:0%
to you could do most of these things by
 

00:01:50.780 --> 00:01:52.990 align:start position:0%
to you could do most of these things by
editing<00:01:51.140><c> the</c><00:01:51.170><c> table</c><00:01:51.560><c> directly</c><00:01:51.800><c> but</c><00:01:52.520><c> the</c><00:01:52.729><c> form</c>

00:01:52.990 --> 00:01:53.000 align:start position:0%
editing the table directly but the form
 

00:01:53.000 --> 00:01:54.430 align:start position:0%
editing the table directly but the form
is<00:01:53.090><c> going</c><00:01:53.240><c> to</c><00:01:53.360><c> be</c><00:01:53.450><c> a</c><00:01:53.540><c> little</c><00:01:53.750><c> easier</c><00:01:53.960><c> and</c>

00:01:54.430 --> 00:01:54.440 align:start position:0%
is going to be a little easier and
 

00:01:54.440 --> 00:01:57.399 align:start position:0%
is going to be a little easier and
faster<00:01:54.590><c> to</c><00:01:54.979><c> use</c><00:01:55.780><c> now</c><00:01:56.780><c> let's</c><00:01:57.080><c> look</c><00:01:57.259><c> at</c><00:01:57.380><c> a</c>

00:01:57.399 --> 00:01:57.409 align:start position:0%
faster to use now let's look at a
 

00:01:57.409 --> 00:01:59.590 align:start position:0%
faster to use now let's look at a
slightly<00:01:57.770><c> more</c><00:01:57.920><c> complex</c><00:01:58.430><c> form</c><00:01:58.820><c> and</c><00:01:59.030><c> this</c><00:01:59.450><c> is</c>

00:01:59.590 --> 00:01:59.600 align:start position:0%
slightly more complex form and this is
 

00:01:59.600 --> 00:02:01.090 align:start position:0%
slightly more complex form and this is
going<00:01:59.780><c> to</c><00:01:59.930><c> let</c><00:02:00.020><c> us</c><00:02:00.080><c> do</c><00:02:00.320><c> things</c><00:02:00.560><c> that</c><00:02:00.680><c> we</c><00:02:00.800><c> really</c>

00:02:01.090 --> 00:02:01.100 align:start position:0%
going to let us do things that we really
 

00:02:01.100 --> 00:02:02.889 align:start position:0%
going to let us do things that we really
couldn't<00:02:01.430><c> do</c><00:02:01.640><c> by</c><00:02:01.790><c> just</c><00:02:02.060><c> editing</c><00:02:02.210><c> the</c><00:02:02.540><c> tables</c>

00:02:02.889 --> 00:02:02.899 align:start position:0%
couldn't do by just editing the tables
 

00:02:02.899 --> 00:02:07.240 align:start position:0%
couldn't do by just editing the tables
I'm<00:02:03.560><c> going</c><00:02:04.369><c> to</c><00:02:04.490><c> open</c><00:02:04.850><c> the</c><00:02:05.030><c> orders</c><00:02:05.420><c> form</c>

00:02:07.240 --> 00:02:07.250 align:start position:0%
I'm going to open the orders form
 

00:02:07.250 --> 00:02:09.310 align:start position:0%
I'm going to open the orders form
and<00:02:07.340><c> this</c><00:02:08.149><c> is</c><00:02:08.270><c> what</c><00:02:08.450><c> the</c><00:02:08.570><c> employees</c><00:02:08.990><c> will</c><00:02:09.170><c> fill</c>

00:02:09.310 --> 00:02:09.320 align:start position:0%
and this is what the employees will fill
 

00:02:09.320 --> 00:02:10.890 align:start position:0%
and this is what the employees will fill
out<00:02:09.470><c> when</c><00:02:09.619><c> the</c><00:02:09.710><c> customer</c><00:02:10.130><c> places</c><00:02:10.310><c> an</c><00:02:10.550><c> order</c>

00:02:10.890 --> 00:02:10.900 align:start position:0%
out when the customer places an order
 

00:02:10.900 --> 00:02:13.210 align:start position:0%
out when the customer places an order
let's<00:02:11.900><c> just</c><00:02:12.080><c> walk</c><00:02:12.290><c> through</c><00:02:12.320><c> the</c><00:02:12.590><c> process</c><00:02:12.800><c> of</c>

00:02:13.210 --> 00:02:13.220 align:start position:0%
let's just walk through the process of
 

00:02:13.220 --> 00:02:16.030 align:start position:0%
let's just walk through the process of
creating<00:02:13.580><c> a</c><00:02:13.820><c> new</c><00:02:13.850><c> order</c><00:02:14.440><c> when</c><00:02:15.440><c> you</c><00:02:15.560><c> click</c><00:02:15.770><c> new</c>

00:02:16.030 --> 00:02:16.040 align:start position:0%
creating a new order when you click new
 

00:02:16.040 --> 00:02:18.010 align:start position:0%
creating a new order when you click new
order<00:02:16.400><c> it</c><00:02:16.580><c> clears</c><00:02:17.030><c> all</c><00:02:17.240><c> of</c><00:02:17.270><c> the</c><00:02:17.420><c> fields</c><00:02:17.510><c> and</c>

00:02:18.010 --> 00:02:18.020 align:start position:0%
order it clears all of the fields and
 

00:02:18.020 --> 00:02:19.960 align:start position:0%
order it clears all of the fields and
then<00:02:18.890><c> you</c><00:02:18.980><c> can</c><00:02:19.130><c> choose</c><00:02:19.370><c> the</c><00:02:19.430><c> name</c><00:02:19.760><c> of</c><00:02:19.820><c> the</c>

00:02:19.960 --> 00:02:19.970 align:start position:0%
then you can choose the name of the
 

00:02:19.970 --> 00:02:21.520 align:start position:0%
then you can choose the name of the
customer<00:02:20.210><c> that's</c><00:02:20.600><c> placing</c><00:02:20.990><c> the</c><00:02:21.080><c> order</c><00:02:21.350><c> and</c>

00:02:21.520 --> 00:02:21.530 align:start position:0%
customer that's placing the order and
 

00:02:21.530 --> 00:02:23.770 align:start position:0%
customer that's placing the order and
the<00:02:22.220><c> information</c><00:02:22.700><c> in</c><00:02:22.790><c> this</c><00:02:22.940><c> list</c><00:02:23.180><c> comes</c><00:02:23.480><c> from</c>

00:02:23.770 --> 00:02:23.780 align:start position:0%
the information in this list comes from
 

00:02:23.780 --> 00:02:26.199 align:start position:0%
the information in this list comes from
the<00:02:23.900><c> customers</c><00:02:24.410><c> table</c><00:02:24.620><c> so</c><00:02:25.370><c> every</c><00:02:25.790><c> customer</c>

00:02:26.199 --> 00:02:26.209 align:start position:0%
the customers table so every customer
 

00:02:26.209 --> 00:02:27.610 align:start position:0%
the customers table so every customer
will<00:02:26.390><c> need</c><00:02:26.540><c> to</c><00:02:26.600><c> already</c><00:02:26.690><c> be</c><00:02:27.080><c> in</c><00:02:27.350><c> the</c><00:02:27.380><c> database</c>

00:02:27.610 --> 00:02:27.620 align:start position:0%
will need to already be in the database
 

00:02:27.620 --> 00:02:30.820 align:start position:0%
will need to already be in the database
before<00:02:28.130><c> they</c><00:02:28.550><c> can</c><00:02:28.700><c> place</c><00:02:28.910><c> an</c><00:02:29.090><c> order</c><00:02:29.270><c> and</c><00:02:29.830><c> it</c>

00:02:30.820 --> 00:02:30.830 align:start position:0%
before they can place an order and it
 

00:02:30.830 --> 00:02:32.410 align:start position:0%
before they can place an order and it
automatically<00:02:31.280><c> generates</c><00:02:31.550><c> a</c><00:02:31.910><c> new</c><00:02:32.090><c> order</c>

00:02:32.410 --> 00:02:32.420 align:start position:0%
automatically generates a new order
 

00:02:32.420 --> 00:02:35.080 align:start position:0%
automatically generates a new order
number<00:02:33.010><c> when</c><00:02:34.010><c> you</c><00:02:34.130><c> click</c><00:02:34.310><c> on</c><00:02:34.430><c> the</c><00:02:34.550><c> pickup</c><00:02:34.880><c> date</c>

00:02:35.080 --> 00:02:35.090 align:start position:0%
number when you click on the pickup date
 

00:02:35.090 --> 00:02:37.449 align:start position:0%
number when you click on the pickup date
field<00:02:35.390><c> a</c><00:02:35.630><c> calendar</c><00:02:36.170><c> button</c><00:02:36.440><c> appears</c><00:02:36.770><c> which</c>

00:02:37.449 --> 00:02:37.459 align:start position:0%
field a calendar button appears which
 

00:02:37.459 --> 00:02:39.160 align:start position:0%
field a calendar button appears which
makes<00:02:37.700><c> it</c><00:02:37.850><c> easy</c><00:02:38.030><c> to</c><00:02:38.180><c> quickly</c><00:02:38.300><c> choose</c><00:02:38.780><c> the</c><00:02:38.990><c> date</c>

00:02:39.160 --> 00:02:39.170 align:start position:0%
makes it easy to quickly choose the date
 

00:02:39.170 --> 00:02:41.660 align:start position:0%
makes it easy to quickly choose the date
that<00:02:39.320><c> you</c><00:02:39.440><c> want</c>

00:02:41.660 --> 00:02:41.670 align:start position:0%
 
 

00:02:41.670 --> 00:02:43.010 align:start position:0%
 
and<00:02:41.760><c> there</c><00:02:42.180><c> are</c><00:02:42.270><c> also</c><00:02:42.450><c> a</c><00:02:42.630><c> couple</c><00:02:42.720><c> of</c>

00:02:43.010 --> 00:02:43.020 align:start position:0%
and there are also a couple of
 

00:02:43.020 --> 00:02:44.630 align:start position:0%
and there are also a couple of
checkboxes<00:02:43.740><c> for</c><00:02:43.950><c> simple</c><00:02:44.280><c> yes-or-no</c>

00:02:44.630 --> 00:02:44.640 align:start position:0%
checkboxes for simple yes-or-no
 

00:02:44.640 --> 00:02:47.270 align:start position:0%
checkboxes for simple yes-or-no
questions<00:02:45.500><c> later</c><00:02:46.500><c> when</c><00:02:46.739><c> you</c><00:02:46.830><c> start</c><00:02:47.099><c> creating</c>

00:02:47.270 --> 00:02:47.280 align:start position:0%
questions later when you start creating
 

00:02:47.280 --> 00:02:49.339 align:start position:0%
questions later when you start creating
forms<00:02:47.940><c> you'll</c><00:02:48.330><c> be</c><00:02:48.480><c> able</c><00:02:48.569><c> to</c><00:02:48.750><c> add</c><00:02:48.900><c> these</c><00:02:49.140><c> types</c>

00:02:49.339 --> 00:02:49.349 align:start position:0%
forms you'll be able to add these types
 

00:02:49.349 --> 00:02:51.140 align:start position:0%
forms you'll be able to add these types
of<00:02:49.560><c> special</c><00:02:49.620><c> tools</c><00:02:50.250><c> to</c><00:02:50.459><c> make</c><00:02:50.670><c> your</c><00:02:50.819><c> forms</c>

00:02:51.140 --> 00:02:51.150 align:start position:0%
of special tools to make your forms
 

00:02:51.150 --> 00:02:54.110 align:start position:0%
of special tools to make your forms
easier<00:02:51.569><c> to</c><00:02:51.750><c> use</c><00:02:51.989><c> and</c><00:02:52.340><c> this</c><00:02:53.340><c> form</c><00:02:53.580><c> has</c><00:02:53.730><c> a</c><00:02:53.760><c> field</c>

00:02:54.110 --> 00:02:54.120 align:start position:0%
easier to use and this form has a field
 

00:02:54.120 --> 00:02:57.000 align:start position:0%
easier to use and this form has a field
where<00:02:54.360><c> you</c><00:02:54.390><c> can</c><00:02:54.450><c> add</c><00:02:54.750><c> notes</c><00:02:55.050><c> if</c><00:02:55.260><c> you</c><00:02:55.290><c> want</c>

00:02:57.000 --> 00:02:57.010 align:start position:0%
where you can add notes if you want
 

00:02:57.010 --> 00:02:59.100 align:start position:0%
where you can add notes if you want
now<00:02:57.760><c> here's</c><00:02:58.090><c> where</c><00:02:58.300><c> this</c><00:02:58.390><c> forum</c><00:02:58.659><c> is</c><00:02:58.780><c> a</c><00:02:58.840><c> little</c>

00:02:59.100 --> 00:02:59.110 align:start position:0%
now here's where this forum is a little
 

00:02:59.110 --> 00:03:01.500 align:start position:0%
now here's where this forum is a little
bit<00:02:59.230><c> different</c><00:02:59.680><c> when</c><00:03:00.250><c> you</c><00:03:00.340><c> click</c><00:03:00.580><c> add</c><00:03:00.760><c> item</c><00:03:01.150><c> it</c>

00:03:01.500 --> 00:03:01.510 align:start position:0%
bit different when you click add item it
 

00:03:01.510 --> 00:03:04.259 align:start position:0%
bit different when you click add item it
opens<00:03:01.810><c> what's</c><00:03:02.019><c> called</c><00:03:02.260><c> a</c><00:03:02.409><c> subform</c><00:03:03.040><c> and</c><00:03:03.340><c> here</c>

00:03:04.259 --> 00:03:04.269 align:start position:0%
opens what's called a subform and here
 

00:03:04.269 --> 00:03:07.680 align:start position:0%
opens what's called a subform and here
you<00:03:04.360><c> can</c><00:03:04.510><c> choose</c><00:03:04.720><c> the</c><00:03:04.930><c> item</c><00:03:05.230><c> that</c><00:03:05.349><c> was</c><00:03:05.470><c> ordered</c>

00:03:07.680 --> 00:03:07.690 align:start position:0%
you can choose the item that was ordered
 

00:03:07.690 --> 00:03:11.520 align:start position:0%
you can choose the item that was ordered
and<00:03:07.810><c> type</c><00:03:08.110><c> in</c><00:03:08.260><c> the</c><00:03:08.350><c> quantity</c>

00:03:11.520 --> 00:03:11.530 align:start position:0%
 
 

00:03:11.530 --> 00:03:13.650 align:start position:0%
 
and<00:03:11.620><c> sometimes</c><00:03:12.520><c> it</c><00:03:12.670><c> may</c><00:03:12.790><c> take</c><00:03:12.970><c> a</c><00:03:13.000><c> few</c><00:03:13.090><c> seconds</c>

00:03:13.650 --> 00:03:13.660 align:start position:0%
and sometimes it may take a few seconds
 

00:03:13.660 --> 00:03:16.290 align:start position:0%
and sometimes it may take a few seconds
to<00:03:13.720><c> update</c>

00:03:16.290 --> 00:03:16.300 align:start position:0%
 
 

00:03:16.300 --> 00:03:19.809 align:start position:0%
 
then<00:03:16.840><c> you</c><00:03:17.020><c> can</c><00:03:17.170><c> add</c><00:03:17.320><c> another</c><00:03:17.530><c> item</c>

00:03:19.809 --> 00:03:19.819 align:start position:0%
then you can add another item
 

00:03:19.819 --> 00:03:21.339 align:start position:0%
then you can add another item
and<00:03:19.909><c> you</c><00:03:20.120><c> can</c><00:03:20.239><c> do</c><00:03:20.329><c> this</c><00:03:20.450><c> as</c><00:03:20.629><c> many</c><00:03:20.659><c> times</c><00:03:20.870><c> as</c><00:03:21.230><c> you</c>

00:03:21.339 --> 00:03:21.349 align:start position:0%
and you can do this as many times as you
 

00:03:21.349 --> 00:03:26.089 align:start position:0%
and you can do this as many times as you
need<00:03:21.530><c> to</c><00:03:21.560><c> until</c><00:03:21.950><c> the</c><00:03:22.250><c> order</c><00:03:22.519><c> is</c><00:03:22.610><c> complete</c>

00:03:26.089 --> 00:03:26.099 align:start position:0%
 
 

00:03:26.099 --> 00:03:28.640 align:start position:0%
 
okay<00:03:26.849><c> now</c><00:03:27.090><c> let's</c><00:03:27.329><c> take</c><00:03:27.510><c> a</c><00:03:27.569><c> look</c><00:03:27.749><c> at</c><00:03:27.900><c> why</c><00:03:28.170><c> forums</c>

00:03:28.640 --> 00:03:28.650 align:start position:0%
okay now let's take a look at why forums
 

00:03:28.650 --> 00:03:31.369 align:start position:0%
okay now let's take a look at why forums
are<00:03:28.829><c> so</c><00:03:29.010><c> important</c><00:03:29.629><c> when</c><00:03:30.629><c> we</c><00:03:30.749><c> place</c><00:03:30.959><c> an</c><00:03:31.109><c> order</c>

00:03:31.369 --> 00:03:31.379 align:start position:0%
are so important when we place an order
 

00:03:31.379 --> 00:03:32.959 align:start position:0%
are so important when we place an order
with<00:03:31.469><c> this</c><00:03:31.650><c> forum</c><00:03:31.920><c> one</c><00:03:32.340><c> of</c><00:03:32.430><c> the</c><00:03:32.549><c> tables</c><00:03:32.849><c> that</c>

00:03:32.959 --> 00:03:32.969 align:start position:0%
with this forum one of the tables that
 

00:03:32.969 --> 00:03:35.780 align:start position:0%
with this forum one of the tables that
is<00:03:33.030><c> modified</c><00:03:33.540><c> is</c><00:03:33.810><c> order</c><00:03:34.260><c> items</c><00:03:34.620><c> now</c><00:03:35.459><c> it</c><00:03:35.639><c> would</c>

00:03:35.780 --> 00:03:35.790 align:start position:0%
is modified is order items now it would
 

00:03:35.790 --> 00:03:37.520 align:start position:0%
is modified is order items now it would
be<00:03:35.909><c> very</c><00:03:36.239><c> difficult</c><00:03:36.599><c> to</c><00:03:36.900><c> edit</c><00:03:37.230><c> this</c><00:03:37.349><c> table</c>

00:03:37.520 --> 00:03:37.530 align:start position:0%
be very difficult to edit this table
 

00:03:37.530 --> 00:03:39.920 align:start position:0%
be very difficult to edit this table
directly<00:03:38.129><c> for</c><00:03:38.969><c> instance</c><00:03:39.299><c> I</c><00:03:39.450><c> don't</c><00:03:39.689><c> know</c><00:03:39.780><c> what</c>

00:03:39.920 --> 00:03:39.930 align:start position:0%
directly for instance I don't know what
 

00:03:39.930 --> 00:03:42.530 align:start position:0%
directly for instance I don't know what
menu<00:03:40.170><c> item</c><00:03:40.409><c> 156</c><00:03:41.159><c> is</c><00:03:41.370><c> and</c><00:03:41.609><c> I</c><00:03:42.030><c> don't</c><00:03:42.090><c> remember</c>

00:03:42.530 --> 00:03:42.540 align:start position:0%
menu item 156 is and I don't remember
 

00:03:42.540 --> 00:03:44.750 align:start position:0%
menu item 156 is and I don't remember
which<00:03:42.840><c> customer</c><00:03:43.349><c> placed</c><00:03:43.620><c> order</c><00:03:44.010><c> number</c><00:03:44.250><c> seven</c>

00:03:44.750 --> 00:03:44.760 align:start position:0%
which customer placed order number seven
 

00:03:44.760 --> 00:03:47.270 align:start position:0%
which customer placed order number seven
but<00:03:45.389><c> access</c><00:03:45.900><c> can</c><00:03:46.139><c> piece</c><00:03:46.379><c> together</c><00:03:46.560><c> the</c><00:03:46.950><c> order</c>

00:03:47.270 --> 00:03:47.280 align:start position:0%
but access can piece together the order
 

00:03:47.280 --> 00:03:49.039 align:start position:0%
but access can piece together the order
by<00:03:47.430><c> looking</c><00:03:47.819><c> up</c><00:03:47.939><c> the</c><00:03:48.090><c> correct</c><00:03:48.359><c> records</c><00:03:48.870><c> in</c>

00:03:49.039 --> 00:03:49.049 align:start position:0%
by looking up the correct records in
 

00:03:49.049 --> 00:03:51.619 align:start position:0%
by looking up the correct records in
different<00:03:49.500><c> tables</c><00:03:49.859><c> so</c><00:03:50.670><c> tables</c><00:03:51.090><c> are</c><00:03:51.209><c> sometimes</c>

00:03:51.619 --> 00:03:51.629 align:start position:0%
different tables so tables are sometimes
 

00:03:51.629 --> 00:03:53.300 align:start position:0%
different tables so tables are sometimes
organized<00:03:52.169><c> in</c><00:03:52.349><c> a</c><00:03:52.409><c> way</c><00:03:52.439><c> that's</c><00:03:52.769><c> easy</c><00:03:52.980><c> for</c>

00:03:53.300 --> 00:03:53.310 align:start position:0%
organized in a way that's easy for
 

00:03:53.310 --> 00:03:55.520 align:start position:0%
organized in a way that's easy for
access<00:03:53.730><c> to</c><00:03:53.760><c> read</c><00:03:54.120><c> but</c><00:03:54.719><c> difficult</c><00:03:55.019><c> for</c><00:03:55.499><c> a</c>

00:03:55.520 --> 00:03:55.530 align:start position:0%
access to read but difficult for a
 

00:03:55.530 --> 00:03:57.679 align:start position:0%
access to read but difficult for a
person<00:03:55.950><c> to</c><00:03:55.980><c> read</c><00:03:56.189><c> and</c><00:03:56.430><c> that's</c><00:03:57.090><c> why</c><00:03:57.299><c> we</c><00:03:57.480><c> often</c>

00:03:57.679 --> 00:03:57.689 align:start position:0%
person to read and that's why we often
 

00:03:57.689 --> 00:03:59.690 align:start position:0%
person to read and that's why we often
have<00:03:58.019><c> to</c><00:03:58.139><c> use</c><00:03:58.169><c> forms</c><00:03:58.829><c> instead</c><00:03:59.129><c> of</c><00:03:59.340><c> editing</c>

00:03:59.690 --> 00:03:59.700 align:start position:0%
have to use forms instead of editing
 

00:03:59.700 --> 00:04:01.550 align:start position:0%
have to use forms instead of editing
tables<00:03:59.909><c> directly</c>

00:04:01.550 --> 00:04:01.560 align:start position:0%
tables directly
 

00:04:01.560 --> 00:04:03.680 align:start position:0%
tables directly
these<00:04:02.220><c> were</c><00:04:02.400><c> just</c><00:04:02.580><c> a</c><00:04:02.730><c> couple</c><00:04:02.940><c> of</c><00:04:03.060><c> examples</c><00:04:03.209><c> of</c>

00:04:03.680 --> 00:04:03.690 align:start position:0%
these were just a couple of examples of
 

00:04:03.690 --> 00:04:06.050 align:start position:0%
these were just a couple of examples of
forms<00:04:04.020><c> and</c><00:04:04.200><c> the</c><00:04:04.650><c> exact</c><00:04:04.980><c> content</c><00:04:05.610><c> and</c><00:04:05.760><c> layout</c>

00:04:06.050 --> 00:04:06.060 align:start position:0%
forms and the exact content and layout
 

00:04:06.060 --> 00:04:07.850 align:start position:0%
forms and the exact content and layout
of<00:04:06.090><c> a</c><00:04:06.330><c> form</c><00:04:06.600><c> will</c><00:04:06.780><c> vary</c><00:04:07.080><c> depending</c><00:04:07.170><c> on</c><00:04:07.650><c> how</c><00:04:07.709><c> the</c>

00:04:07.850 --> 00:04:07.860 align:start position:0%
of a form will vary depending on how the
 

00:04:07.860 --> 00:04:10.220 align:start position:0%
of a form will vary depending on how the
form<00:04:08.160><c> is</c><00:04:08.250><c> meant</c><00:04:08.310><c> to</c><00:04:08.580><c> be</c><00:04:08.700><c> used</c><00:04:08.970><c> but</c><00:04:09.720><c> the</c><00:04:09.870><c> basic</c>

00:04:10.220 --> 00:04:10.230 align:start position:0%
form is meant to be used but the basic
 

00:04:10.230 --> 00:04:12.050 align:start position:0%
form is meant to be used but the basic
process<00:04:10.440><c> of</c><00:04:10.830><c> using</c><00:04:11.190><c> a</c><00:04:11.250><c> form</c><00:04:11.490><c> will</c><00:04:11.640><c> generally</c>

00:04:12.050 --> 00:04:12.060 align:start position:0%
process of using a form will generally
 

00:04:12.060 --> 00:04:13.730 align:start position:0%
process of using a form will generally
be<00:04:12.090><c> very</c><00:04:12.450><c> similar</c><00:04:12.870><c> and</c><00:04:13.050><c> it</c><00:04:13.500><c> will</c><00:04:13.620><c> be</c><00:04:13.709><c> a</c>

00:04:13.730 --> 00:04:13.740 align:start position:0%
be very similar and it will be a
 

00:04:13.740 --> 00:04:15.740 align:start position:0%
be very similar and it will be a
combination<00:04:13.980><c> of</c><00:04:14.490><c> typing</c><00:04:15.000><c> information</c><00:04:15.150><c> into</c>

00:04:15.740 --> 00:04:15.750 align:start position:0%
combination of typing information into
 

00:04:15.750 --> 00:04:18.229 align:start position:0%
combination of typing information into
fields<00:04:16.139><c> and</c><00:04:16.320><c> using</c><00:04:16.980><c> drop-down</c><00:04:17.370><c> menus</c><00:04:17.760><c> buttons</c>

00:04:18.229 --> 00:04:18.239 align:start position:0%
fields and using drop-down menus buttons
 

00:04:18.239 --> 00:04:23.690 align:start position:0%
fields and using drop-down menus buttons
checkboxes<00:04:18.900><c> and</c><00:04:19.560><c> other</c><00:04:19.799><c> tools</c><00:04:20.100><c> like</c><00:04:22.550><c> what</c><00:04:23.550><c> you</c>

00:04:23.690 --> 00:04:23.700 align:start position:0%
checkboxes and other tools like what you
 

00:04:23.700 --> 00:04:27.379 align:start position:0%
checkboxes and other tools like what you
just<00:04:23.880><c> saw</c><00:04:24.800><c> greatest</c><00:04:25.800><c> at</c><00:04:26.280><c> a</c><00:04:26.340><c> comment</c><00:04:26.850><c> subscribe</c>

00:04:27.379 --> 00:04:27.389 align:start position:0%
just saw greatest at a comment subscribe
 

00:04:27.389 --> 00:04:29.130 align:start position:0%
just saw greatest at a comment subscribe
to<00:04:27.690><c> our</c><00:04:27.960><c> Channel</c>

00:04:29.130 --> 00:04:29.140 align:start position:0%
to our Channel
 

00:04:29.140 --> 00:04:31.140 align:start position:0%
to our Channel
the<00:04:29.410><c> freedom</c><00:04:29.860><c> to</c><00:04:29.890><c> learn</c>

00:04:31.140 --> 00:04:31.150 align:start position:0%
the freedom to learn
 

00:04:31.150 --> 00:04:35.879 align:start position:0%
the freedom to learn
what<00:04:31.780><c> you</c><00:04:31.990><c> want</c><00:04:32.490><c> when</c><00:04:33.490><c> you</c><00:04:33.520><c> want</c><00:04:34.889><c> absolutely</c>

00:04:35.879 --> 00:04:35.889 align:start position:0%
what you want when you want absolutely
 

00:04:35.889 --> 00:04:40.060 align:start position:0%
what you want when you want absolutely
free

00:04:40.060 --> 00:04:40.070 align:start position:0%
 
 

00:04:40.070 --> 00:04:43.700 align:start position:0%
 
GCF<00:04:41.070><c> learn</c><00:04:41.670><c> free.org</c>