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.940 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.940 --> 00:00:10.950 align:start position:0%
 
 

00:00:10.950 --> 00:00:12.980 align:start position:0%
 
tables<00:00:11.820><c> are</c><00:00:12.000><c> the</c><00:00:12.060><c> heart</c><00:00:12.450><c> of</c><00:00:12.540><c> any</c><00:00:12.690><c> database</c>

00:00:12.980 --> 00:00:12.990 align:start position:0%
tables are the heart of any database
 

00:00:12.990 --> 00:00:14.750 align:start position:0%
tables are the heart of any database
because<00:00:13.650><c> they</c><00:00:13.920><c> are</c><00:00:14.070><c> where</c><00:00:14.280><c> the</c><00:00:14.430><c> actual</c>

00:00:14.750 --> 00:00:14.760 align:start position:0%
because they are where the actual
 

00:00:14.760 --> 00:00:17.300 align:start position:0%
because they are where the actual
information<00:00:15.480><c> is</c><00:00:15.630><c> stored</c><00:00:15.960><c> and</c><00:00:16.110><c> we're</c><00:00:17.040><c> going</c><00:00:17.220><c> to</c>

00:00:17.300 --> 00:00:17.310 align:start position:0%
information is stored and we're going to
 

00:00:17.310 --> 00:00:20.030 align:start position:0%
information is stored and we're going to
talk<00:00:17.490><c> about</c><00:00:17.520><c> how</c><00:00:17.940><c> to</c><00:00:17.970><c> add</c><00:00:18.480><c> edit</c><00:00:18.840><c> and</c><00:00:19.500><c> delete</c>

00:00:20.030 --> 00:00:20.040 align:start position:0%
talk about how to add edit and delete
 

00:00:20.040 --> 00:00:22.760 align:start position:0%
talk about how to add edit and delete
information<00:00:20.369><c> from</c><00:00:20.910><c> a</c><00:00:20.970><c> table</c><00:00:21.330><c> in</c><00:00:21.770><c> the</c>

00:00:22.760 --> 00:00:22.770 align:start position:0%
information from a table in the
 

00:00:22.770 --> 00:00:24.530 align:start position:0%
information from a table in the
navigation<00:00:23.160><c> pane</c><00:00:23.490><c> double-click</c><00:00:23.910><c> on</c><00:00:24.450><c> the</c>

00:00:24.530 --> 00:00:24.540 align:start position:0%
navigation pane double-click on the
 

00:00:24.540 --> 00:00:27.830 align:start position:0%
navigation pane double-click on the
table<00:00:24.840><c> that</c><00:00:24.900><c> you'd</c><00:00:25.050><c> like</c><00:00:25.200><c> to</c><00:00:25.349><c> open</c><00:00:25.500><c> and</c><00:00:26.840><c> tables</c>

00:00:27.830 --> 00:00:27.840 align:start position:0%
table that you'd like to open and tables
 

00:00:27.840 --> 00:00:29.810 align:start position:0%
table that you'd like to open and tables
will<00:00:28.020><c> be</c><00:00:28.110><c> marked</c><00:00:28.380><c> with</c><00:00:28.440><c> a</c><00:00:28.590><c> blue</c><00:00:28.890><c> icon</c><00:00:29.400><c> next</c><00:00:29.640><c> to</c>

00:00:29.810 --> 00:00:29.820 align:start position:0%
will be marked with a blue icon next to
 

00:00:29.820 --> 00:00:30.349 align:start position:0%
will be marked with a blue icon next to
the<00:00:29.970><c> name</c>

00:00:30.349 --> 00:00:30.359 align:start position:0%
the name
 

00:00:30.359 --> 00:00:33.229 align:start position:0%
the name
if<00:00:30.980><c> you've</c><00:00:31.980><c> used</c><00:00:32.010><c> Excel</c><00:00:32.669><c> or</c><00:00:32.940><c> another</c>

00:00:33.229 --> 00:00:33.239 align:start position:0%
if you've used Excel or another
 

00:00:33.239 --> 00:00:35.030 align:start position:0%
if you've used Excel or another
spreadsheet<00:00:33.600><c> program</c><00:00:34.170><c> then</c><00:00:34.650><c> you'll</c><00:00:34.860><c> probably</c>

00:00:35.030 --> 00:00:35.040 align:start position:0%
spreadsheet program then you'll probably
 

00:00:35.040 --> 00:00:37.400 align:start position:0%
spreadsheet program then you'll probably
find<00:00:35.460><c> tables</c><00:00:35.760><c> to</c><00:00:36.030><c> be</c><00:00:36.059><c> pretty</c><00:00:36.480><c> easy</c><00:00:36.660><c> to</c><00:00:36.870><c> use</c><00:00:36.900><c> and</c>

00:00:37.400 --> 00:00:37.410 align:start position:0%
find tables to be pretty easy to use and
 

