WEBVTT
Kind: captions
Language: en

00:00:09.640 --> 00:00:12.340 align:start position:0%
 
databases<00:00:10.640><c> are</c><00:00:10.880><c> all</c><00:00:11.060><c> around</c><00:00:11.390><c> you</c><00:00:11.600><c> have</c><00:00:12.230><c> you</c>

00:00:12.340 --> 00:00:12.350 align:start position:0%
databases are all around you have you
 

00:00:12.350 --> 00:00:14.200 align:start position:0%
databases are all around you have you
ever<00:00:12.500><c> waited</c><00:00:12.740><c> at</c><00:00:13.010><c> the</c><00:00:13.040><c> doctor's</c><00:00:13.490><c> office</c><00:00:13.520><c> while</c>

00:00:14.200 --> 00:00:14.210 align:start position:0%
ever waited at the doctor's office while
 

00:00:14.210 --> 00:00:15.370 align:start position:0%
ever waited at the doctor's office while
the<00:00:14.330><c> receptionist</c><00:00:14.870><c> punched</c><00:00:15.230><c> in</c><00:00:15.350><c> your</c>

00:00:15.370 --> 00:00:15.380 align:start position:0%
the receptionist punched in your
 

00:00:15.380 --> 00:00:17.980 align:start position:0%
the receptionist punched in your
information<00:00:15.740><c> or</c><00:00:16.250><c> asked</c><00:00:17.060><c> a</c><00:00:17.180><c> store</c><00:00:17.420><c> employee</c><00:00:17.510><c> to</c>

00:00:17.980 --> 00:00:17.990 align:start position:0%
information or asked a store employee to
 

00:00:17.990 --> 00:00:19.540 align:start position:0%
information or asked a store employee to
check<00:00:18.200><c> their</c><00:00:18.350><c> system</c><00:00:18.740><c> for</c><00:00:18.890><c> a</c><00:00:18.920><c> special</c><00:00:19.310><c> item</c>

00:00:19.540 --> 00:00:19.550 align:start position:0%
check their system for a special item
 

00:00:19.550 --> 00:00:21.700 align:start position:0%
check their system for a special item
then<00:00:20.180><c> you've</c><00:00:20.360><c> seen</c><00:00:20.540><c> a</c><00:00:20.600><c> database</c><00:00:21.080><c> in</c><00:00:21.320><c> action</c>

00:00:21.700 --> 00:00:21.710 align:start position:0%
then you've seen a database in action
 

00:00:21.710 --> 00:00:23.980 align:start position:0%
then you've seen a database in action
the<00:00:22.279><c> truth</c><00:00:22.520><c> is</c><00:00:22.700><c> they're</c><00:00:23.000><c> so</c><00:00:23.180><c> useful</c><00:00:23.420><c> you</c><00:00:23.810><c> see</c>

00:00:23.980 --> 00:00:23.990 align:start position:0%
the truth is they're so useful you see
 

00:00:23.990 --> 00:00:24.760 align:start position:0%
the truth is they're so useful you see
them<00:00:24.140><c> all</c><00:00:24.260><c> the</c><00:00:24.349><c> time</c>

00:00:24.760 --> 00:00:24.770 align:start position:0%
them all the time
 

00:00:24.770 --> 00:00:27.010 align:start position:0%
them all the time
with<00:00:25.310><c> Microsoft</c><00:00:25.700><c> Access</c><00:00:26.090><c> you</c><00:00:26.660><c> can</c><00:00:26.840><c> manage</c>

00:00:27.010 --> 00:00:27.020 align:start position:0%
with Microsoft Access you can manage
 

00:00:27.020 --> 00:00:28.930 align:start position:0%
with Microsoft Access you can manage
your<00:00:27.260><c> own</c><00:00:27.320><c> database</c><00:00:27.860><c> to</c><00:00:28.280><c> suit</c><00:00:28.460><c> the</c><00:00:28.580><c> needs</c><00:00:28.789><c> of</c>

00:00:28.930 --> 00:00:28.940 align:start position:0%
your own database to suit the needs of
 

00:00:28.940 --> 00:00:30.700 align:start position:0%
your own database to suit the needs of
your<00:00:29.090><c> business</c><00:00:29.480><c> or</c><00:00:29.750><c> maybe</c><00:00:29.780><c> the</c><00:00:30.199><c> company</c><00:00:30.500><c> you</c>

00:00:30.700 --> 00:00:30.710 align:start position:0%
your business or maybe the company you
 

00:00:30.710 --> 00:00:33.580 align:start position:0%
your business or maybe the company you
work<00:00:30.890><c> for</c><00:00:30.970><c> but</c><00:00:31.970><c> what</c><00:00:32.210><c> exactly</c><00:00:32.360><c> is</c><00:00:32.930><c> a</c><00:00:33.020><c> database</c>

00:00:33.580 --> 00:00:33.590 align:start position:0%
work for but what exactly is a database
 

