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.550><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.839 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><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.839 --> 00:00:10.849 align:start position:0%
 
 

00:00:10.849 --> 00:00:13.249 align:start position:0%
 
creating<00:00:11.849><c> a</c><00:00:11.940><c> forum</c><00:00:12.240><c> can</c><00:00:12.509><c> save</c><00:00:12.750><c> you</c><00:00:12.900><c> a</c><00:00:12.929><c> lot</c><00:00:13.110><c> of</c>

00:00:13.249 --> 00:00:13.259 align:start position:0%
creating a forum can save you a lot of
 

00:00:13.259 --> 00:00:15.230 align:start position:0%
creating a forum can save you a lot of
time<00:00:13.500><c> in</c><00:00:13.679><c> the</c><00:00:13.769><c> long</c><00:00:13.920><c> run</c><00:00:14.160><c> because</c><00:00:14.610><c> it</c><00:00:14.910><c> makes</c><00:00:15.090><c> it</c>

00:00:15.230 --> 00:00:15.240 align:start position:0%
time in the long run because it makes it
 

00:00:15.240 --> 00:00:17.120 align:start position:0%
time in the long run because it makes it
easier<00:00:15.599><c> to</c><00:00:15.660><c> input</c><00:00:16.199><c> the</c><00:00:16.320><c> data</c><00:00:16.349><c> into</c><00:00:16.830><c> one</c><00:00:16.980><c> or</c>

00:00:17.120 --> 00:00:17.130 align:start position:0%
easier to input the data into one or
 

00:00:17.130 --> 00:00:19.279 align:start position:0%
easier to input the data into one or
more<00:00:17.160><c> tables</c><00:00:17.670><c> and</c><00:00:17.910><c> in</c><00:00:18.630><c> this</c><00:00:18.720><c> video</c><00:00:18.990><c> we're</c><00:00:19.259><c> just</c>

00:00:19.279 --> 00:00:19.289 align:start position:0%
more tables and in this video we're just
 

00:00:19.289 --> 00:00:20.960 align:start position:0%
more tables and in this video we're just
going<00:00:19.470><c> to</c><00:00:19.650><c> go</c><00:00:19.829><c> over</c><00:00:19.860><c> the</c><00:00:20.160><c> basics</c><00:00:20.610><c> of</c><00:00:20.730><c> creating</c>

00:00:20.960 --> 00:00:20.970 align:start position:0%
going to go over the basics of creating
 

00:00:20.970 --> 00:00:23.450 align:start position:0%
going to go over the basics of creating
a<00:00:21.539><c> form</c><00:00:21.840><c> from</c><00:00:22.050><c> a</c><00:00:22.169><c> table</c><00:00:22.349><c> adding</c><00:00:23.220><c> additional</c>

00:00:23.450 --> 00:00:23.460 align:start position:0%
a form from a table adding additional
 

00:00:23.460 --> 00:00:25.999 align:start position:0%
a form from a table adding additional
fields<00:00:24.150><c> and</c><00:00:24.349><c> inserting</c><00:00:25.349><c> a</c><00:00:25.439><c> drop</c><00:00:25.739><c> down</c><00:00:25.949><c> menu</c>

00:00:25.999 --> 00:00:26.009 align:start position:0%
fields and inserting a drop down menu
 

00:00:26.009 --> 00:00:29.060 align:start position:0%
fields and inserting a drop down menu
into<00:00:26.579><c> the</c><00:00:26.670><c> form</c><00:00:26.910><c> in</c><00:00:27.179><c> the</c><00:00:28.140><c> navigation</c><00:00:28.859><c> pane</c>

00:00:29.060 --> 00:00:29.070 align:start position:0%
into the form in the navigation pane
 

00:00:29.070 --> 00:00:31.040 align:start position:0%
into the form in the navigation pane
you'll<00:00:29.340><c> need</c><00:00:29.580><c> to</c><00:00:29.820><c> select</c><00:00:30.240><c> the</c><00:00:30.509><c> table</c><00:00:30.810><c> that</c><00:00:30.929><c> you</c>

00:00:31.040 --> 00:00:31.050 align:start position:0%
you'll need to select the table that you
 

00:00:31.050 --> 00:00:32.960 align:start position:0%
you'll need to select the table that you
want<00:00:31.230><c> to</c><00:00:31.289><c> use</c><00:00:31.470><c> and</c><00:00:31.679><c> you</c><00:00:31.710><c> don't</c><00:00:32.610><c> need</c><00:00:32.730><c> to</c><00:00:32.820><c> open</c>

00:00:32.960 --> 00:00:32.970 align:start position:0%
want to use and you don't need to open
 

