WEBVTT
Kind: captions
Language: en

00:00:05.930 --> 00:00:08.570 align:start position:0%
 
you've<00:00:06.930><c> already</c><00:00:07.170><c> seen</c><00:00:07.710><c> how</c><00:00:07.980><c> an</c><00:00:08.099><c> advanced</c>

00:00:08.570 --> 00:00:08.580 align:start position:0%
you've already seen how an advanced
 

00:00:08.580 --> 00:00:11.480 align:start position:0%
you've already seen how an advanced
filter<00:00:09.000><c> is</c><00:00:09.150><c> really</c><00:00:09.389><c> a</c><00:00:09.540><c> very</c><00:00:09.929><c> basic</c><00:00:10.230><c> query</c><00:00:10.679><c> run</c>

00:00:11.480 --> 00:00:11.490 align:start position:0%
filter is really a very basic query run
 

00:00:11.490 --> 00:00:13.789 align:start position:0%
filter is really a very basic query run
and<00:00:11.730><c> only</c><00:00:12.030><c> one</c><00:00:12.300><c> table</c><00:00:12.809><c> in</c><00:00:12.929><c> your</c><00:00:12.960><c> database</c>

00:00:13.789 --> 00:00:13.799 align:start position:0%
and only one table in your database
 

00:00:13.799 --> 00:00:16.129 align:start position:0%
and only one table in your database
well<00:00:14.219><c> sometimes</c><00:00:14.759><c> you</c><00:00:15.150><c> are</c><00:00:15.450><c> going</c><00:00:15.719><c> to</c><00:00:15.839><c> want</c><00:00:16.049><c> to</c>

00:00:16.129 --> 00:00:16.139 align:start position:0%
well sometimes you are going to want to
 

00:00:16.139 --> 00:00:18.380 align:start position:0%
well sometimes you are going to want to
be<00:00:16.289><c> able</c><00:00:16.500><c> to</c><00:00:16.680><c> pull</c><00:00:17.039><c> out</c><00:00:17.070><c> information</c><00:00:17.699><c> from</c>

00:00:18.380 --> 00:00:18.390 align:start position:0%
be able to pull out information from
 

00:00:18.390 --> 00:00:20.359 align:start position:0%
be able to pull out information from
more<00:00:18.690><c> than</c><00:00:18.720><c> one</c><00:00:19.109><c> table</c><00:00:19.320><c> at</c><00:00:19.590><c> a</c><00:00:19.619><c> time</c><00:00:19.710><c> and</c>

00:00:20.359 --> 00:00:20.369 align:start position:0%
more than one table at a time and
 

00:00:20.369 --> 00:00:23.090 align:start position:0%
more than one table at a time and
combined<00:00:21.270><c> it</c><00:00:21.449><c> in</c><00:00:21.539><c> a</c><00:00:21.600><c> meaningful</c><00:00:21.960><c> way</c><00:00:22.140><c> so</c><00:00:22.949><c> that</c>

00:00:23.090 --> 00:00:23.100 align:start position:0%
combined it in a meaningful way so that
 

00:00:23.100 --> 00:00:25.640 align:start position:0%
combined it in a meaningful way so that
you<00:00:23.250><c> can</c><00:00:23.400><c> analyze</c><00:00:23.609><c> it</c><00:00:23.930><c> that</c><00:00:24.930><c> is</c><00:00:25.109><c> what</c><00:00:25.289><c> a</c><00:00:25.320><c> query</c>

00:00:25.640 --> 00:00:25.650 align:start position:0%
you can analyze it that is what a query
 

00:00:25.650 --> 00:00:28.040 align:start position:0%
you can analyze it that is what a query
can<00:00:25.949><c> do</c><00:00:26.099><c> for</c><00:00:26.369><c> you</c><00:00:26.550><c> it</c><00:00:26.970><c> pulls</c><00:00:27.300><c> out</c><00:00:27.480><c> the</c><00:00:27.630><c> data</c><00:00:27.869><c> you</c>

00:00:28.040 --> 00:00:28.050 align:start position:0%
can do for you it pulls out the data you
 

00:00:28.050 --> 00:00:30.410 align:start position:0%
can do for you it pulls out the data you
tell<00:00:28.320><c> it</c><00:00:28.470><c> to</c><00:00:28.680><c> from</c><00:00:29.369><c> the</c><00:00:29.519><c> tables</c><00:00:29.970><c> you</c><00:00:30.090><c> tell</c><00:00:30.300><c> it</c>

00:00:30.410 --> 00:00:30.420 align:start position:0%
tell it to from the tables you tell it
 

00:00:30.420 --> 00:00:32.959 align:start position:0%
tell it to from the tables you tell it
to<00:00:30.570><c> look</c><00:00:30.810><c> in</c><00:00:31.170><c> and</c><00:00:31.470><c> then</c><00:00:31.980><c> shows</c><00:00:32.279><c> it</c><00:00:32.460><c> to</c><00:00:32.610><c> you</c><00:00:32.759><c> in</c><00:00:32.880><c> a</c>

00:00:32.959 --> 00:00:32.969 align:start position:0%
to look in and then shows it to you in a
 

00:00:32.969 --> 00:00:35.660 align:start position:0%
to look in and then shows it to you in a
way<00:00:33.180><c> that</c><00:00:33.210><c> is</c><00:00:33.510><c> easy</c><00:00:33.780><c> for</c><00:00:34.050><c> you</c><00:00:34.170><c> to</c><00:00:34.320><c> analyze</c><00:00:34.670><c> but</c>

00:00:35.660 --> 00:00:35.670 align:start position:0%
way that is easy for you to analyze but
 

00:00:35.670 --> 00:00:38.030 align:start position:0%
way that is easy for you to analyze but
you<00:00:36.270><c> have</c><00:00:36.510><c> to</c><00:00:36.660><c> be</c><00:00:36.780><c> very</c><00:00:36.989><c> careful</c><00:00:37.620><c> in</c><00:00:37.800><c> the</c><00:00:37.890><c> way</c>

00:00:38.030 --> 00:00:38.040 align:start position:0%
you have to be very careful in the way
 

00:00:38.040 --> 00:00:40.310 align:start position:0%
you have to be very careful in the way
you<00:00:38.100><c> tell</c><00:00:38.460><c> it</c><00:00:38.489><c> to</c><00:00:38.730><c> get</c><00:00:38.969><c> your</c><00:00:39.120><c> information</c><00:00:39.420><c> or</c>

