WEBVTT
Kind: captions
Language: en

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

00:00:11.310 --> 00:00:11.320 align:start position:0%
 
 

00:00:11.320 --> 00:00:13.449 align:start position:0%
 
tables<00:00:12.320><c> are</c><00:00:12.500><c> the</c><00:00:12.559><c> heart</c><00:00:12.950><c> of</c><00:00:13.070><c> any</c><00:00:13.250><c> database</c>

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

00:00:13.459 --> 00:00:15.250 align:start position:0%
tables are the heart of any database
because<00:00:14.150><c> they</c><00:00:14.420><c> are</c><00:00:14.570><c> where</c><00:00:14.780><c> the</c><00:00:14.930><c> actual</c>

00:00:15.250 --> 00:00:15.260 align:start position:0%
because they are where the actual
 

00:00:15.260 --> 00:00:17.800 align:start position:0%
because they are where the actual
information<00:00:15.980><c> is</c><00:00:16.129><c> stored</c><00:00:16.460><c> and</c><00:00:16.610><c> we're</c><00:00:17.540><c> going</c><00:00:17.720><c> to</c>

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

00:00:17.810 --> 00:00:20.530 align:start position:0%
information is stored and we're going to
talk<00:00:17.990><c> about</c><00:00:18.020><c> how</c><00:00:18.439><c> to</c><00:00:18.500><c> add</c><00:00:18.980><c> edit</c><00:00:19.340><c> and</c><00:00:20.000><c> delete</c>

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

00:00:20.540 --> 00:00:23.290 align:start position:0%
talk about how to add edit and delete
information<00:00:20.869><c> from</c><00:00:21.410><c> a</c><00:00:21.470><c> table</c><00:00:21.860><c> in</c><00:00:22.300><c> the</c>

00:00:23.290 --> 00:00:23.300 align:start position:0%
information from a table in the
 

00:00:23.300 --> 00:00:25.060 align:start position:0%
information from a table in the
navigation<00:00:23.689><c> pane</c><00:00:24.020><c> double-click</c><00:00:24.439><c> on</c><00:00:24.950><c> the</c>

00:00:25.060 --> 00:00:25.070 align:start position:0%
navigation pane double-click on the
 

00:00:25.070 --> 00:00:27.519 align:start position:0%
navigation pane double-click on the
table<00:00:25.340><c> that</c><00:00:25.430><c> you'd</c><00:00:25.550><c> like</c><00:00:25.700><c> to</c><00:00:25.849><c> open</c><00:00:26.180><c> and</c><00:00:26.529><c> tables</c>

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

00:00:27.529 --> 00:00:29.530 align:start position:0%
table that you'd like to open and tables
will<00:00:27.710><c> be</c><00:00:27.800><c> marked</c><00:00:28.070><c> with</c><00:00:28.130><c> a</c><00:00:28.279><c> blue</c><00:00:28.579><c> icon</c><00:00:28.820><c> next</c><00:00:29.360><c> to</c>

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

00:00:29.540 --> 00:00:30.069 align:start position:0%
will be marked with a blue icon next to
the<00:00:29.660><c> name</c>

00:00:30.069 --> 00:00:30.079 align:start position:0%
the name
 

00:00:30.079 --> 00:00:32.710 align:start position:0%
the name
if<00:00:30.460><c> you've</c><00:00:31.460><c> used</c><00:00:31.489><c> Excel</c><00:00:32.149><c> or</c><00:00:32.450><c> another</c>

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

00:00:32.720 --> 00:00:34.540 align:start position:0%
if you've used Excel or another
spreadsheet<00:00:33.110><c> program</c><00:00:33.680><c> then</c><00:00:34.160><c> you'll</c><00:00:34.340><c> probably</c>

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

00:00:34.550 --> 00:00:36.880 align:start position:0%
spreadsheet program then you'll probably
find<00:00:34.969><c> tables</c><00:00:35.239><c> to</c><00:00:35.540><c> be</c><00:00:35.630><c> pretty</c><00:00:35.960><c> easy</c><00:00:36.170><c> to</c><00:00:36.380><c> use</c><00:00:36.410><c> and</c>

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

00:00:36.890 --> 00:00:39.310 align:start position:0%
find tables to be pretty easy to use and
they<00:00:37.430><c> are</c><00:00:37.460><c> very</c><00:00:37.880><c> similar</c><00:00:38.180><c> but</c><00:00:38.899><c> there</c><00:00:39.050><c> are</c><00:00:39.170><c> some</c>

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

00:00:39.320 --> 00:00:41.020 align:start position:0%
they are very similar but there are some
different<00:00:39.620><c> terms</c><00:00:39.920><c> that</c><00:00:40.130><c> we</c><00:00:40.250><c> use</c><00:00:40.280><c> when</c><00:00:40.790><c> talking</c>

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

00:00:41.030 --> 00:00:44.349 align:start position:0%
different terms that we use when talking
about<00:00:41.210><c> an</c><00:00:41.449><c> access</c><00:00:41.570><c> table</c><00:00:42.280><c> each</c><00:00:43.280><c> row</c><00:00:43.760><c> is</c><00:00:44.089><c> called</c>

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