00:00:32.970 --> 00:00:34.340 align:start position:0%
want to use and you don't need to open
it<00:00:33.210><c> just</c><00:00:33.480><c> make</c><00:00:33.629><c> sure</c><00:00:33.870><c> that</c><00:00:34.050><c> the</c><00:00:34.170><c> name</c><00:00:34.290><c> is</c>

00:00:34.340 --> 00:00:34.350 align:start position:0%
it just make sure that the name is
 

00:00:34.350 --> 00:00:36.710 align:start position:0%
it just make sure that the name is
highlighted<00:00:34.949><c> I'm</c><00:00:35.460><c> using</c><00:00:35.820><c> the</c><00:00:36.150><c> customers</c>

00:00:36.710 --> 00:00:36.720 align:start position:0%
highlighted I'm using the customers
 

00:00:36.720 --> 00:00:40.700 align:start position:0%
highlighted I'm using the customers
table<00:00:37.250><c> then</c><00:00:38.250><c> in</c><00:00:38.640><c> the</c><00:00:38.820><c> create</c><00:00:39.150><c> tab</c><00:00:39.559><c> you</c><00:00:40.559><c> can</c>

00:00:40.700 --> 00:00:40.710 align:start position:0%
table then in the create tab you can
 

00:00:40.710 --> 00:00:43.490 align:start position:0%
table then in the create tab you can
click<00:00:40.920><c> the</c><00:00:41.190><c> form</c><00:00:41.489><c> command</c><00:00:41.910><c> and</c><00:00:42.409><c> it</c><00:00:43.409><c> will</c>

00:00:43.490 --> 00:00:43.500 align:start position:0%
click the form command and it will
 

00:00:43.500 --> 00:00:45.560 align:start position:0%
click the form command and it will
create<00:00:43.680><c> a</c><00:00:43.830><c> new</c><00:00:44.190><c> form</c><00:00:44.519><c> that</c><00:00:44.729><c> contains</c><00:00:45.119><c> all</c><00:00:45.420><c> of</c>

00:00:45.560 --> 00:00:45.570 align:start position:0%
create a new form that contains all of
 

00:00:45.570 --> 00:00:48.020 align:start position:0%
create a new form that contains all of
the<00:00:45.690><c> fields</c><00:00:46.080><c> from</c><00:00:46.140><c> your</c><00:00:46.440><c> table</c><00:00:46.799><c> and</c><00:00:47.430><c> before</c>

00:00:48.020 --> 00:00:48.030 align:start position:0%
the fields from your table and before
 

00:00:48.030 --> 00:00:49.729 align:start position:0%
the fields from your table and before
you<00:00:48.299><c> do</c><00:00:48.420><c> anything</c><00:00:48.659><c> else</c><00:00:48.960><c> you</c><00:00:49.049><c> should</c><00:00:49.229><c> save</c>

00:00:49.729 --> 00:00:49.739 align:start position:0%
you do anything else you should save
 

00:00:49.739 --> 00:00:57.579 align:start position:0%
you do anything else you should save
this<00:00:49.949><c> form</c><00:00:50.750><c> I'll</c><00:00:51.750><c> call</c><00:00:51.989><c> it</c><00:00:52.140><c> customers</c><00:00:52.799><c> form</c>

00:00:57.579 --> 00:00:57.589 align:start position:0%
 
 

00:00:57.589 --> 00:01:00.049 align:start position:0%
 
sometimes<00:00:58.589><c> your</c><00:00:59.040><c> form</c><00:00:59.309><c> will</c><00:00:59.460><c> include</c><00:00:59.850><c> a</c>

00:01:00.049 --> 00:01:00.059 align:start position:0%
sometimes your form will include a
 

00:01:00.059 --> 00:01:02.810 align:start position:0%
sometimes your form will include a
subform<00:01:00.979><c> access</c><00:01:01.979><c> will</c><00:01:02.129><c> create</c><00:01:02.430><c> one</c><00:01:02.640><c> of</c><00:01:02.670><c> these</c>

00:01:02.810 --> 00:01:02.820 align:start position:0%
subform access will create one of these
 

00:01:02.820 --> 00:01:04.969 align:start position:0%
subform access will create one of these
if<00:01:03.119><c> your</c><00:01:03.269><c> table</c><00:01:03.420><c> is</c><00:01:03.720><c> linked</c><00:01:04.140><c> to</c><00:01:04.350><c> another</c><00:01:04.379><c> table</c>

00:01:04.969 --> 00:01:04.979 align:start position:0%
if your table is linked to another table
 

00:01:04.979 --> 00:01:07.640 align:start position:0%
if your table is linked to another table
for<00:01:05.180><c> example</c><00:01:06.180><c> here</c><00:01:06.510><c> our</c><00:01:06.659><c> customers</c><00:01:07.170><c> table</c><00:01:07.500><c> is</c>

00:01:07.640 --> 00:01:07.650 align:start position:0%
for example here our customers table is
 