00:00:40.310 --> 00:00:40.320 align:start position:0%
you tell it to get your information or
 

00:00:40.320 --> 00:00:42.470 align:start position:0%
you tell it to get your information or
it<00:00:40.469><c> may</c><00:00:40.620><c> not</c><00:00:40.800><c> return</c><00:00:40.980><c> the</c><00:00:41.489><c> results</c><00:00:41.940><c> you</c><00:00:42.030><c> expect</c>

00:00:42.470 --> 00:00:42.480 align:start position:0%
it may not return the results you expect
 

00:00:42.480 --> 00:00:45.830 align:start position:0%
it may not return the results you expect
it<00:00:43.280><c> let's</c><00:00:44.280><c> talk</c><00:00:44.489><c> about</c><00:00:44.640><c> how</c><00:00:45.000><c> to</c><00:00:45.059><c> design</c><00:00:45.360><c> a</c>

00:00:45.830 --> 00:00:45.840 align:start position:0%
it let's talk about how to design a
 

00:00:45.840 --> 00:00:47.750 align:start position:0%
it let's talk about how to design a
query<00:00:46.260><c> before</c><00:00:46.739><c> we</c><00:00:46.860><c> even</c><00:00:47.070><c> get</c><00:00:47.309><c> into</c><00:00:47.550><c> using</c>

00:00:47.750 --> 00:00:47.760 align:start position:0%
query before we even get into using
 

00:00:47.760 --> 00:00:50.600 align:start position:0%
query before we even get into using
access<00:00:48.149><c> to</c><00:00:48.570><c> set</c><00:00:48.780><c> it</c><00:00:48.899><c> up</c><00:00:49.250><c> queries</c><00:00:50.250><c> help</c><00:00:50.489><c> you</c>

00:00:50.600 --> 00:00:50.610 align:start position:0%
access to set it up queries help you
 

00:00:50.610 --> 00:00:53.090 align:start position:0%
access to set it up queries help you
answer<00:00:51.079><c> questions</c><00:00:52.079><c> you</c><00:00:52.199><c> may</c><00:00:52.500><c> have</c><00:00:52.530><c> about</c><00:00:52.800><c> your</c>

00:00:53.090 --> 00:00:53.100 align:start position:0%
answer questions you may have about your
 

00:00:53.100 --> 00:00:55.700 align:start position:0%
answer questions you may have about your
data<00:00:53.489><c> like</c><00:00:53.760><c> which</c><00:00:54.690><c> customers</c><00:00:55.260><c> have</c><00:00:55.289><c> ordered</c>

00:00:55.700 --> 00:00:55.710 align:start position:0%
data like which customers have ordered
 

00:00:55.710 --> 00:00:58.880 align:start position:0%
data like which customers have ordered
technology<00:00:56.309><c> books</c><00:00:57.079><c> now</c><00:00:58.079><c> before</c><00:00:58.410><c> we</c><00:00:58.530><c> go</c><00:00:58.649><c> much</c>

00:00:58.880 --> 00:00:58.890 align:start position:0%
technology books now before we go much
 

00:00:58.890 --> 00:01:00.979 align:start position:0%
technology books now before we go much
further<00:00:59.250><c> I</c><00:00:59.609><c> think</c><00:00:59.940><c> it</c><00:01:00.090><c> will</c><00:01:00.210><c> help</c><00:01:00.390><c> if</c><00:01:00.600><c> we</c><00:01:00.750><c> talk</c>

00:01:00.979 --> 00:01:00.989 align:start position:0%
further I think it will help if we talk
 

00:01:00.989 --> 00:01:04.219 align:start position:0%
further I think it will help if we talk
about<00:01:01.140><c> some</c><00:01:01.620><c> query</c><00:01:01.949><c> design</c><00:01:02.370><c> basics</c><00:01:03.030><c> you</c><00:01:04.019><c> don't</c>

00:01:04.219 --> 00:01:04.229 align:start position:0%
about some query design basics you don't
 

00:01:04.229 --> 00:01:06.289 align:start position:0%
about some query design basics you don't
need<00:01:04.439><c> to</c><00:01:04.619><c> know</c><00:01:04.769><c> how</c><00:01:05.100><c> to</c><00:01:05.159><c> write</c><00:01:05.580><c> in</c><00:01:05.760><c> the</c><00:01:05.850><c> formal</c>

00:01:06.289 --> 00:01:06.299 align:start position:0%
need to know how to write in the formal
 

00:01:06.299 --> 00:01:08.780 align:start position:0%
need to know how to write in the formal
query<00:01:06.600><c> language</c><00:01:07.110><c> to</c><00:01:07.260><c> use</c><00:01:07.439><c> access</c><00:01:07.979><c> but</c>

00:01:08.780 --> 00:01:08.790 align:start position:0%
query language to use access but
 

00:01:08.790 --> 00:01:11.960 align:start position:0%
query language to use access but
understanding<00:01:09.780><c> how</c><00:01:09.810><c> queries</c><00:01:10.470><c> work</c><00:01:10.799><c> and</c><00:01:11.430><c> using</c>

00:01:11.960 --> 00:01:11.970 align:start position:0%
understanding how queries work and using
 

00:01:11.970 --> 00:01:14.719 align:start position:0%
understanding how queries work and using
a<00:01:12.060><c> process</c><00:01:12.360><c> to</c><00:01:12.780><c> design</c><00:01:12.930><c> your</c><00:01:13.439><c> own</c><00:01:13.470><c> query</c><00:01:14.130><c> can</c>

00:01:14.719 --> 00:01:14.729 align:start position:0%
a process to design your own query can
 

00:01:14.729 --> 00:01:16.820 align:start position:0%
a process to design your own query can
certainly<00:01:15.150><c> make</c><00:01:15.450><c> the</c><00:01:15.479><c> process</c><00:01:15.810><c> easier</c><00:01:16.590><c> and</c>

00:01:16.820 --> 00:01:16.830 align:start position:0%
certainly make the process easier and
 

00:01:16.830 --> 00:01:19.340 align:start position:0%
certainly make the process easier and
increases<00:01:17.729><c> the</c><00:01:17.909><c> likelihood</c><00:01:18.119><c> that</c><00:01:18.780><c> you'll</c><00:01:19.140><c> get</c>

