WEBVTT
Kind: captions
Language: en

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

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

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

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

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

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

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

00:00:41.480 --> 00:00:43.710
Each row is called a record.

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

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

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

00:01:00.559 --> 00:01:03.170
Each column is called a field.

00:01:03.170 --> 00:01:06.830
And each field contains a different type of
information.

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

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

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

00:01:23.500 --> 00:01:25.460
then type in the new text.

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

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

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

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

00:01:44.140 --> 00:01:45.140
record.

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

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

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

00:01:55.260 --> 00:01:57.470
move between records.

00:01:57.470 --> 00:02:04.630
Or, if you prefer, you can use the arrows
on the Record Navigation bar.

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

00:02:09.209 --> 00:02:14.870
And then type in the person's information.

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

00:02:20.890 --> 00:02:25.590
then on the Home tab, click the Delete command.

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

00:02:30.450 --> 00:02:33.230
if other objects refer to the record.

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

00:02:37.730 --> 00:02:40.230
Table to be incomplete.

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

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

00:02:52.349 --> 00:02:53.349
at once.

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

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

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

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

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

00:03:25.820 --> 00:03:29.180
Click Find Next to look for the word.

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

00:03:33.799 --> 00:03:37.080
this one and find the next one.

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

00:03:42.650 --> 00:03:50.800
one and decide whether you want to replace
it.

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

00:03:54.940 --> 00:03:56.879
of skipping any of them.

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

00:04:00.830 --> 00:04:05.410
you don't want.

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

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