00:01:07.650 --> 00:01:09.890 align:start position:0%
for example here our customers table is
linked<00:01:08.010><c> to</c><00:01:08.220><c> the</c><00:01:08.369><c> orders</c><00:01:08.700><c> table</c><00:01:08.850><c> so</c><00:01:09.630><c> the</c>

00:01:09.890 --> 00:01:09.900 align:start position:0%
linked to the orders table so the
 

00:01:09.900 --> 00:01:11.899 align:start position:0%
linked to the orders table so the
subform<00:01:10.470><c> will</c><00:01:10.710><c> include</c><00:01:11.100><c> a</c><00:01:11.280><c> list</c><00:01:11.490><c> of</c><00:01:11.640><c> any</c>

00:01:11.899 --> 00:01:11.909 align:start position:0%
subform will include a list of any
 

00:01:11.909 --> 00:01:13.730 align:start position:0%
subform will include a list of any
orders<00:01:12.330><c> that</c><00:01:12.570><c> the</c><00:01:12.659><c> customer</c><00:01:13.049><c> is</c><00:01:13.080><c> placed</c><00:01:13.470><c> in</c>

00:01:13.730 --> 00:01:13.740 align:start position:0%
orders that the customer is placed in
 

00:01:13.740 --> 00:01:16.610 align:start position:0%
orders that the customer is placed in
many<00:01:14.610><c> cases</c><00:01:14.940><c> this</c><00:01:15.090><c> may</c><00:01:15.270><c> be</c><00:01:15.330><c> useful</c><00:01:15.600><c> but</c><00:01:16.350><c> if</c><00:01:16.530><c> you</c>

00:01:16.610 --> 00:01:16.620 align:start position:0%
many cases this may be useful but if you
 

00:01:16.620 --> 00:01:18.350 align:start position:0%
many cases this may be useful but if you
don't<00:01:16.890><c> need</c><00:01:17.040><c> the</c><00:01:17.160><c> subform</c><00:01:17.550><c> you</c><00:01:17.820><c> can</c><00:01:18.030><c> delete</c><00:01:18.330><c> it</c>

00:01:18.350 --> 00:01:18.360 align:start position:0%
don't need the subform you can delete it
 

00:01:18.360 --> 00:01:21.080 align:start position:0%
don't need the subform you can delete it
by<00:01:18.510><c> just</c><00:01:18.930><c> clicking</c><00:01:19.170><c> on</c><00:01:19.410><c> it</c><00:01:19.560><c> and</c><00:01:19.850><c> pressing</c><00:01:20.850><c> the</c>

00:01:21.080 --> 00:01:21.090 align:start position:0%
by just clicking on it and pressing the
 

00:01:21.090 --> 00:01:25.250 align:start position:0%
by just clicking on it and pressing the
Delete<00:01:21.390><c> key</c><00:01:23.060><c> now</c><00:01:24.060><c> if</c><00:01:24.210><c> we</c><00:01:24.360><c> later</c><00:01:24.600><c> decided</c><00:01:25.050><c> to</c>

00:01:25.250 --> 00:01:25.260 align:start position:0%
Delete key now if we later decided to
 

00:01:25.260 --> 00:01:27.380 align:start position:0%
Delete key now if we later decided to
add<00:01:25.410><c> a</c><00:01:25.440><c> field</c><00:01:25.800><c> to</c><00:01:25.920><c> the</c><00:01:26.130><c> customers</c><00:01:26.580><c> table</c><00:01:26.760><c> it</c>

00:01:27.380 --> 00:01:27.390 align:start position:0%
add a field to the customers table it
 

00:01:27.390 --> 00:01:29.090 align:start position:0%
add a field to the customers table it
would<00:01:27.630><c> not</c><00:01:27.870><c> appear</c><00:01:28.230><c> automatically</c><00:01:28.770><c> in</c><00:01:28.890><c> this</c>

00:01:29.090 --> 00:01:29.100 align:start position:0%
would not appear automatically in this
 

00:01:29.100 --> 00:01:31.090 align:start position:0%
would not appear automatically in this
form<00:01:29.370><c> so</c><00:01:29.820><c> we</c><00:01:29.940><c> would</c><00:01:30.090><c> need</c><00:01:30.180><c> to</c><00:01:30.240><c> add</c><00:01:30.360><c> it</c><00:01:30.630><c> manually</c>

00:01:31.090 --> 00:01:31.100 align:start position:0%
form so we would need to add it manually
 

00:01:31.100 --> 00:01:33.950 align:start position:0%
form so we would need to add it manually
to<00:01:32.100><c> do</c><00:01:32.250><c> this</c><00:01:32.430><c> you</c><00:01:32.670><c> can</c><00:01:32.820><c> select</c><00:01:33.000><c> add</c><00:01:33.390><c> existing</c>

00:01:33.950 --> 00:01:33.960 align:start position:0%
to do this you can select add existing
 