00:00:44.359 --> 00:00:47.229 align:start position:0%
about an access table each row is called
a<00:00:44.660><c> record</c><00:00:44.870><c> in</c><00:00:45.320><c> this</c><00:00:46.219><c> table</c><00:00:46.460><c> every</c><00:00:46.730><c> record</c>

00:00:47.229 --> 00:00:47.239 align:start position:0%
a record in this table every record
 

00:00:47.239 --> 00:00:49.840 align:start position:0%
a record in this table every record
contains<00:00:47.660><c> a</c><00:00:47.839><c> customer's</c><00:00:48.320><c> name</c><00:00:48.589><c> address</c><00:00:49.399><c> and</c>

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

00:00:49.850 --> 00:00:52.810 align:start position:0%
contains a customer's name address and
other<00:00:50.210><c> information</c><00:00:51.070><c> each</c><00:00:52.070><c> record</c><00:00:52.399><c> will</c><00:00:52.640><c> have</c>

00:00:52.810 --> 00:00:52.820 align:start position:0%
other information each record will have
 

00:00:52.820 --> 00:00:55.090 align:start position:0%
other information each record will have
a<00:00:53.089><c> unique</c><00:00:53.480><c> ID</c><00:00:53.749><c> number</c><00:00:54.230><c> and</c><00:00:54.379><c> this</c><00:00:55.039><c> number</c>

00:00:55.090 --> 00:00:55.100 align:start position:0%
a unique ID number and this number
 

00:00:55.100 --> 00:00:56.560 align:start position:0%
a unique ID number and this number
cannot<00:00:55.820><c> be</c><00:00:55.879><c> changed</c>

00:00:56.560 --> 00:00:56.570 align:start position:0%
cannot be changed
 

00:00:56.570 --> 00:00:59.049 align:start position:0%
cannot be changed
so<00:00:57.230><c> Jerrod</c><00:00:57.679><c> Smith's</c><00:00:57.980><c> number</c><00:00:58.309><c> will</c><00:00:58.489><c> always</c><00:00:58.730><c> be</c>

00:00:59.049 --> 00:00:59.059 align:start position:0%
so Jerrod Smith's number will always be
 

00:00:59.059 --> 00:01:01.520 align:start position:0%
so Jerrod Smith's number will always be
three<00:00:59.300><c> no</c><00:00:59.690><c> matter</c><00:00:59.870><c> what</c>

00:01:01.520 --> 00:01:01.530 align:start position:0%
three no matter what
 

00:01:01.530 --> 00:01:05.030 align:start position:0%
three no matter what
each<00:01:02.130><c> column</c><00:01:02.850><c> is</c><00:01:03.030><c> called</c><00:01:03.420><c> a</c><00:01:03.630><c> field</c><00:01:03.960><c> and</c><00:01:04.230><c> each</c>

00:01:05.030 --> 00:01:05.040 align:start position:0%
each column is called a field and each
 

00:01:05.040 --> 00:01:06.680 align:start position:0%
each column is called a field and each
field<00:01:05.309><c> contains</c><00:01:05.430><c> a</c><00:01:06.060><c> different</c><00:01:06.210><c> type</c><00:01:06.660><c> of</c>

00:01:06.680 --> 00:01:06.690 align:start position:0%
field contains a different type of
 

00:01:06.690 --> 00:01:09.230 align:start position:0%
field contains a different type of
information<00:01:07.280><c> for</c><00:01:08.280><c> example</c><00:01:08.370><c> here</c><00:01:08.910><c> we</c><00:01:09.030><c> have</c>

00:01:09.230 --> 00:01:09.240 align:start position:0%
information for example here we have
 

00:01:09.240 --> 00:01:11.780 align:start position:0%
information for example here we have
fields<00:01:09.690><c> for</c><00:01:09.750><c> the</c><00:01:10.110><c> street</c><00:01:10.410><c> address</c><00:01:10.740><c> city</c><00:01:11.520><c> state</c>

00:01:11.780 --> 00:01:11.790 align:start position:0%
fields for the street address city state
 

00:01:11.790 --> 00:01:16.040 align:start position:0%
fields for the street address city state
and<00:01:12.660><c> zip</c><00:01:12.750><c> code</c><00:01:13.760><c> just</c><00:01:14.760><c> like</c><00:01:14.970><c> in</c><00:01:15.090><c> Excel</c><00:01:15.210><c> each</c><00:01:15.720><c> box</c>

00:01:16.040 --> 00:01:16.050 align:start position:0%
and zip code just like in Excel each box
 

00:01:16.050 --> 00:01:18.740 align:start position:0%
and zip code just like in Excel each box
is<00:01:16.290><c> called</c><00:01:16.500><c> a</c><00:01:16.800><c> cell</c><00:01:17.070><c> if</c><00:01:17.360><c> you</c><00:01:18.360><c> want</c><00:01:18.540><c> to</c><00:01:18.630><c> change</c>

