WEBVTT
Kind: captions
Language: en

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

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

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

00:00:10.900 --> 00:00:10.910 align:start position:0%
 
 

00:00:10.910 --> 00:00:13.390 align:start position:0%
 
we've<00:00:11.570><c> already</c><00:00:11.840><c> looked</c><00:00:12.140><c> at</c><00:00:12.350><c> how</c><00:00:12.470><c> tables</c><00:00:13.010><c> store</c>

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

00:00:13.400 --> 00:00:15.640 align:start position:0%
we've already looked at how tables store
information<00:00:13.760><c> in</c><00:00:14.090><c> a</c><00:00:14.210><c> database</c><00:00:14.330><c> but</c><00:00:15.200><c> you're</c><00:00:15.440><c> not</c>

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

00:00:15.650 --> 00:00:17.050 align:start position:0%
information in a database but you're not
always<00:00:15.860><c> going</c><00:00:16.190><c> to</c><00:00:16.250><c> be</c><00:00:16.400><c> entering</c><00:00:16.760><c> data</c>

00:00:17.050 --> 00:00:17.060 align:start position:0%
always going to be entering data
 

00:00:17.060 --> 00:00:19.600 align:start position:0%
always going to be entering data
directly<00:00:17.600><c> into</c><00:00:17.869><c> a</c><00:00:18.020><c> table</c><00:00:18.470><c> much</c><00:00:19.160><c> of</c><00:00:19.340><c> the</c><00:00:19.430><c> time</c>

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

00:00:19.610 --> 00:00:22.109 align:start position:0%
directly into a table much of the time
you're<00:00:19.880><c> going</c><00:00:20.000><c> to</c><00:00:20.090><c> be</c><00:00:20.240><c> using</c><00:00:20.599><c> forms</c><00:00:21.050><c> instead</c><00:00:21.529><c> a</c>

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

00:00:22.119 --> 00:00:24.220 align:start position:0%
you're going to be using forms instead a
form<00:00:23.119><c> gives</c><00:00:23.360><c> you</c><00:00:23.480><c> a</c><00:00:23.510><c> more</c><00:00:23.810><c> user-friendly</c>

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

00:00:24.230 --> 00:00:26.769 align:start position:0%
form gives you a more user-friendly
interface<00:00:25.070><c> for</c><00:00:25.310><c> entering</c><00:00:25.700><c> data</c><00:00:25.849><c> and</c><00:00:26.180><c> they</c>

00:00:26.769 --> 00:00:26.779 align:start position:0%
interface for entering data and they
 

00:00:26.779 --> 00:00:28.120 align:start position:0%
interface for entering data and they
make<00:00:26.989><c> sure</c><00:00:27.169><c> that</c><00:00:27.320><c> the</c><00:00:27.470><c> data</c><00:00:27.619><c> goes</c><00:00:27.890><c> exactly</c>

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

00:00:28.130 --> 00:00:30.670 align:start position:0%
make sure that the data goes exactly
where<00:00:28.730><c> it</c><00:00:28.820><c> needs</c><00:00:29.029><c> to</c><00:00:29.119><c> sometimes</c><00:00:29.560><c> the</c><00:00:30.560><c> data</c>

00:00:30.670 --> 00:00:30.680 align:start position:0%
where it needs to sometimes the data
 

00:00:30.680 --> 00:00:32.740 align:start position:0%
where it needs to sometimes the data
just<00:00:30.950><c> goes</c><00:00:31.220><c> to</c><00:00:31.400><c> one</c><00:00:31.579><c> table</c><00:00:31.790><c> but</c><00:00:32.270><c> other</c><00:00:32.419><c> times</c>

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

00:00:32.750 --> 00:00:34.540 align:start position:0%
just goes to one table but other times
it<00:00:32.930><c> could</c><00:00:33.110><c> be</c><00:00:33.260><c> several</c><00:00:33.739><c> different</c><00:00:33.829><c> tables</c><00:00:34.340><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.550 align:start position:0%
it could be several different tables and
a<00:00:34.850><c> form</c><00:00:35.149><c> can</c><00:00:35.390><c> keep</c><00:00:35.570><c> track</c><00:00:35.870><c> of</c><00:00:36.050><c> that</c><00:00:36.230><c> so</c><00:00:36.500><c> you</c>

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

00:00:36.560 --> 00:00:39.580 align:start position:0%
a form can keep track of that so you
don't<00:00:36.829><c> have</c><00:00:36.950><c> to</c><00:00:37.810><c> right</c><00:00:38.810><c> now</c><00:00:38.960><c> we're</c><00:00:39.170><c> looking</c><00:00:39.290><c> at</c>

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

00:00:39.590 --> 00:00:41.770 align:start position:0%
don't have to right now we're looking at
the<00:00:39.860><c> customers</c><00:00:40.430><c> form</c><00:00:40.760><c> that</c><00:00:41.000><c> was</c><00:00:41.120><c> created</c><00:00:41.600><c> for</c>

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

00:00:41.780 --> 00:00:44.110 align:start position:0%
the customers form that was created for
our<00:00:41.989><c> database</c><00:00:42.230><c> and</c><00:00:42.680><c> this</c><00:00:43.340><c> gives</c><00:00:43.580><c> us</c><00:00:43.730><c> an</c><00:00:43.880><c> easy</c>

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