00:01:33.960 --> 00:01:36.680 align:start position:0%
to do this you can select add existing
fields<00:01:34.560><c> from</c><00:01:34.740><c> the</c><00:01:34.890><c> design</c><00:01:35.190><c> tab</c><00:01:35.430><c> and</c><00:01:35.730><c> this</c><00:01:36.510><c> will</c>

00:01:36.680 --> 00:01:36.690 align:start position:0%
fields from the design tab and this will
 

00:01:36.690 --> 00:01:38.930 align:start position:0%
fields from the design tab and this will
open<00:01:36.960><c> up</c><00:01:37.080><c> the</c><00:01:37.260><c> field</c><00:01:37.530><c> list</c><00:01:37.950><c> which</c><00:01:38.430><c> shows</c><00:01:38.460><c> all</c>

00:01:38.930 --> 00:01:38.940 align:start position:0%
open up the field list which shows all
 

00:01:38.940 --> 00:01:41.210 align:start position:0%
open up the field list which shows all
of<00:01:38.970><c> the</c><00:01:39.240><c> fields</c><00:01:39.270><c> from</c><00:01:39.720><c> this</c><00:01:39.930><c> table</c><00:01:40.350><c> you</c><00:01:41.190><c> can</c>

00:01:41.210 --> 00:01:41.220 align:start position:0%
of the fields from this table you can
 

00:01:41.220 --> 00:01:43.010 align:start position:0%
of the fields from this table you can
just<00:01:41.520><c> double-click</c><00:01:41.940><c> a</c><00:01:42.150><c> field</c><00:01:42.479><c> to</c><00:01:42.659><c> add</c><00:01:42.810><c> it</c><00:01:42.990><c> to</c>

00:01:43.010 --> 00:01:43.020 align:start position:0%
just double-click a field to add it to
 

00:01:43.020 --> 00:01:45.380 align:start position:0%
just double-click a field to add it to
the<00:01:43.200><c> form</c><00:01:43.409><c> or</c><00:01:44.130><c> if</c><00:01:44.610><c> you</c><00:01:44.729><c> want</c><00:01:44.940><c> to</c><00:01:45.030><c> add</c><00:01:45.150><c> a</c><00:01:45.180><c> field</c>

00:01:45.380 --> 00:01:45.390 align:start position:0%
the form or if you want to add a field
 

00:01:45.390 --> 00:01:47.300 align:start position:0%
the form or if you want to add a field
from<00:01:45.690><c> a</c><00:01:45.750><c> different</c><00:01:45.930><c> table</c><00:01:46.229><c> click</c><00:01:46.860><c> show</c><00:01:47.280><c> all</c>

00:01:47.300 --> 00:01:47.310 align:start position:0%
from a different table click show all
 

00:01:47.310 --> 00:01:50.600 align:start position:0%
from a different table click show all
tables<00:01:47.940><c> and</c><00:01:48.470><c> then</c><00:01:49.470><c> locate</c><00:01:49.890><c> the</c><00:01:49.920><c> table</c><00:01:50.370><c> and</c>

00:01:50.600 --> 00:01:50.610 align:start position:0%
tables and then locate the table and
 

00:01:50.610 --> 00:01:52.520 align:start position:0%
tables and then locate the table and
field<00:01:50.850><c> that</c><00:01:51.060><c> you</c><00:01:51.180><c> want</c>

00:01:52.520 --> 00:01:52.530 align:start position:0%
field that you want
 

00:01:52.530 --> 00:01:54.620 align:start position:0%
field that you want
but<00:01:53.370><c> for</c><00:01:53.520><c> now</c><00:01:53.610><c> we</c><00:01:53.670><c> have</c><00:01:54.000><c> all</c><00:01:54.210><c> of</c><00:01:54.360><c> the</c><00:01:54.450><c> fields</c>

00:01:54.620 --> 00:01:54.630 align:start position:0%
but for now we have all of the fields
 

00:01:54.630 --> 00:01:56.390 align:start position:0%
but for now we have all of the fields
that<00:01:54.870><c> we</c><00:01:55.020><c> need</c><00:01:55.050><c> so</c><00:01:55.470><c> I'm</c><00:01:55.710><c> just</c><00:01:55.860><c> going</c><00:01:56.070><c> to</c><00:01:56.130><c> close</c>

00:01:56.390 --> 00:01:56.400 align:start position:0%
that we need so I'm just going to close
 

00:01:56.400 --> 00:02:00.110 align:start position:0%
that we need so I'm just going to close
this<00:01:56.670><c> pane</c><00:01:57.980><c> with</c><00:01:58.980><c> some</c><00:01:59.220><c> fields</c><00:01:59.610><c> you</c><00:01:59.730><c> may</c><00:01:59.880><c> want</c>