00:00:33.590 --> 00:00:36.160 align:start position:0%
work for but what exactly is a database
well<00:00:34.430><c> it's</c><00:00:34.640><c> a</c><00:00:34.760><c> collection</c><00:00:35.210><c> of</c><00:00:35.330><c> information</c><00:00:35.660><c> or</c>

00:00:36.160 --> 00:00:36.170 align:start position:0%
well it's a collection of information or
 

00:00:36.170 --> 00:00:37.810 align:start position:0%
well it's a collection of information or
data<00:00:36.559><c> that's</c><00:00:37.100><c> stored</c><00:00:37.250><c> on</c><00:00:37.550><c> a</c><00:00:37.670><c> computer</c>

00:00:37.810 --> 00:00:37.820 align:start position:0%
data that's stored on a computer
 

00:00:37.820 --> 00:00:40.360 align:start position:0%
data that's stored on a computer
allowing<00:00:38.660><c> you</c><00:00:38.870><c> to</c><00:00:38.989><c> enter</c><00:00:39.140><c> access</c><00:00:39.980><c> and</c><00:00:40.220><c> analyze</c>

00:00:40.360 --> 00:00:40.370 align:start position:0%
allowing you to enter access and analyze
 

00:00:40.370 --> 00:00:42.360 align:start position:0%
allowing you to enter access and analyze
it<00:00:40.850><c> in</c><00:00:40.970><c> a</c><00:00:41.059><c> way</c><00:00:41.180><c> you</c><00:00:41.239><c> never</c><00:00:41.510><c> could</c><00:00:41.870><c> on</c><00:00:42.019><c> paper</c>

00:00:42.360 --> 00:00:42.370 align:start position:0%
it in a way you never could on paper
 

00:00:42.370 --> 00:00:45.520 align:start position:0%
it in a way you never could on paper
let's<00:00:43.370><c> think</c><00:00:43.729><c> about</c><00:00:43.879><c> that</c><00:00:44.239><c> before</c><00:00:44.750><c> computers</c>

00:00:45.520 --> 00:00:45.530 align:start position:0%
let's think about that before computers
 

00:00:45.530 --> 00:00:47.350 align:start position:0%
let's think about that before computers
what<00:00:45.949><c> sort</c><00:00:46.159><c> of</c><00:00:46.220><c> paper</c><00:00:46.460><c> records</c><00:00:46.940><c> do</c><00:00:47.089><c> you</c><00:00:47.180><c> think</c>

00:00:47.350 --> 00:00:47.360 align:start position:0%
what sort of paper records do you think
 

00:00:47.360 --> 00:00:49.030 align:start position:0%
what sort of paper records do you think
the<00:00:47.479><c> doctor's</c><00:00:47.839><c> office</c><00:00:47.989><c> kept</c><00:00:48.379><c> on</c><00:00:48.500><c> file</c>

00:00:49.030 --> 00:00:49.040 align:start position:0%
the doctor's office kept on file
 

00:00:49.040 --> 00:00:51.040 align:start position:0%
the doctor's office kept on file
certainly<00:00:49.729><c> a</c><00:00:49.820><c> list</c><00:00:50.059><c> of</c><00:00:50.210><c> patients</c><00:00:50.390><c> and</c><00:00:50.839><c> their</c>

00:00:51.040 --> 00:00:51.050 align:start position:0%
certainly a list of patients and their
 

00:00:51.050 --> 00:00:53.530 align:start position:0%
certainly a list of patients and their
contact<00:00:51.530><c> information</c><00:00:52.000><c> also</c><00:00:53.000><c> their</c><00:00:53.180><c> medical</c>

00:00:53.530 --> 00:00:53.540 align:start position:0%
contact information also their medical
 

00:00:53.540 --> 00:00:55.509 align:start position:0%
contact information also their medical
history<00:00:54.019><c> and</c><00:00:54.049><c> a</c><00:00:54.260><c> list</c><00:00:54.440><c> of</c><00:00:54.530><c> past</c><00:00:54.799><c> appointments</c>

00:00:55.509 --> 00:00:55.519 align:start position:0%
history and a list of past appointments
 

00:00:55.519 --> 00:00:57.910 align:start position:0%
history and a list of past appointments
that's<00:00:56.330><c> how</c><00:00:56.540><c> databases</c><00:00:57.110><c> work</c><00:00:57.320><c> from</c><00:00:57.799><c> the</c>

00:00:57.910 --> 00:00:57.920 align:start position:0%
that's how databases work from the
 

00:00:57.920 --> 00:00:59.860 align:start position:0%
that's how databases work from the
simplest<00:00:58.339><c> to</c><00:00:58.489><c> the</c><00:00:58.519><c> most</c><00:00:58.610><c> complex</c><00:00:58.879><c> they're</c>

00:00:59.860 --> 00:00:59.870 align:start position:0%
simplest to the most complex they're
 