00:00:44.120 --> 00:00:46.360 align:start position:0%
our database and this gives us an easy
way<00:00:44.270><c> of</c><00:00:44.600><c> adding</c><00:00:44.840><c> or</c><00:00:45.170><c> changing</c><00:00:45.220><c> information</c><00:00:46.220><c> in</c>

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

00:00:46.370 --> 00:00:49.360 align:start position:0%
way of adding or changing information in
the<00:00:46.490><c> customers</c><00:00:46.970><c> table</c><00:00:47.800><c> the</c><00:00:48.800><c> difference</c><00:00:49.190><c> is</c>

00:00:49.360 --> 00:00:49.370 align:start position:0%
the customers table the difference is
 

00:00:49.370 --> 00:00:51.580 align:start position:0%
the customers table the difference is
here<00:00:49.940><c> we</c><00:00:49.970><c> can</c><00:00:50.270><c> just</c><00:00:50.300><c> focus</c><00:00:50.660><c> on</c><00:00:50.900><c> one</c><00:00:51.170><c> record</c><00:00:51.350><c> at</c>

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

00:00:51.590 --> 00:00:53.680 align:start position:0%
here we can just focus on one record at
a<00:00:51.680><c> time</c><00:00:51.710><c> and</c><00:00:52.160><c> there</c><00:00:52.910><c> are</c><00:00:53.030><c> also</c><00:00:53.240><c> some</c>

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

00:00:53.690 --> 00:00:55.870 align:start position:0%
a time and there are also some
specialized<00:00:54.320><c> tools</c><00:00:54.620><c> like</c><00:00:54.920><c> drop-down</c><00:00:55.400><c> boxes</c>

00:00:55.870 --> 00:00:55.880 align:start position:0%
specialized tools like drop-down boxes
 

00:00:55.880 --> 00:00:58.030 align:start position:0%
specialized tools like drop-down boxes
and<00:00:56.210><c> buttons</c><00:00:56.660><c> for</c><00:00:56.780><c> saving</c><00:00:57.350><c> deleting</c><00:00:57.860><c> and</c>

00:00:58.030 --> 00:00:58.040 align:start position:0%
and buttons for saving deleting and
 

00:00:58.040 --> 00:01:01.690 align:start position:0%
and buttons for saving deleting and
printing<00:00:59.380><c> we</c><00:01:00.380><c> can</c><00:01:00.530><c> use</c><00:01:00.710><c> a</c><00:01:00.740><c> drop-down</c><00:01:01.130><c> box</c><00:01:01.340><c> to</c>

00:01:01.690 --> 00:01:01.700 align:start position:0%
printing we can use a drop-down box to
 

00:01:01.700 --> 00:01:04.509 align:start position:0%
printing we can use a drop-down box to
find<00:01:02.060><c> an</c><00:01:02.210><c> existing</c><00:01:02.450><c> customer</c><00:01:02.840><c> and</c><00:01:03.339><c> we</c><00:01:04.339><c> could</c>

00:01:04.509 --> 00:01:04.519 align:start position:0%
find an existing customer and we could
 

00:01:04.519 --> 00:01:06.280 align:start position:0%
find an existing customer and we could
also<00:01:04.670><c> type</c><00:01:05.059><c> a</c><00:01:05.180><c> last</c><00:01:05.420><c> name</c><00:01:05.630><c> to</c><00:01:05.840><c> jump</c><00:01:06.079><c> to</c><00:01:06.259><c> a</c>

00:01:06.280 --> 00:01:06.290 align:start position:0%
also type a last name to jump to a
 

00:01:06.290 --> 00:01:09.660 align:start position:0%
also type a last name to jump to a
record<00:01:06.650><c> and</c><00:01:07.659><c> when</c><00:01:08.659><c> we</c><00:01:08.780><c> click</c><00:01:08.990><c> on</c><00:01:09.140><c> the</c><00:01:09.259><c> name</c>

00:01:09.660 --> 00:01:09.670 align:start position:0%
record and when we click on the name
 

00:01:09.670 --> 00:01:12.219 align:start position:0%
record and when we click on the name
their<00:01:10.670><c> information</c><00:01:11.270><c> will</c><00:01:11.390><c> appear</c><00:01:11.540><c> in</c><00:01:11.960><c> these</c>

00:01:12.219 --> 00:01:12.229 align:start position:0%
their information will appear in these
 

00:01:12.229 --> 00:01:15.730 align:start position:0%
their information will appear in these
fields<00:01:12.770><c> where</c><00:01:13.040><c> we</c><00:01:13.159><c> can</c><00:01:13.310><c> then</c><00:01:13.430><c> edit</c><00:01:13.820><c> it</c><00:01:14.740><c> I'm</c>

00:01:15.730 --> 00:01:15.740 align:start position:0%
fields where we can then edit it I'm
 

00:01:15.740 --> 00:01:17.139 align:start position:0%
fields where we can then edit it I'm
just<00:01:15.950><c> going</c><00:01:16.100><c> to</c><00:01:16.130><c> change</c><00:01:16.429><c> this</c><00:01:16.640><c> customer's</c>

00:01:17.139 --> 00:01:17.149 align:start position:0%
just going to change this customer's
 

00:01:17.149 --> 00:01:22.359 align:start position:0%
just going to change this customer's
address<00:01:20.380><c> now</c><00:01:21.380><c> some</c><00:01:21.679><c> fields</c><00:01:22.039><c> may</c><00:01:22.189><c> have</c><00:01:22.340><c> a</c>

00:01:22.359 --> 00:01:22.369 align:start position:0%
address now some fields may have a
 

