WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:08.290 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:07.269><c> one</c><00:00:08.269><c> of</c>

00:00:08.290 --> 00:00:08.300 align:start position:0%
opportunities for a better life one of
 

00:00:08.300 --> 00:00:10.150 align:start position:0%
opportunities for a better life one of
the<00:00:08.419><c> most</c><00:00:08.660><c> powerful</c><00:00:08.959><c> ways</c><00:00:09.379><c> of</c><00:00:09.620><c> analyzing</c><00:00:10.129><c> your</c>

00:00:10.150 --> 00:00:10.160 align:start position:0%
the most powerful ways of analyzing your
 

00:00:10.160 --> 00:00:12.339 align:start position:0%
the most powerful ways of analyzing your
data<00:00:10.400><c> and</c><00:00:10.610><c> access</c><00:00:10.789><c> is</c><00:00:11.179><c> by</c><00:00:11.450><c> creating</c><00:00:11.719><c> a</c><00:00:12.110><c> query</c>

00:00:12.339 --> 00:00:12.349 align:start position:0%
data and access is by creating a query
 

00:00:12.349 --> 00:00:14.739 align:start position:0%
data and access is by creating a query
running<00:00:13.339><c> a</c><00:00:13.429><c> query</c><00:00:13.759><c> is</c><00:00:13.999><c> like</c><00:00:14.179><c> asking</c><00:00:14.629><c> your</c>

00:00:14.739 --> 00:00:14.749 align:start position:0%
running a query is like asking your
 

00:00:14.749 --> 00:00:17.589 align:start position:0%
running a query is like asking your
database<00:00:15.169><c> a</c><00:00:15.200><c> question</c><00:00:15.799><c> a</c><00:00:16.060><c> query</c><00:00:17.060><c> can</c><00:00:17.119><c> retrieve</c>

00:00:17.589 --> 00:00:17.599 align:start position:0%
database a question a query can retrieve
 

00:00:17.599 --> 00:00:19.810 align:start position:0%
database a question a query can retrieve
data<00:00:17.810><c> from</c><00:00:17.960><c> a</c><00:00:18.380><c> single</c><00:00:18.710><c> table</c><00:00:18.859><c> or</c><00:00:19.189><c> from</c>

00:00:19.810 --> 00:00:19.820 align:start position:0%
data from a single table or from
 

00:00:19.820 --> 00:00:21.999 align:start position:0%
data from a single table or from
multiple<00:00:20.269><c> tables</c><00:00:20.330><c> and</c><00:00:20.840><c> it</c><00:00:21.380><c> all</c><00:00:21.529><c> depends</c><00:00:21.920><c> on</c>

00:00:21.999 --> 00:00:22.009 align:start position:0%
multiple tables and it all depends on
 

00:00:22.009 --> 00:00:25.060 align:start position:0%
multiple tables and it all depends on
how<00:00:22.189><c> complex</c><00:00:22.580><c> your</c><00:00:22.820><c> question</c><00:00:23.240><c> is</c><00:00:23.480><c> in</c><00:00:24.070><c> this</c>

00:00:25.060 --> 00:00:25.070 align:start position:0%
how complex your question is in this
 

00:00:25.070 --> 00:00:26.470 align:start position:0%
how complex your question is in this
video<00:00:25.339><c> we're</c><00:00:25.609><c> just</c><00:00:25.759><c> going</c><00:00:25.939><c> to</c><00:00:26.000><c> focus</c><00:00:26.210><c> on</c>

00:00:26.470 --> 00:00:26.480 align:start position:0%
video we're just going to focus on
 

00:00:26.480 --> 00:00:28.480 align:start position:0%
video we're just going to focus on
making<00:00:26.869><c> a</c><00:00:26.960><c> simple</c><00:00:27.320><c> query</c><00:00:27.529><c> that</c><00:00:27.859><c> uses</c><00:00:28.189><c> a</c><00:00:28.220><c> single</c>

00:00:28.480 --> 00:00:28.490 align:start position:0%
making a simple query that uses a single
 

00:00:28.490 --> 00:00:30.880 align:start position:0%
making a simple query that uses a single
table<00:00:28.820><c> and</c><00:00:29.150><c> this</c><00:00:29.749><c> is</c><00:00:29.869><c> sometimes</c><00:00:30.109><c> called</c><00:00:30.410><c> an</c>

00:00:30.880 --> 00:00:30.890 align:start position:0%
table and this is sometimes called an
 

00:00:30.890 --> 00:00:34.180 align:start position:0%
table and this is sometimes called an
advanced<00:00:31.369><c> filter</c><00:00:32.260><c> let's</c><00:00:33.260><c> suppose</c><00:00:33.559><c> our</c><00:00:33.800><c> bakery</c>

00:00:34.180 --> 00:00:34.190 align:start position:0%
advanced filter let's suppose our bakery
 

00:00:34.190 --> 00:00:36.279 align:start position:0%
advanced filter let's suppose our bakery
has<00:00:34.370><c> an</c><00:00:34.579><c> upcoming</c><00:00:34.730><c> event</c><00:00:35.090><c> and</c><00:00:35.480><c> I</c><00:00:35.989><c> want</c><00:00:36.170><c> to</c><00:00:36.230><c> get</c>

00:00:36.279 --> 00:00:36.289 align:start position:0%
has an upcoming event and I want to get
 

00:00:36.289 --> 00:00:38.020 align:start position:0%
has an upcoming event and I want to get
a<00:00:36.350><c> list</c><00:00:36.530><c> of</c><00:00:36.680><c> all</c><00:00:36.920><c> of</c><00:00:36.950><c> our</c><00:00:37.219><c> customers</c><00:00:37.700><c> who</c><00:00:37.850><c> live</c>

00:00:38.020 --> 00:00:38.030 align:start position:0%
a list of all of our customers who live
 

