WEBVTT
Kind: captions
Language: en

00:00:11.449 --> 00:00:14.959 align:start position:0%
 
if<00:00:12.449><c> you've</c><00:00:13.019><c> looked</c><00:00:13.199><c> for</c><00:00:13.349><c> a</c><00:00:13.500><c> job</c><00:00:13.529><c> online</c><00:00:13.980><c> or</c>

00:00:14.959 --> 00:00:14.969 align:start position:0%
if you've looked for a job online or
 

00:00:14.969 --> 00:00:16.939 align:start position:0%
if you've looked for a job online or
search<00:00:15.299><c> for</c><00:00:15.330><c> a</c><00:00:15.660><c> book</c><00:00:15.839><c> at</c><00:00:15.990><c> your</c><00:00:16.080><c> local</c><00:00:16.320><c> library</c>

00:00:16.939 --> 00:00:16.949 align:start position:0%
search for a book at your local library
 

00:00:16.949 --> 00:00:19.279 align:start position:0%
search for a book at your local library
you<00:00:17.490><c> know</c><00:00:17.640><c> first</c><00:00:17.910><c> hand</c><00:00:18.180><c> what</c><00:00:18.360><c> databases</c><00:00:18.930><c> can</c>

00:00:19.279 --> 00:00:19.289 align:start position:0%
you know first hand what databases can
 

00:00:19.289 --> 00:00:21.620 align:start position:0%
you know first hand what databases can
do<00:00:19.470><c> but</c><00:00:20.130><c> do</c><00:00:20.250><c> you</c><00:00:20.340><c> know</c><00:00:20.520><c> how</c><00:00:20.759><c> they</c><00:00:20.970><c> work</c><00:00:21.180><c> what</c>

00:00:21.620 --> 00:00:21.630 align:start position:0%
do but do you know how they work what
 

00:00:21.630 --> 00:00:24.170 align:start position:0%
do but do you know how they work what
goes<00:00:21.810><c> on</c><00:00:21.960><c> behind</c><00:00:22.349><c> the</c><00:00:22.439><c> scenes</c><00:00:22.710><c> in</c><00:00:23.180><c> Microsoft</c>

00:00:24.170 --> 00:00:24.180 align:start position:0%
goes on behind the scenes in Microsoft
 

00:00:24.180 --> 00:00:26.359 align:start position:0%
goes on behind the scenes in Microsoft
Access<00:00:24.480><c> databases</c><00:00:25.410><c> are</c><00:00:25.710><c> made</c><00:00:25.860><c> up</c><00:00:25.980><c> of</c><00:00:26.129><c> four</c>

00:00:26.359 --> 00:00:26.369 align:start position:0%
Access databases are made up of four
 

00:00:26.369 --> 00:00:29.540 align:start position:0%
Access databases are made up of four
simple<00:00:26.759><c> objects</c><00:00:27.360><c> tables</c><00:00:28.020><c> forms</c><00:00:28.739><c> queries</c><00:00:29.340><c> and</c>

00:00:29.540 --> 00:00:29.550 align:start position:0%
simple objects tables forms queries and
 

00:00:29.550 --> 00:00:32.479 align:start position:0%
simple objects tables forms queries and
reports<00:00:30.020><c> together</c><00:00:31.020><c> these</c><00:00:31.559><c> objects</c><00:00:32.219><c> allow</c><00:00:32.430><c> you</c>

00:00:32.479 --> 00:00:32.489 align:start position:0%
reports together these objects allow you
 

00:00:32.489 --> 00:00:34.250 align:start position:0%
reports together these objects allow you
to<00:00:32.700><c> do</c><00:00:32.850><c> all</c><00:00:32.879><c> the</c><00:00:33.270><c> things</c><00:00:33.480><c> you</c><00:00:33.629><c> associate</c><00:00:34.230><c> with</c>

00:00:34.250 --> 00:00:34.260 align:start position:0%
to do all the things you associate with
 

00:00:34.260 --> 00:00:36.350 align:start position:0%
to do all the things you associate with
using<00:00:34.710><c> a</c><00:00:34.800><c> database</c><00:00:35.070><c> from</c><00:00:35.789><c> storing</c><00:00:36.210><c> and</c>

00:00:36.350 --> 00:00:36.360 align:start position:0%
using a database from storing and
 

00:00:36.360 --> 00:00:38.299 align:start position:0%
using a database from storing and
entering<00:00:36.750><c> more</c><00:00:36.989><c> and</c><00:00:37.170><c> more</c><00:00:37.350><c> information</c><00:00:38.010><c> to</c>

00:00:38.299 --> 00:00:38.309 align:start position:0%
entering more and more information to
 

00:00:38.309 --> 00:00:40.340 align:start position:0%
entering more and more information to
analyzing<00:00:38.879><c> and</c><00:00:39.210><c> compiling</c><00:00:39.570><c> search</c><00:00:39.899><c> results</c>

00:00:40.340 --> 00:00:40.350 align:start position:0%
analyzing and compiling search results
 

00:00:40.350 --> 00:00:42.500 align:start position:0%
analyzing and compiling search results
by<00:00:41.190><c> now</c><00:00:41.340><c> you</c><00:00:41.400><c> should</c><00:00:41.700><c> know</c><00:00:41.730><c> that</c><00:00:42.000><c> a</c><00:00:42.060><c> database</c>

00:00:42.500 --> 00:00:42.510 align:start position:0%
by now you should know that a database
 

00:00:42.510 --> 00:00:44.180 align:start position:0%
by now you should know that a database
is<00:00:42.780><c> essentially</c><00:00:43.350><c> a</c><00:00:43.380><c> collection</c><00:00:43.920><c> of</c><00:00:44.010><c> data</c>

00:00:44.180 --> 00:00:44.190 align:start position:0%
is essentially a collection of data
 

00:00:44.190 --> 00:00:46.700 align:start position:0%
is essentially a collection of data
organized<00:00:44.970><c> into</c><00:00:45.390><c> many</c><00:00:45.570><c> connected</c><00:00:46.050><c> lists</c><00:00:46.560><c> or</c>

00:00:46.700 --> 00:00:46.710 align:start position:0%
organized into many connected lists or
 