00:01:18.740 --> 00:01:18.750 align:start position:0%
is called a cell if you want to change
 

00:01:18.750 --> 00:01:20.570 align:start position:0%
is called a cell if you want to change
the<00:01:18.960><c> information</c><00:01:19.470><c> in</c><00:01:19.560><c> a</c><00:01:19.650><c> cell</c><00:01:19.860><c> all</c><00:01:20.130><c> you</c><00:01:20.460><c> have</c>

00:01:20.570 --> 00:01:20.580 align:start position:0%
the information in a cell all you have
 

00:01:20.580 --> 00:01:23.240 align:start position:0%
the information in a cell all you have
to<00:01:20.729><c> do</c><00:01:20.880><c> is</c><00:01:21.150><c> select</c><00:01:21.510><c> it</c><00:01:21.869><c> and</c><00:01:22.050><c> then</c><00:01:22.710><c> type</c><00:01:23.070><c> in</c><00:01:23.220><c> the</c>

00:01:23.240 --> 00:01:23.250 align:start position:0%
to do is select it and then type in the
 

00:01:23.250 --> 00:01:25.250 align:start position:0%
to do is select it and then type in the
new<00:01:23.460><c> text</c><00:01:23.970><c> and</c><00:01:24.119><c> let's</c><00:01:24.780><c> say</c><00:01:24.960><c> that</c><00:01:24.990><c> this</c>

00:01:25.250 --> 00:01:25.260 align:start position:0%
new text and let's say that this
 

00:01:25.260 --> 00:01:27.730 align:start position:0%
new text and let's say that this
customer<00:01:25.740><c> has</c><00:01:25.979><c> a</c><00:01:26.010><c> new</c><00:01:26.430><c> email</c><00:01:26.850><c> address</c><00:01:27.000><c> after</c>

00:01:27.730 --> 00:01:27.740 align:start position:0%
customer has a new email address after
 

00:01:27.740 --> 00:01:30.230 align:start position:0%
customer has a new email address after
you<00:01:28.740><c> edit</c><00:01:29.040><c> a</c><00:01:29.100><c> record</c><00:01:29.220><c> you</c><00:01:29.520><c> can</c><00:01:29.700><c> save</c><00:01:29.940><c> it</c><00:01:30.090><c> by</c>

00:01:30.230 --> 00:01:30.240 align:start position:0%
you edit a record you can save it by
 

00:01:30.240 --> 00:01:33.440 align:start position:0%
you edit a record you can save it by
clicking<00:01:30.270><c> save</c><00:01:30.990><c> on</c><00:01:31.290><c> the</c><00:01:31.500><c> Home</c><00:01:31.680><c> tab</c><00:01:32.450><c> but</c>

00:01:33.440 --> 00:01:33.450 align:start position:0%
clicking save on the Home tab but
 

00:01:33.450 --> 00:01:35.270 align:start position:0%
clicking save on the Home tab but
whenever<00:01:33.750><c> you</c><00:01:33.990><c> click</c><00:01:34.320><c> out</c><00:01:34.500><c> of</c><00:01:34.530><c> a</c><00:01:34.740><c> cell</c><00:01:34.979><c> it's</c>

00:01:35.270 --> 00:01:35.280 align:start position:0%
whenever you click out of a cell it's
 

00:01:35.280 --> 00:01:37.130 align:start position:0%
whenever you click out of a cell it's
going<00:01:35.520><c> to</c><00:01:35.700><c> automatically</c><00:01:36.240><c> save</c><00:01:36.570><c> it</c><00:01:36.720><c> for</c><00:01:36.990><c> you</c>

00:01:37.130 --> 00:01:37.140 align:start position:0%
going to automatically save it for you
 

00:01:37.140 --> 00:01:39.170 align:start position:0%
going to automatically save it for you
so<00:01:37.830><c> if</c><00:01:38.100><c> you're</c><00:01:38.220><c> making</c><00:01:38.369><c> a</c><00:01:38.700><c> lot</c><00:01:38.910><c> of</c><00:01:38.970><c> different</c>

00:01:39.170 --> 00:01:39.180 align:start position:0%
so if you're making a lot of different
 

00:01:39.180 --> 00:01:40.670 align:start position:0%
so if you're making a lot of different
changes<00:01:39.780><c> you</c><00:01:39.960><c> don't</c><00:01:40.050><c> have</c><00:01:40.200><c> to</c><00:01:40.380><c> worry</c><00:01:40.560><c> about</c>

00:01:40.670 --> 00:01:40.680 align:start position:0%
changes you don't have to worry about
 

00:01:40.680 --> 00:01:42.859 align:start position:0%
changes you don't have to worry about
saving<00:01:41.040><c> each</c><00:01:41.399><c> record</c><00:01:41.759><c> but</c><00:01:42.420><c> it</c><00:01:42.509><c> is</c><00:01:42.600><c> a</c><00:01:42.630><c> good</c><00:01:42.840><c> idea</c>

00:01:42.859 --> 00:01:42.869 align:start position:0%
saving each record but it is a good idea
 