00:00:38.030 --> 00:00:40.209 align:start position:0%
a list of all of our customers who live
nearby<00:00:38.329><c> so</c><00:00:38.780><c> we</c><00:00:38.870><c> can</c><00:00:39.020><c> send</c><00:00:39.260><c> them</c><00:00:39.350><c> invitations</c><00:00:40.010><c> a</c>

00:00:40.209 --> 00:00:40.219 align:start position:0%
nearby so we can send them invitations a
 

00:00:40.219 --> 00:00:42.580 align:start position:0%
nearby so we can send them invitations a
query<00:00:41.149><c> is</c><00:00:41.329><c> going</c><00:00:41.390><c> to</c><00:00:41.600><c> be</c><00:00:41.690><c> able</c><00:00:41.809><c> to</c><00:00:41.930><c> go</c><00:00:42.170><c> into</c><00:00:42.379><c> the</c>

00:00:42.580 --> 00:00:42.590 align:start position:0%
query is going to be able to go into the
 

00:00:42.590 --> 00:00:44.889 align:start position:0%
query is going to be able to go into the
customers<00:00:43.039><c> table</c><00:00:43.250><c> and</c><00:00:43.550><c> find</c><00:00:44.180><c> the</c><00:00:44.329><c> names</c><00:00:44.600><c> and</c>

00:00:44.889 --> 00:00:44.899 align:start position:0%
customers table and find the names and
 

00:00:44.899 --> 00:00:47.920 align:start position:0%
customers table and find the names and
addresses<00:00:45.260><c> of</c><00:00:45.440><c> the</c><00:00:45.620><c> nearby</c><00:00:46.070><c> customers</c><00:00:46.930><c> to</c>

00:00:47.920 --> 00:00:47.930 align:start position:0%
addresses of the nearby customers to
 

00:00:47.930 --> 00:00:50.520 align:start position:0%
addresses of the nearby customers to
create<00:00:48.079><c> a</c><00:00:48.260><c> query</c><00:00:48.530><c> go</c><00:00:48.920><c> to</c><00:00:48.980><c> the</c><00:00:49.250><c> create</c><00:00:49.489><c> tab</c><00:00:49.879><c> and</c>

00:00:50.520 --> 00:00:50.530 align:start position:0%
create a query go to the create tab and
 

00:00:50.530 --> 00:00:57.310 align:start position:0%
create a query go to the create tab and
then<00:00:51.530><c> click</c><00:00:51.769><c> the</c><00:00:51.949><c> query</c><00:00:52.219><c> design</c><00:00:52.550><c> command</c>

00:00:57.310 --> 00:00:57.320 align:start position:0%
 
 

00:00:57.320 --> 00:00:59.770 align:start position:0%
 
and<00:00:57.579><c> then</c><00:00:58.579><c> you'll</c><00:00:58.730><c> need</c><00:00:58.880><c> to</c><00:00:58.970><c> select</c><00:00:59.180><c> the</c><00:00:59.570><c> table</c>

00:00:59.770 --> 00:00:59.780 align:start position:0%
and then you'll need to select the table
 

00:00:59.780 --> 00:01:01.390 align:start position:0%
and then you'll need to select the table
or<00:01:00.170><c> tables</c><00:01:00.590><c> that</c><00:01:00.710><c> you</c><00:01:00.800><c> want</c><00:01:00.980><c> to</c><00:01:01.040><c> retrieve</c><00:01:01.370><c> the</c>

00:01:01.390 --> 00:01:01.400 align:start position:0%
or tables that you want to retrieve the
 

00:01:01.400 --> 00:01:03.700 align:start position:0%
or tables that you want to retrieve the
data<00:01:01.550><c> from</c><00:01:01.930><c> we're</c><00:01:02.930><c> just</c><00:01:03.170><c> using</c><00:01:03.350><c> the</c><00:01:03.530><c> customers</c>

00:01:03.700 --> 00:01:03.710 align:start position:0%
data from we're just using the customers
 

00:01:03.710 --> 00:01:09.610 align:start position:0%
data from we're just using the customers
table<00:01:04.309><c> for</c><00:01:04.489><c> now</c><00:01:06.130><c> click</c><00:01:07.130><c> Add</c><00:01:07.310><c> and</c><00:01:08.350><c> then</c><00:01:09.350><c> you</c><00:01:09.440><c> can</c>

00:01:09.610 --> 00:01:09.620 align:start position:0%
table for now click Add and then you can
 

00:01:09.620 --> 00:01:13.270 align:start position:0%
table for now click Add and then you can
close<00:01:09.830><c> this</c><00:01:10.100><c> window</c><00:01:11.800><c> when</c><00:01:12.800><c> working</c><00:01:13.010><c> with</c>

00:01:13.270 --> 00:01:13.280 align:start position:0%
close this window when working with
 

00:01:13.280 --> 00:01:14.859 align:start position:0%
close this window when working with
queries<00:01:13.580><c> there</c><00:01:13.880><c> are</c><00:01:14.060><c> a</c><00:01:14.090><c> couple</c><00:01:14.360><c> of</c><00:01:14.510><c> different</c>

00:01:14.859 --> 00:01:14.869 align:start position:0%
queries there are a couple of different
 

00:01:14.869 --> 00:01:17.050 align:start position:0%
queries there are a couple of different
views<00:01:15.080><c> that</c><00:01:15.170><c> we're</c><00:01:15.440><c> going</c><00:01:15.619><c> to</c><00:01:15.710><c> use</c><00:01:15.920><c> if</c><00:01:16.130><c> you</c>

00:01:17.050 --> 00:01:17.060 align:start position:0%
views that we're going to use if you
 

00:01:17.060 --> 00:01:19.810 align:start position:0%
views that we're going to use if you
click<00:01:17.240><c> on</c><00:01:17.330><c> the</c><00:01:17.479><c> view</c><00:01:17.780><c> drop</c><00:01:18.080><c> down</c><00:01:18.320><c> arrow</c><00:01:18.820><c> then</c>

00:01:19.810 --> 00:01:19.820 align:start position:0%
click on the view drop down arrow then
 

