WEBVTT
Kind: captions
Language: en

00:00:05.480 --> 00:00:08.210 align:start position:0%
 
now<00:00:06.480><c> we</c><00:00:06.540><c> need</c><00:00:06.870><c> to</c><00:00:07.020><c> work</c><00:00:07.200><c> on</c><00:00:07.350><c> our</c><00:00:07.500><c> orders</c><00:00:07.890><c> form</c>

00:00:08.210 --> 00:00:08.220 align:start position:0%
now we need to work on our orders form
 

00:00:08.220 --> 00:00:10.310 align:start position:0%
now we need to work on our orders form
which<00:00:08.550><c> is</c><00:00:08.670><c> the</c><00:00:08.760><c> most</c><00:00:08.910><c> crucial</c><00:00:09.300><c> of</c><00:00:09.599><c> our</c><00:00:09.780><c> forms</c>

00:00:10.310 --> 00:00:10.320 align:start position:0%
which is the most crucial of our forms
 

00:00:10.320 --> 00:00:12.440 align:start position:0%
which is the most crucial of our forms
it's<00:00:10.800><c> where</c><00:00:11.130><c> we'll</c><00:00:11.250><c> have</c><00:00:11.490><c> our</c><00:00:11.550><c> database</c><00:00:12.120><c> user</c>

00:00:12.440 --> 00:00:12.450 align:start position:0%
it's where we'll have our database user
 

00:00:12.450 --> 00:00:15.440 align:start position:0%
it's where we'll have our database user
the<00:00:12.840><c> store</c><00:00:13.080><c> employee</c><00:00:13.639><c> identify</c><00:00:14.639><c> what</c><00:00:14.910><c> book</c><00:00:15.240><c> or</c>

00:00:15.440 --> 00:00:15.450 align:start position:0%
the store employee identify what book or
 

00:00:15.450 --> 00:00:16.970 align:start position:0%
the store employee identify what book or
books<00:00:15.750><c> are</c><00:00:15.990><c> being</c><00:00:16.139><c> ordered</c><00:00:16.500><c> by</c><00:00:16.650><c> which</c>

00:00:16.970 --> 00:00:16.980 align:start position:0%
books are being ordered by which
 

00:00:16.980 --> 00:00:19.010 align:start position:0%
books are being ordered by which
customer<00:00:17.520><c> now</c><00:00:18.000><c> we</c><00:00:18.060><c> already</c><00:00:18.330><c> have</c><00:00:18.690><c> the</c><00:00:18.810><c> basic</c>

00:00:19.010 --> 00:00:19.020 align:start position:0%
customer now we already have the basic
 

00:00:19.020 --> 00:00:21.650 align:start position:0%
customer now we already have the basic
form<00:00:19.470><c> set</c><00:00:19.710><c> up</c><00:00:19.859><c> it</c><00:00:20.340><c> was</c><00:00:20.490><c> created</c><00:00:21.029><c> just</c><00:00:21.270><c> like</c><00:00:21.480><c> our</c>

00:00:21.650 --> 00:00:21.660 align:start position:0%
form set up it was created just like our
 

00:00:21.660 --> 00:00:24.140 align:start position:0%
form set up it was created just like our
other<00:00:21.930><c> forms</c><00:00:22.439><c> it</c><00:00:22.650><c> shows</c><00:00:23.250><c> all</c><00:00:23.519><c> the</c><00:00:23.550><c> fields</c><00:00:24.119><c> that</c>

00:00:24.140 --> 00:00:24.150 align:start position:0%
other forms it shows all the fields that
 

00:00:24.150 --> 00:00:25.939 align:start position:0%
other forms it shows all the fields that
are<00:00:24.269><c> in</c><00:00:24.359><c> the</c><00:00:24.510><c> orders</c><00:00:24.840><c> table</c><00:00:25.109><c> and</c><00:00:25.529><c> it</c><00:00:25.859><c> is</c>

00:00:25.939 --> 00:00:25.949 align:start position:0%
are in the orders table and it is
 

00:00:25.949 --> 00:00:28.009 align:start position:0%
are in the orders table and it is
currently<00:00:26.400><c> showing</c><00:00:26.699><c> the</c><00:00:26.970><c> first</c><00:00:27.269><c> record</c><00:00:27.810><c> in</c>

00:00:28.009 --> 00:00:28.019 align:start position:0%
currently showing the first record in
 

00:00:28.019 --> 00:00:30.439 align:start position:0%
currently showing the first record in
the<00:00:28.140><c> orders</c><00:00:28.439><c> table</c><00:00:28.650><c> the</c><00:00:29.460><c> setup</c><00:00:29.880><c> of</c><00:00:30.000><c> this</c><00:00:30.119><c> form</c>

00:00:30.439 --> 00:00:30.449 align:start position:0%
the orders table the setup of this form
 

00:00:30.449 --> 00:00:32.179 align:start position:0%
the orders table the setup of this form
isn't<00:00:30.900><c> very</c><00:00:31.050><c> useful</c><00:00:31.109><c> to</c><00:00:31.560><c> someone</c><00:00:31.949><c> who</c><00:00:32.070><c> is</c>

00:00:32.179 --> 00:00:32.189 align:start position:0%
isn't very useful to someone who is
 

00:00:32.189 --> 00:00:34.970 align:start position:0%
isn't very useful to someone who is
entering<00:00:32.550><c> orders</c><00:00:32.759><c> all</c><00:00:33.420><c> of</c><00:00:33.719><c> these</c><00:00:33.840><c> IDs</c><00:00:34.290><c> really</c>

00:00:34.970 --> 00:00:34.980 align:start position:0%
entering orders all of these IDs really
 

00:00:34.980 --> 00:00:36.770 align:start position:0%
entering orders all of these IDs really
don't<00:00:35.190><c> mean</c><00:00:35.430><c> much</c><00:00:35.700><c> the</c><00:00:35.940><c> person</c><00:00:36.149><c> taking</c><00:00:36.480><c> a</c><00:00:36.660><c> new</c>

00:00:36.770 --> 00:00:36.780 align:start position:0%
don't mean much the person taking a new
 

00:00:36.780 --> 00:00:38.869 align:start position:0%
don't mean much the person taking a new
order<00:00:37.140><c> the</c><00:00:37.680><c> only</c><00:00:37.980><c> thing</c><00:00:38.160><c> a</c><00:00:38.190><c> person</c><00:00:38.640><c> entering</c>

00:00:38.869 --> 00:00:38.879 align:start position:0%
order the only thing a person entering
 

00:00:38.879 --> 00:00:40.760 align:start position:0%
order the only thing a person entering
data<00:00:39.180><c> would</c><00:00:39.450><c> care</c><00:00:39.690><c> about</c><00:00:39.840><c> is</c><00:00:40.170><c> the</c><00:00:40.320><c> customer</c>

00:00:40.760 --> 00:00:40.770 align:start position:0%
data would care about is the customer
 

00:00:40.770 --> 00:00:43.400 align:start position:0%
data would care about is the customer
name<00:00:41.010><c> and</c><00:00:41.309><c> the</c><00:00:41.670><c> book</c><00:00:41.879><c> title</c><00:00:42.420><c> in</c><00:00:42.629><c> other</c><00:00:43.140><c> words</c>

00:00:43.400 --> 00:00:43.410 align:start position:0%
name and the book title in other words
 

00:00:43.410 --> 00:00:47.029 align:start position:0%
name and the book title in other words
who<00:00:43.860><c> ordered</c><00:00:44.190><c> what</c><00:00:44.930><c> now</c><00:00:45.930><c> as</c><00:00:46.289><c> our</c><00:00:46.530><c> database</c>

00:00:47.029 --> 00:00:47.039 align:start position:0%
who ordered what now as our database
 

00:00:47.039 --> 00:00:49.160 align:start position:0%
who ordered what now as our database
owner<00:00:47.340><c> we</c><00:00:47.700><c> want</c><00:00:47.940><c> to</c><00:00:48.059><c> restrict</c><00:00:48.420><c> the</c><00:00:48.629><c> use</c><00:00:48.899><c> of</c><00:00:49.079><c> the</c>

00:00:49.160 --> 00:00:49.170 align:start position:0%
owner we want to restrict the use of the
 

00:00:49.170 --> 00:00:52.459 align:start position:0%
owner we want to restrict the use of the
form<00:00:49.559><c> to</c><00:00:49.860><c> only</c><00:00:50.160><c> entering</c><00:00:51.090><c> new</c><00:00:51.390><c> records</c><00:00:51.840><c> so</c>

00:00:52.459 --> 00:00:52.469 align:start position:0%
form to only entering new records so
 

00:00:52.469 --> 00:00:54.529 align:start position:0%
form to only entering new records so
that<00:00:52.500><c> the</c><00:00:52.710><c> person</c><00:00:53.129><c> using</c><00:00:53.489><c> the</c><00:00:53.520><c> form</c><00:00:53.969><c> doesn't</c>

00:00:54.529 --> 00:00:54.539 align:start position:0%
that the person using the form doesn't
 

00:00:54.539 --> 00:00:56.569 align:start position:0%
that the person using the form doesn't
accidentally<00:00:55.050><c> overwrite</c><00:00:55.649><c> an</c><00:00:55.800><c> existing</c><00:00:55.890><c> order</c>

00:00:56.569 --> 00:00:56.579 align:start position:0%
accidentally overwrite an existing order
 

00:00:56.579 --> 00:00:59.150 align:start position:0%
accidentally overwrite an existing order
we<00:00:57.239><c> wanted</c><00:00:57.660><c> to</c><00:00:57.780><c> open</c><00:00:58.140><c> to</c><00:00:58.230><c> the</c><00:00:58.350><c> new</c><00:00:58.530><c> record</c><00:00:58.980><c> each</c>

00:00:59.150 --> 00:00:59.160 align:start position:0%
we wanted to open to the new record each
 

00:00:59.160 --> 00:01:01.580 align:start position:0%
we wanted to open to the new record each
time<00:00:59.539><c> so</c><00:01:00.539><c> let's</c><00:01:00.750><c> set</c><00:01:00.960><c> up</c><00:01:00.989><c> that</c><00:01:01.230><c> level</c><00:01:01.410><c> of</c>

00:01:01.580 --> 00:01:01.590 align:start position:0%
time so let's set up that level of
 

00:01:01.590 --> 00:01:03.460 align:start position:0%
time so let's set up that level of
control<00:01:01.980><c> right</c><00:01:02.280><c> now</c>

00:01:03.460 --> 00:01:03.470 align:start position:0%
control right now
 

00:01:03.470 --> 00:01:07.070 align:start position:0%
control right now
first<00:01:04.470><c> let's</c><00:01:04.739><c> rename</c><00:01:05.159><c> the</c><00:01:05.369><c> form</c><00:01:05.760><c> new</c><00:01:06.360><c> orders</c>

00:01:07.070 --> 00:01:07.080 align:start position:0%
first let's rename the form new orders
 

00:01:07.080 --> 00:01:09.380 align:start position:0%
first let's rename the form new orders
so<00:01:07.680><c> our</c><00:01:07.830><c> user</c><00:01:08.159><c> can</c><00:01:08.400><c> tell</c><00:01:08.640><c> at</c><00:01:08.820><c> first</c><00:01:08.970><c> glance</c>

00:01:09.380 --> 00:01:09.390 align:start position:0%
so our user can tell at first glance
 

00:01:09.390 --> 00:01:11.450 align:start position:0%
so our user can tell at first glance
that<00:01:09.659><c> he</c><00:01:09.869><c> or</c><00:01:09.930><c> she</c><00:01:10.020><c> should</c><00:01:10.229><c> be</c><00:01:10.680><c> entering</c><00:01:11.070><c> only</c>