00:01:22.369 --> 00:01:24.249 align:start position:0%
address now some fields may have a
validation<00:01:23.090><c> rule</c><00:01:23.329><c> that</c><00:01:23.509><c> limits</c><00:01:23.569><c> the</c><00:01:24.020><c> type</c><00:01:24.229><c> of</c>

00:01:24.249 --> 00:01:24.259 align:start position:0%
validation rule that limits the type of
 

00:01:24.259 --> 00:01:26.830 align:start position:0%
validation rule that limits the type of
data<00:01:24.649><c> that</c><00:01:24.770><c> can</c><00:01:25.069><c> be</c><00:01:25.159><c> entered</c><00:01:25.359><c> for</c><00:01:26.359><c> example</c>

00:01:26.830 --> 00:01:26.840 align:start position:0%
data that can be entered for example
 

00:01:26.840 --> 00:01:28.989 align:start position:0%
data that can be entered for example
here<00:01:27.319><c> the</c><00:01:27.560><c> state</c><00:01:27.859><c> needs</c><00:01:28.100><c> to</c><00:01:28.219><c> be</c><00:01:28.399><c> a</c><00:01:28.429><c> two</c><00:01:28.819><c> letter</c>

00:01:28.989 --> 00:01:28.999 align:start position:0%
here the state needs to be a two letter
 

00:01:28.999 --> 00:01:30.969 align:start position:0%
here the state needs to be a two letter
postal<00:01:29.539><c> code</c><00:01:29.749><c> and</c><00:01:29.899><c> if</c><00:01:30.350><c> I</c><00:01:30.439><c> try</c><00:01:30.679><c> to</c><00:01:30.710><c> type</c>

00:01:30.969 --> 00:01:30.979 align:start position:0%
postal code and if I try to type
 

00:01:30.979 --> 00:01:33.099 align:start position:0%
postal code and if I try to type
anything<00:01:31.219><c> else</c><00:01:31.520><c> a</c><00:01:31.789><c> window</c><00:01:32.329><c> will</c><00:01:32.479><c> pop</c><00:01:32.509><c> up</c><00:01:32.689><c> with</c>

00:01:33.099 --> 00:01:33.109 align:start position:0%
anything else a window will pop up with
 

00:01:33.109 --> 00:01:34.569 align:start position:0%
anything else a window will pop up with
instructions<00:01:33.740><c> on</c><00:01:33.920><c> how</c><00:01:34.069><c> to</c><00:01:34.130><c> fill</c><00:01:34.369><c> it</c><00:01:34.490><c> out</c>

00:01:34.569 --> 00:01:34.579 align:start position:0%
instructions on how to fill it out
 

00:01:34.579 --> 00:01:39.279 align:start position:0%
instructions on how to fill it out
correctly<00:01:34.819><c> and</c><00:01:37.299><c> I'll</c><00:01:38.299><c> change</c><00:01:38.600><c> this</c><00:01:38.840><c> back</c><00:01:39.109><c> to</c>

00:01:39.279 --> 00:01:39.289 align:start position:0%
correctly and I'll change this back to
 

00:01:39.289 --> 00:01:44.020 align:start position:0%
correctly and I'll change this back to
NC<00:01:39.799><c> and</c><00:01:42.340><c> when</c><00:01:43.340><c> you're</c><00:01:43.459><c> done</c><00:01:43.609><c> you</c><00:01:43.850><c> can</c><00:01:43.880><c> click</c>

00:01:44.020 --> 00:01:44.030 align:start position:0%
NC and when you're done you can click
 

00:01:44.030 --> 00:01:48.789 align:start position:0%
NC and when you're done you can click
Save<00:01:46.420><c> there's</c><00:01:47.420><c> also</c><00:01:47.630><c> a</c><00:01:47.810><c> button</c><00:01:48.229><c> to</c><00:01:48.439><c> create</c><00:01:48.590><c> a</c>

00:01:48.789 --> 00:01:48.799 align:start position:0%
Save there's also a button to create a
 

00:01:48.799 --> 00:01:51.609 align:start position:0%
Save there's also a button to create a
new<00:01:48.920><c> record</c><00:01:49.509><c> which</c><00:01:50.509><c> automatically</c><00:01:51.170><c> clears</c>

00:01:51.609 --> 00:01:51.619 align:start position:0%
new record which automatically clears
 

00:01:51.619 --> 00:01:53.319 align:start position:0%
new record which automatically clears
all<00:01:51.859><c> of</c><00:01:51.889><c> the</c><00:01:52.069><c> fields</c><00:01:52.189><c> so</c><00:01:52.639><c> we</c><00:01:52.670><c> can</c><00:01:52.880><c> type</c><00:01:53.090><c> in</c><00:01:53.209><c> a</c>

00:01:53.319 --> 00:01:53.329 align:start position:0%
all of the fields so we can type in a
 

00:01:53.329 --> 00:01:56.080 align:start position:0%
all of the fields so we can type in a
new<00:01:53.509><c> customers</c><00:01:54.020><c> information</c><00:01:54.850><c> so</c><00:01:55.850><c> if</c><00:01:55.969><c> you</c>

00:01:56.080 --> 00:01:56.090 align:start position:0%
new customers information so if you
 

00:01:56.090 --> 00:01:57.639 align:start position:0%
new customers information so if you
wanted<00:01:56.389><c> to</c><00:01:56.539><c> you</c><00:01:56.719><c> could</c><00:01:56.959><c> do</c><00:01:57.170><c> most</c><00:01:57.409><c> of</c><00:01:57.529><c> these</c>