00:01:19.820 --> 00:01:21.780 align:start position:0%
click on the view drop down arrow then
you<00:01:19.970><c> can</c><00:01:20.119><c> see</c><00:01:20.300><c> that</c><00:01:20.450><c> we</c><00:01:20.570><c> are</c><00:01:20.600><c> in</c><00:01:20.840><c> design</c><00:01:21.290><c> view</c>

00:01:21.780 --> 00:01:21.790 align:start position:0%
you can see that we are in design view
 

00:01:21.790 --> 00:01:24.130 align:start position:0%
you can see that we are in design view
when<00:01:22.790><c> we</c><00:01:22.910><c> finish</c><00:01:23.240><c> the</c><00:01:23.390><c> query</c><00:01:23.570><c> we're</c><00:01:23.840><c> going</c><00:01:24.080><c> to</c>

00:01:24.130 --> 00:01:24.140 align:start position:0%
when we finish the query we're going to
 

00:01:24.140 --> 00:01:25.990 align:start position:0%
when we finish the query we're going to
be<00:01:24.229><c> viewing</c><00:01:24.619><c> the</c><00:01:24.710><c> results</c><00:01:24.830><c> in</c><00:01:25.250><c> datasheet</c><00:01:25.759><c> view</c>

00:01:25.990 --> 00:01:26.000 align:start position:0%
be viewing the results in datasheet view
 

00:01:26.000 --> 00:01:28.210 align:start position:0%
be viewing the results in datasheet view
and<00:01:26.450><c> you</c><00:01:27.110><c> can</c><00:01:27.259><c> use</c><00:01:27.410><c> this</c><00:01:27.590><c> menu</c><00:01:27.830><c> to</c><00:01:27.979><c> switch</c>

00:01:28.210 --> 00:01:28.220 align:start position:0%
and you can use this menu to switch
 

00:01:28.220 --> 00:01:33.279 align:start position:0%
and you can use this menu to switch
views<00:01:28.640><c> whenever</c><00:01:28.910><c> you</c><00:01:29.060><c> want</c><00:01:31.780><c> the</c><00:01:32.780><c> customers</c>

00:01:33.279 --> 00:01:33.289 align:start position:0%
views whenever you want the customers
 

00:01:33.289 --> 00:01:35.290 align:start position:0%
views whenever you want the customers
table<00:01:33.470><c> appears</c><00:01:34.039><c> as</c><00:01:34.220><c> a</c><00:01:34.250><c> small</c><00:01:34.550><c> window</c><00:01:35.060><c> in</c><00:01:35.090><c> the</c>

00:01:35.290 --> 00:01:35.300 align:start position:0%
table appears as a small window in the
 

00:01:35.300 --> 00:01:37.450 align:start position:0%
table appears as a small window in the
object<00:01:35.590><c> relationship</c><00:01:36.590><c> pane</c><00:01:36.860><c> which</c><00:01:37.160><c> is</c><00:01:37.340><c> this</c>

00:01:37.450 --> 00:01:37.460 align:start position:0%
object relationship pane which is this
 

00:01:37.460 --> 00:01:39.940 align:start position:0%
object relationship pane which is this
area<00:01:37.670><c> here</c><00:01:37.820><c> and</c><00:01:38.240><c> it</c><00:01:39.170><c> has</c><00:01:39.289><c> a</c><00:01:39.320><c> list</c><00:01:39.560><c> of</c><00:01:39.710><c> all</c><00:01:39.920><c> of</c>

00:01:39.940 --> 00:01:39.950 align:start position:0%
area here and it has a list of all of
 

00:01:39.950 --> 00:01:41.859 align:start position:0%
area here and it has a list of all of
the<00:01:40.190><c> fields</c><00:01:40.550><c> that</c><00:01:40.610><c> are</c><00:01:40.729><c> in</c><00:01:40.850><c> this</c><00:01:41.060><c> table</c><00:01:41.300><c> such</c>

00:01:41.859 --> 00:01:41.869 align:start position:0%
the fields that are in this table such
 

00:01:41.869 --> 00:01:44.020 align:start position:0%
the fields that are in this table such
as<00:01:41.899><c> first</c><00:01:42.350><c> name</c><00:01:42.590><c> last</c><00:01:42.950><c> name</c><00:01:43.160><c> and</c><00:01:43.580><c> street</c>

00:01:44.020 --> 00:01:44.030 align:start position:0%
as first name last name and street
 

00:01:44.030 --> 00:01:46.810 align:start position:0%
as first name last name and street
address<00:01:44.590><c> and</c><00:01:45.590><c> I'm</c><00:01:45.680><c> going</c><00:01:45.890><c> to</c><00:01:45.979><c> resize</c><00:01:46.460><c> it</c><00:01:46.490><c> so</c><00:01:46.789><c> I</c>

00:01:46.810 --> 00:01:46.820 align:start position:0%
address and I'm going to resize it so I
 

00:01:46.820 --> 00:01:50.770 align:start position:0%
address and I'm going to resize it so I
can<00:01:47.030><c> see</c><00:01:47.210><c> all</c><00:01:47.420><c> of</c><00:01:47.450><c> the</c><00:01:47.720><c> fields</c><00:01:49.660><c> what</c><00:01:50.660><c> we're</c>

00:01:50.770 --> 00:01:50.780 align:start position:0%
can see all of the fields what we're
 

00:01:50.780 --> 00:01:52.749 align:start position:0%
can see all of the fields what we're
going<00:01:50.960><c> to</c><00:01:51.020><c> do</c><00:01:51.200><c> is</c><00:01:51.410><c> double-click</c><00:01:51.890><c> each</c><00:01:52.250><c> field</c>

00:01:52.749 --> 00:01:52.759 align:start position:0%
going to do is double-click each field
 

00:01:52.759 --> 00:01:55.330 align:start position:0%
going to do is double-click each field
that<00:01:52.970><c> we</c><00:01:53.060><c> want</c><00:01:53.090><c> to</c><00:01:53.330><c> include</c><00:01:53.660><c> in</c><00:01:53.960><c> the</c><00:01:54.080><c> query</c><00:01:54.340><c> we</c>

