WEBVTT
Kind: captions
Language: en

00:00:07.410 --> 00:00:12.020
Finally, the heart of your Access database
is the Navigation Pane.

00:00:12.020 --> 00:00:16.430
It shows you what's in the database
and makes them easily accessible for you.

00:00:16.430 --> 00:00:22.400
A Microsoft Access database is made up of
several components including tables, forms,

00:00:22.400 --> 00:00:28.750
queries, and reports.
These components are called database objects.

00:00:28.750 --> 00:00:33.640
One or more of these objects are formed when
a database is created.

00:00:33.640 --> 00:00:38.620
Let's take a look at the Navigation Pane and
see how it works, and then discuss the database

00:00:38.620 --> 00:00:41.760
objects.
The first thing you'll want to know how to

00:00:41.760 --> 00:00:47.239
do is work with the Navigation pane.
To open and close the Navigation Pane, just

00:00:47.239 --> 00:00:52.270
click the Shutter Bar Button.
With the Navigation Pane open you'll see 1

00:00:52.270 --> 00:00:57.730
or more groups.
You can collapse and expand a group by simply

00:00:57.730 --> 00:01:03.750
clicking the down or up double arrows.
You can also select the way in which the objects

00:01:03.750 --> 00:01:08.060
in the database are displayed in the Navigation
Pane.

00:01:08.060 --> 00:01:12.860
Just click the drop-down arrow here to see
your options.

00:01:12.860 --> 00:01:19.860
You can include the creation or modified dates,
or display objects as icons or lists.

00:01:20.410 --> 00:01:27.410
Let's take a look at Tables.
To open a table just click the table icon.

00:01:28.729 --> 00:01:34.380
Tables are usually created for specific topics
as you can see here we have a table for our

00:01:34.380 --> 00:01:41.380
inventory of books.
We have columns, or fields, of information

00:01:41.899 --> 00:01:48.569
such as title and author.
Each row is a record that is comprised of

00:01:48.569 --> 00:01:55.569
one or more fields.
We'll talk more about fields in another lesson.

00:01:57.929 --> 00:02:04.830
Another database object is called a query.
A query lets you find and retrieve information

00:02:04.830 --> 00:02:11.780
from one or more tables based on a set of
search conditions you define by using the

00:02:11.780 --> 00:02:17.430
fields in one or more tables.
Don't worry, we'll look further into queries

00:02:17.430 --> 00:02:22.340
in a later lesson.
You can also use forms with your database.

00:02:22.340 --> 00:02:28.040
Primarily, people use forms to make data entry
to database tables easier.

00:02:28.040 --> 00:02:35.040
Instead of entering data directly into a table,
a user can use an easy-to-read form.

00:02:35.230 --> 00:02:38.820
The final object I want to show you is the
report.

00:02:38.820 --> 00:02:45.790
A report is an effective way to analyze and
present data in a printed format using a specific

00:02:45.790 --> 00:02:50.840
layout.
You have control over the size and appearance

00:02:50.840 --> 00:02:56.650
of information printed on the report, just
like you do with Microsoft Word documents.

00:02:56.650 --> 00:03:00.370
We will also cover forms and reports in later
lessons.

00:03:00.370 --> 00:03:06.030
When you're ready to close any of these objects,
just notice the tabs to the right of the Navigation

00:03:06.030 --> 00:03:11.540
Pane.
The highlighted tab is the active tab, and

00:03:11.540 --> 00:03:15.220
can be easily closed by clicking the X on
the right.

00:03:15.220 --> 00:03:22.220
As I said before, if Access looks a little
complex to you right now don't panic because

00:03:22.370 --> 00:03:26.290
additional lessons will cover each of these
objects in greater detail.