00:00:37.410 --> 00:00:39.799 align:start position:0%
find tables to be pretty easy to use and
they<00:00:37.949><c> are</c><00:00:37.980><c> very</c><00:00:38.400><c> similar</c><00:00:38.699><c> but</c><00:00:39.390><c> there</c><00:00:39.570><c> are</c><00:00:39.660><c> some</c>

00:00:39.799 --> 00:00:39.809 align:start position:0%
they are very similar but there are some
 

00:00:39.809 --> 00:00:41.450 align:start position:0%
they are very similar but there are some
different<00:00:40.140><c> terms</c><00:00:40.410><c> that</c><00:00:40.650><c> we</c><00:00:40.769><c> use</c><00:00:40.800><c> when</c><00:00:41.280><c> talking</c>

00:00:41.450 --> 00:00:41.460 align:start position:0%
different terms that we use when talking
 

00:00:41.460 --> 00:00:45.469 align:start position:0%
different terms that we use when talking
about<00:00:41.730><c> an</c><00:00:41.940><c> access</c><00:00:42.059><c> table</c><00:00:43.400><c> each</c><00:00:44.400><c> row</c><00:00:44.879><c> is</c><00:00:45.210><c> called</c>

00:00:45.469 --> 00:00:45.479 align:start position:0%
about an access table each row is called
 

00:00:45.479 --> 00:00:48.200 align:start position:0%
about an access table each row is called
a<00:00:45.780><c> record</c><00:00:45.989><c> in</c><00:00:46.440><c> this</c><00:00:47.339><c> table</c><00:00:47.550><c> every</c><00:00:47.850><c> record</c>

00:00:48.200 --> 00:00:48.210 align:start position:0%
a record in this table every record
 

00:00:48.210 --> 00:00:50.869 align:start position:0%
a record in this table every record
contains<00:00:48.750><c> a</c><00:00:48.960><c> customer's</c><00:00:49.440><c> name</c><00:00:49.739><c> address</c><00:00:50.489><c> and</c>

00:00:50.869 --> 00:00:50.879 align:start position:0%
contains a customer's name address and
 

00:00:50.879 --> 00:00:53.780 align:start position:0%
contains a customer's name address and
other<00:00:51.299><c> information</c><00:00:52.129><c> each</c><00:00:53.129><c> record</c><00:00:53.519><c> will</c><00:00:53.760><c> have</c>

00:00:53.780 --> 00:00:53.790 align:start position:0%
other information each record will have
 

00:00:53.790 --> 00:00:56.210 align:start position:0%
other information each record will have
a<00:00:54.180><c> unique</c><00:00:54.570><c> ID</c><00:00:54.870><c> number</c><00:00:55.350><c> and</c><00:00:55.500><c> this</c><00:00:56.159><c> number</c>

00:00:56.210 --> 00:00:56.220 align:start position:0%
a unique ID number and this number
 

00:00:56.220 --> 00:00:57.649 align:start position:0%
a unique ID number and this number
cannot<00:00:56.909><c> be</c><00:00:57.120><c> changed</c>

00:00:57.649 --> 00:00:57.659 align:start position:0%
cannot be changed
 

00:00:57.659 --> 00:01:00.140 align:start position:0%
cannot be changed
so<00:00:58.290><c> Jerrod</c><00:00:58.769><c> Smith's</c><00:00:59.070><c> number</c><00:00:59.400><c> will</c><00:00:59.580><c> always</c><00:00:59.940><c> be</c>

00:01:00.140 --> 00:01:00.150 align:start position:0%
so Jerrod Smith's number will always be
 

00:01:00.150 --> 00:01:04.340 align:start position:0%
so Jerrod Smith's number will always be
three<00:01:00.510><c> no</c><00:01:00.780><c> matter</c><00:01:00.960><c> what</c><00:01:02.479><c> each</c><00:01:03.479><c> column</c><00:01:04.170><c> is</c>

00:01:04.340 --> 00:01:04.350 align:start position:0%
three no matter what each column is
 

00:01:04.350 --> 00:01:07.340 align:start position:0%
three no matter what each column is
called<00:01:04.710><c> a</c><00:01:04.920><c> field</c><00:01:05.250><c> and</c><00:01:05.549><c> each</c><00:01:06.330><c> field</c><00:01:06.540><c> contains</c><00:01:07.110><c> a</c>

00:01:07.340 --> 00:01:07.350 align:start position:0%
called a field and each field contains a
 

00:01:07.350 --> 00:01:09.890 align:start position:0%
called a field and each field contains a
different<00:01:07.500><c> type</c><00:01:07.950><c> of</c><00:01:07.979><c> information</c><00:01:08.900><c> for</c>

00:01:09.890 --> 00:01:09.900 align:start position:0%
different type of information for
 

00:01:09.900 --> 00:01:11.719 align:start position:0%
different type of information for
example<00:01:10.290><c> here</c><00:01:10.530><c> we</c><00:01:10.560><c> have</c><00:01:10.680><c> fields</c><00:01:11.310><c> for</c><00:01:11.549><c> the</c>