00:00:46.710 --> 00:00:49.490 align:start position:0%
organized into many connected lists or
tables<00:00:47.310><c> that</c><00:00:47.910><c> puts</c><00:00:48.210><c> tables</c><00:00:48.810><c> at</c><00:00:48.989><c> the</c><00:00:49.050><c> heart</c><00:00:49.410><c> of</c>

00:00:49.490 --> 00:00:49.500 align:start position:0%
tables that puts tables at the heart of
 

00:00:49.500 --> 00:00:51.350 align:start position:0%
tables that puts tables at the heart of
any<00:00:49.620><c> database</c><00:00:49.860><c> the</c><00:00:50.550><c> place</c><00:00:50.790><c> where</c><00:00:51.149><c> your</c>

00:00:51.350 --> 00:00:51.360 align:start position:0%
any database the place where your
 

00:00:51.360 --> 00:00:54.139 align:start position:0%
any database the place where your
information<00:00:51.540><c> is</c><00:00:52.110><c> stored</c><00:00:52.430><c> this</c><00:00:53.430><c> table</c><00:00:53.850><c> is</c><00:00:53.940><c> from</c>

00:00:54.139 --> 00:00:54.149 align:start position:0%
information is stored this table is from
 

00:00:54.149 --> 00:00:55.760 align:start position:0%
information is stored this table is from
an<00:00:54.270><c> actual</c><00:00:54.450><c> Access</c><00:00:55.079><c> database</c>

00:00:55.760 --> 00:00:55.770 align:start position:0%
an actual Access database
 

00:00:55.770 --> 00:00:58.400 align:start position:0%
an actual Access database
mine<00:00:56.160><c> it's</c><00:00:56.760><c> a</c><00:00:56.940><c> list</c><00:00:57.120><c> of</c><00:00:57.270><c> customers</c><00:00:57.480><c> one</c><00:00:58.200><c> of</c><00:00:58.290><c> the</c>

00:00:58.400 --> 00:00:58.410 align:start position:0%
mine it's a list of customers one of the
 

00:00:58.410 --> 00:01:00.200 align:start position:0%
mine it's a list of customers one of the
many<00:00:58.590><c> things</c><00:00:58.829><c> I</c><00:00:59.040><c> keep</c><00:00:59.250><c> on</c><00:00:59.370><c> file</c><00:00:59.700><c> to</c><00:00:59.910><c> help</c><00:01:00.030><c> me</c>

00:01:00.200 --> 00:01:00.210 align:start position:0%
many things I keep on file to help me
 

00:01:00.210 --> 00:01:02.690 align:start position:0%
many things I keep on file to help me
run<00:01:00.360><c> my</c><00:01:00.540><c> business</c><00:01:00.930><c> a</c><00:01:01.140><c> specialty</c><00:01:01.559><c> bakery</c><00:01:02.040><c> the</c>

00:01:02.690 --> 00:01:02.700 align:start position:0%
run my business a specialty bakery the
 

00:01:02.700 --> 00:01:04.850 align:start position:0%
run my business a specialty bakery the
familiar<00:01:03.149><c> layout</c><00:01:03.329><c> of</c><00:01:03.630><c> horizontal</c><00:01:04.290><c> rows</c><00:01:04.500><c> and</c>

00:01:04.850 --> 00:01:04.860 align:start position:0%
familiar layout of horizontal rows and
 

00:01:04.860 --> 00:01:07.039 align:start position:0%
familiar layout of horizontal rows and
vertical<00:01:05.640><c> columns</c><00:01:06.060><c> takes</c><00:01:06.570><c> on</c><00:01:06.750><c> a</c><00:01:06.780><c> new</c><00:01:06.869><c> meaning</c>

00:01:07.039 --> 00:01:07.049 align:start position:0%
vertical columns takes on a new meaning
 

00:01:07.049 --> 00:01:09.950 align:start position:0%
vertical columns takes on a new meaning
here<00:01:07.619><c> an</c><00:01:07.799><c> access</c><00:01:08.670><c> a</c><00:01:08.850><c> row</c><00:01:09.060><c> is</c><00:01:09.240><c> more</c><00:01:09.450><c> than</c><00:01:09.600><c> a</c><00:01:09.719><c> row</c>

00:01:09.950 --> 00:01:09.960 align:start position:0%
here an access a row is more than a row
 

00:01:09.960 --> 00:01:12.230 align:start position:0%
here an access a row is more than a row
it's<00:01:10.290><c> a</c><00:01:10.500><c> record</c><00:01:10.860><c> just</c><00:01:11.040><c> like</c><00:01:11.640><c> these</c><00:01:11.850><c> are</c><00:01:12.030><c> more</c>

00:01:12.230 --> 00:01:12.240 align:start position:0%
it's a record just like these are more
 

00:01:12.240 --> 00:01:14.059 align:start position:0%
it's a record just like these are more
than<00:01:12.420><c> names</c><00:01:12.630><c> and</c><00:01:12.899><c> addresses</c><00:01:13.200><c> they're</c><00:01:13.679><c> people</c>

00:01:14.059 --> 00:01:14.069 align:start position:0%
than names and addresses they're people
 

00:01:14.069 --> 00:01:16.639 align:start position:0%
than names and addresses they're people
some<00:01:14.520><c> of</c><00:01:14.549><c> them</c><00:01:14.789><c> my</c><00:01:14.939><c> favorite</c><00:01:15.329><c> customers</c><00:01:15.780><c> each</c>

00:01:16.639 --> 00:01:16.649 align:start position:0%
some of them my favorite customers each
 

00:01:16.649 --> 00:01:18.529 align:start position:0%
some of them my favorite customers each
record<00:01:16.950><c> begins</c><00:01:17.429><c> with</c><00:01:17.670><c> a</c><00:01:17.700><c> unique</c><00:01:18.060><c> ID</c><00:01:18.329><c> number</c>

00:01:18.529 --> 00:01:18.539 align:start position:0%
record begins with a unique ID number
 

00:01:18.539 --> 00:01:21.289 align:start position:0%
record begins with a unique ID number
and<00:01:18.990><c> spans</c><00:01:19.530><c> several</c><00:01:19.829><c> fields</c><00:01:20.490><c> including</c><00:01:21.179><c> in</c>