00:01:19.340 --> 00:01:19.350 align:start position:0%
increases the likelihood that you'll get
 

00:01:19.350 --> 00:01:21.859 align:start position:0%
increases the likelihood that you'll get
the<00:01:19.500><c> results</c><00:01:19.650><c> you'll</c><00:01:20.009><c> expect</c><00:01:20.430><c> to</c><00:01:21.330><c> make</c><00:01:21.540><c> any</c>

00:01:21.859 --> 00:01:21.869 align:start position:0%
the results you'll expect to make any
 

00:01:21.869 --> 00:01:24.969 align:start position:0%
the results you'll expect to make any
query<00:01:22.290><c> work</c><00:01:22.710><c> you</c><00:01:23.220><c> need</c><00:01:23.400><c> to</c><00:01:23.460><c> know</c><00:01:23.759><c> three</c><00:01:24.060><c> things</c>

00:01:24.969 --> 00:01:24.979 align:start position:0%
query work you need to know three things
 

00:01:24.979 --> 00:01:27.920 align:start position:0%
query work you need to know three things
what<00:01:25.979><c> fields</c><00:01:26.490><c> do</c><00:01:26.640><c> you</c><00:01:26.790><c> want</c><00:01:27.119><c> to</c><00:01:27.299><c> see</c><00:01:27.600><c> in</c><00:01:27.840><c> the</c>

00:01:27.920 --> 00:01:27.930 align:start position:0%
what fields do you want to see in the
 

00:01:27.930 --> 00:01:30.260 align:start position:0%
what fields do you want to see in the
results<00:01:28.439><c> now</c><00:01:29.130><c> in</c><00:01:29.310><c> this</c><00:01:29.460><c> step</c><00:01:29.759><c> you're</c>

00:01:30.260 --> 00:01:30.270 align:start position:0%
results now in this step you're
 

00:01:30.270 --> 00:01:32.149 align:start position:0%
results now in this step you're
selecting<00:01:30.840><c> the</c><00:01:30.930><c> field</c><00:01:31.110><c> you</c><00:01:31.380><c> want</c><00:01:31.619><c> access</c><00:01:31.829><c> to</c>

00:01:32.149 --> 00:01:32.159 align:start position:0%
selecting the field you want access to
 

00:01:32.159 --> 00:01:36.800 align:start position:0%
selecting the field you want access to
show<00:01:32.549><c> you</c><00:01:32.610><c> in</c><00:01:32.909><c> your</c><00:01:33.090><c> results</c><00:01:35.090><c> which</c><00:01:36.090><c> tables</c><00:01:36.659><c> or</c>

00:01:36.800 --> 00:01:36.810 align:start position:0%
show you in your results which tables or
 

00:01:36.810 --> 00:01:39.499 align:start position:0%
show you in your results which tables or
queries<00:01:37.110><c> hold</c><00:01:37.680><c> the</c><00:01:37.860><c> info</c><00:01:38.159><c> you</c><00:01:38.340><c> need</c><00:01:38.369><c> in</c><00:01:38.909><c> this</c>

00:01:39.499 --> 00:01:39.509 align:start position:0%
queries hold the info you need in this
 

00:01:39.509 --> 00:01:41.929 align:start position:0%
queries hold the info you need in this
step<00:01:39.840><c> you're</c><00:01:40.350><c> telling</c><00:01:40.829><c> access</c><00:01:41.310><c> where</c><00:01:41.610><c> to</c><00:01:41.820><c> get</c>

00:01:41.929 --> 00:01:41.939 align:start position:0%
step you're telling access where to get
 

00:01:41.939 --> 00:01:45.530 align:start position:0%
step you're telling access where to get
the<00:01:42.090><c> information</c><00:01:42.119><c> from</c><00:01:43.729><c> what</c><00:01:44.729><c> conditions</c><00:01:45.420><c> do</c>

00:01:45.530 --> 00:01:45.540 align:start position:0%
the information from what conditions do
 

00:01:45.540 --> 00:01:47.539 align:start position:0%
the information from what conditions do
you<00:01:45.630><c> want</c><00:01:45.810><c> the</c><00:01:45.930><c> data</c><00:01:46.140><c> to</c><00:01:46.350><c> meet</c><00:01:46.560><c> this</c><00:01:47.340><c> is</c>

00:01:47.539 --> 00:01:47.549 align:start position:0%
you want the data to meet this is
 

00:01:47.549 --> 00:01:49.399 align:start position:0%
you want the data to meet this is
telling<00:01:47.850><c> access</c><00:01:48.299><c> that</c><00:01:48.479><c> you</c><00:01:48.540><c> want</c><00:01:48.840><c> to</c><00:01:48.990><c> see</c><00:01:49.170><c> all</c>

00:01:49.399 --> 00:01:49.409 align:start position:0%
telling access that you want to see all
 

00:01:49.409 --> 00:01:52.010 align:start position:0%
telling access that you want to see all
the<00:01:49.649><c> records</c><00:01:50.130><c> where</c><00:01:50.670><c> a</c><00:01:50.970><c> certain</c><00:01:51.479><c> condition</c><00:01:51.899><c> is</c>

00:01:52.010 --> 00:01:52.020 align:start position:0%
the records where a certain condition is
 

00:01:52.020 --> 00:01:56.420 align:start position:0%
the records where a certain condition is
met<00:01:53.630><c> now</c><00:01:54.630><c> let's</c><00:01:54.840><c> plan</c><00:01:55.170><c> this</c><00:01:55.350><c> out</c><00:01:55.560><c> on</c><00:01:55.710><c> paper</c><00:01:56.040><c> for</c>

00:01:56.420 --> 00:01:56.430 align:start position:0%
met now let's plan this out on paper for
 

00:01:56.430 --> 00:01:59.719 align:start position:0%
met now let's plan this out on paper for
our<00:01:56.490><c> first</c><00:01:57.030><c> question</c><00:01:58.100><c> which</c><00:01:59.100><c> customers</c><00:01:59.700><c> have</c>

00:01:59.719 --> 00:01:59.729 align:start position:0%
our first question which customers have
 

00:01:59.729 --> 00:02:02.450 align:start position:0%
our first question which customers have
ordered<00:02:00.149><c> technology</c><00:02:00.719><c> books</c><00:02:01.009><c> we</c><00:02:02.009><c> have</c><00:02:02.189><c> a</c><00:02:02.219><c> new</c>