00:01:11.719 --> 00:01:11.729 align:start position:0%
example here we have fields for the
 

00:01:11.729 --> 00:01:17.620 align:start position:0%
example here we have fields for the
street<00:01:12.030><c> address</c><00:01:12.360><c> city</c><00:01:13.040><c> state</c><00:01:14.299><c> and</c><00:01:15.299><c> zip</c><00:01:15.439><c> code</c>

00:01:17.620 --> 00:01:17.630 align:start position:0%
street address city state and zip code
 

00:01:17.630 --> 00:01:20.660 align:start position:0%
street address city state and zip code
just<00:01:18.630><c> like</c><00:01:18.750><c> in</c><00:01:18.960><c> Excel</c><00:01:19.350><c> each</c><00:01:19.590><c> box</c><00:01:19.920><c> is</c><00:01:20.159><c> called</c><00:01:20.430><c> a</c>

00:01:20.660 --> 00:01:20.670 align:start position:0%
just like in Excel each box is called a
 

00:01:20.670 --> 00:01:22.819 align:start position:0%
just like in Excel each box is called a
cell<00:01:20.939><c> if</c><00:01:21.210><c> you</c><00:01:22.049><c> want</c><00:01:22.229><c> to</c><00:01:22.469><c> change</c><00:01:22.680><c> the</c>

00:01:22.819 --> 00:01:22.829 align:start position:0%
cell if you want to change the
 

00:01:22.829 --> 00:01:24.740 align:start position:0%
cell if you want to change the
information<00:01:23.039><c> in</c><00:01:23.399><c> a</c><00:01:23.490><c> cell</c><00:01:23.729><c> all</c><00:01:24.090><c> you</c><00:01:24.329><c> have</c><00:01:24.450><c> to</c><00:01:24.600><c> do</c>

00:01:24.740 --> 00:01:24.750 align:start position:0%
information in a cell all you have to do
 

00:01:24.750 --> 00:01:27.319 align:start position:0%
information in a cell all you have to do
is<00:01:25.020><c> select</c><00:01:25.380><c> it</c><00:01:25.740><c> and</c><00:01:25.920><c> then</c><00:01:26.609><c> type</c><00:01:26.909><c> in</c><00:01:27.090><c> the</c><00:01:27.179><c> new</c>

00:01:27.319 --> 00:01:27.329 align:start position:0%
is select it and then type in the new
 

00:01:27.329 --> 00:01:29.599 align:start position:0%
is select it and then type in the new
text<00:01:27.810><c> and</c><00:01:27.990><c> let's</c><00:01:28.649><c> say</c><00:01:28.829><c> that</c><00:01:28.979><c> this</c><00:01:29.130><c> customer</c>

00:01:29.599 --> 00:01:29.609 align:start position:0%
text and let's say that this customer
 

00:01:29.609 --> 00:01:33.980 align:start position:0%
text and let's say that this customer
has<00:01:29.820><c> a</c><00:01:29.850><c> new</c><00:01:30.270><c> email</c><00:01:30.539><c> address</c><00:01:31.219><c> after</c><00:01:32.600><c> you</c><00:01:33.600><c> edit</c><00:01:33.899><c> a</c>

00:01:33.980 --> 00:01:33.990 align:start position:0%
has a new email address after you edit a
 

00:01:33.990 --> 00:01:35.810 align:start position:0%
has a new email address after you edit a
record<00:01:34.109><c> you</c><00:01:34.409><c> can</c><00:01:34.560><c> save</c><00:01:34.799><c> it</c><00:01:34.979><c> by</c><00:01:35.009><c> clicking</c><00:01:35.159><c> save</c>

00:01:35.810 --> 00:01:35.820 align:start position:0%
record you can save it by clicking save
 

00:01:35.820 --> 00:01:37.850 align:start position:0%
record you can save it by clicking save
on<00:01:36.149><c> the</c><00:01:36.390><c> Home</c><00:01:36.539><c> tab</c>

00:01:37.850 --> 00:01:37.860 align:start position:0%
on the Home tab
 

00:01:37.860 --> 00:01:40.070 align:start position:0%
on the Home tab
but<00:01:38.550><c> whenever</c><00:01:38.940><c> you</c><00:01:39.090><c> click</c><00:01:39.360><c> out</c><00:01:39.570><c> of</c><00:01:39.600><c> a</c><00:01:39.840><c> cell</c>

00:01:40.070 --> 00:01:40.080 align:start position:0%
but whenever you click out of a cell
 

00:01:40.080 --> 00:01:42.050 align:start position:0%
but whenever you click out of a cell
it's<00:01:40.380><c> going</c><00:01:40.470><c> to</c><00:01:40.800><c> automatically</c><00:01:41.310><c> save</c><00:01:41.670><c> it</c><00:01:41.790><c> for</c>