00:01:21.289 --> 00:01:21.299 align:start position:0%
and spans several fields including in
 

00:01:21.299 --> 00:01:23.779 align:start position:0%
and spans several fields including in
this<00:01:21.420><c> example</c><00:01:21.810><c> first</c><00:01:22.259><c> name</c><00:01:22.590><c> last</c><00:01:23.159><c> name</c><00:01:23.399><c> street</c>

00:01:23.779 --> 00:01:23.789 align:start position:0%
this example first name last name street
 

00:01:23.789 --> 00:01:26.929 align:start position:0%
this example first name last name street
address<00:01:24.179><c> and</c><00:01:24.719><c> more</c><00:01:25.219><c> notice</c><00:01:26.219><c> I</c><00:01:26.369><c> used</c><00:01:26.609><c> the</c><00:01:26.789><c> word</c>

00:01:26.929 --> 00:01:26.939 align:start position:0%
address and more notice I used the word
 

00:01:26.939 --> 00:01:30.019 align:start position:0%
address and more notice I used the word
field<00:01:27.359><c> instead</c><00:01:27.810><c> of</c><00:01:27.869><c> column</c><00:01:28.380><c> in</c><00:01:28.560><c> Access</c><00:01:29.429><c> fields</c>

00:01:30.019 --> 00:01:30.029 align:start position:0%
field instead of column in Access fields
 

00:01:30.029 --> 00:01:31.849 align:start position:0%
field instead of column in Access fields
are<00:01:30.149><c> designed</c><00:01:30.509><c> to</c><00:01:30.600><c> organize</c><00:01:31.079><c> the</c><00:01:31.289><c> contents</c><00:01:31.770><c> of</c>

00:01:31.849 --> 00:01:31.859 align:start position:0%
are designed to organize the contents of
 

00:01:31.859 --> 00:01:33.529 align:start position:0%
are designed to organize the contents of
your<00:01:31.920><c> records</c><00:01:32.369><c> without</c><00:01:32.609><c> actually</c><00:01:33.389><c> breaking</c>

00:01:33.529 --> 00:01:33.539 align:start position:0%
your records without actually breaking
 

00:01:33.539 --> 00:01:35.899 align:start position:0%
your records without actually breaking
them<00:01:33.929><c> up</c><00:01:34.049><c> that</c><00:01:34.709><c> means</c><00:01:34.979><c> every</c><00:01:35.310><c> entry</c><00:01:35.639><c> in</c><00:01:35.789><c> the</c>

00:01:35.899 --> 00:01:35.909 align:start position:0%
them up that means every entry in the
 

00:01:35.909 --> 00:01:37.699 align:start position:0%
them up that means every entry in the
first<00:01:36.060><c> name</c><00:01:36.329><c> field</c><00:01:36.389><c> is</c><00:01:36.929><c> going</c><00:01:37.200><c> to</c><00:01:37.289><c> be</c><00:01:37.380><c> a</c><00:01:37.409><c> name</c>

00:01:37.699 --> 00:01:37.709 align:start position:0%
first name field is going to be a name
 

00:01:37.709 --> 00:01:40.190 align:start position:0%
first name field is going to be a name
and<00:01:38.149><c> every</c><00:01:39.149><c> entry</c><00:01:39.479><c> in</c><00:01:39.659><c> the</c><00:01:39.779><c> street</c><00:01:40.079><c> address</c>

00:01:40.190 --> 00:01:40.200 align:start position:0%
and every entry in the street address
 

00:01:40.200 --> 00:01:42.709 align:start position:0%
and every entry in the street address
field<00:01:40.649><c> is</c><00:01:40.829><c> going</c><00:01:41.039><c> to</c><00:01:41.130><c> be</c><00:01:41.219><c> an</c><00:01:41.310><c> address</c><00:01:41.569><c> but</c><00:01:42.569><c> no</c>

00:01:42.709 --> 00:01:42.719 align:start position:0%
field is going to be an address but no
 

00:01:42.719 --> 00:01:44.269 align:start position:0%
field is going to be an address but no
one<00:01:42.840><c> will</c><00:01:42.959><c> ever</c><00:01:43.020><c> become</c><00:01:43.409><c> separated</c><00:01:44.159><c> from</c>

00:01:44.269 --> 00:01:44.279 align:start position:0%
one will ever become separated from
 

00:01:44.279 --> 00:01:45.980 align:start position:0%
one will ever become separated from
their<00:01:44.579><c> record</c><00:01:44.939><c> that's</c><00:01:45.270><c> their</c><00:01:45.569><c> personal</c>

00:01:45.980 --> 00:01:45.990 align:start position:0%
their record that's their personal
 

00:01:45.990 --> 00:01:48.859 align:start position:0%
their record that's their personal
information<00:01:46.670><c> while</c><00:01:47.670><c> tables</c><00:01:48.119><c> are</c><00:01:48.270><c> responsible</c>

00:01:48.859 --> 00:01:48.869 align:start position:0%
information while tables are responsible
 

00:01:48.869 --> 00:01:50.660 align:start position:0%
information while tables are responsible
for<00:01:49.020><c> storing</c><00:01:49.469><c> all</c><00:01:49.619><c> this</c><00:01:49.770><c> data</c><00:01:50.009><c> the</c><00:01:50.490><c> other</c>

00:01:50.660 --> 00:01:50.670 align:start position:0%
for storing all this data the other
 

00:01:50.670 --> 00:01:53.499 align:start position:0%
for storing all this data the other
three<00:01:51.029><c> objects</c><00:01:51.479><c> forms</c><00:01:52.349><c> queries</c><00:01:52.950><c> and</c><00:01:53.159><c> reports</c>

00:01:53.499 --> 00:01:53.509 align:start position:0%
three objects forms queries and reports
 

00:01:53.509 --> 00:01:56.779 align:start position:0%
three objects forms queries and reports
let<00:01:54.509><c> you</c><00:01:54.630><c> work</c><00:01:54.869><c> with</c><00:01:55.049><c> it</c><00:01:55.200><c> forms</c><00:01:56.159><c> are</c><00:01:56.340><c> used</c><00:01:56.549><c> for</c>