00:01:57.639 --> 00:01:57.649 align:start position:0%
wanted to you could do most of these
 

00:01:57.649 --> 00:01:59.859 align:start position:0%
wanted to you could do most of these
things<00:01:57.709><c> by</c><00:01:58.100><c> editing</c><00:01:58.490><c> the</c><00:01:58.609><c> table</c><00:01:58.880><c> directly</c><00:01:59.119><c> but</c>

00:01:59.859 --> 00:01:59.869 align:start position:0%
things by editing the table directly but
 

00:01:59.869 --> 00:02:01.330 align:start position:0%
things by editing the table directly but
the<00:02:00.049><c> form</c><00:02:00.319><c> is</c><00:02:00.439><c> going</c><00:02:00.560><c> to</c><00:02:00.679><c> be</c><00:02:00.770><c> a</c><00:02:00.859><c> little</c><00:02:01.069><c> easier</c>

00:02:01.330 --> 00:02:01.340 align:start position:0%
the form is going to be a little easier
 

00:02:01.340 --> 00:02:04.959 align:start position:0%
the form is going to be a little easier
and<00:02:01.789><c> faster</c><00:02:01.939><c> to</c><00:02:02.329><c> use</c><00:02:03.310><c> now</c><00:02:04.310><c> let's</c><00:02:04.609><c> look</c><00:02:04.759><c> at</c><00:02:04.909><c> a</c>

00:02:04.959 --> 00:02:04.969 align:start position:0%
and faster to use now let's look at a
 

00:02:04.969 --> 00:02:06.999 align:start position:0%
and faster to use now let's look at a
slightly<00:02:05.299><c> more</c><00:02:05.450><c> complex</c><00:02:06.020><c> form</c><00:02:06.319><c> and</c><00:02:06.409><c> this</c><00:02:06.950><c> is</c>

00:02:06.999 --> 00:02:07.009 align:start position:0%
slightly more complex form and this is
 

00:02:07.009 --> 00:02:08.589 align:start position:0%
slightly more complex form and this is
going<00:02:07.340><c> to</c><00:02:07.429><c> let</c><00:02:07.549><c> us</c><00:02:07.670><c> do</c><00:02:07.849><c> things</c><00:02:08.030><c> that</c><00:02:08.209><c> we</c><00:02:08.330><c> really</c>

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

00:02:08.599 --> 00:02:10.389 align:start position:0%
going to let us do things that we really
couldn't<00:02:08.990><c> do</c><00:02:09.140><c> by</c><00:02:09.289><c> just</c><00:02:09.560><c> editing</c><00:02:09.709><c> the</c><00:02:10.039><c> tables</c>

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

00:02:10.399 --> 00:02:13.980 align:start position:0%
couldn't do by just editing the tables
I'm<00:02:11.330><c> going</c><00:02:11.870><c> to</c><00:02:11.990><c> open</c><00:02:12.200><c> the</c><00:02:12.530><c> orders</c><00:02:12.920><c> form</c><00:02:13.310><c> and</c>

00:02:13.980 --> 00:02:13.990 align:start position:0%
I'm going to open the orders form and
 

00:02:13.990 --> 00:02:16.330 align:start position:0%
I'm going to open the orders form and
this<00:02:14.990><c> is</c><00:02:15.050><c> what</c><00:02:15.319><c> the</c><00:02:15.440><c> employees</c><00:02:15.860><c> will</c><00:02:16.040><c> fill</c><00:02:16.190><c> out</c>

00:02:16.330 --> 00:02:16.340 align:start position:0%
this is what the employees will fill out
 

00:02:16.340 --> 00:02:18.730 align:start position:0%
this is what the employees will fill out
when<00:02:16.490><c> the</c><00:02:16.580><c> customer</c><00:02:17.000><c> places</c><00:02:17.180><c> an</c><00:02:17.420><c> order</c><00:02:17.740><c> let's</c>

00:02:18.730 --> 00:02:18.740 align:start position:0%
when the customer places an order let's
 

00:02:18.740 --> 00:02:20.050 align:start position:0%
when the customer places an order let's
just<00:02:18.950><c> walk</c><00:02:19.160><c> through</c><00:02:19.190><c> the</c><00:02:19.460><c> process</c><00:02:19.670><c> of</c>

00:02:20.050 --> 00:02:20.060 align:start position:0%
just walk through the process of
 

00:02:20.060 --> 00:02:23.890 align:start position:0%
just walk through the process of
creating<00:02:20.570><c> a</c><00:02:20.690><c> new</c><00:02:20.870><c> order</c><00:02:22.300><c> when</c><00:02:23.300><c> you</c><00:02:23.420><c> click</c><00:02:23.630><c> new</c>

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

00:02:23.900 --> 00:02:26.620 align:start position:0%
creating a new order when you click new
order<00:02:24.260><c> it</c><00:02:25.130><c> clears</c><00:02:25.580><c> all</c><00:02:25.790><c> of</c><00:02:25.820><c> the</c><00:02:25.970><c> fields</c><00:02:26.060><c> and</c>

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

00:02:26.630 --> 00:02:28.540 align:start position:0%
order it clears all of the fields and
then<00:02:27.410><c> you</c><00:02:27.500><c> can</c><00:02:27.680><c> choose</c><00:02:27.920><c> the</c><00:02:28.130><c> name</c><00:02:28.280><c> of</c><00:02:28.460><c> the</c>

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