00:02:00.110 --> 00:02:00.120 align:start position:0%
this pane with some fields you may want
 

00:02:00.120 --> 00:02:02.330 align:start position:0%
this pane with some fields you may want
to<00:02:00.150><c> add</c><00:02:00.360><c> a</c><00:02:00.390><c> drop-down</c><00:02:01.110><c> menu</c><00:02:01.170><c> which</c><00:02:01.890><c> access</c>

00:02:02.330 --> 00:02:02.340 align:start position:0%
to add a drop-down menu which access
 

00:02:02.340 --> 00:02:04.940 align:start position:0%
to add a drop-down menu which access
calls<00:02:02.610><c> a</c><00:02:02.820><c> combo</c><00:02:03.240><c> box</c><00:02:03.450><c> this</c><00:02:04.260><c> can</c><00:02:04.470><c> make</c><00:02:04.590><c> the</c><00:02:04.710><c> form</c>

00:02:04.940 --> 00:02:04.950 align:start position:0%
calls a combo box this can make the form
 

00:02:04.950 --> 00:02:07.040 align:start position:0%
calls a combo box this can make the form
easier<00:02:05.400><c> to</c><00:02:05.550><c> use</c><00:02:05.790><c> because</c><00:02:06.060><c> the</c><00:02:06.270><c> user</c><00:02:06.479><c> can</c><00:02:06.840><c> just</c>

00:02:07.040 --> 00:02:07.050 align:start position:0%
easier to use because the user can just
 

00:02:07.050 --> 00:02:09.380 align:start position:0%
easier to use because the user can just
click<00:02:07.350><c> on</c><00:02:07.500><c> the</c><00:02:07.590><c> value</c><00:02:07.740><c> that</c><00:02:08.009><c> they</c><00:02:08.190><c> want</c><00:02:08.390><c> I'm</c>

00:02:09.380 --> 00:02:09.390 align:start position:0%
click on the value that they want I'm
 

00:02:09.390 --> 00:02:11.420 align:start position:0%
click on the value that they want I'm
going<00:02:09.690><c> to</c><00:02:09.780><c> create</c><00:02:09.990><c> a</c><00:02:10.110><c> combo</c><00:02:10.500><c> box</c><00:02:10.679><c> for</c><00:02:11.100><c> the</c><00:02:11.280><c> add</c>

00:02:11.420 --> 00:02:11.430 align:start position:0%
going to create a combo box for the add
 

00:02:11.430 --> 00:02:14.930 align:start position:0%
going to create a combo box for the add
to<00:02:11.730><c> mailing</c><00:02:11.910><c> list</c><00:02:12.240><c> field</c><00:02:12.570><c> in</c><00:02:13.430><c> the</c><00:02:14.430><c> design</c><00:02:14.760><c> tab</c>

00:02:14.930 --> 00:02:14.940 align:start position:0%
to mailing list field in the design tab
 

00:02:14.940 --> 00:02:17.960 align:start position:0%
to mailing list field in the design tab
find<00:02:15.450><c> the</c><00:02:15.600><c> controls</c><00:02:15.660><c> group</c><00:02:16.530><c> and</c><00:02:16.740><c> select</c><00:02:17.700><c> the</c>

00:02:17.960 --> 00:02:17.970 align:start position:0%
find the controls group and select the
 

00:02:17.970 --> 00:02:21.680 align:start position:0%
find the controls group and select the
combo<00:02:18.150><c> box</c><00:02:18.630><c> command</c><00:02:20.180><c> then</c><00:02:21.180><c> you</c><00:02:21.390><c> can</c><00:02:21.540><c> just</c>

00:02:21.680 --> 00:02:21.690 align:start position:0%
combo box command then you can just
 

00:02:21.690 --> 00:02:23.000 align:start position:0%
combo box command then you can just
click<00:02:21.959><c> on</c><00:02:22.050><c> the</c><00:02:22.170><c> form</c><00:02:22.440><c> where</c><00:02:22.620><c> you</c><00:02:22.680><c> want</c><00:02:22.860><c> it</c><00:02:22.920><c> to</c>

00:02:23.000 --> 00:02:23.010 align:start position:0%
click on the form where you want it to
 

00:02:23.010 --> 00:02:27.530 align:start position:0%
click on the form where you want it to
go<00:02:24.560><c> the</c><00:02:25.560><c> combo</c><00:02:25.950><c> box</c><00:02:25.980><c> wizard</c><00:02:26.370><c> will</c><00:02:26.820><c> open</c><00:02:26.850><c> up</c><00:02:27.300><c> and</c>

00:02:27.530 --> 00:02:27.540 align:start position:0%
go the combo box wizard will open up and
 