00:01:56.779 --> 00:01:56.789 align:start position:0%
let you work with it forms are used for
 

00:01:56.789 --> 00:01:58.940 align:start position:0%
let you work with it forms are used for
entering<00:01:57.270><c> modifying</c><00:01:57.899><c> and</c><00:01:58.169><c> viewing</c><00:01:58.560><c> records</c>

00:01:58.940 --> 00:01:58.950 align:start position:0%
entering modifying and viewing records
 

00:01:58.950 --> 00:02:01.039 align:start position:0%
entering modifying and viewing records
ever<00:01:59.490><c> had</c><00:01:59.849><c> to</c><00:02:00.060><c> fill</c><00:02:00.359><c> out</c><00:02:00.389><c> a</c><00:02:00.509><c> form</c><00:02:00.810><c> while</c>

00:02:01.039 --> 00:02:01.049 align:start position:0%
ever had to fill out a form while
 

00:02:01.049 --> 00:02:02.929 align:start position:0%
ever had to fill out a form while
visiting<00:02:01.409><c> the</c><00:02:01.529><c> doctor's</c><00:02:01.889><c> office</c><00:02:02.039><c> or</c><00:02:02.459><c> applying</c>

00:02:02.929 --> 00:02:02.939 align:start position:0%
visiting the doctor's office or applying
 

00:02:02.939 --> 00:02:05.179 align:start position:0%
visiting the doctor's office or applying
for<00:02:03.149><c> a</c><00:02:03.209><c> job</c><00:02:03.240><c> forms</c><00:02:04.200><c> are</c><00:02:04.349><c> used</c><00:02:04.560><c> so</c><00:02:04.950><c> often</c>

00:02:05.179 --> 00:02:05.189 align:start position:0%
for a job forms are used so often
 

00:02:05.189 --> 00:02:06.830 align:start position:0%
for a job forms are used so often
because<00:02:05.700><c> they're</c><00:02:05.909><c> an</c><00:02:06.029><c> easy</c><00:02:06.270><c> way</c><00:02:06.509><c> to</c><00:02:06.569><c> guide</c>

00:02:06.830 --> 00:02:06.840 align:start position:0%
because they're an easy way to guide
 

00:02:06.840 --> 00:02:09.830 align:start position:0%
because they're an easy way to guide
people<00:02:07.259><c> into</c><00:02:07.439><c> entering</c><00:02:08.039><c> data</c><00:02:08.340><c> correctly</c><00:02:08.840><c> when</c>

00:02:09.830 --> 00:02:09.840 align:start position:0%
people into entering data correctly when
 

00:02:09.840 --> 00:02:11.600 align:start position:0%
people into entering data correctly when
you<00:02:10.050><c> or</c><00:02:10.259><c> someone</c><00:02:10.289><c> else</c><00:02:10.770><c> uses</c><00:02:11.190><c> one</c><00:02:11.340><c> of</c><00:02:11.459><c> your</c>

00:02:11.600 --> 00:02:11.610 align:start position:0%
you or someone else uses one of your
 

00:02:11.610 --> 00:02:13.940 align:start position:0%
you or someone else uses one of your
forms<00:02:11.940><c> and</c><00:02:12.060><c> access</c><00:02:12.510><c> that</c><00:02:13.080><c> data</c><00:02:13.349><c> goes</c><00:02:13.620><c> exactly</c>

00:02:13.940 --> 00:02:13.950 align:start position:0%
forms and access that data goes exactly
 

00:02:13.950 --> 00:02:16.610 align:start position:0%
forms and access that data goes exactly
where<00:02:14.400><c> you</c><00:02:14.610><c> want</c><00:02:14.819><c> it</c><00:02:14.910><c> to</c><00:02:15.030><c> go</c><00:02:15.180><c> this</c><00:02:15.420><c> form</c><00:02:16.410><c> makes</c>

00:02:16.610 --> 00:02:16.620 align:start position:0%
where you want it to go this form makes
 

00:02:16.620 --> 00:02:18.440 align:start position:0%
where you want it to go this form makes
it<00:02:16.770><c> easy</c><00:02:16.920><c> to</c><00:02:17.069><c> add</c><00:02:17.490><c> a</c><00:02:17.520><c> record</c><00:02:17.880><c> for</c><00:02:18.240><c> a</c><00:02:18.270><c> new</c>

00:02:18.440 --> 00:02:18.450 align:start position:0%
it easy to add a record for a new
 

00:02:18.450 --> 00:02:20.110 align:start position:0%
it easy to add a record for a new
customer

00:02:20.110 --> 00:02:20.120 align:start position:0%
customer
 

00:02:20.120 --> 00:02:23.740 align:start position:0%
customer
or<00:02:20.959><c> edit</c><00:02:21.560><c> an</c><00:02:21.680><c> existing</c><00:02:21.769><c> one</c><00:02:22.269><c> anyone</c><00:02:23.269><c> can</c><00:02:23.480><c> do</c><00:02:23.599><c> it</c>

00:02:23.740 --> 00:02:23.750 align:start position:0%
or edit an existing one anyone can do it
 

00:02:23.750 --> 00:02:25.809 align:start position:0%
or edit an existing one anyone can do it
without<00:02:24.050><c> ever</c><00:02:24.379><c> having</c><00:02:24.620><c> to</c><00:02:24.800><c> face</c><00:02:25.069><c> the</c><00:02:25.310><c> size</c><00:02:25.550><c> and</c>

00:02:25.809 --> 00:02:25.819 align:start position:0%
without ever having to face the size and
 

00:02:25.819 --> 00:02:27.880 align:start position:0%
without ever having to face the size and
scope<00:02:26.120><c> of</c><00:02:26.330><c> that</c><00:02:26.420><c> table</c><00:02:26.720><c> or</c><00:02:27.050><c> the</c><00:02:27.260><c> possibility</c>

00:02:27.880 --> 00:02:27.890 align:start position:0%
scope of that table or the possibility
 

00:02:27.890 --> 00:02:31.900 align:start position:0%
scope of that table or the possibility
of<00:02:27.920><c> making</c><00:02:28.129><c> a</c><00:02:28.340><c> mistake</c><00:02:30.280><c> queries</c><00:02:31.280><c> give</c><00:02:31.760><c> you</c><00:02:31.879><c> a</c>