00:02:28.550 --> 00:02:30.730 align:start position:0%
then you can choose the name of the
customer<00:02:28.760><c> that's</c><00:02:29.090><c> placing</c><00:02:29.510><c> the</c><00:02:29.630><c> order</c><00:02:29.900><c> the</c>

00:02:30.730 --> 00:02:30.740 align:start position:0%
customer that's placing the order the
 

00:02:30.740 --> 00:02:32.440 align:start position:0%
customer that's placing the order the
information<00:02:31.250><c> in</c><00:02:31.340><c> this</c><00:02:31.430><c> list</c><00:02:31.700><c> comes</c><00:02:31.970><c> from</c><00:02:32.300><c> the</c>

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

00:02:32.450 --> 00:02:34.900 align:start position:0%
information in this list comes from the
customers<00:02:32.930><c> table</c><00:02:33.170><c> so</c><00:02:33.890><c> every</c><00:02:34.340><c> customer</c><00:02:34.760><c> will</c>

00:02:34.900 --> 00:02:34.910 align:start position:0%
customers table so every customer will
 

00:02:34.910 --> 00:02:36.400 align:start position:0%
customers table so every customer will
need<00:02:35.060><c> to</c><00:02:35.120><c> already</c><00:02:35.240><c> be</c><00:02:35.600><c> in</c><00:02:35.870><c> the</c><00:02:35.900><c> database</c>

00:02:36.400 --> 00:02:36.410 align:start position:0%
need to already be in the database
 

00:02:36.410 --> 00:02:39.020 align:start position:0%
need to already be in the database
before<00:02:36.650><c> they</c><00:02:37.100><c> can</c><00:02:37.250><c> place</c><00:02:37.430><c> an</c><00:02:37.640><c> order</c>

00:02:39.020 --> 00:02:39.030 align:start position:0%
before they can place an order
 

00:02:39.030 --> 00:02:41.210 align:start position:0%
before they can place an order
and<00:02:39.120><c> it</c><00:02:39.959><c> automatically</c><00:02:40.410><c> generates</c><00:02:40.650><c> a</c><00:02:41.040><c> new</c>

00:02:41.210 --> 00:02:41.220 align:start position:0%
and it automatically generates a new
 

00:02:41.220 --> 00:02:43.020 align:start position:0%
and it automatically generates a new
order<00:02:41.550><c> number</c>

00:02:43.020 --> 00:02:43.030 align:start position:0%
order number
 

00:02:43.030 --> 00:02:45.090 align:start position:0%
order number
when<00:02:43.750><c> you</c><00:02:43.840><c> click</c><00:02:44.020><c> on</c><00:02:44.140><c> the</c><00:02:44.290><c> pickup</c><00:02:44.500><c> date</c><00:02:44.800><c> field</c>

00:02:45.090 --> 00:02:45.100 align:start position:0%
when you click on the pickup date field
 

00:02:45.100 --> 00:02:47.760 align:start position:0%
when you click on the pickup date field
a<00:02:45.370><c> calendar</c><00:02:46.090><c> button</c><00:02:46.300><c> appears</c><00:02:46.690><c> which</c><00:02:47.380><c> makes</c><00:02:47.620><c> it</c>

00:02:47.760 --> 00:02:47.770 align:start position:0%
a calendar button appears which makes it
 

00:02:47.770 --> 00:02:49.350 align:start position:0%
a calendar button appears which makes it
easy<00:02:47.920><c> to</c><00:02:48.040><c> quickly</c><00:02:48.430><c> choose</c><00:02:48.670><c> the</c><00:02:48.880><c> date</c><00:02:49.060><c> that</c><00:02:49.240><c> you</c>

00:02:49.350 --> 00:02:49.360 align:start position:0%
easy to quickly choose the date that you
 

00:02:49.360 --> 00:02:53.520 align:start position:0%
easy to quickly choose the date that you
want<00:02:49.390><c> and</c><00:02:51.660><c> there</c><00:02:52.660><c> are</c><00:02:52.780><c> also</c><00:02:52.960><c> a</c><00:02:53.140><c> couple</c><00:02:53.230><c> of</c>

00:02:53.520 --> 00:02:53.530 align:start position:0%
want and there are also a couple of
 

00:02:53.530 --> 00:02:55.140 align:start position:0%
want and there are also a couple of
checkboxes<00:02:54.250><c> for</c><00:02:54.460><c> simple</c><00:02:54.790><c> yes-or-no</c>

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

00:02:55.150 --> 00:02:57.630 align:start position:0%
checkboxes for simple yes-or-no
questions<00:02:55.860><c> later</c><00:02:56.860><c> when</c><00:02:57.100><c> you</c><00:02:57.190><c> start</c><00:02:57.430><c> creating</c>

00:02:57.630 --> 00:02:57.640 align:start position:0%
questions later when you start creating
 

00:02:57.640 --> 00:02:59.699 align:start position:0%
questions later when you start creating
forms<00:02:58.270><c> you'll</c><00:02:58.660><c> be</c><00:02:58.810><c> able</c><00:02:58.930><c> to</c><00:02:59.110><c> add</c><00:02:59.230><c> these</c><00:02:59.500><c> types</c>

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

00:02:59.709 --> 00:03:01.470 align:start position:0%
forms you'll be able to add these types
of<00:02:59.920><c> special</c><00:02:59.980><c> tools</c><00:03:00.610><c> to</c><00:03:00.880><c> make</c><00:03:01.030><c> your</c><00:03:01.180><c> forms</c>