00:00:59.870 --> 00:01:02.110 align:start position:0%
simplest to the most complex they're
basically<00:01:00.290><c> a</c><00:01:00.409><c> collection</c><00:01:00.769><c> of</c><00:01:01.040><c> Lists</c><00:01:01.460><c> not</c><00:01:01.970><c> on</c>

00:01:02.110 --> 00:01:02.120 align:start position:0%
basically a collection of Lists not on
 

00:01:02.120 --> 00:01:03.729 align:start position:0%
basically a collection of Lists not on
paper<00:01:02.330><c> but</c><00:01:02.629><c> on</c><00:01:02.780><c> your</c><00:01:02.930><c> computer</c><00:01:03.409><c> where</c>

00:01:03.729 --> 00:01:03.739 align:start position:0%
paper but on your computer where
 

00:01:03.739 --> 00:01:05.710 align:start position:0%
paper but on your computer where
programs<00:01:04.159><c> like</c><00:01:04.370><c> access</c><00:01:04.879><c> make</c><00:01:05.120><c> it</c><00:01:05.239><c> possible</c><00:01:05.390><c> to</c>

00:01:05.710 --> 00:01:05.720 align:start position:0%
programs like access make it possible to
 

00:01:05.720 --> 00:01:07.570 align:start position:0%
programs like access make it possible to
organize<00:01:06.380><c> your</c><00:01:06.560><c> data</c><00:01:06.710><c> make</c><00:01:07.220><c> it</c><00:01:07.369><c> searchable</c>

00:01:07.570 --> 00:01:07.580 align:start position:0%
organize your data make it searchable
 

00:01:07.580 --> 00:01:10.899 align:start position:0%
organize your data make it searchable
and<00:01:08.030><c> so</c><00:01:08.299><c> much</c><00:01:08.479><c> more</c><00:01:08.810><c> let's</c><00:01:09.350><c> take</c><00:01:09.560><c> a</c><00:01:09.590><c> look</c><00:01:09.909><c> say</c>

00:01:10.899 --> 00:01:10.909 align:start position:0%
and so much more let's take a look say
 

00:01:10.909 --> 00:01:12.970 align:start position:0%
and so much more let's take a look say
you're<00:01:11.090><c> a</c><00:01:11.119><c> hard-working</c><00:01:11.450><c> amateur</c><00:01:12.110><c> Baker</c><00:01:12.290><c> you</c>

00:01:12.970 --> 00:01:12.980 align:start position:0%
you're a hard-working amateur Baker you
 

00:01:12.980 --> 00:01:14.560 align:start position:0%
you're a hard-working amateur Baker you
might<00:01:13.130><c> decide</c><00:01:13.430><c> to</c><00:01:13.490><c> keep</c><00:01:13.760><c> a</c><00:01:13.880><c> database</c><00:01:14.060><c> of</c><00:01:14.480><c> all</c>

00:01:14.560 --> 00:01:14.570 align:start position:0%
might decide to keep a database of all
 

00:01:14.570 --> 00:01:16.300 align:start position:0%
might decide to keep a database of all
the<00:01:14.630><c> cookies</c><00:01:15.050><c> you</c><00:01:15.170><c> know</c><00:01:15.320><c> how</c><00:01:15.470><c> to</c><00:01:15.530><c> make</c><00:01:15.770><c> and</c><00:01:15.980><c> the</c>

00:01:16.300 --> 00:01:16.310 align:start position:0%
the cookies you know how to make and the
 

00:01:16.310 --> 00:01:17.980 align:start position:0%
the cookies you know how to make and the
people<00:01:16.430><c> you</c><00:01:16.670><c> make</c><00:01:16.850><c> them</c><00:01:17.000><c> for</c><00:01:17.240><c> your</c><00:01:17.630><c> friends</c>

00:01:17.980 --> 00:01:17.990 align:start position:0%
people you make them for your friends
 

00:01:17.990 --> 00:01:20.320 align:start position:0%
people you make them for your friends
and<00:01:18.110><c> family</c><00:01:18.440><c> a</c><00:01:18.590><c> simple</c><00:01:19.370><c> database</c><00:01:19.550><c> because</c><00:01:20.210><c> it</c>

00:01:20.320 --> 00:01:20.330 align:start position:0%
and family a simple database because it
 

00:01:20.330 --> 00:01:22.930 align:start position:0%
and family a simple database because it
only<00:01:20.420><c> contains</c><00:01:20.900><c> two</c><00:01:21.290><c> lists</c><00:01:21.800><c> if</c><00:01:21.920><c> you</c><00:01:22.790><c> were</c><00:01:22.910><c> a</c>

00:01:22.930 --> 00:01:22.940 align:start position:0%
only contains two lists if you were a
 