00:02:31.900 --> 00:02:31.910 align:start position:0%
of making a mistake queries give you a
 

00:02:31.910 --> 00:02:34.210 align:start position:0%
of making a mistake queries give you a
way<00:02:32.150><c> to</c><00:02:32.180><c> search</c><00:02:32.510><c> for</c><00:02:32.780><c> and</c><00:02:33.050><c> compile</c><00:02:33.500><c> data</c><00:02:33.739><c> from</c>

00:02:34.210 --> 00:02:34.220 align:start position:0%
way to search for and compile data from
 

00:02:34.220 --> 00:02:36.400 align:start position:0%
way to search for and compile data from
one<00:02:34.400><c> or</c><00:02:34.430><c> more</c><00:02:34.610><c> of</c><00:02:34.819><c> your</c><00:02:35.060><c> tables</c><00:02:35.450><c> running</c><00:02:36.319><c> a</c>

00:02:36.400 --> 00:02:36.410 align:start position:0%
one or more of your tables running a
 

00:02:36.410 --> 00:02:38.500 align:start position:0%
one or more of your tables running a
query<00:02:36.709><c> is</c><00:02:36.890><c> like</c><00:02:37.129><c> asking</c><00:02:37.370><c> a</c><00:02:37.700><c> detailed</c><00:02:38.060><c> question</c>

00:02:38.500 --> 00:02:38.510 align:start position:0%
query is like asking a detailed question
 

00:02:38.510 --> 00:02:40.300 align:start position:0%
query is like asking a detailed question
of<00:02:38.629><c> your</c><00:02:38.780><c> database</c><00:02:39.049><c> or</c><00:02:39.349><c> doing</c><00:02:39.890><c> an</c><00:02:39.980><c> advanced</c>

00:02:40.300 --> 00:02:40.310 align:start position:0%
of your database or doing an advanced
 

00:02:40.310 --> 00:02:41.410 align:start position:0%
of your database or doing an advanced
search<00:02:40.580><c> on</c><00:02:40.849><c> the</c><00:02:40.940><c> Internet</c>

00:02:41.410 --> 00:02:41.420 align:start position:0%
search on the Internet
 

00:02:41.420 --> 00:02:43.720 align:start position:0%
search on the Internet
when<00:02:42.080><c> you</c><00:02:42.200><c> build</c><00:02:42.410><c> a</c><00:02:42.500><c> query</c><00:02:42.709><c> in</c><00:02:42.950><c> Access</c><00:02:43.129><c> you're</c>

00:02:43.720 --> 00:02:43.730 align:start position:0%
when you build a query in Access you're
 

00:02:43.730 --> 00:02:45.850 align:start position:0%
when you build a query in Access you're
defining<00:02:44.090><c> specific</c><00:02:44.390><c> search</c><00:02:45.080><c> conditions</c><00:02:45.650><c> to</c>

00:02:45.850 --> 00:02:45.860 align:start position:0%
defining specific search conditions to
 

00:02:45.860 --> 00:02:48.759 align:start position:0%
defining specific search conditions to
find<00:02:46.040><c> exactly</c><00:02:46.790><c> the</c><00:02:46.970><c> data</c><00:02:47.120><c> you</c><00:02:47.420><c> want</c><00:02:47.450><c> a</c><00:02:47.930><c> query</c>

00:02:48.759 --> 00:02:48.769 align:start position:0%
find exactly the data you want a query
 

00:02:48.769 --> 00:02:50.320 align:start position:0%
find exactly the data you want a query
could<00:02:49.010><c> help</c><00:02:49.250><c> you</c><00:02:49.340><c> find</c><00:02:49.580><c> the</c><00:02:49.700><c> name</c><00:02:49.849><c> and</c><00:02:50.090><c> number</c>

00:02:50.320 --> 00:02:50.330 align:start position:0%
could help you find the name and number
 

00:02:50.330 --> 00:02:52.059 align:start position:0%
could help you find the name and number
of<00:02:50.360><c> every</c><00:02:50.750><c> customer</c><00:02:50.959><c> who's</c><00:02:51.379><c> made</c><00:02:51.620><c> a</c><00:02:51.650><c> purchase</c>

00:02:52.059 --> 00:02:52.069 align:start position:0%
of every customer who's made a purchase
 

00:02:52.069 --> 00:02:54.039 align:start position:0%
of every customer who's made a purchase
in<00:02:52.220><c> the</c><00:02:52.310><c> last</c><00:02:52.549><c> week</c><00:02:52.790><c> for</c><00:02:53.060><c> example</c><00:02:53.090><c> that's</c>

00:02:54.039 --> 00:02:54.049 align:start position:0%
in the last week for example that's
 

00:02:54.049 --> 00:02:55.630 align:start position:0%
in the last week for example that's
something<00:02:54.500><c> you</c><00:02:54.590><c> might</c><00:02:54.739><c> not</c><00:02:54.920><c> be</c><00:02:55.099><c> able</c><00:02:55.250><c> to</c><00:02:55.370><c> find</c>

00:02:55.630 --> 00:02:55.640 align:start position:0%
something you might not be able to find
 

00:02:55.640 --> 00:02:57.250 align:start position:0%
something you might not be able to find
just<00:02:56.000><c> by</c><00:02:56.060><c> looking</c><00:02:56.480><c> at</c><00:02:56.599><c> the</c><00:02:56.690><c> records</c><00:02:57.049><c> in</c><00:02:57.170><c> your</c>

00:02:57.250 --> 00:02:57.260 align:start position:0%
just by looking at the records in your
 

00:02:57.260 --> 00:03:00.759 align:start position:0%
just by looking at the records in your
table<00:02:58.660><c> reports</c><00:02:59.660><c> give</c><00:03:00.079><c> you</c><00:03:00.200><c> the</c><00:03:00.349><c> ability</c><00:03:00.560><c> to</c>

00:03:00.759 --> 00:03:00.769 align:start position:0%
table reports give you the ability to
 

00:03:00.769 --> 00:03:02.770 align:start position:0%
table reports give you the ability to
present<00:03:01.099><c> your</c><00:03:01.430><c> data</c><00:03:01.579><c> from</c><00:03:02.060><c> any</c><00:03:02.239><c> table</c><00:03:02.660><c> or</c>