00:03:01.470 --> 00:03:01.480 align:start position:0%
of special tools to make your forms
 

00:03:01.480 --> 00:03:04.860 align:start position:0%
of special tools to make your forms
easier<00:03:01.930><c> to</c><00:03:02.080><c> use</c><00:03:02.320><c> and</c><00:03:03.090><c> this</c><00:03:04.090><c> form</c><00:03:04.300><c> has</c><00:03:04.480><c> a</c><00:03:04.510><c> field</c>

00:03:04.860 --> 00:03:04.870 align:start position:0%
easier to use and this form has a field
 

00:03:04.870 --> 00:03:10.470 align:start position:0%
easier to use and this form has a field
where<00:03:05.110><c> you</c><00:03:05.140><c> can</c><00:03:05.200><c> add</c><00:03:05.500><c> notes</c><00:03:05.800><c> if</c><00:03:06.010><c> you</c><00:03:06.040><c> want</c><00:03:09.480><c> now</c>

00:03:10.470 --> 00:03:10.480 align:start position:0%
where you can add notes if you want now
 

00:03:10.480 --> 00:03:11.970 align:start position:0%
where you can add notes if you want now
here's<00:03:10.840><c> where</c><00:03:11.020><c> this</c><00:03:11.140><c> form</c><00:03:11.410><c> is</c><00:03:11.560><c> a</c><00:03:11.590><c> little</c><00:03:11.860><c> bit</c>

00:03:11.970 --> 00:03:11.980 align:start position:0%
here's where this form is a little bit
 

00:03:11.980 --> 00:03:14.460 align:start position:0%
here's where this form is a little bit
different<00:03:12.400><c> when</c><00:03:13.209><c> you</c><00:03:13.300><c> click</c><00:03:13.540><c> add</c><00:03:13.720><c> item</c><00:03:14.110><c> it</c>

00:03:14.460 --> 00:03:14.470 align:start position:0%
different when you click add item it
 

00:03:14.470 --> 00:03:17.640 align:start position:0%
different when you click add item it
opens<00:03:14.770><c> what's</c><00:03:14.980><c> called</c><00:03:15.220><c> a</c><00:03:15.370><c> subform</c><00:03:16.000><c> and</c><00:03:16.650><c> here</c>

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

00:03:17.650 --> 00:03:20.690 align:start position:0%
opens what's called a subform and here
you<00:03:17.739><c> can</c><00:03:17.920><c> choose</c><00:03:18.100><c> the</c><00:03:18.160><c> item</c><00:03:18.610><c> that</c><00:03:18.760><c> was</c><00:03:18.850><c> ordered</c>

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

00:03:20.700 --> 00:03:25.470 align:start position:0%
you can choose the item that was ordered
type<00:03:21.700><c> in</c><00:03:21.880><c> the</c><00:03:22.000><c> quantity</c><00:03:22.180><c> and</c><00:03:23.820><c> then</c><00:03:24.820><c> save</c><00:03:25.239><c> and</c>

00:03:25.470 --> 00:03:25.480 align:start position:0%
type in the quantity and then save and
 

00:03:25.480 --> 00:03:29.100 align:start position:0%
type in the quantity and then save and
close<00:03:25.950><c> if</c><00:03:27.300><c> the</c><00:03:28.300><c> form</c><00:03:28.540><c> doesn't</c><00:03:28.959><c> update</c>

00:03:29.100 --> 00:03:29.110 align:start position:0%
close if the form doesn't update
 

00:03:29.110 --> 00:03:31.229 align:start position:0%
close if the form doesn't update
automatically<00:03:29.920><c> you</c><00:03:30.459><c> can</c><00:03:30.489><c> just</c><00:03:30.820><c> go</c><00:03:30.940><c> to</c><00:03:30.970><c> the</c>

00:03:31.229 --> 00:03:31.239 align:start position:0%
automatically you can just go to the
 

00:03:31.239 --> 00:03:32.970 align:start position:0%
automatically you can just go to the
drop<00:03:31.510><c> down</c><00:03:31.540><c> arrow</c><00:03:32.020><c> below</c><00:03:32.320><c> the</c><00:03:32.620><c> refresh</c>

00:03:32.970 --> 00:03:32.980 align:start position:0%
drop down arrow below the refresh
 

00:03:32.980 --> 00:03:38.490 align:start position:0%
drop down arrow below the refresh
command<00:03:33.400><c> and</c><00:03:33.959><c> select</c><00:03:34.959><c> refresh</c><00:03:37.170><c> then</c><00:03:38.170><c> you</c><00:03:38.350><c> can</c>

00:03:38.490 --> 00:03:38.500 align:start position:0%
command and select refresh then you can
 

00:03:38.500 --> 00:03:41.970 align:start position:0%
command and select refresh then you can
add<00:03:38.650><c> another</c><00:03:38.860><c> item</c><00:03:39.310><c> and</c><00:03:40.470><c> you</c><00:03:41.470><c> can</c><00:03:41.620><c> do</c><00:03:41.709><c> this</c><00:03:41.830><c> as</c>

00:03:41.970 --> 00:03:41.980 align:start position:0%
add another item and you can do this as
 