00:02:02.450 --> 00:02:02.460 align:start position:0%
ordered technology books we have a new
 

00:02:02.460 --> 00:02:04.550 align:start position:0%
ordered technology books we have a new
technology<00:02:02.820><c> series</c><00:02:03.540><c> and</c><00:02:03.869><c> we</c><00:02:03.990><c> wanted</c><00:02:04.290><c> to</c><00:02:04.350><c> send</c>

00:02:04.550 --> 00:02:04.560 align:start position:0%
technology series and we wanted to send
 

00:02:04.560 --> 00:02:06.410 align:start position:0%
technology series and we wanted to send
these<00:02:04.740><c> customers</c><00:02:05.250><c> a</c><00:02:05.280><c> coupon</c><00:02:05.729><c> for</c><00:02:05.969><c> the</c><00:02:06.060><c> next</c>

00:02:06.410 --> 00:02:06.420 align:start position:0%
these customers a coupon for the next
 

00:02:06.420 --> 00:02:09.279 align:start position:0%
these customers a coupon for the next
book<00:02:06.570><c> release</c><00:02:07.129><c> so</c><00:02:08.129><c> let's</c><00:02:08.340><c> start</c><00:02:08.670><c> planning</c>

00:02:09.279 --> 00:02:09.289 align:start position:0%
book release so let's start planning
 

00:02:09.289 --> 00:02:12.290 align:start position:0%
book release so let's start planning
first<00:02:10.289><c> we</c><00:02:10.890><c> need</c><00:02:11.069><c> to</c><00:02:11.220><c> select</c><00:02:11.400><c> the</c><00:02:11.670><c> fields</c><00:02:12.180><c> we</c>

00:02:12.290 --> 00:02:12.300 align:start position:0%
first we need to select the fields we
 

00:02:12.300 --> 00:02:13.220 align:start position:0%
first we need to select the fields we
want<00:02:12.450><c> to</c><00:02:12.629><c> see</c><00:02:12.900><c> and</c>

00:02:13.220 --> 00:02:13.230 align:start position:0%
want to see and
 

00:02:13.230 --> 00:02:16.100 align:start position:0%
want to see and
results<00:02:13.920><c> if</c><00:02:14.159><c> we</c><00:02:14.909><c> want</c><00:02:15.120><c> to</c><00:02:15.209><c> send</c><00:02:15.480><c> coupons</c><00:02:15.750><c> to</c>

00:02:16.100 --> 00:02:16.110 align:start position:0%
results if we want to send coupons to
 

00:02:16.110 --> 00:02:18.350 align:start position:0%
results if we want to send coupons to
our<00:02:16.230><c> customers</c><00:02:16.920><c> we'd</c><00:02:17.370><c> obviously</c><00:02:17.610><c> want</c><00:02:18.209><c> the</c>

00:02:18.350 --> 00:02:18.360 align:start position:0%
our customers we'd obviously want the
 

00:02:18.360 --> 00:02:21.350 align:start position:0%
our customers we'd obviously want the
customers<00:02:18.780><c> name</c><00:02:19.049><c> and</c><00:02:19.319><c> address</c><00:02:19.680><c> fields</c><00:02:20.220><c> so</c><00:02:21.180><c> the</c>

00:02:21.350 --> 00:02:21.360 align:start position:0%
customers name and address fields so the
 

00:02:21.360 --> 00:02:23.869 align:start position:0%
customers name and address fields so the
fields<00:02:21.750><c> we</c><00:02:21.870><c> will</c><00:02:21.959><c> select</c><00:02:22.200><c> our</c><00:02:22.680><c> first</c><00:02:23.549><c> name</c>

00:02:23.869 --> 00:02:23.879 align:start position:0%
fields we will select our first name
 

00:02:23.879 --> 00:02:28.690 align:start position:0%
fields we will select our first name
last<00:02:24.780><c> name</c><00:02:25.200><c> street</c><00:02:25.909><c> city</c><00:02:26.909><c> state</c><00:02:27.750><c> and</c><00:02:27.959><c> zip</c>

00:02:28.690 --> 00:02:28.700 align:start position:0%
last name street city state and zip
 

00:02:28.700 --> 00:02:32.660 align:start position:0%
last name street city state and zip
these<00:02:29.700><c> are</c><00:02:29.940><c> in</c><00:02:30.060><c> the</c><00:02:30.150><c> customers</c><00:02:30.629><c> table</c><00:02:31.670><c> now</c>

00:02:32.660 --> 00:02:32.670 align:start position:0%
these are in the customers table now
 

00:02:32.670 --> 00:02:35.180 align:start position:0%
these are in the customers table now
which<00:02:33.569><c> tables</c><00:02:34.049><c> hold</c><00:02:34.290><c> these</c><00:02:34.530><c> fields</c><00:02:34.950><c> that</c><00:02:34.980><c> we</c>

00:02:35.180 --> 00:02:35.190 align:start position:0%
which tables hold these fields that we
 

00:02:35.190 --> 00:02:38.509 align:start position:0%
which tables hold these fields that we
need<00:02:36.260><c> we</c><00:02:37.260><c> already</c><00:02:37.769><c> know</c><00:02:37.980><c> that</c><00:02:38.010><c> we</c><00:02:38.310><c> need</c><00:02:38.489><c> the</c>

00:02:38.509 --> 00:02:38.519 align:start position:0%
need we already know that we need the
 

00:02:38.519 --> 00:02:40.699 align:start position:0%
need we already know that we need the
customers<00:02:39.209><c> table</c><00:02:39.450><c> for</c><00:02:40.019><c> the</c><00:02:40.140><c> names</c><00:02:40.440><c> and</c>

00:02:40.699 --> 00:02:40.709 align:start position:0%
customers table for the names and
 

00:02:40.709 --> 00:02:42.860 align:start position:0%
customers table for the names and
addresses<00:02:41.160><c> but</c><00:02:41.849><c> we're</c><00:02:41.970><c> also</c><00:02:42.180><c> going</c><00:02:42.540><c> to</c><00:02:42.629><c> need</c>

00:02:42.860 --> 00:02:42.870 align:start position:0%
addresses but we're also going to need
 