00:01:42.050 --> 00:01:42.060 align:start position:0%
it's going to automatically save it for
 

00:01:42.060 --> 00:01:44.300 align:start position:0%
it's going to automatically save it for
you<00:01:42.240><c> so</c><00:01:43.050><c> if</c><00:01:43.320><c> you're</c><00:01:43.470><c> making</c><00:01:43.590><c> a</c><00:01:43.950><c> lot</c><00:01:44.190><c> of</c>

00:01:44.300 --> 00:01:44.310 align:start position:0%
you so if you're making a lot of
 

00:01:44.310 --> 00:01:45.620 align:start position:0%
you so if you're making a lot of
different<00:01:44.610><c> changes</c><00:01:44.790><c> you</c><00:01:45.210><c> don't</c><00:01:45.300><c> have</c><00:01:45.540><c> to</c>

00:01:45.620 --> 00:01:45.630 align:start position:0%
different changes you don't have to
 

00:01:45.630 --> 00:01:47.840 align:start position:0%
different changes you don't have to
worry<00:01:45.810><c> about</c><00:01:45.930><c> saving</c><00:01:46.290><c> each</c><00:01:46.650><c> record</c><00:01:47.010><c> but</c><00:01:47.640><c> it</c><00:01:47.730><c> is</c>

00:01:47.840 --> 00:01:47.850 align:start position:0%
worry about saving each record but it is
 

00:01:47.850 --> 00:01:49.400 align:start position:0%
worry about saving each record but it is
a<00:01:47.880><c> good</c><00:01:48.030><c> idea</c><00:01:48.300><c> to</c><00:01:48.420><c> save</c><00:01:48.660><c> the</c><00:01:48.690><c> last</c><00:01:49.050><c> one</c><00:01:49.290><c> that</c>

00:01:49.400 --> 00:01:49.410 align:start position:0%
a good idea to save the last one that
 

00:01:49.410 --> 00:01:50.840 align:start position:0%
a good idea to save the last one that
you're<00:01:49.500><c> working</c><00:01:49.620><c> on</c><00:01:49.920><c> just</c><00:01:50.370><c> to</c><00:01:50.460><c> make</c><00:01:50.490><c> sure</c><00:01:50.730><c> that</c>

00:01:50.840 --> 00:01:50.850 align:start position:0%
you're working on just to make sure that
 

00:01:50.850 --> 00:01:52.280 align:start position:0%
you're working on just to make sure that
you<00:01:50.970><c> don't</c><00:01:51.120><c> lose</c><00:01:51.390><c> any</c><00:01:51.420><c> changes</c><00:01:52.080><c> when</c><00:01:52.230><c> you</c>

00:01:52.280 --> 00:01:52.290 align:start position:0%
you don't lose any changes when you
 

00:01:52.290 --> 00:01:55.220 align:start position:0%
you don't lose any changes when you
close<00:01:52.500><c> the</c><00:01:52.710><c> database</c><00:01:53.100><c> if</c><00:01:53.870><c> you</c><00:01:54.870><c> are</c><00:01:55.020><c> editing</c>

00:01:55.220 --> 00:01:55.230 align:start position:0%
close the database if you are editing
 

00:01:55.230 --> 00:01:56.810 align:start position:0%
close the database if you are editing
more<00:01:55.560><c> than</c><00:01:55.710><c> one</c><00:01:55.830><c> record</c><00:01:56.010><c> you</c><00:01:56.310><c> can</c><00:01:56.460><c> use</c><00:01:56.640><c> the</c>

00:01:56.810 --> 00:01:56.820 align:start position:0%
more than one record you can use the
 

00:01:56.820 --> 00:01:58.430 align:start position:0%
more than one record you can use the
arrow<00:01:57.030><c> keys</c><00:01:57.360><c> on</c><00:01:57.390><c> your</c><00:01:57.630><c> keyboard</c><00:01:57.780><c> to</c><00:01:58.320><c> move</c>

00:01:58.430 --> 00:01:58.440 align:start position:0%
arrow keys on your keyboard to move
 

00:01:58.440 --> 00:02:02.660 align:start position:0%
arrow keys on your keyboard to move
between<00:01:58.680><c> records</c><00:01:59.630><c> or</c><00:02:00.740><c> if</c><00:02:01.740><c> you</c><00:02:01.860><c> prefer</c><00:02:02.220><c> you</c><00:02:02.520><c> can</c>

00:02:02.660 --> 00:02:02.670 align:start position:0%
between records or if you prefer you can
 

00:02:02.670 --> 00:02:04.670 align:start position:0%
between records or if you prefer you can
use<00:02:02.880><c> the</c><00:02:03.030><c> arrows</c><00:02:03.390><c> on</c><00:02:03.420><c> the</c><00:02:03.810><c> record</c><00:02:04.110><c> navigation</c>