00:01:11.450 --> 00:01:11.460 align:start position:0%
that he or she should be entering only
 

00:01:11.460 --> 00:01:16.820 align:start position:0%
that he or she should be entering only
new<00:01:11.820><c> orders</c><00:01:14.689><c> to</c><00:01:15.689><c> make</c><00:01:15.930><c> it</c><00:01:16.080><c> so</c><00:01:16.229><c> that</c><00:01:16.259><c> records</c>

00:01:16.820 --> 00:01:16.830 align:start position:0%
new orders to make it so that records
 

00:01:16.830 --> 00:01:19.460 align:start position:0%
new orders to make it so that records
can<00:01:17.040><c> only</c><00:01:17.280><c> be</c><00:01:17.850><c> added</c><00:01:18.090><c> we</c><00:01:18.780><c> have</c><00:01:18.990><c> to</c><00:01:19.140><c> set</c><00:01:19.350><c> the</c>

00:01:19.460 --> 00:01:19.470 align:start position:0%
can only be added we have to set the
 

00:01:19.470 --> 00:01:21.920 align:start position:0%
can only be added we have to set the
form<00:01:19.740><c> properties</c><00:01:20.400><c> you</c><00:01:21.240><c> can</c><00:01:21.420><c> do</c><00:01:21.630><c> that</c><00:01:21.810><c> in</c>

00:01:21.920 --> 00:01:21.930 align:start position:0%
form properties you can do that in
 

00:01:21.930 --> 00:01:25.910 align:start position:0%
form properties you can do that in
design<00:01:22.259><c> view</c><00:01:23.659><c> if</c><00:01:24.659><c> the</c><00:01:24.869><c> property</c><00:01:25.350><c> sheet</c><00:01:25.619><c> is</c><00:01:25.770><c> not</c>

00:01:25.910 --> 00:01:25.920 align:start position:0%
design view if the property sheet is not
 

00:01:25.920 --> 00:01:28.969 align:start position:0%
design view if the property sheet is not
already<00:01:26.250><c> open</c><00:01:26.850><c> click</c><00:01:27.659><c> on</c><00:01:27.900><c> the</c><00:01:28.290><c> property</c><00:01:28.740><c> sheet</c>

00:01:28.969 --> 00:01:28.979 align:start position:0%
already open click on the property sheet
 

00:01:28.979 --> 00:01:31.429 align:start position:0%
already open click on the property sheet
command<00:01:29.460><c> in</c><00:01:29.670><c> the</c><00:01:29.759><c> tools</c><00:01:30.030><c> group</c><00:01:30.390><c> under</c><00:01:31.290><c> the</c>

00:01:31.429 --> 00:01:31.439 align:start position:0%
command in the tools group under the
 

00:01:31.439 --> 00:01:35.120 align:start position:0%
command in the tools group under the
design<00:01:31.770><c> tab</c><00:01:33.170><c> now</c><00:01:34.170><c> make</c><00:01:34.409><c> sure</c><00:01:34.439><c> form</c><00:01:34.979><c> is</c>

00:01:35.120 --> 00:01:35.130 align:start position:0%
design tab now make sure form is
 

00:01:35.130 --> 00:01:37.069 align:start position:0%
design tab now make sure form is
selected<00:01:35.670><c> from</c><00:01:35.729><c> the</c><00:01:35.820><c> drop-down</c><00:01:36.150><c> since</c><00:01:36.840><c> that's</c>

00:01:37.069 --> 00:01:37.079 align:start position:0%
selected from the drop-down since that's
 

00:01:37.079 --> 00:01:39.370 align:start position:0%
selected from the drop-down since that's
where<00:01:37.350><c> we</c><00:01:37.439><c> want</c><00:01:37.710><c> to</c><00:01:37.829><c> make</c><00:01:37.979><c> our</c><00:01:38.159><c> changes</c>

00:01:39.370 --> 00:01:39.380 align:start position:0%
where we want to make our changes
 

00:01:39.380 --> 00:01:41.780 align:start position:0%
where we want to make our changes
now<00:01:40.380><c> we'll</c><00:01:40.590><c> set</c><00:01:40.770><c> a</c><00:01:40.799><c> few</c><00:01:41.070><c> options</c><00:01:41.490><c> under</c><00:01:41.759><c> the</c>

00:01:41.780 --> 00:01:41.790 align:start position:0%
now we'll set a few options under the
 

00:01:41.790 --> 00:01:44.450 align:start position:0%
now we'll set a few options under the
data<00:01:42.119><c> tab</c><00:01:42.420><c> the</c><00:01:43.200><c> text</c><00:01:43.710><c> in</c><00:01:43.770><c> the</c><00:01:43.890><c> lower</c><00:01:44.130><c> left</c>

00:01:44.450 --> 00:01:44.460 align:start position:0%
data tab the text in the lower left
 

00:01:44.460 --> 00:01:46.789 align:start position:0%
data tab the text in the lower left
corner<00:01:44.759><c> of</c><00:01:44.909><c> the</c><00:01:45.060><c> window</c><00:01:45.479><c> helps</c><00:01:46.170><c> you</c><00:01:46.290><c> know</c><00:01:46.470><c> what</c>

00:01:46.789 --> 00:01:46.799 align:start position:0%
corner of the window helps you know what
 

00:01:46.799 --> 00:01:49.249 align:start position:0%
corner of the window helps you know what
each<00:01:47.009><c> field</c><00:01:47.310><c> property</c><00:01:47.729><c> does</c><00:01:47.970><c> so</c><00:01:48.720><c> if</c><00:01:48.840><c> we</c><00:01:48.990><c> click</c>

00:01:49.249 --> 00:01:49.259 align:start position:0%
each field property does so if we click
 

00:01:49.259 --> 00:01:52.670 align:start position:0%
each field property does so if we click
in<00:01:49.439><c> data</c><00:01:49.680><c> entry</c><00:01:50.600><c> we</c><00:01:51.600><c> know</c><00:01:51.810><c> it</c><00:01:51.960><c> is</c><00:01:52.049><c> asking</c><00:01:52.530><c> you</c>

00:01:52.670 --> 00:01:52.680 align:start position:0%
in data entry we know it is asking you
 

00:01:52.680 --> 00:01:55.039 align:start position:0%
in data entry we know it is asking you
if<00:01:52.860><c> you</c><00:01:53.040><c> want</c><00:01:53.369><c> to</c><00:01:53.430><c> only</c><00:01:53.820><c> allow</c><00:01:54.119><c> new</c><00:01:54.570><c> records</c><00:01:54.990><c> to</c>

00:01:55.039 --> 00:01:55.049 align:start position:0%
if you want to only allow new records to
 

00:01:55.049 --> 00:01:59.270 align:start position:0%
if you want to only allow new records to
be<00:01:55.259><c> added</c><00:01:55.710><c> so</c><00:01:55.920><c> we'll</c><00:01:56.670><c> change</c><00:01:56.969><c> notes</c><00:01:57.329><c> yes</c><00:01:58.280><c> we</c>

00:01:59.270 --> 00:01:59.280 align:start position:0%
be added so we'll change notes yes we
 

00:01:59.280 --> 00:02:01.999 align:start position:0%
be added so we'll change notes yes we
want<00:01:59.520><c> to</c><00:01:59.640><c> be</c><00:01:59.790><c> able</c><00:01:59.939><c> to</c><00:02:00.180><c> allow</c><00:02:00.420><c> additions</c><00:02:01.200><c> so</c>

00:02:01.999 --> 00:02:02.009 align:start position:0%
want to be able to allow additions so
 

00:02:02.009 --> 00:02:05.270 align:start position:0%
want to be able to allow additions so
this<00:02:02.250><c> will</c><00:02:02.430><c> remain</c><00:02:02.610><c> yes</c><00:02:03.560><c> now</c><00:02:04.560><c> we</c><00:02:04.619><c> don't</c><00:02:04.950><c> want</c>

00:02:05.270 --> 00:02:05.280 align:start position:0%
this will remain yes now we don't want
 

00:02:05.280 --> 00:02:08.180 align:start position:0%
this will remain yes now we don't want
to<00:02:05.399><c> allow</c><00:02:05.610><c> deletions</c><00:02:06.360><c> so</c><00:02:07.079><c> we'll</c><00:02:07.229><c> set</c><00:02:07.500><c> that</c><00:02:07.530><c> to</c>

00:02:08.180 --> 00:02:08.190 align:start position:0%
to allow deletions so we'll set that to
 

00:02:08.190 --> 00:02:11.390 align:start position:0%
to allow deletions so we'll set that to
no<00:02:08.220><c> and</c><00:02:08.970><c> we</c><00:02:09.959><c> also</c><00:02:10.170><c> don't</c><00:02:10.530><c> want</c><00:02:10.679><c> our</c><00:02:10.979><c> users</c><00:02:11.310><c> who</c>

00:02:11.390 --> 00:02:11.400 align:start position:0%
no and we also don't want our users who
 

00:02:11.400 --> 00:02:13.699 align:start position:0%
no and we also don't want our users who
edit<00:02:11.790><c> data</c><00:02:11.970><c> from</c><00:02:12.239><c> the</c><00:02:12.330><c> orders</c><00:02:12.690><c> form</c>

00:02:13.699 --> 00:02:13.709 align:start position:0%
edit data from the orders form
 

00:02:13.709 --> 00:02:16.819 align:start position:0%
edit data from the orders form
so<00:02:13.829><c> we'll</c><00:02:13.980><c> set</c><00:02:14.219><c> that</c><00:02:14.250><c> to</c><00:02:14.459><c> no</c><00:02:15.469><c> now</c><00:02:16.469><c> we</c><00:02:16.530><c> have</c><00:02:16.799><c> a</c>

00:02:16.819 --> 00:02:16.829 align:start position:0%
so we'll set that to no now we have a
 

00:02:16.829 --> 00:02:18.589 align:start position:0%
so we'll set that to no now we have a
form<00:02:17.189><c> for</c><00:02:17.340><c> our</c><00:02:17.459><c> employees</c><00:02:18.060><c> to</c><00:02:18.180><c> enter</c><00:02:18.209><c> new</c>

00:02:18.589 --> 00:02:18.599 align:start position:0%
form for our employees to enter new
 

00:02:18.599 --> 00:02:22.369 align:start position:0%
form for our employees to enter new
orders<00:02:20.030><c> so</c><00:02:21.030><c> now</c><00:02:21.329><c> let's</c><00:02:21.599><c> look</c><00:02:21.689><c> at</c><00:02:21.900><c> this</c><00:02:22.049><c> form</c>

00:02:22.369 --> 00:02:22.379 align:start position:0%
orders so now let's look at this form
 

00:02:22.379 --> 00:02:24.619 align:start position:0%
orders so now let's look at this form
from<00:02:22.500><c> our</c><00:02:22.650><c> users</c><00:02:23.069><c> point</c><00:02:23.250><c> of</c><00:02:23.400><c> view</c><00:02:23.459><c> how</c><00:02:24.420><c> would</c>

00:02:24.619 --> 00:02:24.629 align:start position:0%
from our users point of view how would
 

00:02:24.629 --> 00:02:26.630 align:start position:0%
from our users point of view how would
he<00:02:24.810><c> or</c><00:02:24.870><c> she</c><00:02:25.109><c> want</c><00:02:25.439><c> to</c><00:02:25.590><c> use</c><00:02:25.829><c> it</c><00:02:26.010><c> when</c><00:02:26.159><c> a</c><00:02:26.189><c> customer</c>