00:02:42.870 --> 00:02:44.839 align:start position:0%
addresses but we're also going to need
the<00:02:43.019><c> books</c><00:02:43.290><c> table</c><00:02:43.590><c> to</c><00:02:43.920><c> tell</c><00:02:44.129><c> us</c><00:02:44.280><c> which</c><00:02:44.519><c> books</c>

00:02:44.839 --> 00:02:44.849 align:start position:0%
the books table to tell us which books
 

00:02:44.849 --> 00:02:48.920 align:start position:0%
the books table to tell us which books
are<00:02:45.030><c> technology</c><00:02:45.629><c> books</c><00:02:47.060><c> and</c><00:02:48.060><c> we'll</c><00:02:48.629><c> need</c><00:02:48.780><c> the</c>

00:02:48.920 --> 00:02:48.930 align:start position:0%
are technology books and we'll need the
 

00:02:48.930 --> 00:02:50.900 align:start position:0%
are technology books and we'll need the
orders<00:02:49.260><c> table</c><00:02:49.470><c> because</c><00:02:50.160><c> that's</c><00:02:50.400><c> where</c><00:02:50.640><c> a</c><00:02:50.670><c> book</c>

00:02:50.900 --> 00:02:50.910 align:start position:0%
orders table because that's where a book
 

00:02:50.910 --> 00:02:54.559 align:start position:0%
orders table because that's where a book
is<00:02:51.000><c> joined</c><00:02:51.329><c> with</c><00:02:51.510><c> a</c><00:02:51.660><c> customer</c><00:02:52.670><c> now</c><00:02:53.670><c> what</c>

00:02:54.559 --> 00:02:54.569 align:start position:0%
is joined with a customer now what
 

00:02:54.569 --> 00:02:57.009 align:start position:0%
is joined with a customer now what
conditions<00:02:55.170><c> do</c><00:02:55.290><c> we</c><00:02:55.410><c> want</c><00:02:55.680><c> the</c><00:02:55.799><c> data</c><00:02:56.040><c> to</c><00:02:56.160><c> meet</c>

00:02:57.009 --> 00:02:57.019 align:start position:0%
conditions do we want the data to meet
 

00:02:57.019 --> 00:03:00.140 align:start position:0%
conditions do we want the data to meet
well<00:02:58.019><c> we</c><00:02:58.140><c> want</c><00:02:58.410><c> to</c><00:02:58.590><c> see</c><00:02:58.799><c> only</c><00:02:59.010><c> the</c><00:02:59.519><c> customer</c>

00:03:00.140 --> 00:03:00.150 align:start position:0%
well we want to see only the customer
 

00:03:00.150 --> 00:03:02.119 align:start position:0%
well we want to see only the customer
names<00:03:00.420><c> and</c><00:03:00.660><c> addresses</c><00:03:01.079><c> for</c><00:03:01.470><c> customers</c><00:03:01.950><c> who</c>

00:03:02.119 --> 00:03:02.129 align:start position:0%
names and addresses for customers who
 

00:03:02.129 --> 00:03:04.309 align:start position:0%
names and addresses for customers who
have<00:03:02.280><c> ordered</c><00:03:02.640><c> books</c><00:03:02.849><c> that</c><00:03:03.480><c> have</c><00:03:03.599><c> a</c><00:03:03.629><c> category</c>

00:03:04.309 --> 00:03:04.319 align:start position:0%
have ordered books that have a category
 

00:03:04.319 --> 00:03:09.199 align:start position:0%
have ordered books that have a category
of<00:03:04.440><c> Technology</c><00:03:07.040><c> now</c><00:03:08.040><c> that</c><00:03:08.220><c> we</c><00:03:08.310><c> have</c><00:03:08.430><c> a</c><00:03:08.459><c> plan</c><00:03:08.819><c> we</c>

00:03:09.199 --> 00:03:09.209 align:start position:0%
of Technology now that we have a plan we
 

00:03:09.209 --> 00:03:12.530 align:start position:0%
of Technology now that we have a plan we
can<00:03:09.629><c> start</c><00:03:09.900><c> building</c><00:03:10.140><c> a</c><00:03:10.379><c> query</c><00:03:10.739><c> in</c><00:03:10.890><c> Access</c><00:03:11.540><c> we</c>

00:03:12.530 --> 00:03:12.540 align:start position:0%
can start building a query in Access we
 

00:03:12.540 --> 00:03:13.970 align:start position:0%
can start building a query in Access we
are<00:03:12.660><c> going</c><00:03:12.930><c> to</c><00:03:13.049><c> build</c><00:03:13.200><c> this</c><00:03:13.349><c> query</c><00:03:13.709><c> from</c>

00:03:13.970 --> 00:03:13.980 align:start position:0%
are going to build this query from
 

00:03:13.980 --> 00:03:16.190 align:start position:0%
are going to build this query from
scratch<00:03:14.310><c> you</c><00:03:15.299><c> do</c><00:03:15.510><c> that</c><00:03:15.690><c> with</c><00:03:15.810><c> the</c><00:03:15.900><c> query</c>

00:03:16.190 --> 00:03:16.200 align:start position:0%
scratch you do that with the query
 

00:03:16.200 --> 00:03:18.979 align:start position:0%
scratch you do that with the query
design<00:03:16.560><c> commands</c><00:03:17.250><c> on</c><00:03:17.370><c> the</c><00:03:17.639><c> create</c><00:03:17.970><c> tab</c><00:03:18.000><c> on</c><00:03:18.750><c> the</c>

00:03:18.979 --> 00:03:18.989 align:start position:0%
design commands on the create tab on the
 

00:03:18.989 --> 00:03:22.129 align:start position:0%
design commands on the create tab on the
ribbon<00:03:19.760><c> now</c><00:03:20.760><c> when</c><00:03:20.910><c> the</c><00:03:21.000><c> show</c><00:03:21.239><c> table</c><00:03:21.540><c> dialog</c>

00:03:22.129 --> 00:03:22.139 align:start position:0%
ribbon now when the show table dialog
 

00:03:22.139 --> 00:03:25.430 align:start position:0%
ribbon now when the show table dialog
box<00:03:22.440><c> opens</c><00:03:22.950><c> pick</c><00:03:23.489><c> all</c><00:03:23.669><c> the</c><00:03:24.090><c> tables</c><00:03:24.720><c> that</c><00:03:25.049><c> you</c>