00:01:42.869 --> 00:01:44.389 align:start position:0%
saving each record but it is a good idea
to<00:01:43.170><c> save</c><00:01:43.410><c> the</c><00:01:43.440><c> last</c><00:01:43.770><c> one</c><00:01:44.070><c> that</c><00:01:44.130><c> you're</c><00:01:44.280><c> working</c>

00:01:44.389 --> 00:01:44.399 align:start position:0%
to save the last one that you're working
 

00:01:44.399 --> 00:01:46.130 align:start position:0%
to save the last one that you're working
on<00:01:44.700><c> just</c><00:01:44.940><c> to</c><00:01:45.240><c> make</c><00:01:45.360><c> sure</c><00:01:45.390><c> that</c><00:01:45.660><c> you</c><00:01:45.720><c> don't</c><00:01:45.840><c> lose</c>

00:01:46.130 --> 00:01:46.140 align:start position:0%
on just to make sure that you don't lose
 

00:01:46.140 --> 00:01:47.630 align:start position:0%
on just to make sure that you don't lose
any<00:01:46.170><c> changes</c><00:01:46.830><c> when</c><00:01:46.979><c> you</c><00:01:47.070><c> close</c><00:01:47.280><c> the</c><00:01:47.490><c> database</c>

00:01:47.630 --> 00:01:47.640 align:start position:0%
any changes when you close the database
 

00:01:47.640 --> 00:01:50.330 align:start position:0%
any changes when you close the database
if<00:01:48.090><c> you</c><00:01:49.020><c> are</c><00:01:49.200><c> editing</c><00:01:49.350><c> more</c><00:01:49.710><c> than</c><00:01:49.860><c> one</c><00:01:49.979><c> record</c>

00:01:50.330 --> 00:01:50.340 align:start position:0%
if you are editing more than one record
 

00:01:50.340 --> 00:01:51.770 align:start position:0%
if you are editing more than one record
you<00:01:50.430><c> can</c><00:01:50.640><c> use</c><00:01:50.789><c> the</c><00:01:50.970><c> arrow</c><00:01:51.180><c> keys</c><00:01:51.509><c> on</c><00:01:51.539><c> your</c>

00:01:51.770 --> 00:01:51.780 align:start position:0%
you can use the arrow keys on your
 

00:01:51.780 --> 00:01:54.440 align:start position:0%
you can use the arrow keys on your
keyboard<00:01:51.930><c> to</c><00:01:52.350><c> move</c><00:01:52.619><c> between</c><00:01:52.830><c> records</c><00:01:53.280><c> or</c><00:01:53.640><c> if</c>

00:01:54.440 --> 00:01:54.450 align:start position:0%
keyboard to move between records or if
 

00:01:54.450 --> 00:01:56.510 align:start position:0%
keyboard to move between records or if
you<00:01:54.600><c> prefer</c><00:01:54.930><c> you</c><00:01:55.259><c> can</c><00:01:55.380><c> use</c><00:01:55.440><c> the</c><00:01:55.770><c> arrows</c><00:01:56.100><c> on</c><00:01:56.310><c> the</c>

00:01:56.510 --> 00:01:56.520 align:start position:0%
you prefer you can use the arrows on the
 

00:01:56.520 --> 00:01:59.150 align:start position:0%
you prefer you can use the arrows on the
record<00:01:56.820><c> navigation</c><00:01:57.000><c> bar</c><00:01:57.630><c> you</c><00:01:57.840><c> can</c><00:01:58.740><c> also</c><00:01:58.860><c> use</c>

00:01:59.150 --> 00:01:59.160 align:start position:0%
record navigation bar you can also use
 

00:01:59.160 --> 00:02:00.889 align:start position:0%
record navigation bar you can also use
the<00:01:59.340><c> record</c><00:01:59.580><c> navigation</c><00:01:59.700><c> bar</c><00:02:00.300><c> to</c><00:02:00.509><c> create</c><00:02:00.690><c> a</c>

00:02:00.889 --> 00:02:00.899 align:start position:0%
the record navigation bar to create a
 

00:02:00.899 --> 00:02:03.950 align:start position:0%
the record navigation bar to create a
new<00:02:01.289><c> record</c><00:02:01.740><c> and</c><00:02:02.180><c> then</c><00:02:03.180><c> type</c><00:02:03.420><c> in</c><00:02:03.570><c> the</c><00:02:03.600><c> person's</c>

00:02:03.950 --> 00:02:03.960 align:start position:0%
new record and then type in the person's
 

00:02:03.960 --> 00:02:07.540 align:start position:0%
new record and then type in the person's
information

00:02:07.540 --> 00:02:07.550 align:start position:0%
 
 

00:02:07.550 --> 00:02:10.150 align:start position:0%
 
if<00:02:07.610><c> you</c><00:02:08.390><c> want</c><00:02:08.600><c> to</c><00:02:08.810><c> delete</c><00:02:09.110><c> a</c><00:02:09.170><c> record</c><00:02:09.380><c> click</c><00:02:09.950><c> the</c>

00:02:10.150 --> 00:02:10.160 align:start position:0%
if you want to delete a record click the
 

