WEBVTT
Kind: captions
Language: en

00:00:11.960 --> 00:00:14.260
Before you jump into Access, it's important
to

00:00:14.260 --> 00:00:16.500
familiarize yourself with the interface

00:00:16.500 --> 00:00:18.180
so that you know where everything is.

00:00:18.180 --> 00:00:20.290
And we're just going to take a quick tour
of the

00:00:20.290 --> 00:00:21.520
different areas of the screen

00:00:21.520 --> 00:00:23.420
that you'll be working with.

00:00:23.420 --> 00:00:28.680
Near the top of the window is a large toolbar
area, and this is called the Ribbon.

00:00:28.680 --> 00:00:30.759
The Ribbon is a collection of most of the
tools

00:00:30.759 --> 00:00:32.910
that you'll need to use in Access,

00:00:32.910 --> 00:00:36.579
and it's divided into different tabs.

00:00:36.579 --> 00:00:38.850
Just above the Ribbon is another toolbar,
called

00:00:38.850 --> 00:00:40.570
the Quick Access Toolbar.

00:00:40.570 --> 00:00:43.470
Here, you can Save the current object,

00:00:43.470 --> 00:00:46.769
and you also have the Undo and Redo commands,

00:00:46.769 --> 00:00:52.670
and you can click the drop-down arrow to add
more commands to it if you like.

00:00:52.670 --> 00:00:54.440
On the left side of the screen, there is an
area

00:00:54.440 --> 00:00:56.739
called the Navigation pane.

00:00:56.739 --> 00:01:00.660
This contains a list of all of the objects
contained in your database.

00:01:00.660 --> 00:01:02.640
All of the objects that are currently open
will

00:01:02.640 --> 00:01:04.750
appear on the Document Tabs bar.

00:01:04.750 --> 00:01:07.200
And you'll use this to select which object
you

00:01:07.200 --> 00:01:11.100
want to view or edit.

00:01:11.100 --> 00:01:13.950
At the bottom of the screen, you can use the
Record Navigation bar

00:01:13.950 --> 00:01:17.460
to navigate through the different records
one at a time.

00:01:17.460 --> 00:01:20.380
And to the right of that is the record search
box,

00:01:20.380 --> 00:01:24.369
which you can use to search for a specific
record.

00:01:24.369 --> 00:01:26.240
Now let's go back to the Ribbon and look at
it in

00:01:26.240 --> 00:01:28.020
a little more detail.

00:01:28.020 --> 00:01:30.420
The Ribbon is designed to make things easy
to

00:01:30.420 --> 00:01:34.200
find, so each tab is divided into groups.

00:01:34.200 --> 00:01:38.700
For example, here in the Forms group, we have
several different commands for working with

00:01:38.700 --> 00:01:39.850
forms.

00:01:39.850 --> 00:01:42.710
When you're working on a database, you may
notice

00:01:42.710 --> 00:01:43.500
that there are some

00:01:43.500 --> 00:01:47.049
extra tabs that appear on the
Ribbon with a label above them,

00:01:47.049 --> 00:01:50.289
and these will just appear automatically
depending on what you're working on.

00:01:50.289 --> 00:01:53.110
In this case, we have a table open, so it
opened

00:01:53.110 --> 00:01:57.210
up a couple of tabs to help us work with tables.

00:01:57.210 --> 00:01:59.180
If you want to hide the Ribbon, you can click
this

00:01:59.180 --> 00:02:01.729
little arrow in the top-right corner.

00:02:01.729 --> 00:02:03.130
But we're going to be working with the Ribbon
a

00:02:03.130 --> 00:02:06.219
lot, so you may want to leave it visible.

00:02:06.219 --> 00:02:11.570
If you're familiar with Office 2007, you may
notice that the Office Button is gone,

00:02:11.570 --> 00:02:14.580
and it has been replaced with the File tab.

00:02:14.580 --> 00:02:17.280
If you click on it, you'll go to Backstage
view,

00:02:17.280 --> 00:02:20.030
and this is where you'll find the Save options,

00:02:20.030 --> 00:02:23.110
and you can open your databases from here.

00:02:23.110 --> 00:02:28.310
And you can also print reports or view a Print
Preview.

00:02:28.310 --> 00:02:29.890
And to get out of Backstage view, you can
just

00:02:29.890 --> 00:02:33.510
click any tab on the Ribbon.

00:02:33.510 --> 00:02:35.020
When you start working with databases,

00:02:35.020 --> 00:02:38.760
you'll use the Navigation pane to open
and manage your objects.

00:02:38.760 --> 00:02:42.120
By default, it sorts all of the objects by
type.

00:02:42.120 --> 00:02:44.040
If you want to sort them a different way,
you can

00:02:44.040 --> 00:02:47.210
click this bar at the top of the Navigation
pane,

00:02:47.210 --> 00:02:51.230
and then choose which sort method you want.

00:02:51.230 --> 00:02:53.800
You can resize the Navigation pane by dragging
the

00:02:53.800 --> 00:02:56.340
right border.

00:02:56.340 --> 00:03:03.070
And you can minimize it by clicking the
double-arrow in the upper-right-hand corner.

00:03:03.070 --> 00:03:05.120
You can also hide the groups that you're
not working on

00:03:05.120 --> 00:03:08.230
by clicking the bar at the top of each group.

00:03:08.230 --> 00:03:12.600
For example, I can hide Categories, Products
Table, and Sales Unit,

00:03:12.600 --> 00:03:18.650
so I can just focus on Customers and Menu
Items.

00:03:18.650 --> 00:03:23.590
Database designers will often set up a special
kind of form called a navigation form.

00:03:23.590 --> 00:03:26.000
This will appear automatically when you open
the

00:03:26.000 --> 00:03:27.070
database.

00:03:27.070 --> 00:03:31.230
Instead of using the Navigation pane and the
Document Tabs bar to navigate through different

00:03:31.230 --> 00:03:35.250
objects, you'll use tabs within the
navigation form.

00:03:35.250 --> 00:03:37.290
This gives you a much more user-friendly way
to

00:03:37.290 --> 00:03:39.340
work with the database.

00:03:39.340 --> 00:03:41.650
For example, the employees at this bakery
only

00:03:41.650 --> 00:03:42.250
need to work with

00:03:42.250 --> 00:03:45.340
the Orders, Customers, and Menu Items.

00:03:45.340 --> 00:03:48.230
They can easily get to these by using the
tabs,

00:03:48.230 --> 00:03:51.950
and some of the tabs will also have sub-tabs
on the right.

00:03:51.950 --> 00:03:54.450
By using the navigation form, we can just
focus on

00:03:54.450 --> 00:03:56.070
the objects that we need,

00:03:56.070 --> 00:03:59.350
without having to worry
about all of the other objects in the database.

00:03:59.350 --> 00:04:03.540
It's a great feature, but again, it's something
that needs to be set up before you can use

00:04:03.540 --> 00:04:04.920
it.

00:04:04.920 --> 00:04:07.770
So those are the basics of how to
get around in Access,

00:04:07.770 --> 00:04:14.770
and in the next video we're going to talk
about how to open and save databases 
and objects.