00:01:22.940 --> 00:01:24.760 align:start position:0%
only contains two lists if you were a
professional<00:01:23.600><c> Baker</c><00:01:23.750><c> your</c><00:01:24.110><c> database</c><00:01:24.500><c> would</c>

00:01:24.760 --> 00:01:24.770 align:start position:0%
professional Baker your database would
 

00:01:24.770 --> 00:01:26.890 align:start position:0%
professional Baker your database would
contain<00:01:25.130><c> more</c><00:01:25.430><c> you'd</c><00:01:25.970><c> have</c><00:01:26.180><c> products</c><00:01:26.780><c> and</c>

00:01:26.890 --> 00:01:26.900 align:start position:0%
contain more you'd have products and
 

00:01:26.900 --> 00:01:29.170 align:start position:0%
contain more you'd have products and
customers<00:01:27.410><c> and</c><00:01:27.620><c> other</c><00:01:28.310><c> things</c><00:01:28.610><c> to</c><00:01:28.790><c> keep</c><00:01:28.940><c> track</c>

00:01:29.170 --> 00:01:29.180 align:start position:0%
customers and other things to keep track
 

00:01:29.180 --> 00:01:32.260 align:start position:0%
customers and other things to keep track
of<00:01:29.390><c> like</c><00:01:29.570><c> prices</c><00:01:30.080><c> sales</c><00:01:30.800><c> units</c><00:01:31.250><c> and</c><00:01:31.430><c> a</c><00:01:31.970><c> list</c><00:01:32.180><c> of</c>

00:01:32.260 --> 00:01:32.270 align:start position:0%
of like prices sales units and a list of
 

00:01:32.270 --> 00:01:34.660 align:start position:0%
of like prices sales units and a list of
orders<00:01:32.630><c> this</c><00:01:33.470><c> access</c><00:01:33.860><c> actually</c><00:01:34.310><c> keep</c><00:01:34.490><c> these</c>

00:01:34.660 --> 00:01:34.670 align:start position:0%
orders this access actually keep these
 

00:01:34.670 --> 00:01:36.250 align:start position:0%
orders this access actually keep these
things<00:01:34.880><c> in</c><00:01:35.060><c> a</c><00:01:35.180><c> big</c><00:01:35.390><c> long</c><00:01:35.630><c> list</c>

00:01:36.250 --> 00:01:36.260 align:start position:0%
things in a big long list
 

00:01:36.260 --> 00:01:39.490 align:start position:0%
things in a big long list
not<00:01:36.920><c> quite</c><00:01:37.210><c> instead</c><00:01:38.210><c> it</c><00:01:38.360><c> uses</c><00:01:38.510><c> tables</c><00:01:39.110><c> like</c>

00:01:39.490 --> 00:01:39.500 align:start position:0%
not quite instead it uses tables like
 

00:01:39.500 --> 00:01:41.530 align:start position:0%
not quite instead it uses tables like
the<00:01:39.650><c> ones</c><00:01:39.830><c> in</c><00:01:39.980><c> Excel</c><00:01:40.400><c> to</c><00:01:40.850><c> list</c><00:01:41.060><c> things</c><00:01:41.270><c> in</c><00:01:41.450><c> a</c>

00:01:41.530 --> 00:01:41.540 align:start position:0%
the ones in Excel to list things in a
 

00:01:41.540 --> 00:01:43.630 align:start position:0%
the ones in Excel to list things in a
little<00:01:41.840><c> more</c><00:01:41.960><c> detail</c><00:01:42.350><c> take</c><00:01:43.070><c> this</c><00:01:43.220><c> example</c>

00:01:43.630 --> 00:01:43.640 align:start position:0%
little more detail take this example
 

00:01:43.640 --> 00:01:45.430 align:start position:0%
little more detail take this example
from<00:01:43.910><c> the</c><00:01:44.060><c> amateur</c><00:01:44.450><c> Baker's</c><00:01:44.750><c> database</c>

00:01:45.430 --> 00:01:45.440 align:start position:0%
from the amateur Baker's database
 

00:01:45.440 --> 00:01:47.320 align:start position:0%
from the amateur Baker's database
it<00:01:45.710><c> lists</c><00:01:46.100><c> friends</c><00:01:46.430><c> and</c><00:01:46.580><c> family</c><00:01:46.940><c> but</c><00:01:47.150><c> also</c>

00:01:47.320 --> 00:01:47.330 align:start position:0%
it lists friends and family but also
 

00:01:47.330 --> 00:01:49.360 align:start position:0%
it lists friends and family but also
important<00:01:47.900><c> information</c><00:01:48.440><c> like</c><00:01:48.470><c> who</c><00:01:48.890><c> has</c><00:01:49.070><c> a</c><00:01:49.100><c> nut</c>

00:01:49.360 --> 00:01:49.370 align:start position:0%
important information like who has a nut
 