00:01:55.330 --> 00:01:55.340 align:start position:0%
that we want to include in the query we
 

00:01:55.340 --> 00:01:57.430 align:start position:0%
that we want to include in the query we
need<00:01:55.550><c> the</c><00:01:55.670><c> customers</c><00:01:56.119><c> name</c><00:01:56.450><c> and</c><00:01:56.780><c> address</c><00:01:57.170><c> so</c>

00:01:57.430 --> 00:01:57.440 align:start position:0%
need the customers name and address so
 

00:01:57.440 --> 00:01:59.320 align:start position:0%
need the customers name and address so
we'll<00:01:58.100><c> double</c><00:01:58.429><c> click</c><00:01:58.460><c> on</c><00:01:58.700><c> the</c><00:01:58.850><c> first</c><00:01:59.090><c> name</c>

00:01:59.320 --> 00:01:59.330 align:start position:0%
we'll double click on the first name
 

00:01:59.330 --> 00:02:06.580 align:start position:0%
we'll double click on the first name
last<00:01:59.800><c> name</c><00:02:00.800><c> street</c><00:02:01.450><c> address</c><00:02:02.450><c> city</c><00:02:03.700><c> state</c><00:02:05.590><c> and</c>

00:02:06.580 --> 00:02:06.590 align:start position:0%
last name street address city state and
 

00:02:06.590 --> 00:02:10.180 align:start position:0%
last name street address city state and
zip<00:02:06.939><c> code</c><00:02:07.939><c> and</c><00:02:08.390><c> we're</c><00:02:09.229><c> not</c><00:02:09.350><c> emailing</c><00:02:09.860><c> or</c>

00:02:10.180 --> 00:02:10.190 align:start position:0%
zip code and we're not emailing or
 

00:02:10.190 --> 00:02:11.680 align:start position:0%
zip code and we're not emailing or
calling<00:02:10.220><c> them</c><00:02:10.670><c> so</c><00:02:11.000><c> we</c><00:02:11.120><c> don't</c><00:02:11.330><c> need</c><00:02:11.480><c> those</c>

00:02:11.680 --> 00:02:11.690 align:start position:0%
calling them so we don't need those
 

00:02:11.690 --> 00:02:15.190 align:start position:0%
calling them so we don't need those
fields<00:02:12.640><c> each</c><00:02:13.640><c> field</c><00:02:14.180><c> now</c><00:02:14.480><c> appears</c><00:02:14.989><c> in</c><00:02:15.049><c> the</c>

00:02:15.190 --> 00:02:15.200 align:start position:0%
fields each field now appears in the
 

00:02:15.200 --> 00:02:17.080 align:start position:0%
fields each field now appears in the
area<00:02:15.530><c> below</c><00:02:15.829><c> which</c><00:02:16.310><c> is</c><00:02:16.459><c> called</c><00:02:16.730><c> the</c><00:02:16.940><c> design</c>

00:02:17.080 --> 00:02:17.090 align:start position:0%
area below which is called the design
 

00:02:17.090 --> 00:02:20.920 align:start position:0%
area below which is called the design
grid<00:02:18.010><c> below</c><00:02:19.010><c> the</c><00:02:19.310><c> field</c><00:02:19.579><c> names</c><00:02:19.880><c> is</c><00:02:20.209><c> the</c><00:02:20.239><c> table</c>

00:02:20.920 --> 00:02:20.930 align:start position:0%
grid below the field names is the table
 

00:02:20.930 --> 00:02:23.259 align:start position:0%
grid below the field names is the table
row<00:02:21.110><c> which</c><00:02:21.680><c> shows</c><00:02:21.980><c> which</c><00:02:22.310><c> table</c><00:02:22.760><c> each</c><00:02:22.940><c> field</c>

00:02:23.259 --> 00:02:23.269 align:start position:0%
row which shows which table each field
 

00:02:23.269 --> 00:02:25.000 align:start position:0%
row which shows which table each field
comes<00:02:23.540><c> from</c><00:02:23.810><c> and</c><00:02:24.019><c> this</c><00:02:24.380><c> will</c><00:02:24.560><c> become</c><00:02:24.829><c> more</c>

00:02:25.000 --> 00:02:25.010 align:start position:0%
comes from and this will become more
 

00:02:25.010 --> 00:02:26.170 align:start position:0%
comes from and this will become more
important<00:02:25.430><c> when</c><00:02:25.519><c> we</c><00:02:25.610><c> start</c><00:02:25.640><c> dealing</c><00:02:26.030><c> with</c>

00:02:26.170 --> 00:02:26.180 align:start position:0%
important when we start dealing with
 

00:02:26.180 --> 00:02:28.630 align:start position:0%
important when we start dealing with
multiple<00:02:26.750><c> tables</c><00:02:26.930><c> and</c><00:02:27.400><c> we're</c><00:02:28.400><c> going</c><00:02:28.610><c> to</c>

00:02:28.630 --> 00:02:28.640 align:start position:0%
multiple tables and we're going to
 

00:02:28.640 --> 00:02:30.729 align:start position:0%
multiple tables and we're going to
modify<00:02:28.940><c> some</c><00:02:29.480><c> of</c><00:02:29.510><c> these</c><00:02:29.720><c> blank</c><00:02:29.780><c> cells</c><00:02:30.440><c> to</c>

00:02:30.729 --> 00:02:30.739 align:start position:0%
modify some of these blank cells to
 

00:02:30.739 --> 00:02:33.699 align:start position:0%
modify some of these blank cells to
refine<00:02:31.100><c> our</c><00:02:31.130><c> query</c><00:02:31.900><c> we</c><00:02:32.900><c> want</c><00:02:33.170><c> the</c><00:02:33.260><c> results</c><00:02:33.680><c> to</c>

00:02:33.699 --> 00:02:33.709 align:start position:0%
refine our query we want the results to
 