00:02:26.630 --> 00:02:26.640 align:start position:0%
he or she want to use it when a customer
 

00:02:26.640 --> 00:02:30.770 align:start position:0%
he or she want to use it when a customer
brings<00:02:26.849><c> a</c><00:02:27.030><c> book</c><00:02:27.299><c> to</c><00:02:27.540><c> purchase</c><00:02:28.019><c> or</c><00:02:28.200><c> order</c><00:02:29.780><c> now</c>

00:02:30.770 --> 00:02:30.780 align:start position:0%
brings a book to purchase or order now
 

00:02:30.780 --> 00:02:32.420 align:start position:0%
brings a book to purchase or order now
you<00:02:30.840><c> see</c><00:02:31.139><c> the</c><00:02:31.230><c> default</c><00:02:31.650><c> view</c><00:02:31.859><c> for</c><00:02:32.069><c> entering</c>

00:02:32.420 --> 00:02:32.430 align:start position:0%
you see the default view for entering
 

00:02:32.430 --> 00:02:35.209 align:start position:0%
you see the default view for entering
new<00:02:32.519><c> orders</c><00:02:33.230><c> let's</c><00:02:34.230><c> quickly</c><00:02:34.530><c> dissect</c><00:02:35.099><c> this</c>

00:02:35.209 --> 00:02:35.219 align:start position:0%
new orders let's quickly dissect this
 

00:02:35.219 --> 00:02:38.869 align:start position:0%
new orders let's quickly dissect this
form<00:02:35.780><c> order</c><00:02:36.780><c> ID</c><00:02:36.989><c> is</c><00:02:37.530><c> just</c><00:02:37.859><c> a</c><00:02:37.950><c> unique</c><00:02:38.310><c> number</c>

00:02:38.869 --> 00:02:38.879 align:start position:0%
form order ID is just a unique number
 

00:02:38.879 --> 00:02:40.910 align:start position:0%
form order ID is just a unique number
that<00:02:38.909><c> the</c><00:02:39.150><c> database</c><00:02:39.599><c> assigns</c><00:02:40.019><c> to</c><00:02:40.260><c> each</c><00:02:40.290><c> order</c>

00:02:40.910 --> 00:02:40.920 align:start position:0%
that the database assigns to each order
 

00:02:40.920 --> 00:02:43.640 align:start position:0%
that the database assigns to each order
this<00:02:41.489><c> isn't</c><00:02:41.969><c> an</c><00:02:42.060><c> editable</c><00:02:42.540><c> field</c><00:02:43.079><c> and</c><00:02:43.439><c> it</c>

00:02:43.640 --> 00:02:43.650 align:start position:0%
this isn't an editable field and it
 

00:02:43.650 --> 00:02:45.710 align:start position:0%
this isn't an editable field and it
isn't<00:02:44.010><c> something</c><00:02:44.280><c> the</c><00:02:44.609><c> user</c><00:02:44.879><c> whatever</c><00:02:45.180><c> needs</c>

00:02:45.710 --> 00:02:45.720 align:start position:0%
isn't something the user whatever needs
 

00:02:45.720 --> 00:02:48.920 align:start position:0%
isn't something the user whatever needs
a<00:02:45.810><c> touch</c><00:02:46.079><c> so</c><00:02:46.439><c> we'll</c><00:02:46.590><c> hide</c><00:02:46.829><c> the</c><00:02:47.040><c> order</c><00:02:47.310><c> ID</c><00:02:47.750><c> to</c><00:02:48.750><c> do</c>

00:02:48.920 --> 00:02:48.930 align:start position:0%
a touch so we'll hide the order ID to do
 

00:02:48.930 --> 00:02:53.599 align:start position:0%
a touch so we'll hide the order ID to do
that<00:02:49.200><c> switch</c><00:02:50.040><c> to</c><00:02:50.069><c> design</c><00:02:50.669><c> view</c><00:02:52.400><c> highlight</c><00:02:53.400><c> the</c>

00:02:53.599 --> 00:02:53.609 align:start position:0%
that switch to design view highlight the
 

00:02:53.609 --> 00:02:57.409 align:start position:0%
that switch to design view highlight the
field<00:02:53.909><c> box</c><00:02:54.299><c> and</c><00:02:54.659><c> its</c><00:02:55.019><c> label</c><00:02:56.120><c> bring</c><00:02:57.120><c> up</c><00:02:57.299><c> the</c>

00:02:57.409 --> 00:02:57.419 align:start position:0%
field box and its label bring up the
 

00:02:57.419 --> 00:02:59.569 align:start position:0%
field box and its label bring up the
property<00:02:57.900><c> sheet</c><00:02:58.169><c> for</c><00:02:58.439><c> these</c><00:02:58.620><c> boxes</c><00:02:59.189><c> if</c><00:02:59.370><c> it's</c>

00:02:59.569 --> 00:02:59.579 align:start position:0%
property sheet for these boxes if it's
 

00:02:59.579 --> 00:03:05.259 align:start position:0%
property sheet for these boxes if it's
not<00:02:59.700><c> already</c><00:02:59.879><c> open</c><00:03:02.750><c> under</c><00:03:03.750><c> the</c><00:03:03.870><c> format</c><00:03:04.319><c> tab</c>

00:03:05.259 --> 00:03:05.269 align:start position:0%
not already open under the format tab
 

00:03:05.269 --> 00:03:09.920 align:start position:0%
not already open under the format tab
select<00:03:06.269><c> snow</c><00:03:06.659><c> beside</c><00:03:07.560><c> visible</c><00:03:08.719><c> now</c><00:03:09.719><c> I'll</c>

00:03:09.920 --> 00:03:09.930 align:start position:0%
select snow beside visible now I'll
 

00:03:09.930 --> 00:03:12.199 align:start position:0%
select snow beside visible now I'll
switch<00:03:10.230><c> back</c><00:03:10.439><c> to</c><00:03:10.469><c> form</c><00:03:10.950><c> view</c><00:03:11.280><c> so</c><00:03:11.639><c> you</c><00:03:11.700><c> can</c><00:03:12.000><c> see</c>

00:03:12.199 --> 00:03:12.209 align:start position:0%
switch back to form view so you can see
 

00:03:12.209 --> 00:03:21.500 align:start position:0%
switch back to form view so you can see
that<00:03:12.389><c> the</c><00:03:12.480><c> order</c><00:03:12.780><c> ID</c><00:03:12.959><c> field</c><00:03:13.409><c> is</c><00:03:13.620><c> hidden</c><00:03:20.510><c> next</c>

00:03:21.500 --> 00:03:21.510 align:start position:0%
that the order ID field is hidden next
 

00:03:21.510 --> 00:03:24.110 align:start position:0%
that the order ID field is hidden next
we<00:03:21.659><c> see</c><00:03:21.900><c> customer</c><00:03:22.440><c> ID</c><00:03:22.650><c> and</c><00:03:23.099><c> book</c><00:03:23.280><c> ID</c><00:03:23.489><c> they</c>

00:03:24.110 --> 00:03:24.120 align:start position:0%
we see customer ID and book ID they
 

00:03:24.120 --> 00:03:26.059 align:start position:0%
we see customer ID and book ID they
obviously<00:03:24.359><c> aren't</c><00:03:24.989><c> very</c><00:03:25.229><c> usable</c><00:03:25.769><c> like</c><00:03:25.919><c> they</c>

00:03:26.059 --> 00:03:26.069 align:start position:0%
obviously aren't very usable like they
 

00:03:26.069 --> 00:03:27.830 align:start position:0%
obviously aren't very usable like they
are<00:03:26.250><c> now</c><00:03:26.519><c> but</c><00:03:26.970><c> we'll</c><00:03:27.150><c> come</c><00:03:27.329><c> back</c><00:03:27.359><c> to</c><00:03:27.540><c> those</c><00:03:27.780><c> in</c>

00:03:27.830 --> 00:03:27.840 align:start position:0%
are now but we'll come back to those in
 

00:03:27.840 --> 00:03:30.110 align:start position:0%
are now but we'll come back to those in
a<00:03:28.079><c> minute</c><00:03:28.409><c> let's</c><00:03:29.010><c> consider</c><00:03:29.400><c> the</c><00:03:29.579><c> order</c><00:03:29.909><c> date</c>

00:03:30.110 --> 00:03:30.120 align:start position:0%
a minute let's consider the order date
 

00:03:30.120 --> 00:03:33.110 align:start position:0%
a minute let's consider the order date
field<00:03:30.479><c> as</c><00:03:30.840><c> a</c><00:03:31.439><c> database</c><00:03:31.919><c> owner</c><00:03:32.310><c> we</c><00:03:32.729><c> want</c><00:03:33.000><c> the</c>

00:03:33.110 --> 00:03:33.120 align:start position:0%
field as a database owner we want the
 

00:03:33.120 --> 00:03:35.119 align:start position:0%
field as a database owner we want the
date<00:03:33.419><c> to</c><00:03:33.449><c> default</c><00:03:34.109><c> to</c><00:03:34.319><c> the</c><00:03:34.409><c> current</c><00:03:34.439><c> date</c>

00:03:35.119 --> 00:03:35.129 align:start position:0%
date to default to the current date
 

00:03:35.129 --> 00:03:37.099 align:start position:0%
date to default to the current date
since<00:03:35.549><c> no</c><00:03:35.760><c> customer</c><00:03:36.269><c> will</c><00:03:36.419><c> place</c><00:03:36.629><c> an</c><00:03:36.810><c> order</c>

00:03:37.099 --> 00:03:37.109 align:start position:0%
since no customer will place an order
 

00:03:37.109 --> 00:03:39.979 align:start position:0%
since no customer will place an order
for<00:03:37.139><c> any</c><00:03:37.530><c> other</c><00:03:37.889><c> day</c><00:03:38.280><c> than</c><00:03:38.579><c> today</c><00:03:38.760><c> and</c><00:03:39.329><c> we</c><00:03:39.870><c> will</c>

00:03:39.979 --> 00:03:39.989 align:start position:0%
for any other day than today and we will
 

00:03:39.989 --> 00:03:42.140 align:start position:0%
for any other day than today and we will
want<00:03:40.199><c> the</c><00:03:40.349><c> information</c><00:03:40.620><c> in</c><00:03:41.010><c> our</c><00:03:41.099><c> table</c><00:03:41.519><c> but</c>

00:03:42.140 --> 00:03:42.150 align:start position:0%
want the information in our table but
 

00:03:42.150 --> 00:03:43.610 align:start position:0%
want the information in our table but
the<00:03:42.269><c> person</c><00:03:42.689><c> entering</c><00:03:43.079><c> the</c><00:03:43.139><c> new</c><00:03:43.290><c> order</c>

00:03:43.610 --> 00:03:43.620 align:start position:0%
the person entering the new order
 

00:03:43.620 --> 00:03:46.309 align:start position:0%
the person entering the new order
wouldn't<00:03:44.159><c> need</c><00:03:44.310><c> to</c><00:03:44.340><c> enter</c><00:03:44.759><c> that</c><00:03:44.959><c> so</c><00:03:45.959><c> to</c><00:03:46.019><c> set</c>

00:03:46.309 --> 00:03:46.319 align:start position:0%
wouldn't need to enter that so to set
 

00:03:46.319 --> 00:03:51.469 align:start position:0%
wouldn't need to enter that so to set
that<00:03:46.560><c> up</c><00:03:46.620><c> go</c><00:03:47.549><c> to</c><00:03:47.609><c> design</c><00:03:48.359><c> view</c><00:03:49.970><c> highlights</c><00:03:50.970><c> the</c>