00:01:49.370 --> 00:01:52.450 align:start position:0%
important information like who has a nut
allergy<00:01:49.400><c> in</c><00:01:49.910><c> the</c><00:01:49.970><c> rest</c><00:01:50.180><c> of</c><00:01:50.330><c> the</c><00:01:50.420><c> table</c><00:01:50.780><c> so</c><00:01:51.740><c> if</c><00:01:51.980><c> a</c>

00:01:52.450 --> 00:01:52.460 align:start position:0%
allergy in the rest of the table so if a
 

00:01:52.460 --> 00:01:54.460 align:start position:0%
allergy in the rest of the table so if a
database<00:01:52.700><c> is</c><00:01:53.180><c> essentially</c><00:01:53.870><c> a</c><00:01:53.900><c> collection</c><00:01:54.140><c> of</c>

00:01:54.460 --> 00:01:54.470 align:start position:0%
database is essentially a collection of
 

00:01:54.470 --> 00:01:56.649 align:start position:0%
database is essentially a collection of
lists<00:01:54.890><c> stored</c><00:01:55.250><c> in</c><00:01:55.400><c> tables</c><00:01:55.580><c> and</c><00:01:56.030><c> you</c><00:01:56.330><c> can</c><00:01:56.510><c> build</c>

00:01:56.649 --> 00:01:56.659 align:start position:0%
lists stored in tables and you can build
 

00:01:56.659 --> 00:01:57.820 align:start position:0%
lists stored in tables and you can build
tables<00:01:57.140><c> in</c><00:01:57.230><c> Excel</c>

00:01:57.820 --> 00:01:57.830 align:start position:0%
tables in Excel
 

00:01:57.830 --> 00:02:00.280 align:start position:0%
tables in Excel
why<00:01:58.130><c> access</c><00:01:58.670><c> why</c><00:01:59.300><c> do</c><00:01:59.360><c> you</c><00:01:59.480><c> need</c><00:01:59.630><c> a</c><00:01:59.659><c> database</c><00:02:00.110><c> at</c>

00:02:00.280 --> 00:02:00.290 align:start position:0%
why access why do you need a database at
 

00:02:00.290 --> 00:02:03.490 align:start position:0%
why access why do you need a database at
all<00:02:00.440><c> let's</c><00:02:01.280><c> compare</c><00:02:01.670><c> while</c><00:02:02.630><c> Excel</c><00:02:03.050><c> is</c><00:02:03.230><c> great</c>

00:02:03.490 --> 00:02:03.500 align:start position:0%
all let's compare while Excel is great
 

00:02:03.500 --> 00:02:05.980 align:start position:0%
all let's compare while Excel is great
at<00:02:03.650><c> storing</c><00:02:04.100><c> and</c><00:02:04.250><c> organizing</c><00:02:04.370><c> numbers</c><00:02:05.240><c> access</c>

00:02:05.980 --> 00:02:05.990 align:start position:0%
at storing and organizing numbers access
 

00:02:05.990 --> 00:02:07.870 align:start position:0%
at storing and organizing numbers access
is<00:02:06.140><c> better</c><00:02:06.350><c> at</c><00:02:06.530><c> analyzing</c><00:02:06.950><c> and</c><00:02:07.400><c> connecting</c>

00:02:07.870 --> 00:02:07.880 align:start position:0%
is better at analyzing and connecting
 

00:02:07.880 --> 00:02:10.029 align:start position:0%
is better at analyzing and connecting
other<00:02:08.060><c> types</c><00:02:08.390><c> of</c><00:02:08.539><c> data</c><00:02:08.690><c> for</c><00:02:09.289><c> example</c><00:02:09.349><c> names</c>

00:02:10.029 --> 00:02:10.039 align:start position:0%
other types of data for example names
 

00:02:10.039 --> 00:02:11.949 align:start position:0%
other types of data for example names
and<00:02:10.280><c> descriptions</c><00:02:10.340><c> or</c><00:02:11.090><c> your</c><00:02:11.480><c> friends</c><00:02:11.810><c> and</c>

00:02:11.949 --> 00:02:11.959 align:start position:0%
and descriptions or your friends and
 

00:02:11.959 --> 00:02:14.020 align:start position:0%
and descriptions or your friends and
their<00:02:12.050><c> favorite</c><00:02:12.230><c> cookies</c><00:02:12.680><c> the</c><00:02:13.430><c> databases</c>

00:02:14.020 --> 00:02:14.030 align:start position:0%
their favorite cookies the databases
 

00:02:14.030 --> 00:02:15.610 align:start position:0%
their favorite cookies the databases
you'll<00:02:14.180><c> be</c><00:02:14.300><c> working</c><00:02:14.629><c> with</c><00:02:14.659><c> in</c><00:02:14.810><c> Access</c><00:02:15.379><c> can</c>

00:02:15.610 --> 00:02:15.620 align:start position:0%
you'll be working with in Access can
 