00:02:27.540 --> 00:02:30.020 align:start position:0%
go the combo box wizard will open up and
if<00:02:28.290><c> you</c><00:02:28.380><c> have</c><00:02:28.530><c> a</c><00:02:28.560><c> long</c><00:02:28.830><c> list</c><00:02:29.130><c> of</c><00:02:29.340><c> values</c><00:02:29.730><c> then</c>

00:02:30.020 --> 00:02:30.030 align:start position:0%
if you have a long list of values then
 

00:02:30.030 --> 00:02:31.850 align:start position:0%
if you have a long list of values then
you<00:02:30.060><c> can</c><00:02:30.360><c> click</c><00:02:30.630><c> the</c><00:02:30.750><c> first</c><00:02:30.989><c> option</c><00:02:31.170><c> to</c><00:02:31.620><c> pull</c>

00:02:31.850 --> 00:02:31.860 align:start position:0%
you can click the first option to pull
 

00:02:31.860 --> 00:02:34.490 align:start position:0%
you can click the first option to pull
the<00:02:32.010><c> values</c><00:02:32.280><c> from</c><00:02:32.459><c> a</c><00:02:32.580><c> table</c><00:02:33.030><c> or</c><00:02:33.120><c> a</c><00:02:33.150><c> query</c><00:02:33.500><c> but</c>

00:02:34.490 --> 00:02:34.500 align:start position:0%
the values from a table or a query but
 

00:02:34.500 --> 00:02:36.229 align:start position:0%
the values from a table or a query but
I'm<00:02:34.620><c> going</c><00:02:34.830><c> to</c><00:02:34.920><c> select</c><00:02:35.070><c> the</c><00:02:35.370><c> second</c><00:02:35.730><c> option</c><00:02:35.850><c> so</c>

00:02:36.229 --> 00:02:36.239 align:start position:0%
I'm going to select the second option so
 

00:02:36.239 --> 00:02:38.060 align:start position:0%
I'm going to select the second option so
that<00:02:36.270><c> I</c><00:02:36.390><c> can</c><00:02:36.600><c> type</c><00:02:36.840><c> the</c><00:02:37.080><c> exact</c><00:02:37.470><c> values</c><00:02:37.830><c> that</c><00:02:38.010><c> I</c>

00:02:38.060 --> 00:02:38.070 align:start position:0%
that I can type the exact values that I
 

00:02:38.070 --> 00:02:43.870 align:start position:0%
that I can type the exact values that I
want<00:02:41.239><c> here</c><00:02:42.239><c> you</c><00:02:42.420><c> can</c><00:02:42.570><c> type</c><00:02:42.750><c> in</c><00:02:42.900><c> each</c><00:02:43.110><c> value</c><00:02:43.440><c> and</c>

00:02:43.870 --> 00:02:43.880 align:start position:0%
want here you can type in each value and
 

00:02:43.880 --> 00:02:46.490 align:start position:0%
want here you can type in each value and
in<00:02:44.880><c> most</c><00:02:45.090><c> cases</c><00:02:45.360><c> you'll</c><00:02:45.660><c> just</c><00:02:45.900><c> use</c><00:02:46.110><c> the</c><00:02:46.320><c> first</c>

00:02:46.490 --> 00:02:46.500 align:start position:0%
in most cases you'll just use the first
 

00:02:46.500 --> 00:02:49.400 align:start position:0%
in most cases you'll just use the first
column<00:02:47.060><c> I'm</c><00:02:48.060><c> typing</c><00:02:48.570><c> three</c><00:02:48.959><c> different</c><00:02:49.290><c> values</c>

00:02:49.400 --> 00:02:49.410 align:start position:0%
column I'm typing three different values
 

00:02:49.410 --> 00:02:51.620 align:start position:0%
column I'm typing three different values
and<00:02:49.800><c> I'm</c><00:02:50.250><c> pressing</c><00:02:50.610><c> the</c><00:02:50.730><c> tab</c><00:02:50.970><c> key</c><00:02:51.000><c> after</c><00:02:51.420><c> each</c>

00:02:51.620 --> 00:02:51.630 align:start position:0%
and I'm pressing the tab key after each
 

00:02:51.630 --> 00:02:55.670 align:start position:0%
and I'm pressing the tab key after each
one<00:02:52.050><c> to</c><00:02:52.260><c> go</c><00:02:52.410><c> to</c><00:02:52.470><c> the</c><00:02:52.560><c> next</c><00:02:52.800><c> row</c><00:02:53.040><c> and</c><00:02:54.590><c> if</c><00:02:55.590><c> you</c>

00:02:55.670 --> 00:02:55.680 align:start position:0%
one to go to the next row and if you
 

00:02:55.680 --> 00:02:57.170 align:start position:0%
one to go to the next row and if you
need<00:02:55.860><c> to</c><00:02:55.980><c> you</c><00:02:56.100><c> can</c><00:02:56.220><c> adjust</c><00:02:56.280><c> the</c><00:02:56.700><c> width</c><00:02:56.850><c> of</c><00:02:57.030><c> the</c>