00:02:10.160 --> 00:02:11.560 align:start position:0%
if you want to delete a record click the
margin<00:02:10.610><c> on</c><00:02:10.790><c> the</c><00:02:10.910><c> left</c><00:02:10.940><c> side</c><00:02:11.210><c> of</c><00:02:11.360><c> the</c><00:02:11.420><c> record</c>

00:02:11.560 --> 00:02:11.570 align:start position:0%
margin on the left side of the record
 

00:02:11.570 --> 00:02:14.230 align:start position:0%
margin on the left side of the record
and<00:02:11.950><c> then</c><00:02:12.950><c> on</c><00:02:13.100><c> the</c><00:02:13.190><c> Home</c><00:02:13.400><c> tab</c><00:02:13.430><c> click</c><00:02:13.970><c> the</c>

00:02:14.230 --> 00:02:14.240 align:start position:0%
and then on the Home tab click the
 

00:02:14.240 --> 00:02:16.110 align:start position:0%
and then on the Home tab click the
delete<00:02:14.630><c> command</c>

00:02:16.110 --> 00:02:16.120 align:start position:0%
delete command
 

00:02:16.120 --> 00:02:17.880 align:start position:0%
delete command
and<00:02:16.690><c> now</c><00:02:16.810><c> normally</c><00:02:17.319><c> you</c><00:02:17.470><c> should</c><00:02:17.620><c> avoid</c>

00:02:17.880 --> 00:02:17.890 align:start position:0%
and now normally you should avoid
 

00:02:17.890 --> 00:02:19.770 align:start position:0%
and now normally you should avoid
deleting<00:02:18.430><c> records</c><00:02:18.610><c> because</c><00:02:19.450><c> it</c><00:02:19.629><c> can</c>

00:02:19.770 --> 00:02:19.780 align:start position:0%
deleting records because it can
 

00:02:19.780 --> 00:02:21.960 align:start position:0%
deleting records because it can
negatively<00:02:19.989><c> impact</c><00:02:20.739><c> the</c><00:02:20.980><c> database</c><00:02:21.430><c> if</c><00:02:21.730><c> other</c>

00:02:21.960 --> 00:02:21.970 align:start position:0%
negatively impact the database if other
 

00:02:21.970 --> 00:02:24.720 align:start position:0%
negatively impact the database if other
objects<00:02:22.480><c> refer</c><00:02:22.840><c> to</c><00:02:23.080><c> the</c><00:02:23.200><c> record</c><00:02:23.379><c> for</c><00:02:24.340><c> example</c>

00:02:24.720 --> 00:02:24.730 align:start position:0%
objects refer to the record for example
 

00:02:24.730 --> 00:02:26.610 align:start position:0%
objects refer to the record for example
if<00:02:24.819><c> we</c><00:02:24.970><c> deleted</c><00:02:25.360><c> a</c><00:02:25.510><c> customer's</c><00:02:26.019><c> record</c><00:02:26.440><c> it</c>

00:02:26.610 --> 00:02:26.620 align:start position:0%
if we deleted a customer's record it
 

00:02:26.620 --> 00:02:28.410 align:start position:0%
if we deleted a customer's record it
could<00:02:27.129><c> cause</c><00:02:27.370><c> the</c><00:02:27.580><c> information</c><00:02:28.120><c> in</c><00:02:28.269><c> the</c>

00:02:28.410 --> 00:02:28.420 align:start position:0%
could cause the information in the
 

00:02:28.420 --> 00:02:31.259 align:start position:0%
could cause the information in the
orders<00:02:28.810><c> table</c><00:02:28.989><c> to</c><00:02:29.290><c> be</c><00:02:29.440><c> incomplete</c><00:02:30.120><c> but</c><00:02:31.120><c> if</c>

00:02:31.259 --> 00:02:31.269 align:start position:0%
orders table to be incomplete but if
 

00:02:31.269 --> 00:02:32.610 align:start position:0%
orders table to be incomplete but if
you're<00:02:31.390><c> just</c><00:02:31.540><c> deleting</c><00:02:31.959><c> a</c><00:02:32.019><c> brand-new</c><00:02:32.440><c> record</c>

00:02:32.610 --> 00:02:32.620 align:start position:0%
you're just deleting a brand-new record
 

00:02:32.620 --> 00:02:35.850 align:start position:0%
you're just deleting a brand-new record
then<00:02:32.920><c> it's</c><00:02:33.069><c> generally</c><00:02:33.489><c> okay</c><00:02:33.879><c> if</c><00:02:34.500><c> you're</c><00:02:35.500><c> sure</c>

00:02:35.850 --> 00:02:35.860 align:start position:0%
then it's generally okay if you're sure
 

00:02:35.860 --> 00:02:37.199 align:start position:0%
then it's generally okay if you're sure
that<00:02:35.890><c> you</c><00:02:36.129><c> want</c><00:02:36.310><c> to</c><00:02:36.370><c> permanently</c><00:02:36.549><c> delete</c><00:02:36.849><c> it</c>

00:02:37.199 --> 00:02:37.209 align:start position:0%
that you want to permanently delete it
 