00:03:02.770 --> 00:03:02.780 align:start position:0%
present your data from any table or
 

00:03:02.780 --> 00:03:05.319 align:start position:0%
present your data from any table or
query<00:03:03.019><c> in</c><00:03:03.290><c> print</c><00:03:03.799><c> if</c><00:03:04.010><c> you've</c><00:03:04.579><c> ever</c><00:03:04.790><c> received</c><00:03:04.970><c> a</c>

00:03:05.319 --> 00:03:05.329 align:start position:0%
query in print if you've ever received a
 

00:03:05.329 --> 00:03:07.119 align:start position:0%
query in print if you've ever received a
printout<00:03:05.660><c> of</c><00:03:05.720><c> an</c><00:03:05.959><c> invoice</c><00:03:06.230><c> or</c><00:03:06.530><c> an</c><00:03:06.860><c> official</c>

00:03:07.119 --> 00:03:07.129 align:start position:0%
printout of an invoice or an official
 

00:03:07.129 --> 00:03:09.190 align:start position:0%
printout of an invoice or an official
school<00:03:07.549><c> transcript</c><00:03:08.180><c> you've</c><00:03:08.510><c> seen</c><00:03:08.750><c> a</c><00:03:08.780><c> database</c>

00:03:09.190 --> 00:03:09.200 align:start position:0%
school transcript you've seen a database
 

00:03:09.200 --> 00:03:11.470 align:start position:0%
school transcript you've seen a database
report<00:03:09.440><c> they're</c><00:03:10.310><c> useful</c><00:03:10.579><c> because</c><00:03:10.940><c> they</c><00:03:11.269><c> let</c>

00:03:11.470 --> 00:03:11.480 align:start position:0%
report they're useful because they let
 

00:03:11.480 --> 00:03:13.270 align:start position:0%
report they're useful because they let
you<00:03:11.599><c> present</c><00:03:11.780><c> parts</c><00:03:12.260><c> of</c><00:03:12.379><c> your</c><00:03:12.500><c> database</c><00:03:12.950><c> in</c><00:03:13.190><c> a</c>

00:03:13.270 --> 00:03:13.280 align:start position:0%
you present parts of your database in a
 

00:03:13.280 --> 00:03:15.729 align:start position:0%
you present parts of your database in a
way<00:03:13.430><c> that's</c><00:03:13.670><c> easy</c><00:03:13.940><c> to</c><00:03:14.180><c> understand</c><00:03:14.690><c> even</c><00:03:15.230><c> easy</c>

00:03:15.729 --> 00:03:15.739 align:start position:0%
way that's easy to understand even easy
 

00:03:15.739 --> 00:03:17.830 align:start position:0%
way that's easy to understand even easy
on<00:03:15.950><c> the</c><00:03:16.069><c> eyes</c><00:03:16.190><c> with</c><00:03:16.730><c> colors</c><00:03:17.090><c> graphics</c><00:03:17.420><c> and</c>

00:03:17.830 --> 00:03:17.840 align:start position:0%
on the eyes with colors graphics and
 

00:03:17.840 --> 00:03:20.380 align:start position:0%
on the eyes with colors graphics and
other<00:03:17.959><c> things</c><00:03:18.260><c> that</c><00:03:18.379><c> you</c><00:03:18.530><c> can</c><00:03:18.709><c> customize</c><00:03:19.390><c> so</c>

00:03:20.380 --> 00:03:20.390 align:start position:0%
other things that you can customize so
 

00:03:20.390 --> 00:03:22.720 align:start position:0%
other things that you can customize so
now<00:03:20.870><c> that</c><00:03:20.930><c> you</c><00:03:21.170><c> know</c><00:03:21.349><c> how</c><00:03:21.590><c> each</c><00:03:21.860><c> object</c><00:03:22.370><c> can</c><00:03:22.610><c> be</c>

00:03:22.720 --> 00:03:22.730 align:start position:0%
now that you know how each object can be
 

00:03:22.730 --> 00:03:25.000 align:start position:0%
now that you know how each object can be
used<00:03:23.000><c> any</c><00:03:23.390><c> idea</c><00:03:23.840><c> how</c><00:03:24.049><c> they</c><00:03:24.170><c> work</c><00:03:24.380><c> together</c><00:03:24.590><c> it</c>

00:03:25.000 --> 00:03:25.010 align:start position:0%
used any idea how they work together it
 

00:03:25.010 --> 00:03:27.129 align:start position:0%
used any idea how they work together it
helps<00:03:25.940><c> to</c><00:03:26.090><c> remember</c><00:03:26.450><c> that</c><00:03:26.569><c> they</c><00:03:26.720><c> all</c><00:03:26.900><c> work</c>

00:03:27.129 --> 00:03:27.139 align:start position:0%
helps to remember that they all work
 

00:03:27.139 --> 00:03:29.110 align:start position:0%
helps to remember that they all work
with<00:03:27.319><c> the</c><00:03:27.350><c> same</c><00:03:27.440><c> data</c><00:03:27.920><c> the</c><00:03:28.370><c> data</c><00:03:28.579><c> stored</c><00:03:29.000><c> in</c>

00:03:29.110 --> 00:03:29.120 align:start position:0%
with the same data the data stored in
 

00:03:29.120 --> 00:03:31.210 align:start position:0%
with the same data the data stored in
your<00:03:29.269><c> tables</c><00:03:29.750><c> let's</c><00:03:30.620><c> take</c><00:03:30.829><c> a</c><00:03:30.859><c> look</c><00:03:31.069><c> at</c><00:03:31.190><c> a</c>

00:03:31.210 --> 00:03:31.220 align:start position:0%
your tables let's take a look at a
 

00:03:31.220 --> 00:03:33.970 align:start position:0%
your tables let's take a look at a
real-life<00:03:31.459><c> example</c><00:03:31.790><c> if</c><00:03:32.389><c> you've</c><00:03:33.350><c> ever</c><00:03:33.500><c> used</c><00:03:33.620><c> an</c>

00:03:33.970 --> 00:03:33.980 align:start position:0%
real-life example if you've ever used an
 