00:03:25.430 --> 00:03:25.440 align:start position:0%
box opens pick all the tables that you
 

00:03:25.440 --> 00:03:27.890 align:start position:0%
box opens pick all the tables that you
outlines<00:03:25.950><c> on</c><00:03:26.250><c> your</c><00:03:26.430><c> plan</c><00:03:26.730><c> we</c><00:03:27.599><c> need</c><00:03:27.750><c> the</c>

00:03:27.890 --> 00:03:27.900 align:start position:0%
outlines on your plan we need the
 

00:03:27.900 --> 00:03:30.830 align:start position:0%
outlines on your plan we need the
customers<00:03:28.440><c> table</c><00:03:28.859><c> the</c><00:03:29.459><c> orders</c><00:03:29.880><c> table</c><00:03:30.120><c> in</c><00:03:30.480><c> the</c>

00:03:30.830 --> 00:03:30.840 align:start position:0%
customers table the orders table in the
 

00:03:30.840 --> 00:03:31.520 align:start position:0%
customers table the orders table in the
books<00:03:31.049><c> table</c>

00:03:31.520 --> 00:03:31.530 align:start position:0%
books table
 

00:03:31.530 --> 00:03:36.860 align:start position:0%
books table
so<00:03:32.250><c> click</c><00:03:32.549><c> them</c><00:03:32.730><c> to</c><00:03:32.880><c> add</c><00:03:33.030><c> them</c><00:03:35.389><c> now</c><00:03:36.389><c> I</c><00:03:36.419><c> need</c><00:03:36.720><c> to</c>

00:03:36.860 --> 00:03:36.870 align:start position:0%
so click them to add them now I need to
 

00:03:36.870 --> 00:03:38.930 align:start position:0%
so click them to add them now I need to
look<00:03:37.049><c> at</c><00:03:37.200><c> my</c><00:03:37.290><c> plan</c><00:03:37.620><c> and</c><00:03:37.799><c> decide</c><00:03:38.099><c> what</c><00:03:38.400><c> feels</c><00:03:38.730><c> I</c>

00:03:38.930 --> 00:03:38.940 align:start position:0%
look at my plan and decide what feels I
 

00:03:38.940 --> 00:03:41.930 align:start position:0%
look at my plan and decide what feels I
need<00:03:39.180><c> from</c><00:03:39.419><c> each</c><00:03:39.660><c> table</c><00:03:40.220><c> well</c><00:03:41.220><c> I</c><00:03:41.250><c> want</c><00:03:41.609><c> to</c><00:03:41.760><c> see</c>

00:03:41.930 --> 00:03:41.940 align:start position:0%
need from each table well I want to see
 

00:03:41.940 --> 00:03:44.180 align:start position:0%
need from each table well I want to see
the<00:03:42.060><c> customers</c><00:03:42.630><c> first</c><00:03:42.900><c> and</c><00:03:43.049><c> last</c><00:03:43.319><c> name</c><00:03:43.739><c> and</c>

00:03:44.180 --> 00:03:44.190 align:start position:0%
the customers first and last name and
 

00:03:44.190 --> 00:03:46.750 align:start position:0%
the customers first and last name and
their<00:03:44.849><c> street</c><00:03:45.150><c> address</c><00:03:45.180><c> city</c><00:03:45.660><c> state</c><00:03:45.930><c> and</c><00:03:46.260><c> zip</c>

00:03:46.750 --> 00:03:46.760 align:start position:0%
their street address city state and zip
 

00:03:46.760 --> 00:03:49.699 align:start position:0%
their street address city state and zip
so<00:03:47.760><c> I'll</c><00:03:47.970><c> highlight</c><00:03:48.329><c> those</c><00:03:48.720><c> fields</c><00:03:49.260><c> and</c><00:03:49.349><c> drag</c>

00:03:49.699 --> 00:03:49.709 align:start position:0%
so I'll highlight those fields and drag
 

00:03:49.709 --> 00:03:51.259 align:start position:0%
so I'll highlight those fields and drag
them<00:03:49.889><c> down</c><00:03:49.919><c> to</c><00:03:50.250><c> the</c><00:03:50.370><c> bottom</c><00:03:50.700><c> portion</c><00:03:50.940><c> of</c><00:03:51.209><c> the</c>

00:03:51.259 --> 00:03:51.269 align:start position:0%
them down to the bottom portion of the
 

00:03:51.269 --> 00:03:54.259 align:start position:0%
them down to the bottom portion of the
screen<00:03:51.450><c> I</c><00:03:52.019><c> also</c><00:03:52.650><c> need</c><00:03:53.010><c> a</c><00:03:53.040><c> category</c><00:03:53.459><c> field</c><00:03:53.970><c> from</c>

00:03:54.259 --> 00:03:54.269 align:start position:0%
screen I also need a category field from
 

00:03:54.269 --> 00:03:56.930 align:start position:0%
screen I also need a category field from
the<00:03:54.389><c> books</c><00:03:54.599><c> table</c><00:03:54.950><c> so</c><00:03:55.950><c> I'll</c><00:03:56.310><c> drag</c><00:03:56.669><c> that</c><00:03:56.879><c> down</c>

00:03:56.930 --> 00:03:56.940 align:start position:0%
the books table so I'll drag that down
 

00:03:56.940 --> 00:04:00.650 align:start position:0%
the books table so I'll drag that down
there<00:03:57.329><c> too</c><00:03:58.730><c> these</c><00:03:59.730><c> are</c><00:03:59.790><c> all</c><00:04:00.090><c> the</c><00:04:00.239><c> fields</c><00:04:00.450><c> I</c>

00:04:00.650 --> 00:04:00.660 align:start position:0%
there too these are all the fields I
 

00:04:00.660 --> 00:04:02.930 align:start position:0%
there too these are all the fields I
care<00:04:00.930><c> about</c><00:04:01.200><c> so</c><00:04:01.799><c> now</c><00:04:01.829><c> I</c><00:04:02.040><c> have</c><00:04:02.220><c> to</c><00:04:02.370><c> tell</c><00:04:02.489><c> access</c>

00:04:02.930 --> 00:04:02.940 align:start position:0%
care about so now I have to tell access
 