00:02:15.620 --> 00:02:17.830 align:start position:0%
you'll be working with in Access can
actually<00:02:16.129><c> understand</c><00:02:16.730><c> how</c><00:02:16.879><c> different</c><00:02:17.329><c> lists</c>

00:02:17.830 --> 00:02:17.840 align:start position:0%
actually understand how different lists
 

00:02:17.840 --> 00:02:19.179 align:start position:0%
actually understand how different lists
and<00:02:17.989><c> their</c><00:02:18.079><c> contents</c><00:02:18.560><c> relate</c><00:02:18.889><c> to</c><00:02:19.040><c> one</c><00:02:19.159><c> another</c>

00:02:19.179 --> 00:02:19.189 align:start position:0%
and their contents relate to one another
 

00:02:19.189 --> 00:02:22.030 align:start position:0%
and their contents relate to one another
we<00:02:20.090><c> call</c><00:02:20.299><c> this</c><00:02:20.480><c> a</c><00:02:20.689><c> relational</c><00:02:21.230><c> database</c>

00:02:22.030 --> 00:02:22.040 align:start position:0%
we call this a relational database
 

00:02:22.040 --> 00:02:23.470 align:start position:0%
we call this a relational database
for<00:02:22.189><c> its</c><00:02:22.340><c> ability</c><00:02:22.760><c> to</c><00:02:22.969><c> understand</c>

00:02:23.470 --> 00:02:23.480 align:start position:0%
for its ability to understand
 

00:02:23.480 --> 00:02:25.479 align:start position:0%
for its ability to understand
relationships<00:02:24.110><c> and</c><00:02:24.349><c> it's</c><00:02:24.739><c> really</c><00:02:25.010><c> what</c><00:02:25.250><c> sets</c>

00:02:25.479 --> 00:02:25.489 align:start position:0%
relationships and it's really what sets
 

00:02:25.489 --> 00:02:27.789 align:start position:0%
relationships and it's really what sets
access<00:02:25.909><c> apart</c><00:02:26.269><c> let's</c><00:02:26.989><c> think</c><00:02:27.170><c> about</c><00:02:27.349><c> what</c><00:02:27.680><c> that</c>

00:02:27.789 --> 00:02:27.799 align:start position:0%
access apart let's think about what that
 

00:02:27.799 --> 00:02:29.649 align:start position:0%
access apart let's think about what that
means<00:02:28.040><c> while</c><00:02:28.430><c> we</c><00:02:28.549><c> go</c><00:02:28.670><c> back</c><00:02:28.849><c> to</c><00:02:29.090><c> our</c><00:02:29.120><c> amateur</c>

00:02:29.649 --> 00:02:29.659 align:start position:0%
means while we go back to our amateur
 

00:02:29.659 --> 00:02:32.050 align:start position:0%
means while we go back to our amateur
bakers<00:02:29.989><c> database</c><00:02:30.409><c> and</c><00:02:30.709><c> build</c><00:02:31.370><c> a</c><00:02:31.519><c> third</c><00:02:31.730><c> list</c>

00:02:32.050 --> 00:02:32.060 align:start position:0%
bakers database and build a third list
 

00:02:32.060 --> 00:02:33.849 align:start position:0%
bakers database and build a third list
to<00:02:32.239><c> keep</c><00:02:32.420><c> track</c><00:02:32.689><c> of</c><00:02:32.719><c> batches</c><00:02:33.230><c> of</c><00:02:33.349><c> cookies</c><00:02:33.469><c> and</c>

00:02:33.849 --> 00:02:33.859 align:start position:0%
to keep track of batches of cookies and
 

00:02:33.859 --> 00:02:36.130 align:start position:0%
to keep track of batches of cookies and
who<00:02:34.250><c> therefore</c><00:02:34.459><c> it's</c><00:02:35.450><c> easy</c><00:02:35.719><c> to</c><00:02:35.959><c> see</c><00:02:36.109><c> the</c>

00:02:36.130 --> 00:02:36.140 align:start position:0%
who therefore it's easy to see the
 

00:02:36.140 --> 00:02:38.410 align:start position:0%
who therefore it's easy to see the
relationship<00:02:36.859><c> here</c><00:02:37.189><c> all</c><00:02:37.370><c> I</c><00:02:37.579><c> did</c><00:02:37.969><c> was</c><00:02:38.180><c> pull</c>

00:02:38.410 --> 00:02:38.420 align:start position:0%
relationship here all I did was pull
 

00:02:38.420 --> 00:02:40.720 align:start position:0%
relationship here all I did was pull
Duane<00:02:38.750><c> from</c><00:02:38.989><c> this</c><00:02:39.170><c> list</c><00:02:39.439><c> and</c><00:02:39.650><c> shortbread</c><00:02:40.489><c> from</c>

00:02:40.720 --> 00:02:40.730 align:start position:0%
Duane from this list and shortbread from
 