00:03:33.980 --> 00:03:35.920 align:start position:0%
real-life example if you've ever used an
electronic<00:03:34.430><c> card</c><00:03:34.819><c> catalog</c><00:03:35.239><c> to</c><00:03:35.420><c> search</c><00:03:35.569><c> for</c><00:03:35.870><c> a</c>

00:03:35.920 --> 00:03:35.930 align:start position:0%
electronic card catalog to search for a
 

00:03:35.930 --> 00:03:37.839 align:start position:0%
electronic card catalog to search for a
book<00:03:36.049><c> at</c><00:03:36.200><c> the</c><00:03:36.230><c> library</c><00:03:36.319><c> it</c><00:03:36.950><c> probably</c><00:03:37.489><c> looked</c>

00:03:37.839 --> 00:03:37.849 align:start position:0%
book at the library it probably looked
 

00:03:37.849 --> 00:03:38.770 align:start position:0%
book at the library it probably looked
something<00:03:38.090><c> like</c><00:03:38.239><c> this</c>

00:03:38.770 --> 00:03:38.780 align:start position:0%
something like this
 

00:03:38.780 --> 00:03:41.319 align:start position:0%
something like this
right<00:03:39.709><c> now</c><00:03:39.889><c> I'm</c><00:03:40.160><c> entering</c><00:03:40.549><c> my</c><00:03:40.609><c> search</c><00:03:40.940><c> terms</c>

00:03:41.319 --> 00:03:41.329 align:start position:0%
right now I'm entering my search terms
 

00:03:41.329 --> 00:03:44.020 align:start position:0%
right now I'm entering my search terms
into<00:03:41.599><c> what</c><00:03:41.840><c> is</c><00:03:41.959><c> actually</c><00:03:42.500><c> a</c><00:03:42.530><c> form</c><00:03:43.040><c> when</c><00:03:44.000><c> I</c>

00:03:44.020 --> 00:03:44.030 align:start position:0%
into what is actually a form when I
 

00:03:44.030 --> 00:03:46.000 align:start position:0%
into what is actually a form when I
press<00:03:44.329><c> this</c><00:03:44.510><c> button</c><00:03:44.569><c> the</c><00:03:45.200><c> database</c><00:03:45.620><c> is</c><00:03:45.799><c> going</c>

00:03:46.000 --> 00:03:46.010 align:start position:0%
press this button the database is going
 

00:03:46.010 --> 00:03:48.400 align:start position:0%
press this button the database is going
to<00:03:46.099><c> create</c><00:03:46.310><c> and</c><00:03:46.609><c> run</c><00:03:46.760><c> a</c><00:03:47.000><c> query</c><00:03:47.359><c> based</c><00:03:47.930><c> on</c><00:03:48.200><c> what</c>

00:03:48.400 --> 00:03:48.410 align:start position:0%
to create and run a query based on what
 

00:03:48.410 --> 00:03:50.349 align:start position:0%
to create and run a query based on what
I'm<00:03:48.500><c> looking</c><00:03:48.829><c> for</c><00:03:49.099><c> books</c><00:03:49.489><c> in</c><00:03:49.700><c> the</c><00:03:49.819><c> series</c><00:03:50.000><c> the</c>

00:03:50.349 --> 00:03:50.359 align:start position:0%
I'm looking for books in the series the
 

00:03:50.359 --> 00:03:52.390 align:start position:0%
I'm looking for books in the series the
Lord<00:03:50.569><c> of</c><00:03:50.630><c> the</c><00:03:50.720><c> Rings</c><00:03:51.010><c> when</c><00:03:52.010><c> the</c><00:03:52.130><c> database</c>

00:03:52.390 --> 00:03:52.400 align:start position:0%
Lord of the Rings when the database
 

00:03:52.400 --> 00:03:54.819 align:start position:0%
Lord of the Rings when the database
finishes<00:03:53.060><c> searching</c><00:03:53.450><c> all</c><00:03:53.660><c> of</c><00:03:53.810><c> its</c><00:03:53.959><c> tables</c><00:03:54.470><c> it</c>

00:03:54.819 --> 00:03:54.829 align:start position:0%
finishes searching all of its tables it
 

00:03:54.829 --> 00:03:56.949 align:start position:0%
finishes searching all of its tables it
returns<00:03:55.310><c> a</c><00:03:55.489><c> report</c><00:03:55.880><c> of</c><00:03:56.030><c> the</c><00:03:56.510><c> records</c><00:03:56.870><c> that</c>

00:03:56.949 --> 00:03:56.959 align:start position:0%
returns a report of the records that
 

00:03:56.959 --> 00:03:59.140 align:start position:0%
returns a report of the records that
matched<00:03:57.290><c> in</c><00:03:57.650><c> this</c><00:03:57.919><c> case</c><00:03:58.130><c> a</c><00:03:58.160><c> list</c><00:03:58.459><c> of</c><00:03:58.609><c> books</c><00:03:58.849><c> all</c>

00:03:59.140 --> 00:03:59.150 align:start position:0%
matched in this case a list of books all
 

00:03:59.150 --> 00:04:01.390 align:start position:0%
matched in this case a list of books all
I<00:03:59.599><c> have</c><00:03:59.900><c> to</c><00:04:00.049><c> do</c><00:04:00.169><c> is</c><00:04:00.349><c> click</c><00:04:00.620><c> a</c><00:04:00.650><c> book</c><00:04:00.889><c> to</c><00:04:01.250><c> learn</c>

00:04:01.390 --> 00:04:01.400 align:start position:0%
I have to do is click a book to learn
 

00:04:01.400 --> 00:04:03.819 align:start position:0%
I have to do is click a book to learn
its<00:04:01.579><c> location</c><00:04:02.060><c> and</c><00:04:02.180><c> status</c><00:04:02.620><c> see</c><00:04:03.620><c> how</c><00:04:03.769><c> the</c>

00:04:03.819 --> 00:04:03.829 align:start position:0%
its location and status see how the
 

00:04:03.829 --> 00:04:06.699 align:start position:0%
its location and status see how the
objects<00:04:04.370><c> all</c><00:04:04.549><c> work</c><00:04:04.760><c> together</c><00:04:05.139><c> first</c><00:04:06.139><c> I</c><00:04:06.380><c> filled</c>