00:02:04.670 --> 00:02:04.680 align:start position:0%
use the arrows on the record navigation
 

00:02:04.680 --> 00:02:08.630 align:start position:0%
use the arrows on the record navigation
bar<00:02:04.890><c> you</c><00:02:06.770><c> can</c><00:02:07.770><c> also</c><00:02:07.860><c> use</c><00:02:08.220><c> the</c><00:02:08.399><c> record</c>

00:02:08.630 --> 00:02:08.640 align:start position:0%
bar you can also use the record
 

00:02:08.640 --> 00:02:10.639 align:start position:0%
bar you can also use the record
navigation<00:02:08.759><c> bar</c><00:02:09.360><c> to</c><00:02:09.390><c> create</c><00:02:09.750><c> a</c><00:02:09.960><c> new</c><00:02:10.350><c> record</c>

00:02:10.639 --> 00:02:10.649 align:start position:0%
navigation bar to create a new record
 

00:02:10.649 --> 00:02:12.920 align:start position:0%
navigation bar to create a new record
and<00:02:11.360><c> then</c><00:02:12.360><c> type</c><00:02:12.600><c> in</c><00:02:12.720><c> the</c><00:02:12.750><c> person's</c>

00:02:12.920 --> 00:02:12.930 align:start position:0%
and then type in the person's
 

00:02:12.930 --> 00:02:18.800 align:start position:0%
and then type in the person's
information<00:02:14.540><c> if</c><00:02:17.030><c> you</c><00:02:18.030><c> want</c><00:02:18.240><c> to</c><00:02:18.450><c> delete</c><00:02:18.750><c> a</c>

00:02:18.800 --> 00:02:18.810 align:start position:0%
information if you want to delete a
 

00:02:18.810 --> 00:02:20.810 align:start position:0%
information if you want to delete a
record<00:02:19.020><c> click</c><00:02:19.590><c> the</c><00:02:19.800><c> margin</c><00:02:20.250><c> on</c><00:02:20.400><c> the</c><00:02:20.520><c> left</c><00:02:20.700><c> side</c>

00:02:20.810 --> 00:02:20.820 align:start position:0%
record click the margin on the left side
 

00:02:20.820 --> 00:02:24.470 align:start position:0%
record click the margin on the left side
of<00:02:20.970><c> the</c><00:02:21.030><c> record</c><00:02:21.330><c> and</c><00:02:23.000><c> then</c><00:02:24.000><c> on</c><00:02:24.120><c> the</c><00:02:24.240><c> Home</c><00:02:24.450><c> tab</c>

00:02:24.470 --> 00:02:24.480 align:start position:0%
of the record and then on the Home tab
 

00:02:24.480 --> 00:02:28.760 align:start position:0%
of the record and then on the Home tab
click<00:02:25.080><c> the</c><00:02:25.110><c> delete</c><00:02:25.650><c> command</c><00:02:27.650><c> and</c><00:02:28.650><c> now</c>

00:02:28.760 --> 00:02:28.770 align:start position:0%
click the delete command and now
 

00:02:28.770 --> 00:02:30.260 align:start position:0%
click the delete command and now
normally<00:02:29.310><c> you</c><00:02:29.430><c> should</c><00:02:29.580><c> avoid</c><00:02:29.880><c> deleting</c>

00:02:30.260 --> 00:02:30.270 align:start position:0%
normally you should avoid deleting
 

00:02:30.270 --> 00:02:32.270 align:start position:0%
normally you should avoid deleting
records<00:02:30.570><c> because</c><00:02:31.410><c> it</c><00:02:31.590><c> can</c><00:02:31.740><c> negatively</c><00:02:31.980><c> impact</c>

00:02:32.270 --> 00:02:32.280 align:start position:0%
records because it can negatively impact
 

00:02:32.280 --> 00:02:35.030 align:start position:0%
records because it can negatively impact
the<00:02:32.940><c> database</c><00:02:33.420><c> if</c><00:02:33.690><c> other</c><00:02:33.930><c> objects</c><00:02:34.440><c> refer</c><00:02:34.800><c> to</c>

00:02:35.030 --> 00:02:35.040 align:start position:0%
the database if other objects refer to
 

00:02:35.040 --> 00:02:37.460 align:start position:0%
the database if other objects refer to
the<00:02:35.160><c> record</c><00:02:35.370><c> for</c><00:02:36.300><c> example</c><00:02:36.690><c> if</c><00:02:36.780><c> we</c><00:02:36.930><c> deleted</c><00:02:37.320><c> a</c>

00:02:37.460 --> 00:02:37.470 align:start position:0%
the record for example if we deleted a
 

00:02:37.470 --> 00:02:39.530 align:start position:0%
the record for example if we deleted a
customer's<00:02:37.980><c> record</c><00:02:38.400><c> it</c><00:02:38.610><c> could</c><00:02:39.090><c> cause</c><00:02:39.330><c> the</c>

