For Full versions of my videos or to join my mailing list go to : http://www.pcwebinars.com Access managing a table - How to manage a table in Microsoft Access 2010, 2013, 2016 tutorial
okay let's talk about managing your
tables what we can do is uh well with
any table you can rename it so if I
right click on a table you actually get
a lot of choices here uh opening a table
would be going into Data view where we
can do data entry a design view is where
we can add or change our fields and
change the field layout we can import
data this is another way we can import
besides using the external data up here
we can export the data to different
sources so we can take the data from
access and go to any of those other um
data
types uh collect and update data via
email we can actually do an email poll
and go right into the access database so
that'll be a different
lesson we can rename a table uh we can
hide a table so nobody else would know
it's there except for us we can delete a
table uh if you delete a table you have
to be careful with that one because
it'll delete it and you won't be able to
get the table back you'll lose your data
uh so be careful with delete uh we can
we can cut and copy maybe uh sometimes
you copy a table and um in fact let me
show you what that would be about if I
copy the
table then of course the next step will
be to do a paste I'm going to right
click on that table and then do a
paste now when you copy the table you
can copy the structure only which would
just be the field layout without the
data we can copy the structure and the
data or we can append the data to an
existing table so this is a really quick
and easy way to to merge your tables
together assuming that they have the
same uh Field layout so we're going to
do the structure and the data
there and if you notice now I have a new
table called copy of
employees and it has the same data as
the original employees table so um let's
say you wanted to try something out and
you didn't want to damage the original
table then you can just make a copy of
the table like that uh so we can right
click on any table and be able to do um
those features of course now let's go
into a table in this case we're going to
double click on the customers
table and that brings you into data
sheet data view um excuse me uh data
sheet view or we call this data view
this is where we can uh add or change
our records or delete the records so we
can change anything about this table if
you just go to a field if you wanted to
change that field you can just type over
that not a
problem okay by the way this data is uh
the data that comes with AIS in the
Northwind database but it's it's really
good sample
data so you you can just click on any
field and over type it to change that
field follow my mouse down here and this
is called the record Navigator this
helps you go to your next and previous
records very quickly so here I I can go
to the first record the previous record
next and then this will be to my last
record and this guy over here is how we
add a new record all right I'll get to
that in a couple minutes uh so I have
first previous next and last now if you
want to go to a specific record by its
number you're going to click on uh the
record number and let's say I want to go
to record 50 I'm just going to type Ty
in the number 50 then I'm going to hit
the enter key on my keyboard and now I'm
on uh record 50 as we can see all right
so that's a quick way to to move around
your table using the the record
Navigator let let's try that one where
we were going to add a record we're
going to click on the
asterisk we're going to add a record so
in this case I'm just going to type in a
AAAA for the uh customer ID uh the
company name uh let's put in skill
caddy
uh the contact name uh let's say is uh
Mary
Smith and the contact title uh he is a
co-owner uh so the address uh Mary lives
at 123 Main
Street and Mary lives in
Dallas
Texas uh his postal code happens to be 1
2 3
45 uh the country is
USA this phone number happens to
be um his phone number happens to be
215
555 1212 so you can see I'm just doing
data entry here this fax number is
215
555
213 and that just put that information
into the record now to add a new record
well it'll let me do a new record again
but otherwise you click on the asterisk
and that's how you can add a new record
now it'll always put the record at the
bottom of the table but you're going to
see that it doesn't really matter
because we can sort on any field but
when you import a new record it always
goes to the bottom of the table uh
another thing we can do in the the table
is we can delete a record so to delete a
record I'm just going to right click on
a record and then we'll say delete
record however when you do that look
what it says you're about to delete one
record if you click yes you won't be
able to undo the delete so you have to
be careful here for that reason I'm
going to pick on no of course if you
really wanted to delete the record you
would pick on yes but all I did to
delete that record was right click and
then pick on delete record as we can see
all right so um this could just some
quick and easy ways to manage your table
in uh Microsoft Excel excuse me in
Microsoft Access and then uh in the next
couple of videos we're going to talk
about sorting the data filtering and
also then we'll talk about um doing uh
just managing your data in general and
also finding the data we're going to
close that window now if it doesn't ask
you to save it Sav those kind of changes
automatically so that's that's a little
bit about managing your table here in
Microsoft Access