00:04:06.699 --> 00:04:06.709 align:start position:0%
objects all work together first I filled
 

00:04:06.709 --> 00:04:09.280 align:start position:0%
objects all work together first I filled
out<00:04:06.829><c> the</c><00:04:07.010><c> form</c><00:04:07.280><c> then</c><00:04:08.150><c> queried</c><00:04:08.750><c> the</c><00:04:08.780><c> database</c>

00:04:09.280 --> 00:04:09.290 align:start position:0%
out the form then queried the database
 

00:04:09.290 --> 00:04:11.559 align:start position:0%
out the form then queried the database
to<00:04:09.590><c> search</c><00:04:09.620><c> for</c><00:04:10.069><c> the</c><00:04:10.160><c> book</c><00:04:10.310><c> the</c><00:04:11.090><c> query</c><00:04:11.359><c> was</c>

00:04:11.559 --> 00:04:11.569 align:start position:0%
to search for the book the query was
 

00:04:11.569 --> 00:04:14.199 align:start position:0%
to search for the book the query was
able<00:04:11.870><c> to</c><00:04:11.900><c> pull</c><00:04:12.230><c> from</c><00:04:12.560><c> all</c><00:04:12.799><c> those</c><00:04:13.069><c> tables</c><00:04:13.609><c> to</c>

00:04:14.199 --> 00:04:14.209 align:start position:0%
able to pull from all those tables to
 

00:04:14.209 --> 00:04:16.719 align:start position:0%
able to pull from all those tables to
produce<00:04:14.419><c> a</c><00:04:14.720><c> report</c><00:04:15.370><c> imagine</c><00:04:16.370><c> what</c><00:04:16.519><c> it</c><00:04:16.609><c> would</c>

00:04:16.719 --> 00:04:16.729 align:start position:0%
produce a report imagine what it would
 

00:04:16.729 --> 00:04:18.310 align:start position:0%
produce a report imagine what it would
be<00:04:16.760><c> like</c><00:04:16.880><c> if</c><00:04:17.209><c> we</c><00:04:17.329><c> didn't</c><00:04:17.599><c> have</c><00:04:17.750><c> these</c><00:04:17.959><c> tools</c>

00:04:18.310 --> 00:04:18.320 align:start position:0%
be like if we didn't have these tools
 

00:04:18.320 --> 00:04:20.409 align:start position:0%
be like if we didn't have these tools
what<00:04:18.950><c> should</c><00:04:19.099><c> be</c><00:04:19.220><c> a</c><00:04:19.250><c> simple</c><00:04:19.669><c> task</c><00:04:19.700><c> would</c>

00:04:20.409 --> 00:04:20.419 align:start position:0%
what should be a simple task would
 

00:04:20.419 --> 00:04:22.180 align:start position:0%
what should be a simple task would
become<00:04:20.780><c> incredibly</c><00:04:21.440><c> complicated</c><00:04:21.799><c> and</c>

00:04:22.180 --> 00:04:22.190 align:start position:0%
become incredibly complicated and
 

00:04:22.190 --> 00:04:24.550 align:start position:0%
become incredibly complicated and
time-consuming<00:04:23.229><c> understanding</c><00:04:24.229><c> the</c><00:04:24.320><c> four</c>

00:04:24.550 --> 00:04:24.560 align:start position:0%
time-consuming understanding the four
 

00:04:24.560 --> 00:04:26.589 align:start position:0%
time-consuming understanding the four
access<00:04:25.099><c> objects</c><00:04:25.760><c> and</c><00:04:25.910><c> how</c><00:04:26.240><c> they</c><00:04:26.419><c> work</c>

00:04:26.589 --> 00:04:26.599 align:start position:0%
access objects and how they work
 

00:04:26.599 --> 00:04:28.209 align:start position:0%
access objects and how they work
together<00:04:26.750><c> can</c><00:04:27.590><c> make</c><00:04:27.650><c> even</c><00:04:28.099><c> the</c><00:04:28.190><c> most</c>

00:04:28.209 --> 00:04:28.219 align:start position:0%
together can make even the most
 

00:04:28.219 --> 00:04:32.780 align:start position:0%
together can make even the most
complicated<00:04:28.760><c> tasks</c><00:04:29.479><c> fairly</c><00:04:29.930><c> user-friendly</c>

00:04:32.780 --> 00:04:32.790 align:start position:0%
 
 

00:04:32.790 --> 00:04:36.750 align:start position:0%
 
like<00:04:33.790><c> what</c><00:04:33.970><c> you</c><00:04:34.120><c> just</c><00:04:34.300><c> saw</c><00:04:35.010><c> rate</c><00:04:36.010><c> it</c><00:04:36.190><c> at</c><00:04:36.700><c> a</c>

00:04:36.750 --> 00:04:36.760 align:start position:0%
like what you just saw rate it at a
 

00:04:36.760 --> 00:04:39.570 align:start position:0%
like what you just saw rate it at a
comment<00:04:37.300><c> subscribe</c><00:04:37.840><c> to</c><00:04:38.260><c> our</c><00:04:38.380><c> Channel</c>

00:04:39.570 --> 00:04:39.580 align:start position:0%
comment subscribe to our Channel
 

00:04:39.580 --> 00:04:43.920 align:start position:0%
comment subscribe to our Channel
the<00:04:39.850><c> freedom</c><00:04:40.300><c> to</c><00:04:40.450><c> learn</c><00:04:41.220><c> what</c><00:04:42.220><c> you</c><00:04:42.430><c> want</c><00:04:42.930><c> when</c>

00:04:43.920 --> 00:04:43.930 align:start position:0%
the freedom to learn what you want when
 

00:04:43.930 --> 00:04:50.510 align:start position:0%
the freedom to learn what you want when
you<00:04:44.140><c> want</c><00:04:45.870><c> absolutely</c><00:04:46.870><c> free</c>

00:04:50.510 --> 00:04:50.520 align:start position:0%
 
 

00:04:50.520 --> 00:04:54.120 align:start position:0%
 
GCF<00:04:51.520><c> learn</c><00:04:52.090><c> free.org</c>