00:02:39.530 --> 00:02:39.540 align:start position:0%
customer's record it could cause the
 

00:02:39.540 --> 00:02:41.390 align:start position:0%
customer's record it could cause the
information<00:02:40.050><c> in</c><00:02:40.230><c> the</c><00:02:40.380><c> orders</c><00:02:40.770><c> table</c><00:02:40.980><c> to</c><00:02:41.250><c> be</c>

00:02:41.390 --> 00:02:41.400 align:start position:0%
information in the orders table to be
 

00:02:41.400 --> 00:02:44.270 align:start position:0%
information in the orders table to be
incomplete<00:02:42.350><c> but</c><00:02:43.350><c> if</c><00:02:43.530><c> you're</c><00:02:43.650><c> just</c><00:02:43.860><c> deleting</c><00:02:44.190><c> a</c>

00:02:44.270 --> 00:02:44.280 align:start position:0%
incomplete but if you're just deleting a
 

00:02:44.280 --> 00:02:45.710 align:start position:0%
incomplete but if you're just deleting a
brand-new<00:02:44.670><c> record</c><00:02:44.880><c> then</c><00:02:45.180><c> it's</c><00:02:45.330><c> generally</c>

00:02:45.710 --> 00:02:45.720 align:start position:0%
brand-new record then it's generally
 

00:02:45.720 --> 00:02:50.500 align:start position:0%
brand-new record then it's generally
okay

00:02:50.500 --> 00:02:50.510 align:start position:0%
 
 

00:02:50.510 --> 00:02:53.089 align:start position:0%
 
for<00:02:51.510><c> some</c><00:02:51.720><c> edits</c><00:02:52.020><c> you</c><00:02:52.200><c> may</c><00:02:52.349><c> want</c><00:02:52.560><c> to</c><00:02:52.620><c> use</c><00:02:52.890><c> the</c>

00:02:53.089 --> 00:02:53.099 align:start position:0%
for some edits you may want to use the
 

00:02:53.099 --> 00:02:54.949 align:start position:0%
for some edits you may want to use the
Find<00:02:53.430><c> and</c><00:02:53.580><c> Replace</c><00:02:53.670><c> option</c><00:02:54.180><c> to</c><00:02:54.569><c> make</c><00:02:54.690><c> a</c><00:02:54.720><c> lot</c><00:02:54.930><c> of</c>

00:02:54.949 --> 00:02:54.959 align:start position:0%
Find and Replace option to make a lot of
 

00:02:54.959 --> 00:02:58.010 align:start position:0%
Find and Replace option to make a lot of
changes<00:02:55.380><c> at</c><00:02:55.500><c> once</c><00:02:55.849><c> I'm</c><00:02:56.849><c> going</c><00:02:57.180><c> to</c><00:02:57.270><c> open</c><00:02:57.510><c> up</c><00:02:57.810><c> the</c>

00:02:58.010 --> 00:02:58.020 align:start position:0%
changes at once I'm going to open up the
 

00:02:58.020 --> 00:03:02.600 align:start position:0%
changes at once I'm going to open up the
products<00:02:58.530><c> table</c><00:02:58.890><c> and</c><00:03:00.709><c> on</c><00:03:01.709><c> the</c><00:03:01.830><c> Home</c><00:03:01.980><c> tab</c><00:03:02.010><c> click</c>

00:03:02.600 --> 00:03:02.610 align:start position:0%
products table and on the Home tab click
 

00:03:02.610 --> 00:03:06.290 align:start position:0%
products table and on the Home tab click
the<00:03:02.940><c> replace</c><00:03:03.420><c> command</c><00:03:03.480><c> and</c><00:03:05.120><c> let's</c><00:03:06.120><c> say</c><00:03:06.270><c> that</c>

00:03:06.290 --> 00:03:06.300 align:start position:0%
the replace command and let's say that
 

00:03:06.300 --> 00:03:08.180 align:start position:0%
the replace command and let's say that
in<00:03:06.510><c> some</c><00:03:06.660><c> of</c><00:03:06.690><c> our</c><00:03:06.870><c> seasonal</c><00:03:07.319><c> products</c><00:03:07.770><c> we</c><00:03:08.069><c> want</c>

00:03:08.180 --> 00:03:08.190 align:start position:0%
in some of our seasonal products we want
 

00:03:08.190 --> 00:03:11.660 align:start position:0%
in some of our seasonal products we want
to<00:03:08.310><c> change</c><00:03:08.580><c> the</c><00:03:08.790><c> word</c><00:03:08.910><c> fall</c><00:03:09.330><c> to</c><00:03:09.720><c> autumn</c><00:03:10.670><c> type</c>

00:03:11.660 --> 00:03:11.670 align:start position:0%
to change the word fall to autumn type
 