00:02:33.709 --> 00:02:36.430 align:start position:0%
refine our query we want the results to
be<00:02:33.890><c> sorted</c><00:02:33.920><c> by</c><00:02:34.430><c> last</c><00:02:34.459><c> name</c><00:02:35.120><c> so</c><00:02:35.780><c> in</c><00:02:36.049><c> the</c><00:02:36.170><c> sort</c>

00:02:36.430 --> 00:02:36.440 align:start position:0%
be sorted by last name so in the sort
 

00:02:36.440 --> 00:02:38.530 align:start position:0%
be sorted by last name so in the sort
row<00:02:36.530><c> we'll</c><00:02:36.920><c> click</c><00:02:37.160><c> the</c><00:02:37.310><c> cell</c><00:02:37.549><c> under</c><00:02:37.790><c> last</c><00:02:38.209><c> name</c>

00:02:38.530 --> 00:02:38.540 align:start position:0%
row we'll click the cell under last name
 

00:02:38.540 --> 00:02:41.550 align:start position:0%
row we'll click the cell under last name
and<00:02:38.860><c> a</c><00:02:39.860><c> drop-down</c><00:02:40.100><c> arrow</c><00:02:40.549><c> will</c><00:02:40.820><c> appear</c><00:02:41.209><c> you</c>

00:02:41.550 --> 00:02:41.560 align:start position:0%
and a drop-down arrow will appear you
 

00:02:41.560 --> 00:02:43.780 align:start position:0%
and a drop-down arrow will appear you
can<00:02:42.560><c> click</c><00:02:42.769><c> it</c><00:02:42.920><c> and</c><00:02:43.100><c> then</c><00:02:43.310><c> choose</c><00:02:43.579><c> how</c><00:02:43.610><c> you</c>

00:02:43.780 --> 00:02:43.790 align:start position:0%
can click it and then choose how you
 

00:02:43.790 --> 00:02:45.970 align:start position:0%
can click it and then choose how you
want<00:02:44.030><c> it</c><00:02:44.060><c> to</c><00:02:44.180><c> be</c><00:02:44.299><c> sorted</c>

00:02:45.970 --> 00:02:45.980 align:start position:0%
want it to be sorted
 

00:02:45.980 --> 00:02:48.530 align:start position:0%
want it to be sorted
next<00:02:46.980><c> we're</c><00:02:47.159><c> going</c><00:02:47.370><c> to</c><00:02:47.459><c> use</c><00:02:47.580><c> the</c><00:02:47.790><c> criteria</c><00:02:48.000><c> row</c>

00:02:48.530 --> 00:02:48.540 align:start position:0%
next we're going to use the criteria row
 

00:02:48.540 --> 00:02:50.690 align:start position:0%
next we're going to use the criteria row
to<00:02:48.599><c> filter</c><00:02:49.230><c> the</c><00:02:49.379><c> records</c><00:02:49.500><c> so</c><00:02:50.040><c> that</c><00:02:50.190><c> it's</c><00:02:50.340><c> only</c>

00:02:50.690 --> 00:02:50.700 align:start position:0%
to filter the records so that it's only
 

00:02:50.700 --> 00:02:52.420 align:start position:0%
to filter the records so that it's only
showing<00:02:50.940><c> the</c><00:02:51.120><c> customers</c><00:02:51.299><c> who</c><00:02:51.690><c> live</c><00:02:51.870><c> nearby</c>

00:02:52.420 --> 00:02:52.430 align:start position:0%
showing the customers who live nearby
 

00:02:52.430 --> 00:02:55.070 align:start position:0%
showing the customers who live nearby
first<00:02:53.430><c> of</c><00:02:53.580><c> all</c><00:02:53.670><c> we</c><00:02:53.849><c> want</c><00:02:54.060><c> to</c><00:02:54.180><c> send</c><00:02:54.420><c> invitations</c>

00:02:55.070 --> 00:02:55.080 align:start position:0%
first of all we want to send invitations
 

00:02:55.080 --> 00:02:57.199 align:start position:0%
first of all we want to send invitations
to<00:02:55.290><c> everyone</c><00:02:55.620><c> who</c><00:02:55.890><c> lives</c><00:02:55.920><c> in</c><00:02:56.159><c> Raleigh</c><00:02:56.400><c> so</c>

00:02:57.199 --> 00:02:57.209 align:start position:0%
to everyone who lives in Raleigh so
 

00:02:57.209 --> 00:02:59.119 align:start position:0%
to everyone who lives in Raleigh so
we'll<00:02:57.450><c> type</c><00:02:57.599><c> Raleigh</c><00:02:58.019><c> in</c><00:02:58.349><c> the</c><00:02:58.500><c> city</c><00:02:58.739><c> column</c>

00:02:59.119 --> 00:02:59.129 align:start position:0%
we'll type Raleigh in the city column
 

00:02:59.129 --> 00:03:01.250 align:start position:0%
we'll type Raleigh in the city column
and<00:02:59.310><c> since</c><00:03:00.269><c> we're</c><00:03:00.420><c> looking</c><00:03:00.659><c> for</c><00:03:00.810><c> an</c><00:03:00.900><c> exact</c>

00:03:01.250 --> 00:03:01.260 align:start position:0%
and since we're looking for an exact
 

00:03:01.260 --> 00:03:02.809 align:start position:0%
and since we're looking for an exact
match<00:03:01.349><c> it</c><00:03:01.860><c> will</c><00:03:02.010><c> need</c><00:03:02.129><c> to</c><00:03:02.250><c> be</c><00:03:02.340><c> in</c><00:03:02.430><c> quotation</c>

00:03:02.809 --> 00:03:02.819 align:start position:0%
match it will need to be in quotation
 

00:03:02.819 --> 00:03:06.199 align:start position:0%
match it will need to be in quotation
marks<00:03:03.860><c> so</c><00:03:04.860><c> far</c><00:03:05.099><c> this</c><00:03:05.250><c> query</c><00:03:05.549><c> will</c><00:03:05.730><c> show</c><00:03:05.909><c> all</c><00:03:06.180><c> of</c>