00:03:41.980 --> 00:03:43.590 align:start position:0%
add another item and you can do this as
many<00:03:42.010><c> times</c><00:03:42.220><c> as</c><00:03:42.610><c> you</c><00:03:42.700><c> need</c><00:03:42.880><c> to</c><00:03:42.910><c> until</c><00:03:43.300><c> the</c>

00:03:43.590 --> 00:03:43.600 align:start position:0%
many times as you need to until the
 

00:03:43.600 --> 00:03:51.090 align:start position:0%
many times as you need to until the
order<00:03:43.750><c> is</c><00:03:43.959><c> complete</c><00:03:49.140><c> okay</c><00:03:50.140><c> now</c><00:03:50.620><c> let's</c><00:03:50.890><c> take</c><00:03:51.040><c> a</c>

00:03:51.090 --> 00:03:51.100 align:start position:0%
order is complete okay now let's take a
 

00:03:51.100 --> 00:03:54.000 align:start position:0%
order is complete okay now let's take a
look<00:03:51.310><c> at</c><00:03:51.459><c> why</c><00:03:51.730><c> forms</c><00:03:52.180><c> are</c><00:03:52.360><c> so</c><00:03:52.570><c> important</c><00:03:53.080><c> when</c>

00:03:54.000 --> 00:03:54.010 align:start position:0%
look at why forms are so important when
 

00:03:54.010 --> 00:03:55.710 align:start position:0%
look at why forms are so important when
we<00:03:54.130><c> place</c><00:03:54.340><c> an</c><00:03:54.489><c> order</c><00:03:54.730><c> with</c><00:03:54.850><c> this</c><00:03:55.000><c> form</c><00:03:55.299><c> one</c><00:03:55.690><c> of</c>

00:03:55.710 --> 00:03:55.720 align:start position:0%
we place an order with this form one of
 

00:03:55.720 --> 00:03:57.630 align:start position:0%
we place an order with this form one of
the<00:03:55.900><c> tables</c><00:03:56.230><c> that</c><00:03:56.290><c> is</c><00:03:56.470><c> modified</c><00:03:56.890><c> is</c><00:03:57.160><c> order</c>

00:03:57.630 --> 00:03:57.640 align:start position:0%
the tables that is modified is order
 

00:03:57.640 --> 00:04:01.170 align:start position:0%
the tables that is modified is order
items<00:03:58.709><c> now</c><00:03:59.709><c> it</c><00:03:59.890><c> would</c><00:04:00.040><c> be</c><00:04:00.070><c> very</c><00:04:00.190><c> difficult</c><00:04:00.820><c> to</c>

00:04:01.170 --> 00:04:01.180 align:start position:0%
items now it would be very difficult to
 

00:04:01.180 --> 00:04:03.660 align:start position:0%
items now it would be very difficult to
edit<00:04:01.330><c> this</c><00:04:01.570><c> table</c><00:04:01.750><c> directly</c><00:04:02.190><c> for</c><00:04:03.190><c> instance</c><00:04:03.549><c> I</c>

00:04:03.660 --> 00:04:03.670 align:start position:0%
edit this table directly for instance I
 

00:04:03.670 --> 00:04:06.240 align:start position:0%
edit this table directly for instance I
don't<00:04:03.790><c> know</c><00:04:04.030><c> what</c><00:04:04.150><c> menu</c><00:04:04.390><c> item</c><00:04:04.630><c> 156</c><00:04:05.410><c> is</c><00:04:05.620><c> and</c><00:04:05.830><c> I</c>

00:04:06.240 --> 00:04:06.250 align:start position:0%
don't know what menu item 156 is and I
 

00:04:06.250 --> 00:04:07.890 align:start position:0%
don't know what menu item 156 is and I
don't<00:04:06.310><c> remember</c><00:04:06.670><c> which</c><00:04:07.090><c> customer</c><00:04:07.630><c> placed</c>

00:04:07.890 --> 00:04:07.900 align:start position:0%
don't remember which customer placed
 

00:04:07.900 --> 00:04:09.030 align:start position:0%
don't remember which customer placed
order<00:04:08.290><c> number</c><00:04:08.500><c> 7</c>

00:04:09.030 --> 00:04:09.040 align:start position:0%
order number 7
 

00:04:09.040 --> 00:04:11.520 align:start position:0%
order number 7
but<00:04:09.670><c> access</c><00:04:10.150><c> can</c><00:04:10.390><c> piece</c><00:04:10.660><c> together</c><00:04:10.870><c> the</c><00:04:11.230><c> order</c>

00:04:11.520 --> 00:04:11.530 align:start position:0%
but access can piece together the order
 

00:04:11.530 --> 00:04:13.350 align:start position:0%
but access can piece together the order
by<00:04:11.709><c> looking</c><00:04:12.100><c> up</c><00:04:12.220><c> the</c><00:04:12.370><c> correct</c><00:04:12.640><c> records</c><00:04:13.150><c> and</c>

00:04:13.350 --> 00:04:13.360 align:start position:0%
by looking up the correct records and
 

00:04:13.360 --> 00:04:16.259 align:start position:0%
by looking up the correct records and
different<00:04:13.750><c> tables</c><00:04:14.280><c> so</c><00:04:15.280><c> tables</c><00:04:15.730><c> are</c><00:04:15.850><c> sometimes</c>

00:04:16.259 --> 00:04:16.269 align:start position:0%
different tables so tables are sometimes
 

00:04:16.269 --> 00:04:17.789 align:start position:0%
different tables so tables are sometimes
organized<00:04:16.810><c> in</c><00:04:16.989><c> a</c><00:04:17.049><c> way</c><00:04:17.079><c> that's</c><00:04:17.410><c> easy</c><00:04:17.620><c> for</c>