00:04:02.940 --> 00:04:07.039 align:start position:0%
care about so now I have to tell access
how<00:04:03.180><c> to</c><00:04:03.239><c> show</c><00:04:03.629><c> them</c><00:04:03.870><c> to</c><00:04:04.139><c> me</c><00:04:04.349><c> I</c><00:04:05.060><c> want</c><00:04:06.060><c> only</c><00:04:06.329><c> books</c>

00:04:07.039 --> 00:04:07.049 align:start position:0%
how to show them to me I want only books
 

00:04:07.049 --> 00:04:09.650 align:start position:0%
how to show them to me I want only books
with<00:04:07.260><c> the</c><00:04:07.349><c> category</c><00:04:07.829><c> of</c><00:04:07.980><c> technology</c><00:04:08.660><c> certain</c>

00:04:09.650 --> 00:04:09.660 align:start position:0%
with the category of technology certain
 

00:04:09.660 --> 00:04:15.170 align:start position:0%
with the category of technology certain
criteria<00:04:10.639><c> I'll</c><00:04:11.639><c> type</c><00:04:12.379><c> technology</c><00:04:14.180><c> access</c>

00:04:15.170 --> 00:04:15.180 align:start position:0%
criteria I'll type technology access
 

00:04:15.180 --> 00:04:17.029 align:start position:0%
criteria I'll type technology access
puts<00:04:15.750><c> the</c><00:04:15.900><c> quotes</c><00:04:16.139><c> around</c><00:04:16.320><c> it</c><00:04:16.620><c> because</c><00:04:16.859><c> that</c>

00:04:17.029 --> 00:04:17.039 align:start position:0%
puts the quotes around it because that
 

00:04:17.039 --> 00:04:19.520 align:start position:0%
puts the quotes around it because that
is<00:04:17.190><c> the</c><00:04:17.310><c> exact</c><00:04:17.849><c> word</c><00:04:18.299><c> it</c><00:04:18.720><c> is</c><00:04:18.840><c> looking</c><00:04:19.169><c> for</c><00:04:19.380><c> in</c>

00:04:19.520 --> 00:04:19.530 align:start position:0%
is the exact word it is looking for in
 

00:04:19.530 --> 00:04:22.399 align:start position:0%
is the exact word it is looking for in
the<00:04:19.620><c> books</c><00:04:19.799><c> table</c><00:04:20.570><c> now</c><00:04:21.570><c> all</c><00:04:21.810><c> you</c><00:04:21.959><c> have</c><00:04:21.989><c> to</c><00:04:22.140><c> do</c>

00:04:22.399 --> 00:04:22.409 align:start position:0%
the books table now all you have to do
 

00:04:22.409 --> 00:04:25.580 align:start position:0%
the books table now all you have to do
is<00:04:22.620><c> hit</c><00:04:22.860><c> and</c><00:04:23.039><c> run</c><00:04:23.280><c> in</c><00:04:23.640><c> the</c><00:04:24.510><c> results</c><00:04:24.930><c> tab</c><00:04:24.990><c> to</c><00:04:25.409><c> run</c>

00:04:25.580 --> 00:04:25.590 align:start position:0%
is hit and run in the results tab to run
 

00:04:25.590 --> 00:04:27.000 align:start position:0%
is hit and run in the results tab to run
the<00:04:25.680><c> query</c>

00:04:27.000 --> 00:04:27.010 align:start position:0%
the query
 

00:04:27.010 --> 00:04:29.250 align:start position:0%
the query
if<00:04:27.460><c> your</c><00:04:28.120><c> results</c><00:04:28.540><c> don't</c><00:04:28.750><c> look</c><00:04:28.930><c> like</c><00:04:29.080><c> you</c>

00:04:29.250 --> 00:04:29.260 align:start position:0%
if your results don't look like you
 

00:04:29.260 --> 00:04:31.290 align:start position:0%
if your results don't look like you
expect<00:04:29.710><c> them</c><00:04:29.860><c> to</c><00:04:29.890><c> you</c><00:04:30.610><c> may</c><00:04:30.820><c> not</c><00:04:31.000><c> have</c><00:04:31.150><c> included</c>

00:04:31.290 --> 00:04:31.300 align:start position:0%
expect them to you may not have included
 

00:04:31.300 --> 00:04:35.160 align:start position:0%
expect them to you may not have included
everything<00:04:32.170><c> from</c><00:04:32.380><c> your</c><00:04:32.470><c> plan</c><00:04:33.570><c> but</c><00:04:34.570><c> ours</c><00:04:34.990><c> looks</c>

00:04:35.160 --> 00:04:35.170 align:start position:0%
everything from your plan but ours looks
 

00:04:35.170 --> 00:04:36.900 align:start position:0%
everything from your plan but ours looks
pretty<00:04:35.440><c> now</c><00:04:36.130><c> by</c><00:04:36.280><c> default</c>

00:04:36.900 --> 00:04:36.910 align:start position:0%
pretty now by default
 

00:04:36.910 --> 00:04:38.370 align:start position:0%
pretty now by default
whatever<00:04:37.180><c> you</c><00:04:37.330><c> drag</c><00:04:37.570><c> to</c><00:04:37.780><c> the</c><00:04:37.810><c> bottom</c><00:04:38.170><c> of</c><00:04:38.290><c> the</c>

00:04:38.370 --> 00:04:38.380 align:start position:0%
whatever you drag to the bottom of the
 

00:04:38.380 --> 00:04:40.530 align:start position:0%
whatever you drag to the bottom of the
screen<00:04:38.590><c> shows</c><00:04:39.100><c> up</c><00:04:39.310><c> in</c><00:04:39.430><c> your</c><00:04:39.460><c> results</c><00:04:39.880><c> we</c>

00:04:40.530 --> 00:04:40.540 align:start position:0%
screen shows up in your results we
 

00:04:40.540 --> 00:04:42.600 align:start position:0%
screen shows up in your results we
really<00:04:40.870><c> don't</c><00:04:40.990><c> need</c><00:04:41.290><c> to</c><00:04:41.350><c> see</c><00:04:41.710><c> the</c><00:04:41.830><c> category</c><00:04:42.400><c> so</c>

00:04:42.600 --> 00:04:42.610 align:start position:0%
really don't need to see the category so
 

00:04:42.610 --> 00:04:44.420 align:start position:0%
really don't need to see the category so
I'm<00:04:42.700><c> gonna</c><00:04:42.790><c> show</c><00:04:43.120><c> you</c><00:04:43.180><c> how</c><00:04:43.390><c> to</c><00:04:43.420><c> remove</c><00:04:43.690><c> this</c>