00:02:40.730 --> 00:02:43.240 align:start position:0%
Duane from this list and shortbread from
here<00:02:41.079><c> access</c><00:02:42.079><c> can</c><00:02:42.290><c> see</c><00:02:42.500><c> and</c><00:02:42.709><c> use</c><00:02:42.980><c> that</c>

00:02:43.240 --> 00:02:43.250 align:start position:0%
here access can see and use that
 

00:02:43.250 --> 00:02:46.300 align:start position:0%
here access can see and use that
relationship<00:02:43.700><c> too</c><00:02:44.120><c> but</c><00:02:44.569><c> Excel</c><00:02:44.989><c> can't</c><00:02:45.349><c> all</c><00:02:46.069><c> of</c>

00:02:46.300 --> 00:02:46.310 align:start position:0%
relationship too but Excel can't all of
 

00:02:46.310 --> 00:02:48.069 align:start position:0%
relationship too but Excel can't all of
these<00:02:46.459><c> things</c><00:02:46.730><c> are</c><00:02:46.879><c> completely</c><00:02:47.390><c> unrelated</c><00:02:47.780><c> as</c>

00:02:48.069 --> 00:02:48.079 align:start position:0%
these things are completely unrelated as
 

00:02:48.079 --> 00:02:50.319 align:start position:0%
these things are completely unrelated as
far<00:02:48.319><c> as</c><00:02:48.439><c> Excel</c><00:02:48.799><c> is</c><00:02:48.950><c> concerned</c><00:02:49.400><c> that</c><00:02:49.879><c> means</c><00:02:50.150><c> you</c>

00:02:50.319 --> 00:02:50.329 align:start position:0%
far as Excel is concerned that means you
 

00:02:50.329 --> 00:02:51.789 align:start position:0%
far as Excel is concerned that means you
wouldn't<00:02:50.599><c> be</c><00:02:50.689><c> able</c><00:02:50.780><c> to</c><00:02:50.900><c> pull</c><00:02:51.170><c> from</c><00:02:51.200><c> one</c><00:02:51.590><c> list</c>

00:02:51.789 --> 00:02:51.799 align:start position:0%
wouldn't be able to pull from one list
 

00:02:51.799 --> 00:02:53.589 align:start position:0%
wouldn't be able to pull from one list
to<00:02:51.950><c> another</c><00:02:52.180><c> eventually</c><00:02:53.180><c> you'd</c><00:02:53.359><c> find</c>

00:02:53.589 --> 00:02:53.599 align:start position:0%
to another eventually you'd find
 

00:02:53.599 --> 00:02:55.270 align:start position:0%
to another eventually you'd find
yourself<00:02:53.719><c> typing</c><00:02:54.139><c> the</c><00:02:54.470><c> same</c><00:02:54.620><c> thing</c><00:02:54.889><c> over</c><00:02:55.129><c> and</c>

00:02:55.270 --> 00:02:55.280 align:start position:0%
yourself typing the same thing over and
 

00:02:55.280 --> 00:02:57.129 align:start position:0%
yourself typing the same thing over and
over<00:02:55.459><c> every</c><00:02:56.060><c> time</c><00:02:56.239><c> you</c><00:02:56.389><c> needed</c><00:02:56.599><c> to</c><00:02:56.810><c> refer</c><00:02:57.109><c> to</c>

00:02:57.129 --> 00:02:57.139 align:start position:0%
over every time you needed to refer to
 

00:02:57.139 --> 00:02:59.589 align:start position:0%
over every time you needed to refer to
Duane<00:02:57.560><c> or</c><00:02:57.889><c> your</c><00:02:58.010><c> shortbread</c><00:02:58.430><c> recipe</c><00:02:58.459><c> or</c><00:02:59.090><c> dad</c>

00:02:59.589 --> 00:02:59.599 align:start position:0%
Duane or your shortbread recipe or dad
 

00:02:59.599 --> 00:03:02.259 align:start position:0%
Duane or your shortbread recipe or dad
and<00:02:59.750><c> chocolate</c><00:03:00.139><c> chip</c><00:03:00.319><c> in</c><00:03:00.700><c> short</c><00:03:01.700><c> access</c>

00:03:02.259 --> 00:03:02.269 align:start position:0%
and chocolate chip in short access
 

00:03:02.269 --> 00:03:04.629 align:start position:0%
and chocolate chip in short access
thinks<00:03:02.629><c> more</c><00:03:02.840><c> like</c><00:03:03.049><c> you</c><00:03:03.290><c> it</c><00:03:03.609><c> recognizes</c><00:03:04.609><c> that</c>

00:03:04.629 --> 00:03:04.639 align:start position:0%
thinks more like you it recognizes that
 

00:03:04.639 --> 00:03:06.399 align:start position:0%
thinks more like you it recognizes that
the<00:03:04.909><c> items</c><00:03:05.209><c> in</c><00:03:05.389><c> these</c><00:03:05.569><c> three</c><00:03:05.840><c> lists</c><00:03:06.230><c> are</c>