00:04:17.789 --> 00:04:17.799 align:start position:0%
organized in a way that's easy for
 

00:04:17.799 --> 00:04:20.159 align:start position:0%
organized in a way that's easy for
access<00:04:18.370><c> to</c><00:04:18.549><c> read</c><00:04:18.760><c> but</c><00:04:19.329><c> difficult</c><00:04:19.630><c> for</c><00:04:20.140><c> a</c>

00:04:20.159 --> 00:04:20.169 align:start position:0%
access to read but difficult for a
 

00:04:20.169 --> 00:04:22.290 align:start position:0%
access to read but difficult for a
person<00:04:20.380><c> to</c><00:04:20.590><c> read</c><00:04:20.829><c> and</c><00:04:21.040><c> that's</c><00:04:21.669><c> why</c><00:04:21.940><c> we</c><00:04:22.120><c> often</c>

00:04:22.290 --> 00:04:22.300 align:start position:0%
person to read and that's why we often
 

00:04:22.300 --> 00:04:24.120 align:start position:0%
person to read and that's why we often
have<00:04:22.660><c> to</c><00:04:22.690><c> use</c><00:04:22.810><c> forms</c><00:04:23.470><c> instead</c><00:04:23.770><c> of</c><00:04:23.979><c> editing</c>

00:04:24.120 --> 00:04:24.130 align:start position:0%
have to use forms instead of editing
 

00:04:24.130 --> 00:04:29.370 align:start position:0%
have to use forms instead of editing
tables<00:04:24.700><c> directly</c><00:04:27.540><c> these</c><00:04:28.540><c> were</c><00:04:28.750><c> just</c><00:04:28.960><c> a</c><00:04:29.110><c> couple</c>

00:04:29.370 --> 00:04:29.380 align:start position:0%
tables directly these were just a couple
 

00:04:29.380 --> 00:04:31.350 align:start position:0%
tables directly these were just a couple
of<00:04:29.470><c> examples</c><00:04:29.710><c> of</c><00:04:30.010><c> forms</c><00:04:30.400><c> and</c><00:04:30.580><c> the</c><00:04:31.030><c> exact</c>

00:04:31.350 --> 00:04:31.360 align:start position:0%
of examples of forms and the exact
 

00:04:31.360 --> 00:04:33.420 align:start position:0%
of examples of forms and the exact
content<00:04:31.990><c> and</c><00:04:32.140><c> layout</c><00:04:32.320><c> of</c><00:04:32.620><c> a</c><00:04:32.710><c> form</c><00:04:32.950><c> will</c><00:04:33.130><c> vary</c>

00:04:33.420 --> 00:04:33.430 align:start position:0%
content and layout of a form will vary
 

00:04:33.430 --> 00:04:35.040 align:start position:0%
content and layout of a form will vary
depending<00:04:33.520><c> on</c><00:04:34.000><c> how</c><00:04:34.060><c> the</c><00:04:34.210><c> form</c><00:04:34.540><c> is</c><00:04:34.630><c> meant</c><00:04:34.690><c> to</c><00:04:34.960><c> be</c>

00:04:35.040 --> 00:04:35.050 align:start position:0%
depending on how the form is meant to be
 

00:04:35.050 --> 00:04:37.590 align:start position:0%
depending on how the form is meant to be
used<00:04:35.350><c> but</c><00:04:36.100><c> the</c><00:04:36.250><c> basic</c><00:04:36.580><c> process</c><00:04:37.060><c> of</c><00:04:37.180><c> using</c><00:04:37.419><c> a</c>

00:04:37.590 --> 00:04:37.600 align:start position:0%
used but the basic process of using a
 

00:04:37.600 --> 00:04:39.390 align:start position:0%
used but the basic process of using a
form<00:04:37.840><c> will</c><00:04:37.990><c> generally</c><00:04:38.410><c> be</c><00:04:38.440><c> very</c><00:04:38.800><c> similar</c><00:04:39.220><c> and</c>

00:04:39.390 --> 00:04:39.400 align:start position:0%
form will generally be very similar and
 

00:04:39.400 --> 00:04:41.280 align:start position:0%
form will generally be very similar and
it<00:04:39.790><c> will</c><00:04:39.910><c> be</c><00:04:40.000><c> a</c><00:04:40.030><c> combination</c><00:04:40.270><c> of</c><00:04:40.780><c> typing</c>

00:04:41.280 --> 00:04:41.290 align:start position:0%
it will be a combination of typing
 

00:04:41.290 --> 00:04:43.290 align:start position:0%
it will be a combination of typing
information<00:04:41.800><c> into</c><00:04:42.040><c> fields</c><00:04:42.460><c> and</c><00:04:42.610><c> using</c>

00:04:43.290 --> 00:04:43.300 align:start position:0%
information into fields and using
 

00:04:43.300 --> 00:04:45.840 align:start position:0%
information into fields and using
drop-down<00:04:43.690><c> menus</c><00:04:44.050><c> buttons</c><00:04:44.560><c> checkboxes</c><00:04:45.190><c> and</c>

00:04:45.840 --> 00:04:45.850 align:start position:0%
drop-down menus buttons checkboxes and
 

00:04:45.850 --> 00:04:48.390 align:start position:0%
drop-down menus buttons checkboxes and
other<00:04:46.090><c> tools</c>