00:03:11.670 --> 00:03:13.210 align:start position:0%
to change the word fall to autumn type
in<00:03:11.850><c> the</c><00:03:11.940><c> word</c><00:03:12.060><c> that</c><00:03:12.090><c> you're</c><00:03:12.330><c> looking</c><00:03:12.600><c> for</c><00:03:12.840><c> and</c>

00:03:13.210 --> 00:03:13.220 align:start position:0%
in the word that you're looking for and
 

00:03:13.220 --> 00:03:15.550 align:start position:0%
in the word that you're looking for and
the<00:03:14.220><c> word</c><00:03:14.370><c> that</c><00:03:14.400><c> you</c><00:03:14.580><c> want</c><00:03:14.610><c> it</c><00:03:14.790><c> replaced</c><00:03:15.030><c> with</c>

00:03:15.550 --> 00:03:15.560 align:start position:0%
the word that you want it replaced with
 

00:03:15.560 --> 00:03:19.759 align:start position:0%
the word that you want it replaced with
and<00:03:17.390><c> we'll</c><00:03:18.390><c> select</c><00:03:18.569><c> current</c><00:03:19.140><c> document</c><00:03:19.620><c> so</c>

00:03:19.759 --> 00:03:19.769 align:start position:0%
and we'll select current document so
 

00:03:19.769 --> 00:03:21.320 align:start position:0%
and we'll select current document so
it'll<00:03:19.950><c> search</c><00:03:20.130><c> throughout</c><00:03:20.459><c> the</c><00:03:20.700><c> entire</c><00:03:21.030><c> table</c>

00:03:21.320 --> 00:03:21.330 align:start position:0%
it'll search throughout the entire table
 

00:03:21.330 --> 00:03:24.080 align:start position:0%
it'll search throughout the entire table
and<00:03:22.069><c> we</c><00:03:23.069><c> want</c><00:03:23.220><c> to</c><00:03:23.310><c> look</c><00:03:23.400><c> for</c><00:03:23.459><c> matches</c><00:03:23.730><c> that</c>

00:03:24.080 --> 00:03:24.090 align:start position:0%
and we want to look for matches that
 

00:03:24.090 --> 00:03:28.820 align:start position:0%
and we want to look for matches that
appear<00:03:24.390><c> in</c><00:03:24.420><c> any</c><00:03:24.780><c> part</c><00:03:25.140><c> of</c><00:03:25.230><c> the</c><00:03:25.290><c> field</c><00:03:27.830><c> click</c>

00:03:28.820 --> 00:03:28.830 align:start position:0%
appear in any part of the field click
 

00:03:28.830 --> 00:03:32.270 align:start position:0%
appear in any part of the field click
find<00:03:29.190><c> next</c><00:03:29.489><c> to</c><00:03:29.760><c> look</c><00:03:29.910><c> for</c><00:03:30.090><c> the</c><00:03:30.150><c> word</c><00:03:30.330><c> and</c><00:03:31.280><c> it</c>

00:03:32.270 --> 00:03:32.280 align:start position:0%
find next to look for the word and it
 

00:03:32.280 --> 00:03:33.920 align:start position:0%
find next to look for the word and it
looks<00:03:32.489><c> like</c><00:03:32.580><c> the</c><00:03:32.790><c> first</c><00:03:33.060><c> instance</c><00:03:33.569><c> of</c><00:03:33.690><c> fall</c>

00:03:33.920 --> 00:03:33.930 align:start position:0%
looks like the first instance of fall
 

00:03:33.930 --> 00:03:36.350 align:start position:0%
looks like the first instance of fall
isn't<00:03:34.440><c> referring</c><00:03:34.680><c> to</c><00:03:34.980><c> the</c><00:03:35.100><c> season</c><00:03:35.549><c> so</c><00:03:36.120><c> we'll</c>

00:03:36.350 --> 00:03:36.360 align:start position:0%
isn't referring to the season so we'll
 

00:03:36.360 --> 00:03:40.120 align:start position:0%
isn't referring to the season so we'll
skip<00:03:36.690><c> this</c><00:03:36.959><c> one</c><00:03:37.019><c> and</c><00:03:37.470><c> find</c><00:03:38.280><c> the</c><00:03:38.459><c> next</c><00:03:38.670><c> one</c>

00:03:40.120 --> 00:03:40.130 align:start position:0%
skip this one and find the next one
 

00:03:40.130 --> 00:03:42.170 align:start position:0%
skip this one and find the next one
and<00:03:41.130><c> when</c><00:03:41.280><c> you</c><00:03:41.370><c> get</c><00:03:41.489><c> to</c><00:03:41.610><c> one</c><00:03:41.730><c> that</c><00:03:41.819><c> you</c><00:03:41.940><c> want</c><00:03:42.120><c> to</c>

00:03:42.170 --> 00:03:42.180 align:start position:0%
and when you get to one that you want to
 

00:03:42.180 --> 00:03:45.440 align:start position:0%
and when you get to one that you want to
change<00:03:42.390><c> click</c><00:03:42.780><c> replace</c><00:03:43.819><c> and</c><00:03:44.819><c> just</c><00:03:45.090><c> go</c><00:03:45.209><c> through</c>