00:02:57.170 --> 00:02:57.180 align:start position:0%
need to you can adjust the width of the
 

00:02:57.180 --> 00:03:02.900 align:start position:0%
need to you can adjust the width of the
column<00:02:57.480><c> and</c><00:02:58.850><c> then</c><00:02:59.850><c> click</c><00:03:00.090><c> Next</c><00:03:01.580><c> now</c><00:03:02.580><c> this</c><00:03:02.760><c> next</c>

00:03:02.900 --> 00:03:02.910 align:start position:0%
column and then click Next now this next
 

00:03:02.910 --> 00:03:05.120 align:start position:0%
column and then click Next now this next
step<00:03:03.090><c> is</c><00:03:03.330><c> very</c><00:03:03.420><c> important</c><00:03:04.230><c> when</c><00:03:04.860><c> the</c><00:03:04.950><c> user</c>

00:03:05.120 --> 00:03:05.130 align:start position:0%
step is very important when the user
 

00:03:05.130 --> 00:03:07.310 align:start position:0%
step is very important when the user
chooses<00:03:05.459><c> a</c><00:03:05.640><c> value</c><00:03:05.730><c> from</c><00:03:06.150><c> the</c><00:03:06.269><c> combo</c><00:03:06.570><c> box</c><00:03:06.600><c> we</c>

00:03:07.310 --> 00:03:07.320 align:start position:0%
chooses a value from the combo box we
 

00:03:07.320 --> 00:03:08.990 align:start position:0%
chooses a value from the combo box we
want<00:03:07.560><c> the</c><00:03:07.650><c> value</c><00:03:07.980><c> to</c><00:03:08.100><c> be</c><00:03:08.130><c> stored</c><00:03:08.610><c> in</c><00:03:08.820><c> the</c>

00:03:08.990 --> 00:03:09.000 align:start position:0%
want the value to be stored in the
 

00:03:09.000 --> 00:03:11.720 align:start position:0%
want the value to be stored in the
customers<00:03:09.450><c> table</c><00:03:09.920><c> we'll</c><00:03:10.920><c> need</c><00:03:11.070><c> to</c><00:03:11.220><c> select</c><00:03:11.370><c> the</c>

00:03:11.720 --> 00:03:11.730 align:start position:0%
customers table we'll need to select the
 

00:03:11.730 --> 00:03:14.570 align:start position:0%
customers table we'll need to select the
second<00:03:12.150><c> option</c><00:03:12.269><c> and</c><00:03:12.920><c> pick</c><00:03:13.920><c> the</c><00:03:14.070><c> field</c><00:03:14.280><c> that</c><00:03:14.459><c> we</c>

00:03:14.570 --> 00:03:14.580 align:start position:0%
second option and pick the field that we
 

00:03:14.580 --> 00:03:17.690 align:start position:0%
second option and pick the field that we
want<00:03:14.820><c> in</c><00:03:15.260><c> this</c><00:03:16.260><c> case</c><00:03:16.500><c> our</c><00:03:16.709><c> combo</c><00:03:17.100><c> box</c><00:03:17.310><c> is</c><00:03:17.549><c> going</c>

00:03:17.690 --> 00:03:17.700 align:start position:0%
want in this case our combo box is going
 

00:03:17.700 --> 00:03:19.789 align:start position:0%
want in this case our combo box is going
to<00:03:17.760><c> be</c><00:03:17.910><c> asking</c><00:03:18.299><c> about</c><00:03:18.510><c> the</c><00:03:18.720><c> mailing</c><00:03:19.080><c> list</c><00:03:19.320><c> so</c>

00:03:19.789 --> 00:03:19.799 align:start position:0%
to be asking about the mailing list so
 

00:03:19.799 --> 00:03:21.530 align:start position:0%
to be asking about the mailing list so
I'll<00:03:20.010><c> choose</c><00:03:20.310><c> the</c><00:03:20.549><c> add</c><00:03:20.730><c> to</c><00:03:21.030><c> mailing</c><00:03:21.209><c> list</c>

00:03:21.530 --> 00:03:21.540 align:start position:0%
I'll choose the add to mailing list
 

00:03:21.540 --> 00:03:24.030 align:start position:0%
I'll choose the add to mailing list
field

00:03:24.030 --> 00:03:24.040 align:start position:0%
 
 

00:03:24.040 --> 00:03:27.479 align:start position:0%
 
and<00:03:25.019><c> then</c><00:03:26.019><c> in</c><00:03:26.140><c> the</c><00:03:26.260><c> last</c><00:03:26.500><c> step</c><00:03:26.769><c> you</c><00:03:26.950><c> can</c><00:03:27.159><c> type</c><00:03:27.340><c> a</c>