00:02:37.209 --> 00:02:40.230 align:start position:0%
that you want to permanently delete it
then<00:02:37.510><c> click</c><00:02:37.870><c> yes</c>

00:02:40.230 --> 00:02:40.240 align:start position:0%
then click yes
 

00:02:40.240 --> 00:02:42.630 align:start position:0%
then click yes
for<00:02:41.050><c> some</c><00:02:41.230><c> edits</c><00:02:41.530><c> you</c><00:02:41.740><c> may</c><00:02:41.860><c> want</c><00:02:42.100><c> to</c><00:02:42.160><c> use</c><00:02:42.430><c> the</c>

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

00:02:42.640 --> 00:02:44.490 align:start position:0%
for some edits you may want to use the
Find<00:02:42.940><c> and</c><00:02:43.120><c> Replace</c><00:02:43.210><c> option</c><00:02:43.690><c> to</c><00:02:44.080><c> make</c><00:02:44.200><c> a</c><00:02:44.230><c> lot</c><00:02:44.470><c> of</c>

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

00:02:44.500 --> 00:02:47.460 align:start position:0%
Find and Replace option to make a lot of
changes<00:02:44.890><c> at</c><00:02:45.040><c> once</c><00:02:45.300><c> I'm</c><00:02:46.300><c> going</c><00:02:46.630><c> to</c><00:02:46.720><c> open</c><00:02:46.960><c> up</c><00:02:47.260><c> the</c>

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

00:02:47.470 --> 00:02:50.520 align:start position:0%
changes at once I'm going to open up the
products<00:02:47.980><c> table</c><00:02:48.340><c> and</c><00:02:48.630><c> on</c><00:02:49.630><c> the</c><00:02:49.750><c> Home</c><00:02:49.900><c> tab</c><00:02:49.930><c> click</c>

00:02:50.520 --> 00:02:50.530 align:start position:0%
products table and on the Home tab click
 

00:02:50.530 --> 00:02:53.400 align:start position:0%
products table and on the Home tab click
the<00:02:50.860><c> replace</c><00:02:51.340><c> command</c>

00:02:53.400 --> 00:02:53.410 align:start position:0%
the replace command
 

00:02:53.410 --> 00:02:54.720 align:start position:0%
 
and<00:02:53.500><c> let's</c><00:02:54.040><c> say</c><00:02:54.160><c> that</c><00:02:54.190><c> in</c><00:02:54.430><c> some</c><00:02:54.580><c> of</c><00:02:54.670><c> our</c>

00:02:54.720 --> 00:02:54.730 align:start position:0%
and let's say that in some of our
 

00:02:54.730 --> 00:02:56.700 align:start position:0%
and let's say that in some of our
seasonal<00:02:55.240><c> products</c><00:02:55.690><c> we</c><00:02:55.960><c> want</c><00:02:56.110><c> to</c><00:02:56.260><c> change</c><00:02:56.500><c> the</c>

00:02:56.700 --> 00:02:56.710 align:start position:0%
seasonal products we want to change the
 

00:02:56.710 --> 00:02:59.820 align:start position:0%
seasonal products we want to change the
word<00:02:56.830><c> fall</c><00:02:57.250><c> to</c><00:02:57.670><c> autumn</c><00:02:58.410><c> type</c><00:02:59.410><c> in</c><00:02:59.590><c> the</c><00:02:59.680><c> word</c>

00:02:59.820 --> 00:02:59.830 align:start position:0%
word fall to autumn type in the word
 

00:02:59.830 --> 00:03:01.770 align:start position:0%
word fall to autumn type in the word
that<00:02:59.980><c> you're</c><00:03:00.040><c> looking</c><00:03:00.100><c> for</c><00:03:00.610><c> and</c><00:03:00.820><c> the</c><00:03:01.630><c> word</c>

00:03:01.770 --> 00:03:01.780 align:start position:0%
that you're looking for and the word
 

00:03:01.780 --> 00:03:04.730 align:start position:0%
that you're looking for and the word
that<00:03:01.810><c> you</c><00:03:01.990><c> want</c><00:03:02.020><c> it</c><00:03:02.200><c> replaced</c><00:03:02.560><c> with</c>

00:03:04.730 --> 00:03:04.740 align:start position:0%
that you want it replaced with
 

00:03:04.740 --> 00:03:06.980 align:start position:0%
that you want it replaced with
and<00:03:04.830><c> will</c><00:03:05.520><c> select</c><00:03:05.850><c> current</c><00:03:06.270><c> documents</c><00:03:06.810><c> so</c><00:03:06.900><c> it</c>

00:03:06.980 --> 00:03:06.990 align:start position:0%
and will select current documents so it
 

00:03:06.990 --> 00:03:08.570 align:start position:0%
and will select current documents so it
will<00:03:07.080><c> search</c><00:03:07.230><c> throughout</c><00:03:07.680><c> the</c><00:03:07.830><c> entire</c><00:03:08.160><c> table</c>

00:03:08.570 --> 00:03:08.580 align:start position:0%
will search throughout the entire table
 