00:03:51.469 --> 00:03:51.479 align:start position:0%
that up go to design view highlights the
 

00:03:51.479 --> 00:03:54.770 align:start position:0%
that up go to design view highlights the
field<00:03:51.750><c> box</c><00:03:52.109><c> and</c><00:03:53.269><c> bring</c><00:03:54.269><c> up</c><00:03:54.419><c> its</c><00:03:54.569><c> properties</c>

00:03:54.770 --> 00:03:54.780 align:start position:0%
field box and bring up its properties
 

00:03:54.780 --> 00:03:57.979 align:start position:0%
field box and bring up its properties
sheet<00:03:55.290><c> if</c><00:03:55.530><c> it's</c><00:03:55.680><c> not</c><00:03:55.829><c> already</c><00:03:56.009><c> open</c><00:03:56.720><c> we</c><00:03:57.720><c> want</c>

00:03:57.979 --> 00:03:57.989 align:start position:0%
sheet if it's not already open we want
 

00:03:57.989 --> 00:03:59.300 align:start position:0%
sheet if it's not already open we want
to<00:03:58.139><c> double</c><00:03:58.349><c> check</c><00:03:58.739><c> and</c><00:03:58.919><c> make</c><00:03:58.979><c> sure</c><00:03:59.099><c> the</c>

00:03:59.300 --> 00:03:59.310 align:start position:0%
to double check and make sure the
 

00:03:59.310 --> 00:04:02.899 align:start position:0%
to double check and make sure the
drop-down<00:03:59.970><c> is</c><00:04:00.299><c> set</c><00:04:00.569><c> to</c><00:04:00.720><c> order</c><00:04:00.900><c> dates</c><00:04:01.759><c> from</c><00:04:02.759><c> the</c>

00:04:02.899 --> 00:04:02.909 align:start position:0%
drop-down is set to order dates from the
 

00:04:02.909 --> 00:04:04.759 align:start position:0%
drop-down is set to order dates from the
data<00:04:03.150><c> tab</c><00:04:03.449><c> we</c><00:04:03.900><c> want</c><00:04:04.079><c> to</c><00:04:04.259><c> make</c><00:04:04.439><c> sure</c><00:04:04.590><c> the</c>

00:04:04.759 --> 00:04:04.769 align:start position:0%
data tab we want to make sure the
 

00:04:04.769 --> 00:04:07.039 align:start position:0%
data tab we want to make sure the
default<00:04:05.159><c> value</c><00:04:05.549><c> is</c><00:04:05.579><c> set</c><00:04:05.939><c> up</c><00:04:06.060><c> to</c><00:04:06.209><c> always</c><00:04:06.689><c> enter</c>

00:04:07.039 --> 00:04:07.049 align:start position:0%
default value is set up to always enter
 

00:04:07.049 --> 00:04:09.619 align:start position:0%
default value is set up to always enter
the<00:04:07.139><c> current</c><00:04:07.500><c> date</c><00:04:08.239><c> we'll</c><00:04:09.239><c> use</c><00:04:09.269><c> the</c>

00:04:09.619 --> 00:04:09.629 align:start position:0%
the current date we'll use the
 

00:04:09.629 --> 00:04:10.999 align:start position:0%
the current date we'll use the
expression<00:04:10.139><c> builder</c><00:04:10.319><c> to</c><00:04:10.650><c> enter</c><00:04:10.889><c> this</c>

00:04:10.999 --> 00:04:11.009 align:start position:0%
expression builder to enter this
 

00:04:11.009 --> 00:04:13.460 align:start position:0%
expression builder to enter this
function<00:04:11.549><c> the</c><00:04:12.419><c> function</c><00:04:12.870><c> starts</c><00:04:13.079><c> with</c><00:04:13.349><c> an</c>

00:04:13.460 --> 00:04:13.470 align:start position:0%
function the function starts with an
 

00:04:13.470 --> 00:04:16.339 align:start position:0%
function the function starts with an
equal<00:04:13.799><c> sign</c><00:04:14.009><c> so</c><00:04:14.400><c> I'll</c><00:04:14.639><c> go</c><00:04:14.849><c> ahead</c><00:04:15.000><c> and</c><00:04:15.659><c> click</c>

00:04:16.339 --> 00:04:16.349 align:start position:0%
equal sign so I'll go ahead and click
 

00:04:16.349 --> 00:04:21.229 align:start position:0%
equal sign so I'll go ahead and click
equals<00:04:19.070><c> next</c><00:04:20.070><c> we</c><00:04:20.190><c> need</c><00:04:20.310><c> to</c><00:04:20.489><c> click</c><00:04:20.729><c> the</c><00:04:20.849><c> common</c>

00:04:21.229 --> 00:04:21.239 align:start position:0%
equals next we need to click the common
 

00:04:21.239 --> 00:04:23.120 align:start position:0%
equals next we need to click the common
expressions<00:04:21.779><c> folder</c><00:04:22.260><c> in</c><00:04:22.440><c> the</c><00:04:22.529><c> first</c><00:04:22.770><c> column</c>

00:04:23.120 --> 00:04:23.130 align:start position:0%
expressions folder in the first column
 

00:04:23.130 --> 00:04:26.839 align:start position:0%
expressions folder in the first column
in<00:04:24.440><c> the</c><00:04:25.440><c> center</c><00:04:25.830><c> column</c><00:04:26.070><c> we'll</c><00:04:26.580><c> click</c><00:04:26.820><c> on</c>

00:04:26.839 --> 00:04:26.849 align:start position:0%
in the center column we'll click on
 

00:04:26.849 --> 00:04:27.620 align:start position:0%
in the center column we'll click on
current

00:04:27.620 --> 00:04:27.630 align:start position:0%
current
 

00:04:27.630 --> 00:04:33.320 align:start position:0%
current
eight<00:04:29.390><c> in</c><00:04:30.710><c> the</c><00:04:31.710><c> third</c><00:04:31.740><c> column</c><00:04:32.250><c> will</c><00:04:33.000><c> click</c><00:04:33.180><c> on</c>

00:04:33.320 --> 00:04:33.330 align:start position:0%
eight in the third column will click on
 

00:04:33.330 --> 00:04:37.070 align:start position:0%
eight in the third column will click on
date<00:04:34.460><c> all</c><00:04:35.460><c> this</c><00:04:35.730><c> equation</c><00:04:36.270><c> really</c><00:04:36.480><c> means</c><00:04:36.870><c> is</c>

00:04:37.070 --> 00:04:37.080 align:start position:0%
date all this equation really means is
 

00:04:37.080 --> 00:04:38.750 align:start position:0%
date all this equation really means is
that<00:04:37.110><c> we</c><00:04:37.230><c> want</c><00:04:37.560><c> this</c><00:04:37.740><c> field</c><00:04:38.100><c> to</c><00:04:38.340><c> always</c>

00:04:38.750 --> 00:04:38.760 align:start position:0%
that we want this field to always
 

00:04:38.760 --> 00:04:40.640 align:start position:0%
that we want this field to always
automatically<00:04:39.420><c> enter</c><00:04:39.840><c> the</c><00:04:39.960><c> current</c><00:04:40.320><c> order</c>

00:04:40.640 --> 00:04:40.650 align:start position:0%
automatically enter the current order
 

00:04:40.650 --> 00:04:43.940 align:start position:0%
automatically enter the current order
date<00:04:41.360><c> we're</c><00:04:42.360><c> finished</c><00:04:42.750><c> with</c><00:04:42.870><c> the</c><00:04:42.990><c> data</c><00:04:43.230><c> tab</c><00:04:43.560><c> so</c>

00:04:43.940 --> 00:04:43.950 align:start position:0%
date we're finished with the data tab so
 

00:04:43.950 --> 00:04:46.040 align:start position:0%
date we're finished with the data tab so
let's<00:04:44.250><c> go</c><00:04:44.460><c> to</c><00:04:44.520><c> the</c><00:04:44.700><c> format</c><00:04:45.120><c> tab</c><00:04:45.300><c> to</c><00:04:45.570><c> hide</c><00:04:45.780><c> this</c>

00:04:46.040 --> 00:04:46.050 align:start position:0%
let's go to the format tab to hide this
 

00:04:46.050 --> 00:04:47.990 align:start position:0%
let's go to the format tab to hide this
field<00:04:46.320><c> too</c><00:04:46.590><c> since</c><00:04:47.250><c> we</c><00:04:47.400><c> were</c><00:04:47.490><c> automatically</c>

00:04:47.990 --> 00:04:48.000 align:start position:0%
field too since we were automatically
 

00:04:48.000 --> 00:04:55.340 align:start position:0%
field too since we were automatically
putting<00:04:48.300><c> today's</c><00:04:48.630><c> date</c><00:04:48.930><c> in</c><00:04:54.110><c> let's</c><00:04:55.110><c> take</c><00:04:55.290><c> a</c>

00:04:55.340 --> 00:04:55.350 align:start position:0%
putting today's date in let's take a
 

00:04:55.350 --> 00:04:58.280 align:start position:0%
putting today's date in let's take a
look<00:04:55.650><c> at</c><00:04:55.740><c> the</c><00:04:55.830><c> form</c><00:04:56.190><c> in</c><00:04:56.460><c> form</c><00:04:56.790><c> view</c><00:04:57.080><c> now</c><00:04:58.080><c> our</c>

00:04:58.280 --> 00:04:58.290 align:start position:0%
look at the form in form view now our
 

00:04:58.290 --> 00:04:59.810 align:start position:0%
look at the form in form view now our
form<00:04:58.710><c> user</c><00:04:58.950><c> just</c><00:04:59.250><c> has</c><00:04:59.430><c> to</c><00:04:59.550><c> worry</c><00:04:59.760><c> about</c>

00:04:59.810 --> 00:04:59.820 align:start position:0%
form user just has to worry about
 

00:04:59.820 --> 00:05:01.790 align:start position:0%
form user just has to worry about
getting<00:05:00.270><c> the</c><00:05:00.360><c> right</c><00:05:00.390><c> customer</c><00:05:01.050><c> ID</c><00:05:01.260><c> in</c><00:05:01.710><c> the</c>

00:05:01.790 --> 00:05:01.800 align:start position:0%
getting the right customer ID in the
 

00:05:01.800 --> 00:05:04.220 align:start position:0%
getting the right customer ID in the
right<00:05:01.950><c> book</c><00:05:02.190><c> ID</c><00:05:02.430><c> but</c><00:05:03.120><c> the</c><00:05:03.150><c> ID</c><00:05:03.600><c> numbers</c><00:05:03.960><c> don't</c>

00:05:04.220 --> 00:05:04.230 align:start position:0%
right book ID but the ID numbers don't
 

00:05:04.230 --> 00:05:06.410 align:start position:0%
right book ID but the ID numbers don't
help<00:05:04.560><c> them</c><00:05:04.710><c> very</c><00:05:04.950><c> much</c><00:05:05.190><c> as</c><00:05:05.340><c> they</c><00:05:05.460><c> are</c><00:05:05.730><c> since</c>

00:05:06.410 --> 00:05:06.420 align:start position:0%
help them very much as they are since
 

00:05:06.420 --> 00:05:08.090 align:start position:0%
help them very much as they are since
they'll<00:05:06.600><c> be</c><00:05:06.660><c> dealing</c><00:05:07.050><c> with</c><00:05:07.080><c> a</c><00:05:07.200><c> real</c><00:05:07.500><c> person</c>

00:05:08.090 --> 00:05:08.100 align:start position:0%
they'll be dealing with a real person
 