00:03:06.199 --> 00:03:06.209 align:start position:0%
marks so far this query will show all of
 

00:03:06.209 --> 00:03:08.240 align:start position:0%
marks so far this query will show all of
the<00:03:06.480><c> customers</c><00:03:06.510><c> who</c><00:03:07.049><c> live</c><00:03:07.170><c> in</c><00:03:07.290><c> Raleigh</c><00:03:07.500><c> but</c>

00:03:08.240 --> 00:03:08.250 align:start position:0%
the customers who live in Raleigh but
 

00:03:08.250 --> 00:03:10.250 align:start position:0%
the customers who live in Raleigh but
none<00:03:08.579><c> of</c><00:03:08.610><c> the</c><00:03:08.819><c> customers</c><00:03:09.000><c> in</c><00:03:09.480><c> other</c><00:03:09.690><c> cities</c>

00:03:10.250 --> 00:03:10.260 align:start position:0%
none of the customers in other cities
 

00:03:10.260 --> 00:03:12.649 align:start position:0%
none of the customers in other cities
but<00:03:10.920><c> one</c><00:03:11.159><c> of</c><00:03:11.190><c> the</c><00:03:11.400><c> ZIP</c><00:03:11.610><c> codes</c><00:03:11.909><c> in</c><00:03:12.090><c> Cary</c><00:03:12.420><c> is</c>

00:03:12.649 --> 00:03:12.659 align:start position:0%
but one of the ZIP codes in Cary is
 

00:03:12.659 --> 00:03:14.990 align:start position:0%
but one of the ZIP codes in Cary is
close<00:03:13.049><c> to</c><00:03:13.260><c> Raleigh</c><00:03:13.500><c> and</c><00:03:13.799><c> let's</c><00:03:14.430><c> say</c><00:03:14.610><c> we'd</c><00:03:14.819><c> like</c>

00:03:14.990 --> 00:03:15.000 align:start position:0%
close to Raleigh and let's say we'd like
 

00:03:15.000 --> 00:03:16.970 align:start position:0%
close to Raleigh and let's say we'd like
to<00:03:15.150><c> send</c><00:03:15.390><c> those</c><00:03:15.599><c> customers</c><00:03:16.140><c> an</c><00:03:16.319><c> invitation</c><00:03:16.860><c> as</c>

00:03:16.970 --> 00:03:16.980 align:start position:0%
to send those customers an invitation as
 

00:03:16.980 --> 00:03:19.460 align:start position:0%
to send those customers an invitation as
well<00:03:17.299><c> to</c><00:03:18.299><c> do</c><00:03:18.480><c> this</c><00:03:18.510><c> we're</c><00:03:18.930><c> going</c><00:03:18.959><c> to</c><00:03:19.200><c> need</c><00:03:19.290><c> to</c>

00:03:19.460 --> 00:03:19.470 align:start position:0%
well to do this we're going to need to
 

00:03:19.470 --> 00:03:22.300 align:start position:0%
well to do this we're going to need to
add<00:03:19.590><c> another</c><00:03:19.980><c> criteria</c><00:03:20.640><c> under</c><00:03:20.849><c> zip</c><00:03:21.269><c> code</c>

00:03:22.300 --> 00:03:22.310 align:start position:0%
add another criteria under zip code
 

00:03:22.310 --> 00:03:24.979 align:start position:0%
add another criteria under zip code
instead<00:03:23.310><c> of</c><00:03:23.370><c> using</c><00:03:23.609><c> the</c><00:03:23.819><c> criteria</c><00:03:24.329><c> row</c><00:03:24.540><c> we're</c>

00:03:24.979 --> 00:03:24.989 align:start position:0%
instead of using the criteria row we're
 

00:03:24.989 --> 00:03:26.930 align:start position:0%
instead of using the criteria row we're
going<00:03:25.019><c> to</c><00:03:25.290><c> use</c><00:03:25.410><c> the</c><00:03:25.590><c> row</c><00:03:25.739><c> below</c><00:03:25.950><c> it</c><00:03:26.129><c> which</c><00:03:26.730><c> is</c>

00:03:26.930 --> 00:03:26.940 align:start position:0%
going to use the row below it which is
 

00:03:26.940 --> 00:03:32.240 align:start position:0%
going to use the row below it which is
the<00:03:27.120><c> or</c><00:03:27.329><c> row</c><00:03:29.299><c> we'll</c><00:03:30.299><c> type</c><00:03:30.510><c> 2</c><00:03:30.870><c> 7</c><00:03:31.260><c> 5</c><00:03:31.470><c> 1</c><00:03:31.769><c> 3</c><00:03:31.799><c> in</c>

00:03:32.240 --> 00:03:32.250 align:start position:0%
the or row we'll type 2 7 5 1 3 in
 

00:03:32.250 --> 00:03:35.030 align:start position:0%
the or row we'll type 2 7 5 1 3 in
quotation<00:03:32.849><c> marks</c><00:03:33.120><c> so</c><00:03:33.440><c> now</c><00:03:34.440><c> the</c><00:03:34.500><c> query</c><00:03:34.859><c> will</c>

00:03:35.030 --> 00:03:35.040 align:start position:0%
quotation marks so now the query will
 

00:03:35.040 --> 00:03:37.520 align:start position:0%
quotation marks so now the query will
show<00:03:35.250><c> customers</c><00:03:35.549><c> who</c><00:03:35.970><c> are</c><00:03:36.090><c> in</c><00:03:36.299><c> Raleigh</c><00:03:36.569><c> or</c><00:03:36.870><c> in</c>

00:03:37.520 --> 00:03:37.530 align:start position:0%
show customers who are in Raleigh or in
 

00:03:37.530 --> 00:03:41.569 align:start position:0%
show customers who are in Raleigh or in
zip<00:03:37.799><c> code</c><00:03:38.010><c> 275</c><00:03:38.819><c> 1</c><00:03:39.090><c> 3</c><00:03:39.769><c> now</c><00:03:40.769><c> the</c><00:03:40.829><c> reason</c><00:03:41.280><c> why</c><00:03:41.430><c> we</c>

