WEBVTT
Kind: captions
Language: en

00:00:11.519 --> 00:00:16.900
Tables are the heart of any database because
they are where the actual information is stored.

00:00:16.900 --> 00:00:22.640
And we're going to talk about how to add,
edit, and delete information from a table.

00:00:22.640 --> 00:00:27.820
In the Navigation pane, double-click on the
table that you'd like to open… and tables

00:00:27.820 --> 00:00:31.779
will be marked with a blue icon next to the
name.

00:00:31.779 --> 00:00:35.870
If you've used Excel, or another spreadsheet
program, then you'll probably find tables

00:00:35.870 --> 00:00:39.250
to be pretty easy to use, and they are very
similar.

00:00:39.250 --> 00:00:44.480
But there are some different terms that we
use when talking about an Access table.

00:00:44.480 --> 00:00:46.710
Each row is called a record.

00:00:46.710 --> 00:00:53.240
In this table, every record contains a customer's
name, address, and other information.

00:00:53.240 --> 00:00:58.250
Each record will have a unique ID number,
and this number cannot be changed.

00:00:58.250 --> 00:01:03.559
So Jerrod Smith's number will always be 3,
no matter what.

00:01:03.559 --> 00:01:06.170
Each column is called a field.

00:01:06.170 --> 00:01:09.830
And each field contains a different type of
information.

00:01:09.830 --> 00:01:18.679
For example, here we have fields for the Street
Address, City, State, and Zip Code.

00:01:18.679 --> 00:01:22.069
Just like in Excel, each box is called a cell.

00:01:22.069 --> 00:01:26.499
If you want to change the information in a
cell, all you have to do is select it, and

00:01:26.499 --> 00:01:28.469
then type in the new text.

00:01:28.469 --> 00:01:33.159
And let's say that this customer has a new
email address.

00:01:33.159 --> 00:01:38.409
After you edit the record, you can save it
by clicking Save on the Home tab.

00:01:38.409 --> 00:01:43.009
But whenever you click out of a cell, it's
going to automatically save it for you.

00:01:43.009 --> 00:01:47.139
So if you're making a lot of different changes,
you don't have to worry about saving each

00:01:47.139 --> 00:01:48.139
record.

00:01:48.139 --> 00:01:50.780
But it is a good idea to save the last one
that you're working on, just to make sure

00:01:50.780 --> 00:01:54.700
that you don't lose any changes when you close
the database.

00:01:54.700 --> 00:01:58.270
If you are editing more than one record, you
can use the arrow keys on your keyboard to

00:01:58.270 --> 00:02:00.479
move between records.

00:02:00.479 --> 00:02:07.639
Or, if you prefer, you can use the arrows
on the Record Navigation bar.

00:02:07.639 --> 00:02:12.220
You can also use the Record Navigation bar
to create a new record.

00:02:12.220 --> 00:02:17.880
And then type in the person's information.

00:02:17.880 --> 00:02:23.890
If you want to delete a record, click the
margin on the left side of the record… and

00:02:23.890 --> 00:02:28.590
then on the Home tab, click the Delete command.

00:02:28.590 --> 00:02:33.450
Now normally you should avoid deleting records
because it can negatively impact the database

00:02:33.450 --> 00:02:36.220
if other objects refer to the record.

00:02:36.220 --> 00:02:40.720
For example, if we deleted a customer's record,
it could cause the information in the Orders

00:02:40.720 --> 00:02:43.230
Table to be incomplete.

00:02:43.230 --> 00:02:51.420
But if you're just deleting a brand new record,
then it's generally okay.

00:02:51.420 --> 00:02:55.360
For some edits, you may want to use the Find
and Replace option to make a lot of changes

00:02:55.360 --> 00:02:56.360
at once.

00:02:56.360 --> 00:03:05.930
I'm going to open up the Products Table…
and on the Home tab, click the Replace command…

00:03:05.930 --> 00:03:11.650
and let's say in some of our seasonal products,
we want to change the word "Fall" to "Autumn."

00:03:11.650 --> 00:03:18.260
Type in the word that you're looking for…
and the word that you want it replaced with.

00:03:18.260 --> 00:03:22.940
And we'll select Current document, so it will
search throughout the entire table… and

00:03:22.940 --> 00:03:28.820
we want to look for matches that appear in
Any Part of the field.

00:03:28.820 --> 00:03:32.180
Click Find Next to look for the word.

00:03:32.180 --> 00:03:36.700
And it looks like the first instance of "fall"
isn't referring to the season, so we'll skip

00:03:36.700 --> 00:03:40.100
this one and find the next one.

00:03:40.100 --> 00:03:45.650
And when you get to one that you want to change,
click Replace… and just go through each

00:03:45.650 --> 00:03:53.810
one and decide whether you want to replace
it.

00:03:53.810 --> 00:03:57.940
And generally you don't want to use Replace
All because that doesn't give you the option

00:03:57.940 --> 00:03:59.880
of skipping any of them.

00:03:59.880 --> 00:04:03.830
So you should only use this option if you're
absolutely sure that it won't replace anything

00:04:03.830 --> 00:04:08.490
you don't want.

00:04:08.490 --> 00:04:13.600
As you practice editing tables, keep in mind
that most of your changes are saved automatically.

00:04:13.600 --> 00:04:17.060
So to be safe, you may want to create new
records to practice with.