00:03:08.580 --> 00:03:10.610 align:start position:0%
will search throughout the entire table
and<00:03:08.760><c> we</c><00:03:09.570><c> want</c><00:03:09.750><c> to</c><00:03:09.840><c> look</c><00:03:09.930><c> for</c><00:03:09.990><c> matches</c><00:03:10.470><c> that</c>

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

00:03:10.620 --> 00:03:13.910 align:start position:0%
and we want to look for matches that
appear<00:03:10.920><c> in</c><00:03:10.950><c> any</c><00:03:11.280><c> part</c><00:03:11.670><c> of</c><00:03:11.760><c> the</c><00:03:11.880><c> field</c><00:03:12.920><c> click</c>

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

00:03:13.920 --> 00:03:16.710 align:start position:0%
appear in any part of the field click
find<00:03:14.280><c> next</c><00:03:14.580><c> to</c><00:03:14.790><c> look</c><00:03:15.000><c> for</c><00:03:15.180><c> the</c><00:03:15.240><c> word</c>

00:03:16.710 --> 00:03:16.720 align:start position:0%
find next to look for the word
 

00:03:16.720 --> 00:03:18.990 align:start position:0%
find next to look for the word
and<00:03:16.810><c> it</c><00:03:17.560><c> looks</c><00:03:17.770><c> like</c><00:03:17.860><c> the</c><00:03:18.070><c> first</c><00:03:18.280><c> instance</c><00:03:18.850><c> of</c>

00:03:18.990 --> 00:03:19.000 align:start position:0%
and it looks like the first instance of
 

00:03:19.000 --> 00:03:21.390 align:start position:0%
and it looks like the first instance of
fall<00:03:19.240><c> isn't</c><00:03:19.540><c> referring</c><00:03:19.990><c> to</c><00:03:20.260><c> the</c><00:03:20.380><c> season</c><00:03:20.830><c> so</c>

00:03:21.390 --> 00:03:21.400 align:start position:0%
fall isn't referring to the season so
 

00:03:21.400 --> 00:03:23.370 align:start position:0%
fall isn't referring to the season so
we'll<00:03:21.610><c> skip</c><00:03:21.970><c> this</c><00:03:22.300><c> one</c><00:03:22.360><c> and</c><00:03:22.840><c> find</c><00:03:23.230><c> the</c><00:03:23.320><c> next</c>

00:03:23.370 --> 00:03:23.380 align:start position:0%
we'll skip this one and find the next
 

00:03:23.380 --> 00:03:26.100 align:start position:0%
we'll skip this one and find the next
one<00:03:24.270><c> and</c><00:03:25.270><c> when</c><00:03:25.450><c> you</c><00:03:25.540><c> get</c><00:03:25.660><c> to</c><00:03:25.780><c> one</c><00:03:25.900><c> that</c><00:03:26.020><c> you</c>

00:03:26.100 --> 00:03:26.110 align:start position:0%
one and when you get to one that you
 

00:03:26.110 --> 00:03:29.160 align:start position:0%
one and when you get to one that you
want<00:03:26.290><c> to</c><00:03:26.380><c> change</c><00:03:26.620><c> click</c><00:03:27.010><c> replace</c><00:03:27.840><c> and</c><00:03:28.840><c> just</c><00:03:29.050><c> go</c>

00:03:29.160 --> 00:03:29.170 align:start position:0%
want to change click replace and just go
 

00:03:29.170 --> 00:03:30.960 align:start position:0%
want to change click replace and just go
through<00:03:29.200><c> each</c><00:03:29.440><c> one</c><00:03:29.920><c> and</c><00:03:30.190><c> decide</c><00:03:30.580><c> whether</c><00:03:30.820><c> you</c>

00:03:30.960 --> 00:03:30.970 align:start position:0%
through each one and decide whether you
 

00:03:30.970 --> 00:03:34.190 align:start position:0%
through each one and decide whether you
want<00:03:31.150><c> to</c><00:03:31.180><c> replace</c><00:03:31.480><c> it</c>

00:03:34.190 --> 00:03:34.200 align:start position:0%
 
 

00:03:34.200 --> 00:03:36.260 align:start position:0%
 
and<00:03:34.520><c> generally</c><00:03:35.520><c> you</c><00:03:35.550><c> don't</c><00:03:35.879><c> want</c><00:03:36.090><c> to</c><00:03:36.180><c> use</c>

00:03:36.260 --> 00:03:36.270 align:start position:0%
and generally you don't want to use
 

00:03:36.270 --> 00:03:38.570 align:start position:0%
and generally you don't want to use
replace<00:03:36.750><c> all</c><00:03:37.110><c> because</c><00:03:37.890><c> that</c><00:03:38.129><c> doesn't</c><00:03:38.459><c> give</c>

00:03:38.570 --> 00:03:38.580 align:start position:0%
replace all because that doesn't give
 