00:05:08.100 --> 00:05:10.460 align:start position:0%
they'll be dealing with a real person
with<00:05:08.460><c> a</c><00:05:08.520><c> real</c><00:05:08.640><c> book</c><00:05:09.180><c> and</c><00:05:09.540><c> not</c><00:05:09.690><c> a</c><00:05:09.750><c> customer</c><00:05:10.290><c> ID</c>

00:05:10.460 --> 00:05:10.470 align:start position:0%
with a real book and not a customer ID
 

00:05:10.470 --> 00:05:13.280 align:start position:0%
with a real book and not a customer ID
with<00:05:10.770><c> a</c><00:05:10.800><c> book</c><00:05:11.070><c> ID</c><00:05:11.330><c> to</c><00:05:12.330><c> make</c><00:05:12.510><c> sure</c><00:05:12.780><c> our</c><00:05:12.810><c> user</c>

00:05:13.280 --> 00:05:13.290 align:start position:0%
with a book ID to make sure our user
 

00:05:13.290 --> 00:05:15.590 align:start position:0%
with a book ID to make sure our user
enters<00:05:13.680><c> the</c><00:05:13.800><c> correct</c><00:05:14.160><c> customer</c><00:05:14.460><c> we</c><00:05:15.210><c> will</c><00:05:15.240><c> want</c>

00:05:15.590 --> 00:05:15.600 align:start position:0%
enters the correct customer we will want
 

00:05:15.600 --> 00:05:17.780 align:start position:0%
enters the correct customer we will want
him<00:05:15.870><c> to</c><00:05:15.990><c> choose</c><00:05:16.260><c> from</c><00:05:16.530><c> our</c><00:05:16.680><c> list</c><00:05:17.070><c> of</c><00:05:17.250><c> customers</c>

00:05:17.780 --> 00:05:17.790 align:start position:0%
him to choose from our list of customers
 

00:05:17.790 --> 00:05:20.300 align:start position:0%
him to choose from our list of customers
but<00:05:18.750><c> we</c><00:05:18.870><c> want</c><00:05:19.110><c> the</c><00:05:19.230><c> database</c><00:05:19.440><c> to</c><00:05:19.830><c> store</c><00:05:20.130><c> the</c>

00:05:20.300 --> 00:05:20.310 align:start position:0%
but we want the database to store the
 

00:05:20.310 --> 00:05:22.430 align:start position:0%
but we want the database to store the
customer<00:05:20.460><c> ID</c><00:05:20.880><c> number</c><00:05:21.540><c> and</c><00:05:21.780><c> not</c><00:05:22.050><c> the</c><00:05:22.230><c> name</c>

00:05:22.430 --> 00:05:22.440 align:start position:0%
customer ID number and not the name
 

00:05:22.440 --> 00:05:25.190 align:start position:0%
customer ID number and not the name
since<00:05:23.220><c> that</c><00:05:23.430><c> is</c><00:05:23.580><c> a</c><00:05:23.610><c> unique</c><00:05:24.060><c> identifier</c><00:05:24.780><c> for</c><00:05:24.810><c> a</c>

00:05:25.190 --> 00:05:25.200 align:start position:0%
since that is a unique identifier for a
 

00:05:25.200 --> 00:05:28.490 align:start position:0%
since that is a unique identifier for a
customer<00:05:26.240><c> well</c><00:05:27.240><c> with</c><00:05:27.390><c> the</c><00:05:27.480><c> combo</c><00:05:27.840><c> box</c><00:05:27.870><c> control</c>

00:05:28.490 --> 00:05:28.500 align:start position:0%
customer well with the combo box control
 

00:05:28.500 --> 00:05:30.860 align:start position:0%
customer well with the combo box control
we<00:05:29.130><c> can</c><00:05:29.310><c> put</c><00:05:29.490><c> all</c><00:05:29.670><c> the</c><00:05:29.820><c> information</c><00:05:29.970><c> our</c><00:05:30.570><c> user</c>

00:05:30.860 --> 00:05:30.870 align:start position:0%
we can put all the information our user
 

00:05:30.870 --> 00:05:33.190 align:start position:0%
we can put all the information our user
needs<00:05:31.260><c> right</c><00:05:31.770><c> on</c><00:05:31.950><c> the</c><00:05:32.070><c> new</c><00:05:32.250><c> order</c><00:05:32.550><c> form</c><00:05:32.820><c> itself</c>

00:05:33.190 --> 00:05:33.200 align:start position:0%
needs right on the new order form itself
 

00:05:33.200 --> 00:05:35.750 align:start position:0%
needs right on the new order form itself
this<00:05:34.200><c> box</c><00:05:34.530><c> will</c><00:05:34.800><c> let</c><00:05:34.830><c> them</c><00:05:35.220><c> choose</c><00:05:35.520><c> the</c>

00:05:35.750 --> 00:05:35.760 align:start position:0%
this box will let them choose the
 

00:05:35.760 --> 00:05:37.820 align:start position:0%
this box will let them choose the
customer<00:05:36.210><c> based</c><00:05:36.570><c> on</c><00:05:36.780><c> a</c><00:05:36.810><c> list</c><00:05:37.170><c> of</c><00:05:37.320><c> the</c><00:05:37.410><c> customer</c>

00:05:37.820 --> 00:05:37.830 align:start position:0%
customer based on a list of the customer
 

00:05:37.830 --> 00:05:40.340 align:start position:0%
customer based on a list of the customer
names<00:05:38.130><c> that</c><00:05:38.730><c> appear</c><00:05:39.120><c> in</c><00:05:39.150><c> our</c><00:05:39.330><c> customers</c><00:05:39.870><c> table</c>

00:05:40.340 --> 00:05:40.350 align:start position:0%
names that appear in our customers table
 

00:05:40.350 --> 00:05:43.730 align:start position:0%
names that appear in our customers table
and<00:05:41.060><c> we</c><00:05:42.060><c> can</c><00:05:42.180><c> set</c><00:05:42.420><c> the</c><00:05:42.540><c> form</c><00:05:42.870><c> controls</c><00:05:43.230><c> up</c><00:05:43.440><c> so</c>

00:05:43.730 --> 00:05:43.740 align:start position:0%
and we can set the form controls up so
 

00:05:43.740 --> 00:05:45.620 align:start position:0%
and we can set the form controls up so
that<00:05:43.890><c> once</c><00:05:44.160><c> our</c><00:05:44.370><c> user</c><00:05:44.640><c> picks</c><00:05:44.940><c> a</c><00:05:45.060><c> customer</c><00:05:45.510><c> from</c>

00:05:45.620 --> 00:05:45.630 align:start position:0%
that once our user picks a customer from
 

00:05:45.630 --> 00:05:48.230 align:start position:0%
that once our user picks a customer from
the<00:05:45.690><c> list</c><00:05:46.020><c> the</c><00:05:46.620><c> customer</c><00:05:47.100><c> ID</c><00:05:47.250><c> is</c><00:05:47.640><c> stored</c><00:05:47.970><c> in</c>

00:05:48.230 --> 00:05:48.240 align:start position:0%
the list the customer ID is stored in
 

00:05:48.240 --> 00:05:52.220 align:start position:0%
the list the customer ID is stored in
the<00:05:48.330><c> orders</c><00:05:48.600><c> table</c><00:05:48.950><c> let's</c><00:05:49.950><c> do</c><00:05:50.160><c> this</c><00:05:50.310><c> now</c><00:05:51.230><c> since</c>

00:05:52.220 --> 00:05:52.230 align:start position:0%
the orders table let's do this now since
 

00:05:52.230 --> 00:05:54.140 align:start position:0%
the orders table let's do this now since
we're<00:05:52.410><c> using</c><00:05:52.440><c> a</c><00:05:52.800><c> combo</c><00:05:53.160><c> box</c><00:05:53.370><c> I</c><00:05:53.670><c> really</c><00:05:53.970><c> don't</c>

00:05:54.140 --> 00:05:54.150 align:start position:0%
we're using a combo box I really don't
 

00:05:54.150 --> 00:05:56.450 align:start position:0%
we're using a combo box I really don't
need<00:05:54.360><c> this</c><00:05:54.570><c> text</c><00:05:54.930><c> box</c><00:05:55.080><c> or</c><00:05:55.380><c> label</c><00:05:55.770><c> anymore</c><00:05:56.010><c> so</c>

00:05:56.450 --> 00:05:56.460 align:start position:0%
need this text box or label anymore so
 

00:05:56.460 --> 00:05:59.150 align:start position:0%
need this text box or label anymore so
I'll<00:05:56.730><c> delete</c><00:05:57.120><c> it</c><00:05:57.590><c> next</c><00:05:58.590><c> we'll</c><00:05:58.740><c> click</c><00:05:58.920><c> on</c><00:05:59.070><c> the</c>

00:05:59.150 --> 00:05:59.160 align:start position:0%
I'll delete it next we'll click on the
 

00:05:59.160 --> 00:06:02.380 align:start position:0%
I'll delete it next we'll click on the
combo<00:05:59.490><c> box</c><00:05:59.520><c> command</c><00:06:00.150><c> in</c><00:06:00.450><c> the</c><00:06:00.540><c> controls</c><00:06:00.900><c> group</c>

00:06:02.380 --> 00:06:02.390 align:start position:0%
combo box command in the controls group
 

00:06:02.390 --> 00:06:05.780 align:start position:0%
combo box command in the controls group
then<00:06:03.390><c> we'll</c><00:06:03.540><c> move</c><00:06:03.690><c> our</c><00:06:03.840><c> cursor</c><00:06:04.110><c> over</c><00:06:04.530><c> our</c><00:06:05.070><c> form</c>

00:06:05.780 --> 00:06:05.790 align:start position:0%
then we'll move our cursor over our form
 

00:06:05.790 --> 00:06:09.380 align:start position:0%
then we'll move our cursor over our form
until<00:06:06.510><c> we</c><00:06:06.630><c> see</c><00:06:06.780><c> a</c><00:06:06.810><c> crosshair</c><00:06:07.530><c> with</c><00:06:07.830><c> a</c><00:06:08.390><c> combo</c>

00:06:09.380 --> 00:06:09.390 align:start position:0%
until we see a crosshair with a combo
 

00:06:09.390 --> 00:06:13.490 align:start position:0%
until we see a crosshair with a combo
box<00:06:09.540><c> icon</c><00:06:11.540><c> now</c><00:06:12.540><c> we're</c><00:06:12.780><c> going</c><00:06:13.050><c> to</c><00:06:13.170><c> draw</c><00:06:13.440><c> the</c>

00:06:13.490 --> 00:06:13.500 align:start position:0%
box icon now we're going to draw the
 

00:06:13.500 --> 00:06:17.510 align:start position:0%
box icon now we're going to draw the
combo<00:06:14.040><c> box</c><00:06:15.410><c> from</c><00:06:16.410><c> the</c><00:06:16.530><c> wizard</c><00:06:16.950><c> we'll</c><00:06:17.280><c> choose</c>

00:06:17.510 --> 00:06:17.520 align:start position:0%
combo box from the wizard we'll choose
 

00:06:17.520 --> 00:06:19.730 align:start position:0%
combo box from the wizard we'll choose
the<00:06:17.700><c> first</c><00:06:17.940><c> option</c><00:06:18.210><c> by</c><00:06:18.840><c> choosing</c><00:06:19.200><c> this</c><00:06:19.500><c> option</c>

00:06:19.730 --> 00:06:19.740 align:start position:0%
the first option by choosing this option
 

00:06:19.740 --> 00:06:21.920 align:start position:0%
the first option by choosing this option
we're<00:06:20.160><c> telling</c><00:06:20.520><c> access</c><00:06:20.940><c> to</c><00:06:21.060><c> find</c><00:06:21.300><c> what</c><00:06:21.750><c> we</c>