00:04:44.420 --> 00:04:44.430 align:start position:0%
I'm gonna show you how to remove this
 

00:04:44.430 --> 00:04:50.220 align:start position:0%
I'm gonna show you how to remove this
let's<00:04:45.430><c> go</c><00:04:45.580><c> back</c><00:04:45.610><c> to</c><00:04:46.000><c> design</c><00:04:46.180><c> view</c><00:04:46.390><c> and</c><00:04:49.230><c> we're</c>

00:04:50.220 --> 00:04:50.230 align:start position:0%
let's go back to design view and we're
 

00:04:50.230 --> 00:04:54.600 align:start position:0%
let's go back to design view and we're
gonna<00:04:50.380><c> uncheck</c><00:04:51.310><c> the</c><00:04:51.520><c> box</c><00:04:52.320><c> on</c><00:04:53.320><c> the</c><00:04:53.920><c> show</c><00:04:54.280><c> row</c>

00:04:54.600 --> 00:04:54.610 align:start position:0%
gonna uncheck the box on the show row
 

00:04:54.610 --> 00:04:57.300 align:start position:0%
gonna uncheck the box on the show row
above<00:04:55.060><c> technology</c><00:04:55.870><c> that</c><00:04:56.380><c> way</c><00:04:56.590><c> the</c><00:04:56.740><c> category</c>

00:04:57.300 --> 00:04:57.310 align:start position:0%
above technology that way the category
 

00:04:57.310 --> 00:05:00.120 align:start position:0%
above technology that way the category
won't<00:04:57.550><c> show</c><00:04:57.760><c> on</c><00:04:57.790><c> our</c><00:04:58.030><c> results</c><00:04:58.890><c> now</c><00:04:59.890><c> don't</c>

00:05:00.120 --> 00:05:00.130 align:start position:0%
won't show on our results now don't
 

00:05:00.130 --> 00:05:02.310 align:start position:0%
won't show on our results now don't
forget<00:05:00.250><c> to</c><00:05:00.430><c> save</c><00:05:00.730><c> your</c><00:05:00.940><c> query</c><00:05:01.240><c> we</c><00:05:01.810><c> may</c><00:05:02.020><c> want</c><00:05:02.260><c> to</c>

00:05:02.310 --> 00:05:02.320 align:start position:0%
forget to save your query we may want to
 

00:05:02.320 --> 00:05:04.290 align:start position:0%
forget to save your query we may want to
run<00:05:02.530><c> this</c><00:05:02.620><c> query</c><00:05:03.010><c> again</c><00:05:03.520><c> the</c><00:05:03.730><c> next</c><00:05:03.940><c> time</c><00:05:04.060><c> we</c>

00:05:04.290 --> 00:05:04.300 align:start position:0%
run this query again the next time we
 

00:05:04.300 --> 00:05:07.200 align:start position:0%
run this query again the next time we
have<00:05:04.420><c> a</c><00:05:04.450><c> technology</c><00:05:04.810><c> bullet</c><00:05:05.260><c> release</c><00:05:06.030><c> save</c><00:05:07.030><c> it</c>

00:05:07.200 --> 00:05:07.210 align:start position:0%
have a technology bullet release save it
 

00:05:07.210 --> 00:05:09.660 align:start position:0%
have a technology bullet release save it
as<00:05:07.420><c> customers</c><00:05:08.140><c> of</c><00:05:08.290><c> tip</c><00:05:08.530><c> books</c><00:05:08.800><c> or</c><00:05:09.070><c> something</c>

00:05:09.660 --> 00:05:09.670 align:start position:0%
as customers of tip books or something
 

00:05:09.670 --> 00:05:14.730 align:start position:0%
as customers of tip books or something
else<00:05:09.850><c> logical</c><00:05:10.480><c> okay</c><00:05:12.810><c> so</c><00:05:13.810><c> now</c><00:05:14.050><c> you've</c><00:05:14.260><c> seen</c><00:05:14.530><c> how</c>

00:05:14.730 --> 00:05:14.740 align:start position:0%
else logical okay so now you've seen how
 

00:05:14.740 --> 00:05:16.680 align:start position:0%
else logical okay so now you've seen how
to<00:05:14.800><c> plan</c><00:05:15.100><c> your</c><00:05:15.130><c> query</c><00:05:15.640><c> out</c><00:05:15.880><c> on</c><00:05:16.030><c> paper</c><00:05:16.270><c> first</c>

00:05:16.680 --> 00:05:16.690 align:start position:0%
to plan your query out on paper first
 

00:05:16.690 --> 00:05:19.440 align:start position:0%
to plan your query out on paper first
and<00:05:17.080><c> how</c><00:05:17.800><c> to</c><00:05:17.860><c> use</c><00:05:18.100><c> the</c><00:05:18.220><c> query</c><00:05:18.520><c> design</c><00:05:18.850><c> tool</c><00:05:19.180><c> to</c>

00:05:19.440 --> 00:05:19.450 align:start position:0%
and how to use the query design tool to
 

00:05:19.450 --> 00:05:22.470 align:start position:0%
and how to use the query design tool to
set<00:05:19.630><c> up</c><00:05:19.750><c> a</c><00:05:19.840><c> simple</c><00:05:20.050><c> select</c><00:05:20.470><c> query</c><00:05:21.060><c> next</c><00:05:22.060><c> we'll</c>

00:05:22.470 --> 00:05:22.480 align:start position:0%
set up a simple select query next we'll
 

00:05:22.480 --> 00:05:24.180 align:start position:0%
set up a simple select query next we'll
look<00:05:22.630><c> at</c><00:05:22.750><c> how</c><00:05:22.810><c> to</c><00:05:22.930><c> use</c><00:05:23.170><c> the</c><00:05:23.320><c> query</c><00:05:23.560><c> wizard</c><00:05:23.920><c> to</c>

00:05:24.180 --> 00:05:24.190 align:start position:0%
look at how to use the query wizard to
 

00:05:24.190 --> 00:05:28.110 align:start position:0%
look at how to use the query wizard to
find<00:05:24.460><c> out</c><00:05:24.580><c> which</c><00:05:24.820><c> book</c><00:05:25.090><c> is</c><00:05:25.210><c> our</c><00:05:25.360><c> bestseller</c>