00:03:06.399 --> 00:03:06.409 align:start position:0%
the items in these three lists are
 

00:03:06.409 --> 00:03:08.830 align:start position:0%
the items in these three lists are
connected<00:03:06.889><c> that</c><00:03:07.579><c> makes</c><00:03:07.819><c> entering</c><00:03:08.359><c> searching</c>

00:03:08.830 --> 00:03:08.840 align:start position:0%
connected that makes entering searching
 

00:03:08.840 --> 00:03:10.869 align:start position:0%
connected that makes entering searching
and<00:03:08.989><c> analyzing</c><00:03:09.109><c> data</c><00:03:09.680><c> so</c><00:03:10.129><c> much</c><00:03:10.430><c> easier</c>

00:03:10.869 --> 00:03:10.879 align:start position:0%
and analyzing data so much easier
 

00:03:10.879 --> 00:03:12.849 align:start position:0%
and analyzing data so much easier
whether<00:03:11.359><c> you</c><00:03:11.599><c> have</c><00:03:11.780><c> two</c><00:03:11.989><c> lists</c><00:03:12.379><c> or</c><00:03:12.530><c> twenty</c>

00:03:12.849 --> 00:03:12.859 align:start position:0%
whether you have two lists or twenty
 

00:03:12.859 --> 00:03:15.759 align:start position:0%
whether you have two lists or twenty
less<00:03:13.489><c> to</c><00:03:13.669><c> type</c><00:03:13.879><c> less</c><00:03:14.180><c> to</c><00:03:14.329><c> keep</c><00:03:14.480><c> track</c><00:03:14.689><c> of</c><00:03:14.900><c> even</c>

00:03:15.759 --> 00:03:15.769 align:start position:0%
less to type less to keep track of even
 

00:03:15.769 --> 00:03:17.649 align:start position:0%
less to type less to keep track of even
the<00:03:15.859><c> most</c><00:03:15.889><c> complicated</c><00:03:16.430><c> tasks</c><00:03:17.150><c> can</c><00:03:17.359><c> be</c><00:03:17.389><c> made</c>

00:03:17.649 --> 00:03:17.659 align:start position:0%
the most complicated tasks can be made
 

00:03:17.659 --> 00:03:19.330 align:start position:0%
the most complicated tasks can be made
simple<00:03:18.109><c> and</c><00:03:18.200><c> user-friendly</c><00:03:18.590><c> once</c><00:03:19.189><c> you</c>

00:03:19.330 --> 00:03:19.340 align:start position:0%
simple and user-friendly once you
 

00:03:19.340 --> 00:03:22.710 align:start position:0%
simple and user-friendly once you
understand<00:03:19.879><c> how</c><00:03:20.000><c> access</c><00:03:20.599><c> and</c><00:03:20.840><c> databases</c><00:03:21.409><c> work</c>

00:03:22.710 --> 00:03:22.720 align:start position:0%
understand how access and databases work
 

00:03:22.720 --> 00:03:26.710 align:start position:0%
understand how access and databases work
like<00:03:23.720><c> what</c><00:03:23.900><c> you</c><00:03:24.079><c> just</c><00:03:24.230><c> saw</c><00:03:25.120><c> rated</c><00:03:26.120><c> at</c><00:03:26.659><c> a</c>

00:03:26.710 --> 00:03:26.720 align:start position:0%
like what you just saw rated at a
 

00:03:26.720 --> 00:03:29.770 align:start position:0%
like what you just saw rated at a
comment<00:03:27.229><c> subscribe</c><00:03:27.769><c> to</c><00:03:28.220><c> our</c><00:03:28.310><c> chil</c><00:03:28.780><c> the</c>

00:03:29.770 --> 00:03:29.780 align:start position:0%
comment subscribe to our chil the
 

00:03:29.780 --> 00:03:31.530 align:start position:0%
comment subscribe to our chil the
freedom<00:03:30.229><c> to</c><00:03:30.260><c> learn</c>

00:03:31.530 --> 00:03:31.540 align:start position:0%
freedom to learn
 

00:03:31.540 --> 00:03:36.270 align:start position:0%
freedom to learn
what<00:03:32.170><c> you</c><00:03:32.349><c> want</c><00:03:32.849><c> when</c><00:03:33.849><c> you</c><00:03:33.879><c> want</c><00:03:35.280><c> absolutely</c>

00:03:36.270 --> 00:03:36.280 align:start position:0%
what you want when you want absolutely
 

00:03:36.280 --> 00:03:40.430 align:start position:0%
what you want when you want absolutely
free

00:03:40.430 --> 00:03:40.440 align:start position:0%
 
 

00:03:40.440 --> 00:03:44.070 align:start position:0%
 
GCF<00:03:41.440><c> learn</c><00:03:42.040><c> free.org</c>