00:06:21.920 --> 00:06:21.930 align:start position:0%
we're telling access to find what we
 

00:06:21.930 --> 00:06:26.200 align:start position:0%
we're telling access to find what we
want<00:06:22.200><c> the</c><00:06:22.320><c> user</c><00:06:22.350><c> to</c><00:06:22.680><c> see</c><00:06:23.070><c> in</c><00:06:23.310><c> the</c><00:06:23.880><c> combo</c><00:06:24.210><c> box</c>

00:06:26.200 --> 00:06:26.210 align:start position:0%
want the user to see in the combo box
 

00:06:26.210 --> 00:06:28.880 align:start position:0%
want the user to see in the combo box
now<00:06:27.210><c> we</c><00:06:27.270><c> needed</c><00:06:27.660><c> to</c><00:06:27.900><c> look</c><00:06:28.140><c> in</c><00:06:28.320><c> the</c><00:06:28.440><c> customers</c>

00:06:28.880 --> 00:06:28.890 align:start position:0%
now we needed to look in the customers
 

00:06:28.890 --> 00:06:34.820 align:start position:0%
now we needed to look in the customers
table<00:06:30.560><c> and</c><00:06:32.240><c> we</c><00:06:33.240><c> need</c><00:06:33.480><c> all</c><00:06:33.690><c> the</c><00:06:33.930><c> fields</c><00:06:34.500><c> so</c><00:06:34.650><c> that</c>

00:06:34.820 --> 00:06:34.830 align:start position:0%
table and we need all the fields so that
 

00:06:34.830 --> 00:06:37.070 align:start position:0%
table and we need all the fields so that
our<00:06:35.010><c> form</c><00:06:35.400><c> user</c><00:06:35.640><c> can</c><00:06:35.910><c> see</c><00:06:36.030><c> a</c><00:06:36.060><c> complete</c><00:06:36.419><c> record</c>

00:06:37.070 --> 00:06:37.080 align:start position:0%
our form user can see a complete record
 

00:06:37.080 --> 00:06:39.469 align:start position:0%
our form user can see a complete record
in<00:06:37.290><c> order</c><00:06:37.680><c> to</c><00:06:37.860><c> figure</c><00:06:38.100><c> out</c><00:06:38.400><c> which</c><00:06:38.729><c> customer</c><00:06:39.300><c> he</c>

00:06:39.469 --> 00:06:39.479 align:start position:0%
in order to figure out which customer he
 

00:06:39.479 --> 00:06:41.480 align:start position:0%
in order to figure out which customer he
needs<00:06:39.690><c> to</c><00:06:39.810><c> enter</c>

00:06:41.480 --> 00:06:41.490 align:start position:0%
needs to enter
 

00:06:41.490 --> 00:06:43.430 align:start position:0%
needs to enter
we<00:06:41.789><c> wanted</c><00:06:42.180><c> to</c><00:06:42.300><c> sort</c><00:06:42.569><c> alphabetically</c><00:06:43.229><c> by</c><00:06:43.410><c> last</c>

00:06:43.430 --> 00:06:43.440 align:start position:0%
we wanted to sort alphabetically by last
 

00:06:43.440 --> 00:06:45.980 align:start position:0%
we wanted to sort alphabetically by last
name<00:06:44.039><c> since</c><00:06:44.610><c> that</c><00:06:44.819><c> is</c><00:06:44.940><c> a</c><00:06:44.970><c> logical</c><00:06:45.270><c> way</c><00:06:45.690><c> for</c><00:06:45.870><c> our</c>

00:06:45.980 --> 00:06:45.990 align:start position:0%
name since that is a logical way for our
 

00:06:45.990 --> 00:06:50.809 align:start position:0%
name since that is a logical way for our
users<00:06:46.380><c> to</c><00:06:46.470><c> look</c><00:06:46.620><c> up</c><00:06:46.740><c> a</c><00:06:46.830><c> customer</c><00:06:49.460><c> here</c><00:06:50.460><c> we</c><00:06:50.669><c> can</c>

00:06:50.809 --> 00:06:50.819 align:start position:0%
users to look up a customer here we can
 

00:06:50.819 --> 00:06:52.999 align:start position:0%
users to look up a customer here we can
set<00:06:51.060><c> the</c><00:06:51.180><c> column</c><00:06:51.509><c> width</c><00:06:51.810><c> so</c><00:06:52.560><c> that</c><00:06:52.710><c> it</c><00:06:52.800><c> all</c>

00:06:52.999 --> 00:06:53.009 align:start position:0%
set the column width so that it all
 

00:06:53.009 --> 00:06:55.839 align:start position:0%
set the column width so that it all
looks<00:06:53.340><c> nicely</c><00:06:53.669><c> compact</c><00:06:54.360><c> on</c><00:06:54.539><c> our</c><00:06:54.630><c> form</c>

00:06:55.839 --> 00:06:55.849 align:start position:0%
looks nicely compact on our form
 

00:06:55.849 --> 00:06:58.820 align:start position:0%
looks nicely compact on our form
double-click<00:06:56.849><c> the</c><00:06:57.150><c> column</c><00:06:57.599><c> edges</c><00:06:58.080><c> to</c><00:06:58.500><c> get</c><00:06:58.710><c> it</c>

00:06:58.820 --> 00:06:58.830 align:start position:0%
double-click the column edges to get it
 

00:06:58.830 --> 00:07:06.890 align:start position:0%
double-click the column edges to get it
to<00:06:58.979><c> best</c><00:06:59.160><c> fit</c><00:07:04.789><c> we</c><00:07:05.789><c> also</c><00:07:06.030><c> have</c><00:07:06.419><c> to</c><00:07:06.569><c> move</c><00:07:06.750><c> the</c>

00:07:06.890 --> 00:07:06.900 align:start position:0%
to best fit we also have to move the
 

00:07:06.900 --> 00:07:10.219 align:start position:0%
to best fit we also have to move the
last<00:07:07.169><c> name</c><00:07:07.560><c> column</c><00:07:07.949><c> over</c><00:07:08.699><c> to</c><00:07:09.120><c> the</c><00:07:09.240><c> left</c><00:07:09.569><c> so</c>

00:07:10.219 --> 00:07:10.229 align:start position:0%
last name column over to the left so
 

00:07:10.229 --> 00:07:12.110 align:start position:0%
last name column over to the left so
that<00:07:10.259><c> we</c><00:07:10.470><c> see</c><00:07:10.620><c> the</c><00:07:10.650><c> last</c><00:07:11.039><c> name</c><00:07:11.400><c> listed</c><00:07:11.849><c> first</c>

00:07:12.110 --> 00:07:12.120 align:start position:0%
that we see the last name listed first
 

00:07:12.120 --> 00:07:15.800 align:start position:0%
that we see the last name listed first
in<00:07:12.449><c> the</c><00:07:12.569><c> drop-down</c><00:07:12.990><c> list</c><00:07:14.360><c> next</c><00:07:15.360><c> we</c><00:07:15.509><c> want</c><00:07:15.690><c> to</c>

00:07:15.800 --> 00:07:15.810 align:start position:0%
in the drop-down list next we want to
 

00:07:15.810 --> 00:07:18.320 align:start position:0%
in the drop-down list next we want to
tell<00:07:16.020><c> access</c><00:07:16.590><c> to</c><00:07:16.770><c> store</c><00:07:17.070><c> the</c><00:07:17.280><c> data</c><00:07:17.310><c> so</c><00:07:18.180><c> we'll</c>

00:07:18.320 --> 00:07:18.330 align:start position:0%
tell access to store the data so we'll
 

00:07:18.330 --> 00:07:21.230 align:start position:0%
tell access to store the data so we'll
select<00:07:18.539><c> the</c><00:07:18.840><c> second</c><00:07:19.320><c> option</c><00:07:19.550><c> this</c><00:07:20.550><c> option</c><00:07:21.090><c> is</c>

00:07:21.230 --> 00:07:21.240 align:start position:0%
select the second option this option is
 

00:07:21.240 --> 00:07:23.240 align:start position:0%
select the second option this option is
asking<00:07:21.690><c> which</c><00:07:21.900><c> value</c><00:07:22.410><c> from</c><00:07:22.590><c> the</c><00:07:22.680><c> orders</c><00:07:23.009><c> table</c>

00:07:23.240 --> 00:07:23.250 align:start position:0%
asking which value from the orders table
 

00:07:23.250 --> 00:07:26.240 align:start position:0%
asking which value from the orders table
we<00:07:23.910><c> want</c><00:07:24.060><c> store</c><00:07:24.479><c> it</c><00:07:24.630><c> in</c><00:07:24.750><c> orders</c><00:07:25.080><c> table</c><00:07:25.289><c> and</c><00:07:25.710><c> we</c>

00:07:26.240 --> 00:07:26.250 align:start position:0%
we want store it in orders table and we
 

00:07:26.250 --> 00:07:29.170 align:start position:0%
we want store it in orders table and we
want<00:07:26.460><c> to</c><00:07:26.669><c> store</c><00:07:26.910><c> our</c><00:07:26.940><c> customers</c><00:07:27.599><c> ID</c><00:07:27.810><c> number</c><00:07:28.440><c> so</c>

00:07:29.170 --> 00:07:29.180 align:start position:0%
want to store our customers ID number so
 

00:07:29.180 --> 00:07:34.100 align:start position:0%
want to store our customers ID number so
selects<00:07:30.180><c> customer</c><00:07:30.599><c> ID</c><00:07:30.780><c> from</c><00:07:31.259><c> this</c><00:07:31.410><c> list</c><00:07:33.110><c> this</c>

00:07:34.100 --> 00:07:34.110 align:start position:0%
selects customer ID from this list this
 

00:07:34.110 --> 00:07:36.620 align:start position:0%
selects customer ID from this list this
is<00:07:34.320><c> the</c><00:07:34.440><c> label</c><00:07:34.860><c> for</c><00:07:35.009><c> the</c><00:07:35.070><c> combo</c><00:07:35.430><c> box</c><00:07:35.460><c> will</c><00:07:36.360><c> type</c>

00:07:36.620 --> 00:07:36.630 align:start position:0%
is the label for the combo box will type
 

00:07:36.630 --> 00:07:40.460 align:start position:0%
is the label for the combo box will type
in<00:07:36.870><c> customer</c><00:07:37.530><c> here</c><00:07:39.080><c> well</c><00:07:40.080><c> it</c><00:07:40.199><c> looks</c><00:07:40.380><c> like</c>

00:07:40.460 --> 00:07:40.470 align:start position:0%
in customer here well it looks like
 

00:07:40.470 --> 00:07:42.469 align:start position:0%
in customer here well it looks like
we're<00:07:40.680><c> finished</c><00:07:40.860><c> here</c><00:07:41.370><c> we'll</c><00:07:41.520><c> go</c><00:07:41.970><c> to</c><00:07:42.030><c> form</c>

00:07:42.469 --> 00:07:42.479 align:start position:0%
we're finished here we'll go to form
 

00:07:42.479 --> 00:07:45.830 align:start position:0%
we're finished here we'll go to form
view<00:07:42.780><c> to</c><00:07:42.900><c> take</c><00:07:43.080><c> a</c><00:07:43.110><c> look</c><00:07:43.380><c> if</c><00:07:44.090><c> you</c><00:07:45.090><c> want</c><00:07:45.330><c> you</c><00:07:45.659><c> can</c>

00:07:45.830 --> 00:07:45.840 align:start position:0%
view to take a look if you want you can
 