00:03:41.569 --> 00:03:41.579 align:start position:0%
zip code 275 1 3 now the reason why we
 

00:03:41.579 --> 00:03:43.550 align:start position:0%
zip code 275 1 3 now the reason why we
didn't<00:03:41.879><c> put</c><00:03:42.060><c> them</c><00:03:42.239><c> both</c><00:03:42.450><c> on</c><00:03:42.510><c> the</c><00:03:42.750><c> same</c><00:03:42.959><c> line</c><00:03:43.290><c> is</c>

00:03:43.550 --> 00:03:43.560 align:start position:0%
didn't put them both on the same line is
 

00:03:43.560 --> 00:03:45.380 align:start position:0%
didn't put them both on the same line is
that<00:03:44.099><c> the</c><00:03:44.250><c> customers</c><00:03:44.700><c> would</c><00:03:44.909><c> then</c><00:03:45.120><c> need</c><00:03:45.359><c> to</c>

00:03:45.380 --> 00:03:45.390 align:start position:0%
that the customers would then need to
 

00:03:45.390 --> 00:03:47.899 align:start position:0%
that the customers would then need to
meet<00:03:45.690><c> both</c><00:03:45.989><c> criteria</c><00:03:46.290><c> in</c><00:03:46.920><c> other</c><00:03:47.519><c> words</c><00:03:47.730><c> the</c>

00:03:47.899 --> 00:03:47.909 align:start position:0%
meet both criteria in other words the
 

00:03:47.909 --> 00:03:49.190 align:start position:0%
meet both criteria in other words the
customer<00:03:48.090><c> would</c><00:03:48.450><c> need</c><00:03:48.629><c> to</c><00:03:48.720><c> live</c><00:03:48.840><c> in</c><00:03:48.989><c> Raleigh</c>

00:03:49.190 --> 00:03:49.200 align:start position:0%
customer would need to live in Raleigh
 

00:03:49.200 --> 00:03:53.180 align:start position:0%
customer would need to live in Raleigh
and<00:03:49.470><c> in</c><00:03:49.980><c> zip</c><00:03:50.190><c> code</c><00:03:50.400><c> 275</c><00:03:51.180><c> 1</c><00:03:51.419><c> 3</c><00:03:51.690><c> in</c><00:03:51.950><c> some</c><00:03:52.950><c> cases</c>

00:03:53.180 --> 00:03:53.190 align:start position:0%
and in zip code 275 1 3 in some cases
 

00:03:53.190 --> 00:03:55.819 align:start position:0%
and in zip code 275 1 3 in some cases
you<00:03:53.459><c> may</c><00:03:53.609><c> want</c><00:03:53.849><c> that</c><00:03:54.060><c> but</c><00:03:54.780><c> in</c><00:03:54.989><c> this</c><00:03:55.109><c> example</c><00:03:55.560><c> it</c>

00:03:55.819 --> 00:03:55.829 align:start position:0%
you may want that but in this example it
 

00:03:55.829 --> 00:03:59.560 align:start position:0%
you may want that but in this example it
will<00:03:55.919><c> not</c><00:03:56.160><c> give</c><00:03:56.340><c> us</c><00:03:56.430><c> the</c><00:03:56.459><c> correct</c><00:03:56.609><c> results</c>

00:03:59.560 --> 00:03:59.570 align:start position:0%
 
 

00:03:59.570 --> 00:04:01.940 align:start position:0%
 
now<00:04:00.570><c> we're</c><00:04:00.810><c> finished</c><00:04:01.110><c> designing</c><00:04:01.440><c> this</c><00:04:01.620><c> query</c>

00:04:01.940 --> 00:04:01.950 align:start position:0%
now we're finished designing this query
 

00:04:01.950 --> 00:04:05.450 align:start position:0%
now we're finished designing this query
and<00:04:02.190><c> the</c><00:04:02.880><c> final</c><00:04:03.210><c> step</c><00:04:03.450><c> is</c><00:04:03.690><c> to</c><00:04:03.750><c> run</c><00:04:04.230><c> it</c><00:04:04.460><c> click</c>

00:04:05.450 --> 00:04:05.460 align:start position:0%
and the final step is to run it click
 

00:04:05.460 --> 00:04:07.930 align:start position:0%
and the final step is to run it click
the<00:04:05.610><c> run</c><00:04:05.820><c> command</c><00:04:06.180><c> on</c><00:04:06.450><c> the</c><00:04:06.630><c> design</c><00:04:06.930><c> tab</c><00:04:07.170><c> and</c>

00:04:07.930 --> 00:04:07.940 align:start position:0%
the run command on the design tab and
 

00:04:07.940 --> 00:04:10.490 align:start position:0%
the run command on the design tab and
the<00:04:08.940><c> results</c><00:04:09.300><c> will</c><00:04:09.450><c> instantly</c><00:04:09.930><c> appear</c><00:04:10.020><c> in</c>

00:04:10.490 --> 00:04:10.500 align:start position:0%
the results will instantly appear in
 

00:04:10.500 --> 00:04:12.590 align:start position:0%
the results will instantly appear in
datasheet<00:04:10.920><c> view</c><00:04:11.100><c> which</c><00:04:11.820><c> looks</c><00:04:12.090><c> exactly</c><00:04:12.240><c> like</c>

00:04:12.590 --> 00:04:12.600 align:start position:0%
datasheet view which looks exactly like
 

00:04:12.600 --> 00:04:14.470 align:start position:0%
datasheet view which looks exactly like
a<00:04:12.750><c> table</c>

00:04:14.470 --> 00:04:14.480 align:start position:0%
a table
 

00:04:14.480 --> 00:04:16.599 align:start position:0%
a table
if<00:04:14.540><c> you</c><00:04:15.440><c> scroll</c><00:04:15.650><c> through</c><00:04:15.890><c> the</c><00:04:15.980><c> results</c><00:04:16.130><c> you</c>