00:03:27.479 --> 00:03:27.489 align:start position:0%
and then in the last step you can type a
 

00:03:27.489 --> 00:03:29.819 align:start position:0%
and then in the last step you can type a
label<00:03:27.670><c> I'm</c><00:03:28.450><c> going</c><00:03:28.840><c> to</c><00:03:28.930><c> call</c><00:03:29.109><c> it</c><00:03:29.260><c> add</c><00:03:29.439><c> to</c>

00:03:29.819 --> 00:03:29.829 align:start position:0%
label I'm going to call it add to
 

00:03:29.829 --> 00:03:35.449 align:start position:0%
label I'm going to call it add to
mailing<00:03:29.980><c> list</c><00:03:30.310><c> and</c><00:03:32.250><c> click</c><00:03:33.250><c> finish</c>

00:03:35.449 --> 00:03:35.459 align:start position:0%
mailing list and click finish
 

00:03:35.459 --> 00:03:39.030 align:start position:0%
mailing list and click finish
the<00:03:36.459><c> combo</c><00:03:36.790><c> box</c><00:03:36.819><c> will</c><00:03:37.239><c> appear</c><00:03:37.329><c> here</c><00:03:37.810><c> and</c><00:03:38.040><c> we</c>

00:03:39.030 --> 00:03:39.040 align:start position:0%
the combo box will appear here and we
 

00:03:39.040 --> 00:03:40.890 align:start position:0%
the combo box will appear here and we
don't<00:03:39.189><c> need</c><00:03:39.430><c> the</c><00:03:39.579><c> original</c><00:03:39.969><c> field</c><00:03:40.209><c> anymore</c><00:03:40.540><c> so</c>

00:03:40.890 --> 00:03:40.900 align:start position:0%
don't need the original field anymore so
 

00:03:40.900 --> 00:03:44.910 align:start position:0%
don't need the original field anymore so
we<00:03:40.989><c> can</c><00:03:41.019><c> delete</c><00:03:41.170><c> it</c><00:03:43.200><c> to</c><00:03:44.200><c> test</c><00:03:44.409><c> the</c><00:03:44.590><c> combo</c><00:03:44.890><c> box</c>

00:03:44.910 --> 00:03:44.920 align:start position:0%
we can delete it to test the combo box
 

00:03:44.920 --> 00:03:49.470 align:start position:0%
we can delete it to test the combo box
we<00:03:45.370><c> can</c><00:03:45.519><c> switch</c><00:03:45.819><c> to</c><00:03:45.849><c> form</c><00:03:46.359><c> view</c><00:03:46.450><c> and</c><00:03:48.450><c> you</c><00:03:49.450><c> can</c>

00:03:49.470 --> 00:03:49.480 align:start position:0%
we can switch to form view and you can
 

00:03:49.480 --> 00:03:53.119 align:start position:0%
we can switch to form view and you can
see<00:03:49.810><c> that</c><00:03:49.959><c> our</c><00:03:50.109><c> three</c><00:03:50.439><c> options</c><00:03:50.980><c> appear</c><00:03:51.430><c> here</c>

00:03:53.119 --> 00:03:53.129 align:start position:0%
see that our three options appear here
 

00:03:53.129 --> 00:03:56.550 align:start position:0%
see that our three options appear here
so<00:03:54.129><c> now</c><00:03:54.280><c> we</c><00:03:54.310><c> have</c><00:03:54.639><c> a</c><00:03:54.670><c> working</c><00:03:54.969><c> form</c><00:03:55.420><c> and</c><00:03:55.659><c> in</c><00:03:56.439><c> the</c>

00:03:56.550 --> 00:03:56.560 align:start position:0%
so now we have a working form and in the
 

00:03:56.560 --> 00:03:57.929 align:start position:0%
so now we have a working form and in the
next<00:03:56.799><c> couple</c><00:03:56.950><c> of</c><00:03:57.099><c> videos</c><00:03:57.159><c> we're</c><00:03:57.639><c> going</c><00:03:57.849><c> to</c>

00:03:57.929 --> 00:03:57.939 align:start position:0%
next couple of videos we're going to
 

00:03:57.939 --> 00:03:59.550 align:start position:0%
next couple of videos we're going to
make<00:03:58.060><c> some</c><00:03:58.299><c> more</c><00:03:58.480><c> adjustments</c><00:03:58.569><c> to</c><00:03:59.139><c> it</c><00:03:59.260><c> to</c><00:03:59.409><c> make</c>

00:03:59.550 --> 00:03:59.560 align:start position:0%
make some more adjustments to it to make
 

00:03:59.560 --> 00:04:02.489 align:start position:0%
make some more adjustments to it to make
it<00:03:59.680><c> better</c><00:03:59.859><c> suit</c><00:04:00.280><c> our</c><00:04:00.430><c> needs</c>