00:07:45.840 --> 00:07:47.719 align:start position:0%
view to take a look if you want you can
move<00:07:45.990><c> the</c><00:07:46.080><c> label</c><00:07:46.500><c> and</c><00:07:46.680><c> the</c><00:07:46.830><c> combo</c><00:07:47.159><c> box</c><00:07:47.190><c> but</c>

00:07:47.719 --> 00:07:47.729 align:start position:0%
move the label and the combo box but
 

00:07:47.729 --> 00:07:49.249 align:start position:0%
move the label and the combo box but
we'll<00:07:47.970><c> take</c><00:07:48.150><c> a</c><00:07:48.180><c> look</c><00:07:48.419><c> at</c><00:07:48.539><c> formatting</c><00:07:49.020><c> in</c><00:07:49.110><c> our</c>

00:07:49.249 --> 00:07:49.259 align:start position:0%
we'll take a look at formatting in our
 

00:07:49.259 --> 00:07:52.580 align:start position:0%
we'll take a look at formatting in our
next<00:07:49.590><c> lesson</c><00:07:50.960><c> now</c><00:07:51.960><c> we're</c><00:07:52.169><c> going</c><00:07:52.259><c> to</c><00:07:52.320><c> do</c><00:07:52.470><c> the</c>

00:07:52.580 --> 00:07:52.590 align:start position:0%
next lesson now we're going to do the
 

00:07:52.590 --> 00:07:55.159 align:start position:0%
next lesson now we're going to do the
same<00:07:52.830><c> thing</c><00:07:53.130><c> for</c><00:07:53.310><c> book</c><00:07:53.520><c> ID</c><00:07:53.729><c> our</c><00:07:54.210><c> form</c><00:07:54.840><c> user</c>

00:07:55.159 --> 00:07:55.169 align:start position:0%
same thing for book ID our form user
 

00:07:55.169 --> 00:07:57.200 align:start position:0%
same thing for book ID our form user
isn't<00:07:55.740><c> going</c><00:07:55.949><c> to</c><00:07:56.070><c> know</c><00:07:56.220><c> the</c><00:07:56.370><c> book</c><00:07:56.580><c> idea</c><00:07:57.030><c> of</c><00:07:57.090><c> the</c>

00:07:57.200 --> 00:07:57.210 align:start position:0%
isn't going to know the book idea of the
 

00:07:57.210 --> 00:07:59.270 align:start position:0%
isn't going to know the book idea of the
book<00:07:57.479><c> so</c><00:07:58.080><c> we'll</c><00:07:58.229><c> want</c><00:07:58.469><c> him</c><00:07:58.710><c> to</c><00:07:58.830><c> be</c><00:07:58.949><c> able</c><00:07:59.099><c> to</c>

00:07:59.270 --> 00:07:59.280 align:start position:0%
book so we'll want him to be able to
 

00:07:59.280 --> 00:08:01.700 align:start position:0%
book so we'll want him to be able to
search<00:07:59.639><c> on</c><00:07:59.940><c> the</c><00:08:00.060><c> book</c><00:08:00.270><c> title</c><00:08:00.690><c> and</c><00:08:00.810><c> author</c><00:08:01.020><c> I'll</c>

00:08:01.700 --> 00:08:01.710 align:start position:0%
search on the book title and author I'll
 

00:08:01.710 --> 00:08:03.080 align:start position:0%
search on the book title and author I'll
go<00:08:01.919><c> ahead</c><00:08:02.070><c> and</c><00:08:02.310><c> finish</c><00:08:02.430><c> this</c><00:08:02.639><c> up</c><00:08:02.820><c> really</c>

00:08:03.080 --> 00:08:03.090 align:start position:0%
go ahead and finish this up really
 

00:08:03.090 --> 00:08:07.550 align:start position:0%
go ahead and finish this up really
quickly<00:08:05.180><c> one</c><00:08:06.180><c> more</c><00:08:06.210><c> enhancement</c><00:08:07.169><c> that</c><00:08:07.409><c> would</c>

00:08:07.550 --> 00:08:07.560 align:start position:0%
quickly one more enhancement that would
 

00:08:07.560 --> 00:08:09.770 align:start position:0%
quickly one more enhancement that would
make<00:08:07.740><c> this</c><00:08:07.919><c> form</c><00:08:08.310><c> more</c><00:08:08.729><c> usable</c><00:08:09.330><c> is</c><00:08:09.479><c> to</c><00:08:09.599><c> add</c><00:08:09.750><c> a</c>

00:08:09.770 --> 00:08:09.780 align:start position:0%
make this form more usable is to add a
 

00:08:09.780 --> 00:08:12.439 align:start position:0%
make this form more usable is to add a
button<00:08:10.169><c> so</c><00:08:10.860><c> that</c><00:08:10.889><c> when</c><00:08:11.190><c> our</c><00:08:11.310><c> form</c><00:08:11.759><c> user</c><00:08:12.060><c> enters</c>

00:08:12.439 --> 00:08:12.449 align:start position:0%
button so that when our form user enters
 

00:08:12.449 --> 00:08:14.899 align:start position:0%
button so that when our form user enters
a<00:08:12.570><c> new</c><00:08:12.719><c> record</c><00:08:12.990><c> they</c><00:08:13.650><c> can</c><00:08:13.830><c> hit</c><00:08:13.979><c> this</c><00:08:14.219><c> button</c><00:08:14.280><c> to</c>

00:08:14.899 --> 00:08:14.909 align:start position:0%
a new record they can hit this button to
 

00:08:14.909 --> 00:08:17.060 align:start position:0%
a new record they can hit this button to
save<00:08:15.210><c> the</c><00:08:15.389><c> record</c><00:08:15.630><c> to</c><00:08:15.960><c> the</c><00:08:16.080><c> orders</c><00:08:16.409><c> table</c><00:08:16.650><c> and</c>

00:08:17.060 --> 00:08:17.070 align:start position:0%
save the record to the orders table and
 

00:08:17.070 --> 00:08:19.850 align:start position:0%
save the record to the orders table and
advance<00:08:17.940><c> to</c><00:08:18.180><c> the</c><00:08:18.270><c> next</c><00:08:18.479><c> new</c><00:08:18.810><c> record</c><00:08:19.259><c> here's</c>

00:08:19.850 --> 00:08:19.860 align:start position:0%
advance to the next new record here's
 

00:08:19.860 --> 00:08:23.689 align:start position:0%
advance to the next new record here's
how<00:08:20.039><c> you</c><00:08:20.099><c> do</c><00:08:20.340><c> that</c><00:08:21.680><c> click</c><00:08:22.680><c> button</c><00:08:23.219><c> on</c><00:08:23.460><c> the</c>

00:08:23.689 --> 00:08:23.699 align:start position:0%
how you do that click button on the
 

00:08:23.699 --> 00:08:26.629 align:start position:0%
how you do that click button on the
controls<00:08:24.120><c> portion</c><00:08:24.690><c> of</c><00:08:24.840><c> the</c><00:08:24.960><c> ribbon</c><00:08:25.460><c> move</c><00:08:26.460><c> your</c>

00:08:26.629 --> 00:08:26.639 align:start position:0%
controls portion of the ribbon move your
 

00:08:26.639 --> 00:08:29.450 align:start position:0%
controls portion of the ribbon move your
mouse<00:08:26.849><c> over</c><00:08:27.240><c> the</c><00:08:27.690><c> form</c><00:08:28.199><c> until</c><00:08:28.710><c> the</c><00:08:28.770><c> crosshair</c>

00:08:29.450 --> 00:08:29.460 align:start position:0%
mouse over the form until the crosshair
 

00:08:29.460 --> 00:08:32.240 align:start position:0%
mouse over the form until the crosshair
with<00:08:29.699><c> the</c><00:08:29.789><c> button</c><00:08:30.030><c> icon</c><00:08:30.240><c> appears</c><00:08:31.039><c> draw</c><00:08:32.039><c> your</c>

00:08:32.240 --> 00:08:32.250 align:start position:0%
with the button icon appears draw your
 

00:08:32.250 --> 00:08:33.920 align:start position:0%
with the button icon appears draw your
button<00:08:32.579><c> wherever</c><00:08:32.969><c> you</c><00:08:33.180><c> want</c><00:08:33.390><c> it</c><00:08:33.450><c> to</c><00:08:33.479><c> appear</c><00:08:33.810><c> on</c>

00:08:33.920 --> 00:08:33.930 align:start position:0%
button wherever you want it to appear on
 

00:08:33.930 --> 00:08:36.500 align:start position:0%
button wherever you want it to appear on
the<00:08:34.050><c> form</c><00:08:34.320><c> you</c><00:08:35.099><c> can</c><00:08:35.279><c> always</c><00:08:35.579><c> move</c><00:08:35.969><c> this</c><00:08:36.209><c> button</c>

00:08:36.500 --> 00:08:36.510 align:start position:0%
the form you can always move this button
 

00:08:36.510 --> 00:08:39.380 align:start position:0%
the form you can always move this button
later<00:08:36.979><c> when</c><00:08:37.979><c> our</c><00:08:38.130><c> button</c><00:08:38.579><c> is</c><00:08:38.669><c> pushed</c><00:08:38.969><c> we</c>

00:08:39.380 --> 00:08:39.390 align:start position:0%
later when our button is pushed we
 

00:08:39.390 --> 00:08:41.750 align:start position:0%
later when our button is pushed we
wanted<00:08:39.779><c> to</c><00:08:39.899><c> save</c><00:08:40.229><c> the</c><00:08:40.560><c> current</c><00:08:40.800><c> record</c><00:08:41.339><c> and</c>

00:08:41.750 --> 00:08:41.760 align:start position:0%
wanted to save the current record and
 

00:08:41.760 --> 00:08:44.630 align:start position:0%
wanted to save the current record and
advance<00:08:42.419><c> to</c><00:08:42.599><c> a</c><00:08:42.719><c> new</c><00:08:43.020><c> record</c><00:08:43.339><c> so</c><00:08:44.339><c> from</c><00:08:44.550><c> the</c>

00:08:44.630 --> 00:08:44.640 align:start position:0%
advance to a new record so from the
 

00:08:44.640 --> 00:08:47.269 align:start position:0%
advance to a new record so from the
categories<00:08:45.300><c> list</c><00:08:45.600><c> we'll</c><00:08:46.079><c> select</c><00:08:46.380><c> record</c>

00:08:47.269 --> 00:08:47.279 align:start position:0%
categories list we'll select record
 

00:08:47.279 --> 00:08:50.000 align:start position:0%
categories list we'll select record
navigation<00:08:47.490><c> and</c><00:08:48.390><c> from</c><00:08:49.170><c> the</c><00:08:49.290><c> action</c><00:08:49.740><c> list</c>

00:08:50.000 --> 00:08:50.010 align:start position:0%
navigation and from the action list
 

00:08:50.010 --> 00:08:54.430 align:start position:0%
navigation and from the action list
we'll<00:08:50.400><c> select</c><00:08:50.640><c> go</c><00:08:51.300><c> to</c><00:08:51.360><c> next</c><00:08:51.870><c> record</c><00:08:53.300><c> the</c>

00:08:54.430 --> 00:08:54.440 align:start position:0%
we'll select go to next record the
 

00:08:54.440 --> 00:08:56.770 align:start position:0%
we'll select go to next record the
next<00:08:54.830><c> screen</c><00:08:55.280><c> lets</c><00:08:55.790><c> us</c><00:08:56.000><c> decide</c><00:08:56.330><c> whether</c><00:08:56.690><c> or</c>

00:08:56.770 --> 00:08:56.780 align:start position:0%
next screen lets us decide whether or
 