00:03:38.580 --> 00:03:40.400 align:start position:0%
replace all because that doesn't give
you<00:03:38.670><c> the</c><00:03:38.790><c> option</c><00:03:39.269><c> of</c><00:03:39.390><c> skipping</c><00:03:39.660><c> any</c><00:03:40.080><c> of</c><00:03:40.230><c> them</c>

00:03:40.400 --> 00:03:40.410 align:start position:0%
you the option of skipping any of them
 

00:03:40.410 --> 00:03:42.350 align:start position:0%
you the option of skipping any of them
so<00:03:41.069><c> you</c><00:03:41.129><c> should</c><00:03:41.370><c> only</c><00:03:41.489><c> use</c><00:03:41.610><c> this</c><00:03:41.849><c> option</c><00:03:42.000><c> if</c>

00:03:42.350 --> 00:03:42.360 align:start position:0%
so you should only use this option if
 

00:03:42.360 --> 00:03:43.880 align:start position:0%
so you should only use this option if
you're<00:03:42.540><c> absolutely</c><00:03:42.989><c> sure</c><00:03:43.260><c> that</c><00:03:43.650><c> it</c><00:03:43.739><c> won't</c>

00:03:43.880 --> 00:03:43.890 align:start position:0%
you're absolutely sure that it won't
 

00:03:43.890 --> 00:03:46.980 align:start position:0%
you're absolutely sure that it won't
replace<00:03:44.129><c> anything</c><00:03:44.760><c> that</c><00:03:44.910><c> you</c><00:03:45.000><c> don't</c><00:03:45.180><c> want</c>

00:03:46.980 --> 00:03:46.990 align:start position:0%
replace anything that you don't want
 

00:03:46.990 --> 00:03:49.380 align:start position:0%
replace anything that you don't want
as<00:03:47.050><c> you</c><00:03:47.650><c> practice</c><00:03:47.830><c> editing</c><00:03:48.220><c> tables</c><00:03:48.640><c> keep</c><00:03:49.270><c> in</c>

00:03:49.380 --> 00:03:49.390 align:start position:0%
as you practice editing tables keep in
 

00:03:49.390 --> 00:03:51.000 align:start position:0%
as you practice editing tables keep in
mind<00:03:49.600><c> that</c><00:03:49.780><c> most</c><00:03:50.080><c> of</c><00:03:50.290><c> your</c><00:03:50.440><c> changes</c><00:03:50.830><c> are</c><00:03:50.980><c> saved</c>

00:03:51.000 --> 00:03:51.010 align:start position:0%
mind that most of your changes are saved
 

00:03:51.010 --> 00:03:53.790 align:start position:0%
mind that most of your changes are saved
automatically<00:03:51.820><c> so</c><00:03:52.600><c> to</c><00:03:52.660><c> be</c><00:03:52.900><c> safe</c><00:03:53.110><c> you</c><00:03:53.350><c> may</c><00:03:53.560><c> want</c>

00:03:53.790 --> 00:03:53.800 align:start position:0%
automatically so to be safe you may want
 

00:03:53.800 --> 00:03:57.680 align:start position:0%
automatically so to be safe you may want
to<00:03:53.860><c> create</c><00:03:54.100><c> new</c><00:03:54.310><c> records</c><00:03:55.000><c> to</c><00:03:55.090><c> practice</c><00:03:55.570><c> with</c>

00:03:57.680 --> 00:03:57.690 align:start position:0%
to create new records to practice with
 

00:03:57.690 --> 00:04:01.650 align:start position:0%
to create new records to practice with
light<00:03:58.690><c> that</c><00:03:58.870><c> you</c><00:03:59.020><c> just</c><00:03:59.230><c> saw</c><00:04:00.120><c> greatest</c><00:04:01.120><c> add</c><00:04:01.600><c> a</c>

00:04:01.650 --> 00:04:01.660 align:start position:0%
light that you just saw greatest add a
 

00:04:01.660 --> 00:04:03.870 align:start position:0%
light that you just saw greatest add a
comment<00:04:01.990><c> subscribe</c><00:04:02.740><c> to</c><00:04:03.160><c> our</c><00:04:03.280><c> Channel</c>

00:04:03.870 --> 00:04:03.880 align:start position:0%
comment subscribe to our Channel
 

00:04:03.880 --> 00:04:06.490 align:start position:0%
comment subscribe to our Channel
the<00:04:04.750><c> freedom</c><00:04:05.200><c> to</c><00:04:05.230><c> learn</c>

00:04:06.490 --> 00:04:06.500 align:start position:0%
the freedom to learn
 

00:04:06.500 --> 00:04:11.770 align:start position:0%
the freedom to learn
what<00:04:07.130><c> you</c><00:04:07.340><c> want</c><00:04:07.810><c> when</c><00:04:08.810><c> you</c><00:04:08.840><c> want</c><00:04:10.780><c> absolutely</c>

00:04:11.770 --> 00:04:11.780 align:start position:0%
what you want when you want absolutely
 

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

00:04:15.390 --> 00:04:15.400 align:start position:0%
 
 

00:04:15.400 --> 00:04:19.030 align:start position:0%
 
GCF<00:04:16.400><c> learn</c><00:04:17.000><c> free.org</c>