00:03:45.440 --> 00:03:45.450 align:start position:0%
change click replace and just go through
 

00:03:45.450 --> 00:03:47.180 align:start position:0%
change click replace and just go through
each<00:03:45.630><c> one</c><00:03:45.660><c> and</c><00:03:46.230><c> decide</c><00:03:46.620><c> whether</c><00:03:46.830><c> you</c><00:03:46.980><c> want</c><00:03:47.160><c> to</c>

00:03:47.180 --> 00:03:47.190 align:start position:0%
each one and decide whether you want to
 

00:03:47.190 --> 00:03:54.800 align:start position:0%
each one and decide whether you want to
replace<00:03:47.489><c> it</c><00:03:50.330><c> and</c><00:03:53.239><c> generally</c><00:03:54.239><c> you</c><00:03:54.359><c> don't</c><00:03:54.570><c> want</c>

00:03:54.800 --> 00:03:54.810 align:start position:0%
replace it and generally you don't want
 

00:03:54.810 --> 00:03:57.050 align:start position:0%
replace it and generally you don't want
to<00:03:54.870><c> use</c><00:03:54.989><c> replace</c><00:03:55.440><c> all</c><00:03:55.829><c> because</c><00:03:56.579><c> that</c><00:03:56.850><c> doesn't</c>

00:03:57.050 --> 00:03:57.060 align:start position:0%
to use replace all because that doesn't
 

00:03:57.060 --> 00:03:58.940 align:start position:0%
to use replace all because that doesn't
give<00:03:57.299><c> you</c><00:03:57.390><c> the</c><00:03:57.450><c> option</c><00:03:57.989><c> of</c><00:03:58.109><c> skipping</c><00:03:58.350><c> any</c><00:03:58.799><c> of</c>

00:03:58.940 --> 00:03:58.950 align:start position:0%
give you the option of skipping any of
 

00:03:58.950 --> 00:04:00.860 align:start position:0%
give you the option of skipping any of
them<00:03:59.100><c> so</c><00:03:59.910><c> you</c><00:03:59.970><c> should</c><00:04:00.239><c> only</c><00:04:00.359><c> use</c><00:04:00.450><c> this</c><00:04:00.690><c> option</c>

00:04:00.860 --> 00:04:00.870 align:start position:0%
them so you should only use this option
 

00:04:00.870 --> 00:04:02.750 align:start position:0%
them so you should only use this option
if<00:04:01.200><c> you're</c><00:04:01.380><c> absolutely</c><00:04:01.829><c> sure</c><00:04:02.280><c> that</c><00:04:02.310><c> it</c><00:04:02.519><c> won't</c>

00:04:02.750 --> 00:04:02.760 align:start position:0%
if you're absolutely sure that it won't
 

00:04:02.760 --> 00:04:07.720 align:start position:0%
if you're absolutely sure that it won't
replace<00:04:03.120><c> anything</c><00:04:03.480><c> that</c><00:04:03.780><c> you</c><00:04:03.870><c> don't</c><00:04:04.079><c> want</c><00:04:04.700><c> as</c>

00:04:07.720 --> 00:04:07.730 align:start position:0%
 
 

00:04:07.730 --> 00:04:10.670 align:start position:0%
 
you<00:04:08.730><c> practice</c><00:04:09.120><c> editing</c><00:04:09.299><c> tables</c><00:04:09.720><c> keep</c><00:04:10.350><c> in</c><00:04:10.470><c> mind</c>

00:04:10.670 --> 00:04:10.680 align:start position:0%
you practice editing tables keep in mind
 

00:04:10.680 --> 00:04:12.199 align:start position:0%
you practice editing tables keep in mind
that<00:04:10.859><c> most</c><00:04:11.220><c> of</c><00:04:11.400><c> your</c><00:04:11.489><c> changes</c><00:04:11.910><c> are</c><00:04:12.060><c> saved</c>

00:04:12.199 --> 00:04:12.209 align:start position:0%
that most of your changes are saved
 

00:04:12.209 --> 00:04:14.870 align:start position:0%
that most of your changes are saved
automatically<00:04:12.900><c> so</c><00:04:13.650><c> to</c><00:04:13.709><c> be</c><00:04:13.980><c> safe</c><00:04:14.190><c> you</c><00:04:14.430><c> may</c><00:04:14.640><c> want</c>

00:04:14.870 --> 00:04:14.880 align:start position:0%
automatically so to be safe you may want
 

00:04:14.880 --> 00:04:18.859 align:start position:0%
automatically so to be safe you may want
to<00:04:14.940><c> create</c><00:04:15.180><c> new</c><00:04:15.630><c> records</c><00:04:16.079><c> to</c><00:04:16.229><c> practice</c><00:04:16.650><c> with</c>