00:08:56.780 --> 00:08:58.720 align:start position:0%
next screen lets us decide whether or
not<00:08:57.080><c> we</c><00:08:57.260><c> want</c><00:08:57.500><c> text</c><00:08:57.980><c> or</c><00:08:58.100><c> a</c><00:08:58.130><c> picture</c><00:08:58.520><c> on</c><00:08:58.640><c> the</c>

00:08:58.720 --> 00:08:58.730 align:start position:0%
not we want text or a picture on the
 

00:08:58.730 --> 00:09:01.570 align:start position:0%
not we want text or a picture on the
button<00:08:59.030><c> I</c><00:08:59.270><c> want</c><00:08:59.870><c> the</c><00:08:59.990><c> text</c><00:09:00.290><c> to</c><00:09:00.500><c> read</c><00:09:00.950><c> submit</c>

00:09:01.570 --> 00:09:01.580 align:start position:0%
button I want the text to read submit
 

00:09:01.580 --> 00:09:04.000 align:start position:0%
button I want the text to read submit
because<00:09:02.240><c> that's</c><00:09:02.480><c> what</c><00:09:02.750><c> we</c><00:09:02.840><c> generally</c><00:09:03.410><c> see</c><00:09:03.770><c> on</c>

00:09:04.000 --> 00:09:04.010 align:start position:0%
because that's what we generally see on
 

00:09:04.010 --> 00:09:06.490 align:start position:0%
because that's what we generally see on
forums<00:09:04.730><c> where</c><00:09:05.270><c> we</c><00:09:05.390><c> have</c><00:09:05.570><c> to</c><00:09:05.720><c> enter</c><00:09:06.050><c> and</c><00:09:06.230><c> send</c>

00:09:06.490 --> 00:09:06.500 align:start position:0%
forums where we have to enter and send
 

00:09:06.500 --> 00:09:07.420 align:start position:0%
forums where we have to enter and send
information

00:09:07.420 --> 00:09:07.430 align:start position:0%
information
 

00:09:07.430 --> 00:09:10.030 align:start position:0%
information
now<00:09:07.820><c> once</c><00:09:08.120><c> a</c><00:09:08.300><c> user</c><00:09:08.510><c> clicks</c><00:09:08.930><c> submit</c><00:09:09.290><c> the</c>

00:09:10.030 --> 00:09:10.040 align:start position:0%
now once a user clicks submit the
 

00:09:10.040 --> 00:09:12.010 align:start position:0%
now once a user clicks submit the
information<00:09:10.160><c> will</c><00:09:10.820><c> be</c><00:09:10.910><c> saved</c><00:09:11.270><c> to</c><00:09:11.630><c> the</c><00:09:11.720><c> orders</c>

00:09:12.010 --> 00:09:12.020 align:start position:0%
information will be saved to the orders
 

00:09:12.020 --> 00:09:15.610 align:start position:0%
information will be saved to the orders
table<00:09:12.290><c> also</c><00:09:12.860><c> by</c><00:09:13.700><c> hitting</c><00:09:13.940><c> submit</c><00:09:14.270><c> we</c><00:09:15.170><c> advance</c>

00:09:15.610 --> 00:09:15.620 align:start position:0%
table also by hitting submit we advance
 

00:09:15.620 --> 00:09:18.550 align:start position:0%
table also by hitting submit we advance
to<00:09:15.860><c> the</c><00:09:15.950><c> next</c><00:09:16.190><c> blank</c><00:09:16.700><c> record</c><00:09:17.090><c> on</c><00:09:17.450><c> the</c><00:09:18.110><c> next</c>

00:09:18.550 --> 00:09:18.560 align:start position:0%
to the next blank record on the next
 

00:09:18.560 --> 00:09:21.100 align:start position:0%
to the next blank record on the next
screen<00:09:19.010><c> we</c><00:09:19.610><c> can</c><00:09:19.760><c> choose</c><00:09:20.030><c> to</c><00:09:20.240><c> give</c><00:09:20.450><c> this</c><00:09:20.750><c> button</c>

00:09:21.100 --> 00:09:21.110 align:start position:0%
screen we can choose to give this button
 

00:09:21.110 --> 00:09:24.100 align:start position:0%
screen we can choose to give this button
a<00:09:21.170><c> special</c><00:09:21.560><c> name</c><00:09:22.030><c> this</c><00:09:23.030><c> could</c><00:09:23.270><c> be</c><00:09:23.420><c> handy</c><00:09:23.930><c> if</c>

00:09:24.100 --> 00:09:24.110 align:start position:0%
a special name this could be handy if
 

00:09:24.110 --> 00:09:26.020 align:start position:0%
a special name this could be handy if
you<00:09:24.260><c> have</c><00:09:24.410><c> several</c><00:09:24.770><c> buttons</c><00:09:25.280><c> and</c><00:09:25.550><c> you</c><00:09:25.640><c> need</c><00:09:25.850><c> to</c>

00:09:26.020 --> 00:09:26.030 align:start position:0%
you have several buttons and you need to
 

00:09:26.030 --> 00:09:28.210 align:start position:0%
you have several buttons and you need to
know<00:09:26.210><c> which</c><00:09:26.570><c> is</c><00:09:26.600><c> which</c><00:09:27.020><c> if</c><00:09:27.350><c> you</c><00:09:27.560><c> ever</c><00:09:27.770><c> have</c><00:09:28.070><c> to</c>

00:09:28.210 --> 00:09:28.220 align:start position:0%
know which is which if you ever have to
 

00:09:28.220 --> 00:09:30.730 align:start position:0%
know which is which if you ever have to
edit<00:09:28.370><c> the</c><00:09:28.580><c> buttons</c><00:09:28.880><c> later</c><00:09:29.180><c> I'll</c><00:09:29.870><c> type</c><00:09:30.500><c> in</c>

00:09:30.730 --> 00:09:30.740 align:start position:0%
edit the buttons later I'll type in
 

00:09:30.740 --> 00:09:33.400 align:start position:0%
edit the buttons later I'll type in
submit<00:09:31.250><c> here</c><00:09:31.610><c> let's</c><00:09:32.360><c> go</c><00:09:32.510><c> back</c><00:09:32.540><c> to</c><00:09:32.960><c> form</c><00:09:33.290><c> view</c>

00:09:33.400 --> 00:09:33.410 align:start position:0%
submit here let's go back to form view
 

00:09:33.410 --> 00:09:38.470 align:start position:0%
submit here let's go back to form view
and<00:09:34.100><c> test</c><00:09:34.820><c> out</c><00:09:35.030><c> our</c><00:09:35.060><c> new</c><00:09:35.450><c> form</c><00:09:36.820><c> so</c><00:09:37.820><c> now</c><00:09:38.120><c> if</c>

00:09:38.470 --> 00:09:38.480 align:start position:0%
and test out our new form so now if
 

00:09:38.480 --> 00:09:41.590 align:start position:0%
and test out our new form so now if
Jimmy<00:09:38.780><c> Smith</c><00:09:39.230><c> purchases</c><00:09:40.010><c> Computer</c><00:09:40.640><c> Basics</c><00:09:40.670><c> it</c>

00:09:41.590 --> 00:09:41.600 align:start position:0%
Jimmy Smith purchases Computer Basics it
 

00:09:41.600 --> 00:09:43.840 align:start position:0%
Jimmy Smith purchases Computer Basics it
will<00:09:42.050><c> be</c><00:09:42.170><c> much</c><00:09:42.440><c> easier</c><00:09:42.770><c> to</c><00:09:43.010><c> enter</c><00:09:43.460><c> and</c><00:09:43.640><c> save</c>

00:09:43.840 --> 00:09:43.850 align:start position:0%
will be much easier to enter and save
 

00:09:43.850 --> 00:09:46.390 align:start position:0%
will be much easier to enter and save
the<00:09:44.030><c> new</c><00:09:44.150><c> record</c><00:09:44.570><c> to</c><00:09:44.690><c> our</c><00:09:44.840><c> orders</c><00:09:45.230><c> table</c><00:09:45.470><c> as</c><00:09:45.830><c> I</c>

00:09:46.390 --> 00:09:46.400 align:start position:0%
the new record to our orders table as I
 

00:09:46.400 --> 00:09:49.420 align:start position:0%
the new record to our orders table as I
said<00:09:46.610><c> before</c><00:09:46.790><c> by</c><00:09:47.480><c> clicking</c><00:09:47.930><c> submit</c><00:09:48.430><c> access</c>

00:09:49.420 --> 00:09:49.430 align:start position:0%
said before by clicking submit access
 

00:09:49.430 --> 00:09:51.370 align:start position:0%
said before by clicking submit access
automatically<00:09:50.210><c> saves</c><00:09:50.510><c> the</c><00:09:50.690><c> record</c><00:09:50.870><c> to</c><00:09:51.260><c> the</c>

00:09:51.370 --> 00:09:51.380 align:start position:0%
automatically saves the record to the
 

00:09:51.380 --> 00:09:53.740 align:start position:0%
automatically saves the record to the
table<00:09:51.830><c> but</c><00:09:52.250><c> you</c><00:09:52.400><c> may</c><00:09:52.670><c> have</c><00:09:52.700><c> to</c><00:09:53.090><c> click</c><00:09:53.240><c> refresh</c>

00:09:53.740 --> 00:09:53.750 align:start position:0%
table but you may have to click refresh
 

00:09:53.750 --> 00:09:57.100 align:start position:0%
table but you may have to click refresh
all<00:09:54.110><c> in</c><00:09:54.760><c> the</c><00:09:55.760><c> orders</c><00:09:56.120><c> table</c><00:09:56.360><c> to</c><00:09:56.810><c> see</c><00:09:56.990><c> the</c>

00:09:57.100 --> 00:09:57.110 align:start position:0%
all in the orders table to see the
 

00:09:57.110 --> 00:09:59.260 align:start position:0%
all in the orders table to see the
change<00:09:57.440><c> so</c><00:09:58.370><c> you've</c><00:09:58.520><c> learned</c><00:09:58.730><c> how</c><00:09:59.030><c> to</c><00:09:59.060><c> make</c>

00:09:59.260 --> 00:09:59.270 align:start position:0%
change so you've learned how to make
 

00:09:59.270 --> 00:10:01.510 align:start position:0%
change so you've learned how to make
forms<00:09:59.780><c> really</c><00:10:00.230><c> user-friendly</c><00:10:00.560><c> by</c><00:10:01.160><c> adding</c>

00:10:01.510 --> 00:10:01.520 align:start position:0%
forms really user-friendly by adding
 

00:10:01.520 --> 00:10:03.310 align:start position:0%
forms really user-friendly by adding
command<00:10:01.970><c> buttons</c><00:10:02.360><c> and</c><00:10:02.630><c> setting</c><00:10:03.020><c> form</c>

00:10:03.310 --> 00:10:03.320 align:start position:0%
command buttons and setting form
 

00:10:03.320 --> 00:10:06.010 align:start position:0%
command buttons and setting form
properties<00:10:03.920><c> and</c><00:10:04.250><c> our</c><00:10:04.700><c> next</c><00:10:05.180><c> lesson</c><00:10:05.630><c> we'll</c>

00:10:06.010 --> 00:10:06.020 align:start position:0%
properties and our next lesson we'll
 

00:10:06.020 --> 00:10:09.730 align:start position:0%
properties and our next lesson we'll
learn<00:10:06.200><c> how</c><00:10:06.260><c> to</c><00:10:06.440><c> make</c><00:10:06.560><c> this</c><00:10:06.860><c> form</c><00:10:07.220><c> look</c><00:10:07.460><c> good</c>