00:04:16.599 --> 00:04:16.609 align:start position:0%
if you scroll through the results you
 

00:04:16.609 --> 00:04:18.340 align:start position:0%
if you scroll through the results you
can<00:04:16.639><c> see</c><00:04:16.790><c> that</c><00:04:17.150><c> each</c><00:04:17.299><c> customer</c><00:04:17.840><c> lives</c><00:04:18.049><c> either</c>

00:04:18.340 --> 00:04:18.350 align:start position:0%
can see that each customer lives either
 

00:04:18.350 --> 00:04:24.520 align:start position:0%
can see that each customer lives either
in<00:04:18.590><c> Raleigh</c><00:04:18.889><c> or</c><00:04:19.160><c> in</c><00:04:19.880><c> zip</c><00:04:20.090><c> code</c><00:04:20.329><c> 275</c><00:04:21.109><c> 1</c><00:04:21.350><c> 3</c><00:04:21.650><c> if</c><00:04:23.530><c> you</c>

00:04:24.520 --> 00:04:24.530 align:start position:0%
in Raleigh or in zip code 275 1 3 if you
 

00:04:24.530 --> 00:04:25.990 align:start position:0%
in Raleigh or in zip code 275 1 3 if you
want<00:04:24.710><c> to</c><00:04:24.800><c> make</c><00:04:24.919><c> any</c><00:04:24.949><c> changes</c><00:04:25.490><c> to</c><00:04:25.550><c> the</c><00:04:25.729><c> query</c>

00:04:25.990 --> 00:04:26.000 align:start position:0%
want to make any changes to the query
 

00:04:26.000 --> 00:04:28.210 align:start position:0%
want to make any changes to the query
you<00:04:26.180><c> can</c><00:04:26.449><c> click</c><00:04:26.840><c> the</c><00:04:26.990><c> view</c><00:04:27.020><c> drop</c><00:04:27.680><c> down</c><00:04:27.919><c> arrow</c>

00:04:28.210 --> 00:04:28.220 align:start position:0%
you can click the view drop down arrow
 

00:04:28.220 --> 00:04:33.520 align:start position:0%
you can click the view drop down arrow
and<00:04:28.690><c> go</c><00:04:29.690><c> back</c><00:04:29.870><c> to</c><00:04:30.050><c> design</c><00:04:30.199><c> view</c><00:04:30.470><c> and</c><00:04:32.350><c> just</c><00:04:33.350><c> like</c>

00:04:33.520 --> 00:04:33.530 align:start position:0%
and go back to design view and just like
 

00:04:33.530 --> 00:04:36.240 align:start position:0%
and go back to design view and just like
any<00:04:33.770><c> object</c><00:04:33.949><c> it's</c><00:04:34.460><c> a</c><00:04:34.639><c> good</c><00:04:34.820><c> idea</c><00:04:35.060><c> to</c><00:04:35.180><c> save</c><00:04:35.449><c> it</c>

00:04:36.240 --> 00:04:36.250 align:start position:0%
any object it's a good idea to save it
 

00:04:36.250 --> 00:04:43.330 align:start position:0%
any object it's a good idea to save it
I'll<00:04:37.250><c> call</c><00:04:37.550><c> it</c><00:04:37.760><c> nearby</c><00:04:38.270><c> customers</c><00:04:42.130><c> this</c><00:04:43.130><c> was</c>

00:04:43.330 --> 00:04:43.340 align:start position:0%
I'll call it nearby customers this was
 

00:04:43.340 --> 00:04:45.730 align:start position:0%
I'll call it nearby customers this was
just<00:04:43.580><c> a</c><00:04:43.669><c> basic</c><00:04:43.940><c> example</c><00:04:44.240><c> and</c><00:04:44.840><c> in</c><00:04:45.410><c> the</c><00:04:45.530><c> next</c>

00:04:45.730 --> 00:04:45.740 align:start position:0%
just a basic example and in the next
 

00:04:45.740 --> 00:04:47.140 align:start position:0%
just a basic example and in the next
video<00:04:46.040><c> we're</c><00:04:46.250><c> going</c><00:04:46.370><c> to</c><00:04:46.490><c> talk</c><00:04:46.699><c> about</c><00:04:46.729><c> how</c><00:04:47.090><c> to</c>

00:04:47.140 --> 00:04:47.150 align:start position:0%
video we're going to talk about how to
 

00:04:47.150 --> 00:04:49.750 align:start position:0%
video we're going to talk about how to
make<00:04:47.330><c> a</c><00:04:47.360><c> query</c><00:04:47.720><c> with</c><00:04:47.900><c> multiple</c><00:04:48.440><c> tables</c><00:04:48.760><c> you</c>

00:04:49.750 --> 00:04:49.760 align:start position:0%
make a query with multiple tables you
 

00:04:49.760 --> 00:04:51.279 align:start position:0%
make a query with multiple tables you
may<00:04:49.820><c> want</c><00:04:50.150><c> to</c><00:04:50.210><c> practice</c><00:04:50.449><c> this</c><00:04:50.870><c> one</c><00:04:51.080><c> a</c><00:04:51.110><c> few</c>

00:04:51.279 --> 00:04:51.289 align:start position:0%
may want to practice this one a few
 

00:04:51.289 --> 00:04:53.350 align:start position:0%
may want to practice this one a few
times<00:04:51.350><c> before</c><00:04:51.860><c> you</c><00:04:52.100><c> go</c><00:04:52.280><c> on</c><00:04:52.460><c> to</c><00:04:52.910><c> make</c><00:04:53.060><c> sure</c><00:04:53.240><c> that</c>

00:04:53.350 --> 00:04:53.360 align:start position:0%
times before you go on to make sure that
 

00:04:53.360 --> 00:04:56.380 align:start position:0%
times before you go on to make sure that
you're<00:04:53.510><c> comfortable</c><00:04:53.750><c> with</c><00:04:54.080><c> the</c><00:04:54.199><c> process</c>