WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.550><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.999 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:03.899><c> life</c>

00:00:10.999 --> 00:00:11.009 align:start position:0%
 
 

00:00:11.009 --> 00:00:13.039 align:start position:0%
 
one<00:00:11.700><c> of</c><00:00:11.790><c> the</c><00:00:11.910><c> most</c><00:00:12.059><c> powerful</c><00:00:12.690><c> ways</c><00:00:12.839><c> of</c>

00:00:13.039 --> 00:00:13.049 align:start position:0%
one of the most powerful ways of
 

00:00:13.049 --> 00:00:14.900 align:start position:0%
one of the most powerful ways of
analyzing<00:00:13.559><c> your</c><00:00:13.619><c> data</c><00:00:13.679><c> and</c><00:00:14.070><c> access</c><00:00:14.219><c> is</c><00:00:14.639><c> by</c>

00:00:14.900 --> 00:00:14.910 align:start position:0%
analyzing your data and access is by
 

00:00:14.910 --> 00:00:17.779 align:start position:0%
analyzing your data and access is by
creating<00:00:15.420><c> a</c><00:00:15.539><c> query</c><00:00:15.949><c> running</c><00:00:16.949><c> a</c><00:00:17.039><c> query</c><00:00:17.340><c> is</c><00:00:17.580><c> like</c>

00:00:17.779 --> 00:00:17.789 align:start position:0%
creating a query running a query is like
 

00:00:17.789 --> 00:00:20.779 align:start position:0%
creating a query running a query is like
asking<00:00:18.210><c> your</c><00:00:18.330><c> database</c><00:00:18.779><c> a</c><00:00:18.810><c> question</c><00:00:19.380><c> a</c><00:00:19.789><c> query</c>

00:00:20.779 --> 00:00:20.789 align:start position:0%
asking your database a question a query
 

00:00:20.789 --> 00:00:23.240 align:start position:0%
asking your database a question a query
can<00:00:20.849><c> retrieve</c><00:00:21.360><c> data</c><00:00:21.570><c> from</c><00:00:21.720><c> a</c><00:00:22.140><c> single</c><00:00:22.289><c> table</c><00:00:22.770><c> or</c>

00:00:23.240 --> 00:00:23.250 align:start position:0%
can retrieve data from a single table or
 

00:00:23.250 --> 00:00:25.909 align:start position:0%
can retrieve data from a single table or
from<00:00:23.849><c> multiple</c><00:00:24.239><c> tables</c><00:00:24.449><c> and</c><00:00:24.810><c> it</c><00:00:25.349><c> all</c><00:00:25.500><c> depends</c>

00:00:25.909 --> 00:00:25.919 align:start position:0%
from multiple tables and it all depends
 

00:00:25.919 --> 00:00:29.060 align:start position:0%
from multiple tables and it all depends
on<00:00:25.980><c> how</c><00:00:26.160><c> complex</c><00:00:26.550><c> your</c><00:00:26.759><c> question</c><00:00:27.210><c> is</c><00:00:27.449><c> in</c><00:00:28.070><c> this</c>

00:00:29.060 --> 00:00:29.070 align:start position:0%
on how complex your question is in this
 

00:00:29.070 --> 00:00:30.439 align:start position:0%
on how complex your question is in this
video<00:00:29.310><c> we're</c><00:00:29.580><c> just</c><00:00:29.609><c> going</c><00:00:29.910><c> to</c><00:00:29.970><c> focus</c><00:00:30.210><c> on</c>

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

00:00:30.449 --> 00:00:32.450 align:start position:0%
video we're just going to focus on
making<00:00:30.839><c> a</c><00:00:30.929><c> simple</c><00:00:31.199><c> query</c><00:00:31.500><c> that</c><00:00:31.830><c> uses</c><00:00:32.009><c> a</c><00:00:32.220><c> single</c>

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

00:00:32.460 --> 00:00:34.850 align:start position:0%
making a simple query that uses a single
table<00:00:32.790><c> and</c><00:00:33.150><c> this</c><00:00:33.720><c> is</c><00:00:33.839><c> sometimes</c><00:00:34.080><c> called</c><00:00:34.379><c> an</c>

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

00:00:34.860 --> 00:00:38.119 align:start position:0%
table and this is sometimes called an
advanced<00:00:35.339><c> filter</c><00:00:36.230><c> let's</c><00:00:37.230><c> suppose</c><00:00:37.530><c> our</c><00:00:37.769><c> bakery</c>

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

00:00:38.129 --> 00:00:40.280 align:start position:0%
advanced filter let's suppose our bakery
has<00:00:38.339><c> an</c><00:00:38.550><c> upcoming</c><00:00:38.699><c> event</c><00:00:39.059><c> and</c><00:00:39.449><c> I</c><00:00:39.960><c> want</c><00:00:40.140><c> to</c><00:00:40.199><c> get</c>

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

00:00:40.290 --> 00:00:41.990 align:start position:0%
has an upcoming event and I want to get
a<00:00:40.320><c> list</c><00:00:40.500><c> of</c><00:00:40.650><c> all</c><00:00:40.920><c> of</c><00:00:40.949><c> our</c><00:00:41.159><c> customers</c><00:00:41.670><c> who</c><00:00:41.820><c> live</c>

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

00:00:42.000 --> 00:00:44.180 align:start position:0%
a list of all of our customers who live
nearby<00:00:42.300><c> so</c><00:00:42.750><c> we</c><00:00:42.839><c> can</c><00:00:42.989><c> send</c><00:00:43.199><c> them</c><00:00:43.350><c> invitations</c><00:00:43.980><c> a</c>

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

00:00:44.190 --> 00:00:46.549 align:start position:0%
nearby so we can send them invitations a
query<00:00:45.120><c> is</c><00:00:45.300><c> going</c><00:00:45.360><c> to</c><00:00:45.539><c> be</c><00:00:45.660><c> able</c><00:00:45.780><c> to</c><00:00:45.989><c> go</c><00:00:46.140><c> into</c><00:00:46.350><c> the</c>

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

00:00:46.559 --> 00:00:48.860 align:start position:0%
query is going to be able to go into the
customers<00:00:47.010><c> table</c><00:00:47.370><c> and</c><00:00:47.520><c> find</c><00:00:48.149><c> the</c><00:00:48.300><c> names</c><00:00:48.570><c> and</c>

00:00:48.860 --> 00:00:48.870 align:start position:0%
customers table and find the names and
 

00:00:48.870 --> 00:00:51.889 align:start position:0%
customers table and find the names and
addresses<00:00:49.230><c> of</c><00:00:49.559><c> the</c><00:00:49.710><c> nearby</c><00:00:50.039><c> customers</c><00:00:50.899><c> to</c>

00:00:51.889 --> 00:00:51.899 align:start position:0%
addresses of the nearby customers to
 

00:00:51.899 --> 00:00:54.490 align:start position:0%
addresses of the nearby customers to
create<00:00:52.199><c> a</c><00:00:52.230><c> query</c><00:00:52.500><c> go</c><00:00:52.890><c> to</c><00:00:52.949><c> the</c><00:00:53.219><c> create</c><00:00:53.460><c> tab</c><00:00:53.850><c> and</c>

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

00:00:54.500 --> 00:00:58.090 align:start position:0%
create a query go to the create tab and
then<00:00:55.500><c> click</c><00:00:55.739><c> the</c><00:00:55.769><c> query</c><00:00:56.190><c> design</c><00:00:56.519><c> command</c><00:00:56.969><c> and</c>

00:00:58.090 --> 00:00:58.100 align:start position:0%
then click the query design command and
 

00:00:58.100 --> 00:01:00.680 align:start position:0%
then click the query design command and
then<00:00:59.100><c> you'll</c><00:00:59.250><c> need</c><00:00:59.370><c> to</c><00:00:59.430><c> select</c><00:00:59.730><c> the</c><00:01:00.120><c> table</c><00:01:00.300><c> or</c>

00:01:00.680 --> 00:01:00.690 align:start position:0%
then you'll need to select the table or
 

00:01:00.690 --> 00:01:01.939 align:start position:0%
then you'll need to select the table or
tables<00:01:01.109><c> that</c><00:01:01.230><c> you</c><00:01:01.350><c> want</c><00:01:01.530><c> to</c><00:01:01.590><c> retrieve</c><00:01:01.920><c> the</c>

00:01:01.939 --> 00:01:01.949 align:start position:0%
tables that you want to retrieve the
 

00:01:01.949 --> 00:01:04.219 align:start position:0%
tables that you want to retrieve the
data<00:01:02.100><c> from</c><00:01:02.480><c> we're</c><00:01:03.480><c> just</c><00:01:03.719><c> using</c><00:01:03.870><c> the</c><00:01:04.080><c> customers</c>

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

00:01:04.229 --> 00:01:10.160 align:start position:0%
data from we're just using the customers
table<00:01:04.860><c> for</c><00:01:05.039><c> now</c><00:01:06.679><c> click</c><00:01:07.679><c> Add</c><00:01:07.860><c> and</c><00:01:08.899><c> then</c><00:01:09.899><c> you</c><00:01:09.990><c> can</c>

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

00:01:10.170 --> 00:01:14.480 align:start position:0%
table for now click Add and then you can
close<00:01:10.410><c> this</c><00:01:10.619><c> window</c><00:01:12.979><c> when</c><00:01:13.979><c> working</c><00:01:14.220><c> with</c>

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

00:01:14.490 --> 00:01:16.070 align:start position:0%
close this window when working with
queries<00:01:14.880><c> there</c><00:01:15.090><c> are</c><00:01:15.270><c> a</c><00:01:15.300><c> couple</c><00:01:15.569><c> of</c><00:01:15.720><c> different</c>

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

00:01:16.080 --> 00:01:18.589 align:start position:0%
queries there are a couple of different
views<00:01:16.289><c> that</c><00:01:16.380><c> we're</c><00:01:16.649><c> going</c><00:01:16.800><c> to</c><00:01:16.890><c> use</c><00:01:17.130><c> if</c><00:01:17.599><c> you</c>

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

00:01:18.599 --> 00:01:21.169 align:start position:0%
views that we're going to use if you
click<00:01:18.780><c> on</c><00:01:18.899><c> the</c><00:01:19.020><c> view</c><00:01:19.289><c> drop</c><00:01:19.619><c> down</c><00:01:19.860><c> arrow</c><00:01:20.190><c> then</c>

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

00:01:21.179 --> 00:01:23.139 align:start position:0%
click on the view drop down arrow then
you<00:01:21.330><c> can</c><00:01:21.479><c> see</c><00:01:21.660><c> that</c><00:01:21.810><c> we</c><00:01:21.929><c> are</c><00:01:21.959><c> in</c><00:01:22.200><c> design</c><00:01:22.619><c> view</c>

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

00:01:23.149 --> 00:01:25.490 align:start position:0%
you can see that we are in design view
when<00:01:24.149><c> we</c><00:01:24.300><c> finish</c><00:01:24.599><c> the</c><00:01:24.750><c> query</c><00:01:24.929><c> we're</c><00:01:25.200><c> going</c><00:01:25.440><c> to</c>

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

00:01:25.500 --> 00:01:27.350 align:start position:0%
when we finish the query we're going to
be<00:01:25.619><c> viewing</c><00:01:25.890><c> the</c><00:01:26.069><c> results</c><00:01:26.190><c> in</c><00:01:26.610><c> datasheet</c><00:01:27.119><c> view</c>

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

00:01:27.360 --> 00:01:29.570 align:start position:0%
be viewing the results in datasheet view
and<00:01:27.840><c> you</c><00:01:28.500><c> can</c><00:01:28.619><c> use</c><00:01:28.770><c> this</c><00:01:28.979><c> menu</c><00:01:29.220><c> to</c><00:01:29.340><c> switch</c>

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

00:01:29.580 --> 00:01:33.140 align:start position:0%
and you can use this menu to switch
views<00:01:29.729><c> whenever</c><00:01:30.300><c> you</c><00:01:30.420><c> want</c>

00:01:33.140 --> 00:01:33.150 align:start position:0%
 
 

00:01:33.150 --> 00:01:35.910 align:start position:0%
 
the<00:01:34.150><c> customers</c><00:01:34.660><c> table</c><00:01:35.020><c> appears</c><00:01:35.410><c> as</c><00:01:35.590><c> a</c><00:01:35.620><c> small</c>

00:01:35.910 --> 00:01:35.920 align:start position:0%
the customers table appears as a small
 

00:01:35.920 --> 00:01:38.220 align:start position:0%
the customers table appears as a small
window<00:01:36.430><c> in</c><00:01:36.460><c> the</c><00:01:36.820><c> object</c><00:01:36.960><c> relationship</c><00:01:37.960><c> pane</c>

00:01:38.220 --> 00:01:38.230 align:start position:0%
window in the object relationship pane
 

00:01:38.230 --> 00:01:40.680 align:start position:0%
window in the object relationship pane
which<00:01:38.530><c> is</c><00:01:38.710><c> this</c><00:01:38.830><c> area</c><00:01:39.040><c> here</c><00:01:39.190><c> and</c><00:01:39.580><c> it</c><00:01:40.540><c> has</c><00:01:40.660><c> a</c>

00:01:40.680 --> 00:01:40.690 align:start position:0%
which is this area here and it has a
 

00:01:40.690 --> 00:01:42.270 align:start position:0%
which is this area here and it has a
list<00:01:40.930><c> of</c><00:01:41.080><c> all</c><00:01:41.260><c> of</c><00:01:41.440><c> the</c><00:01:41.560><c> fields</c><00:01:41.920><c> that</c><00:01:42.040><c> are</c><00:01:42.190><c> in</c>

00:01:42.270 --> 00:01:42.280 align:start position:0%
list of all of the fields that are in
 

00:01:42.280 --> 00:01:44.520 align:start position:0%
list of all of the fields that are in
this<00:01:42.400><c> table</c><00:01:42.640><c> such</c><00:01:43.240><c> as</c><00:01:43.420><c> first</c><00:01:43.690><c> name</c><00:01:43.840><c> last</c><00:01:44.320><c> name</c>

00:01:44.520 --> 00:01:44.530 align:start position:0%
this table such as first name last name
 

00:01:44.530 --> 00:01:47.340 align:start position:0%
this table such as first name last name
and<00:01:44.680><c> street</c><00:01:45.400><c> address</c><00:01:45.729><c> and</c><00:01:46.050><c> I'm</c><00:01:47.050><c> going</c><00:01:47.260><c> to</c>

00:01:47.340 --> 00:01:47.350 align:start position:0%
and street address and I'm going to
 

00:01:47.350 --> 00:01:50.719 align:start position:0%
and street address and I'm going to
resize<00:01:47.830><c> it</c><00:01:48.040><c> so</c><00:01:48.070><c> I</c><00:01:48.190><c> can</c><00:01:48.400><c> see</c><00:01:48.580><c> all</c><00:01:48.790><c> of</c><00:01:48.820><c> the</c><00:01:49.090><c> fields</c>

00:01:50.719 --> 00:01:50.729 align:start position:0%
resize it so I can see all of the fields
 

00:01:50.729 --> 00:01:52.950 align:start position:0%
resize it so I can see all of the fields
what<00:01:51.729><c> we're</c><00:01:51.850><c> going</c><00:01:52.030><c> to</c><00:01:52.090><c> do</c><00:01:52.270><c> is</c><00:01:52.479><c> double-click</c>

00:01:52.950 --> 00:01:52.960 align:start position:0%
what we're going to do is double-click
 

00:01:52.960 --> 00:01:55.020 align:start position:0%
what we're going to do is double-click
each<00:01:53.320><c> field</c><00:01:53.830><c> that</c><00:01:54.040><c> we</c><00:01:54.130><c> want</c><00:01:54.340><c> to</c><00:01:54.400><c> include</c><00:01:54.820><c> in</c>

00:01:55.020 --> 00:01:55.030 align:start position:0%
each field that we want to include in
 

00:01:55.030 --> 00:01:57.840 align:start position:0%
each field that we want to include in
the<00:01:55.150><c> query</c><00:01:55.410><c> we</c><00:01:56.410><c> need</c><00:01:56.619><c> the</c><00:01:56.740><c> customers</c><00:01:57.190><c> name</c><00:01:57.520><c> and</c>

00:01:57.840 --> 00:01:57.850 align:start position:0%
the query we need the customers name and
 

00:01:57.850 --> 00:01:59.910 align:start position:0%
the query we need the customers name and
address<00:01:58.240><c> so</c><00:01:58.510><c> we'll</c><00:01:59.170><c> double</c><00:01:59.500><c> click</c><00:01:59.680><c> on</c><00:01:59.770><c> the</c>

00:01:59.910 --> 00:01:59.920 align:start position:0%
address so we'll double click on the
 

00:01:59.920 --> 00:02:05.520 align:start position:0%
address so we'll double click on the
first<00:02:00.160><c> name</c><00:02:00.630><c> last</c><00:02:01.630><c> name</c><00:02:02.400><c> street</c><00:02:03.400><c> address</c><00:02:04.530><c> city</c>

00:02:05.520 --> 00:02:05.530 align:start position:0%
first name last name street address city
 

00:02:05.530 --> 00:02:10.440 align:start position:0%
first name last name street address city
state<00:02:06.690><c> and</c><00:02:07.690><c> zip</c><00:02:08.190><c> code</c><00:02:09.190><c> and</c><00:02:09.459><c> we're</c><00:02:10.300><c> not</c>

00:02:10.440 --> 00:02:10.450 align:start position:0%
state and zip code and we're not
 

00:02:10.450 --> 00:02:12.390 align:start position:0%
state and zip code and we're not
emailing<00:02:10.899><c> or</c><00:02:11.230><c> calling</c><00:02:11.260><c> them</c><00:02:11.770><c> so</c><00:02:12.070><c> we</c><00:02:12.220><c> don't</c>

00:02:12.390 --> 00:02:12.400 align:start position:0%
emailing or calling them so we don't
 

00:02:12.400 --> 00:02:16.050 align:start position:0%
emailing or calling them so we don't
need<00:02:12.550><c> those</c><00:02:12.760><c> fields</c><00:02:13.709><c> each</c><00:02:14.709><c> field</c><00:02:15.250><c> now</c><00:02:15.520><c> appears</c>

00:02:16.050 --> 00:02:16.060 align:start position:0%
need those fields each field now appears
 

00:02:16.060 --> 00:02:18.000 align:start position:0%
need those fields each field now appears
in<00:02:16.239><c> the</c><00:02:16.330><c> area</c><00:02:16.600><c> below</c><00:02:16.900><c> which</c><00:02:17.350><c> is</c><00:02:17.530><c> called</c><00:02:17.800><c> the</c>

00:02:18.000 --> 00:02:18.010 align:start position:0%
in the area below which is called the
 

00:02:18.010 --> 00:02:21.630 align:start position:0%
in the area below which is called the
design<00:02:18.430><c> grid</c><00:02:19.200><c> below</c><00:02:20.200><c> the</c><00:02:20.380><c> field</c><00:02:20.650><c> names</c><00:02:20.950><c> is</c><00:02:21.280><c> the</c>

00:02:21.630 --> 00:02:21.640 align:start position:0%
design grid below the field names is the
 

00:02:21.640 --> 00:02:24.000 align:start position:0%
design grid below the field names is the
table<00:02:22.000><c> row</c><00:02:22.180><c> which</c><00:02:22.750><c> shows</c><00:02:23.080><c> which</c><00:02:23.380><c> table</c><00:02:23.830><c> each</c>

00:02:24.000 --> 00:02:24.010 align:start position:0%
table row which shows which table each
 

00:02:24.010 --> 00:02:25.740 align:start position:0%
table row which shows which table each
field<00:02:24.340><c> comes</c><00:02:24.610><c> from</c><00:02:24.700><c> and</c><00:02:25.090><c> this</c><00:02:25.480><c> will</c><00:02:25.630><c> become</c>

00:02:25.740 --> 00:02:25.750 align:start position:0%
field comes from and this will become
 

00:02:25.750 --> 00:02:27.090 align:start position:0%
field comes from and this will become
more<00:02:25.930><c> important</c><00:02:26.500><c> when</c><00:02:26.590><c> we</c><00:02:26.680><c> start</c><00:02:26.709><c> dealing</c>

00:02:27.090 --> 00:02:27.100 align:start position:0%
more important when we start dealing
 

00:02:27.100 --> 00:02:29.699 align:start position:0%
more important when we start dealing
with<00:02:27.250><c> multiple</c><00:02:27.580><c> tables</c><00:02:28.000><c> and</c><00:02:28.470><c> we're</c><00:02:29.470><c> going</c><00:02:29.680><c> to</c>

00:02:29.699 --> 00:02:29.709 align:start position:0%
with multiple tables and we're going to
 

00:02:29.709 --> 00:02:31.800 align:start position:0%
with multiple tables and we're going to
modify<00:02:30.010><c> some</c><00:02:30.550><c> of</c><00:02:30.580><c> these</c><00:02:30.790><c> blank</c><00:02:30.850><c> cells</c><00:02:31.510><c> to</c>

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

00:02:31.810 --> 00:02:35.160 align:start position:0%
modify some of these blank cells to
refine<00:02:32.170><c> our</c><00:02:32.200><c> query</c>

00:02:35.160 --> 00:02:35.170 align:start position:0%
 
 

00:02:35.170 --> 00:02:38.010 align:start position:0%
 
we<00:02:36.160><c> want</c><00:02:36.430><c> the</c><00:02:36.520><c> results</c><00:02:36.940><c> to</c><00:02:37.000><c> be</c><00:02:37.150><c> sorted</c><00:02:37.180><c> by</c><00:02:37.600><c> last</c>

00:02:38.010 --> 00:02:38.020 align:start position:0%
we want the results to be sorted by last
 

00:02:38.020 --> 00:02:40.559 align:start position:0%
we want the results to be sorted by last
name<00:02:38.380><c> so</c><00:02:39.069><c> in</c><00:02:39.340><c> the</c><00:02:39.459><c> sort</c><00:02:39.700><c> row</c><00:02:39.790><c> we'll</c><00:02:40.209><c> click</c><00:02:40.420><c> the</c>

00:02:40.559 --> 00:02:40.569 align:start position:0%
name so in the sort row we'll click the
 

00:02:40.569 --> 00:02:43.350 align:start position:0%
name so in the sort row we'll click the
cell<00:02:40.810><c> under</c><00:02:41.080><c> last</c><00:02:41.500><c> name</c><00:02:41.830><c> and</c><00:02:42.120><c> a</c><00:02:43.120><c> drop-down</c>

00:02:43.350 --> 00:02:43.360 align:start position:0%
cell under last name and a drop-down
 

00:02:43.360 --> 00:02:46.380 align:start position:0%
cell under last name and a drop-down
arrow<00:02:43.810><c> will</c><00:02:44.080><c> appear</c><00:02:44.470><c> you</c><00:02:44.670><c> can</c><00:02:45.670><c> click</c><00:02:46.060><c> it</c><00:02:46.180><c> and</c>

00:02:46.380 --> 00:02:46.390 align:start position:0%
arrow will appear you can click it and
 

00:02:46.390 --> 00:02:49.220 align:start position:0%
arrow will appear you can click it and
then<00:02:46.569><c> choose</c><00:02:46.840><c> how</c><00:02:46.990><c> you</c><00:02:47.050><c> want</c><00:02:47.290><c> it</c><00:02:47.350><c> to</c><00:02:47.410><c> be</c><00:02:47.560><c> sorted</c>

00:02:49.220 --> 00:02:49.230 align:start position:0%
then choose how you want it to be sorted
 

00:02:49.230 --> 00:02:51.780 align:start position:0%
then choose how you want it to be sorted
next<00:02:50.230><c> we're</c><00:02:50.440><c> going</c><00:02:50.560><c> to</c><00:02:50.709><c> use</c><00:02:50.860><c> the</c><00:02:51.040><c> criteria</c><00:02:51.580><c> row</c>

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

00:02:51.790 --> 00:02:53.820 align:start position:0%
next we're going to use the criteria row
to<00:02:51.850><c> filter</c><00:02:52.510><c> the</c><00:02:52.630><c> records</c><00:02:52.750><c> so</c><00:02:53.320><c> that</c><00:02:53.350><c> it's</c><00:02:53.620><c> only</c>

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

00:02:53.830 --> 00:02:55.880 align:start position:0%
to filter the records so that it's only
showing<00:02:54.010><c> the</c><00:02:54.340><c> customers</c><00:02:54.820><c> who</c><00:02:54.970><c> live</c><00:02:55.150><c> nearby</c>

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

00:02:55.890 --> 00:02:58.050 align:start position:0%
showing the customers who live nearby
first<00:02:56.890><c> of</c><00:02:57.010><c> all</c><00:02:57.100><c> we</c><00:02:57.310><c> want</c><00:02:57.490><c> to</c><00:02:57.610><c> send</c><00:02:57.880><c> invitations</c>

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

00:02:58.060 --> 00:03:00.630 align:start position:0%
first of all we want to send invitations
to<00:02:58.630><c> everyone</c><00:02:59.170><c> who</c><00:02:59.320><c> lives</c><00:02:59.530><c> in</c><00:02:59.650><c> Raleigh</c><00:02:59.830><c> so</c>

00:03:00.630 --> 00:03:00.640 align:start position:0%
to everyone who lives in Raleigh so
 

00:03:00.640 --> 00:03:02.580 align:start position:0%
to everyone who lives in Raleigh so
we'll<00:03:00.880><c> type</c><00:03:01.060><c> Raleigh</c><00:03:01.450><c> in</c><00:03:01.780><c> the</c><00:03:01.959><c> city</c><00:03:02.170><c> column</c>

00:03:02.580 --> 00:03:02.590 align:start position:0%
we'll type Raleigh in the city column
 

00:03:02.590 --> 00:03:04.500 align:start position:0%
we'll type Raleigh in the city column
and<00:03:02.739><c> since</c><00:03:03.520><c> we're</c><00:03:03.700><c> looking</c><00:03:03.940><c> for</c><00:03:04.090><c> an</c><00:03:04.180><c> exact</c>

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

00:03:04.510 --> 00:03:06.090 align:start position:0%
and since we're looking for an exact
match<00:03:04.780><c> it</c><00:03:05.140><c> will</c><00:03:05.290><c> need</c><00:03:05.410><c> to</c><00:03:05.500><c> be</c><00:03:05.590><c> in</c><00:03:05.709><c> quotation</c>

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

00:03:06.100 --> 00:03:09.479 align:start position:0%
match it will need to be in quotation
marks<00:03:06.280><c> so</c><00:03:07.380><c> far</c><00:03:08.380><c> this</c><00:03:08.560><c> query</c><00:03:08.830><c> will</c><00:03:08.980><c> show</c><00:03:09.190><c> all</c><00:03:09.459><c> of</c>

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

00:03:09.489 --> 00:03:11.520 align:start position:0%
marks so far this query will show all of
the<00:03:09.730><c> customers</c><00:03:10.180><c> who</c><00:03:10.209><c> live</c><00:03:10.450><c> in</c><00:03:10.570><c> Raleigh</c><00:03:10.780><c> but</c>

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

00:03:11.530 --> 00:03:13.290 align:start position:0%
the customers who live in Raleigh but
none<00:03:11.860><c> of</c><00:03:12.010><c> the</c><00:03:12.100><c> customers</c><00:03:12.280><c> in</c><00:03:12.760><c> other</c><00:03:12.970><c> cities</c>

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

00:03:13.300 --> 00:03:15.930 align:start position:0%
none of the customers in other cities
but<00:03:14.200><c> one</c><00:03:14.410><c> of</c><00:03:14.440><c> the</c><00:03:14.680><c> ZIP</c><00:03:14.890><c> codes</c><00:03:15.160><c> in</c><00:03:15.370><c> Cary</c><00:03:15.700><c> is</c>

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

00:03:15.940 --> 00:03:18.120 align:start position:0%
but one of the ZIP codes in Cary is
close<00:03:16.300><c> to</c><00:03:16.540><c> Raleigh</c><00:03:16.750><c> and</c><00:03:17.080><c> let's</c><00:03:17.709><c> say</c><00:03:17.890><c> we'd</c><00:03:18.100><c> like</c>

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

00:03:18.130 --> 00:03:20.220 align:start position:0%
close to Raleigh and let's say we'd like
to<00:03:18.310><c> send</c><00:03:18.670><c> those</c><00:03:18.880><c> customers</c><00:03:19.420><c> an</c><00:03:19.600><c> invitation</c><00:03:20.110><c> as</c>

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

00:03:20.230 --> 00:03:22.740 align:start position:0%
to send those customers an invitation as
well<00:03:20.580><c> to</c><00:03:21.580><c> do</c><00:03:21.760><c> this</c><00:03:21.790><c> we're</c><00:03:22.209><c> going</c><00:03:22.360><c> to</c><00:03:22.480><c> need</c><00:03:22.660><c> to</c>

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

00:03:22.750 --> 00:03:25.550 align:start position:0%
well to do this we're going to need to
add<00:03:22.870><c> another</c><00:03:23.230><c> criteria</c><00:03:23.920><c> under</c><00:03:24.130><c> zip</c><00:03:24.550><c> code</c>

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

00:03:25.560 --> 00:03:28.259 align:start position:0%
add another criteria under zip code
instead<00:03:26.560><c> of</c><00:03:26.620><c> using</c><00:03:26.860><c> the</c><00:03:27.100><c> criteria</c><00:03:27.610><c> row</c><00:03:27.820><c> we're</c>

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

00:03:28.269 --> 00:03:30.030 align:start position:0%
instead of using the criteria row we're
going<00:03:28.480><c> to</c><00:03:28.540><c> use</c><00:03:28.660><c> the</c><00:03:28.840><c> row</c><00:03:28.989><c> below</c><00:03:29.230><c> it</c><00:03:29.380><c> which</c><00:03:30.010><c> is</c>

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

00:03:30.040 --> 00:03:33.380 align:start position:0%
going to use the row below it which is
the<00:03:30.400><c> or</c><00:03:30.610><c> row</c>

00:03:33.380 --> 00:03:33.390 align:start position:0%
 
 

00:03:33.390 --> 00:03:35.510 align:start position:0%
 
we'll<00:03:33.600><c> type</c><00:03:33.780><c> two</c><00:03:34.140><c> seven</c><00:03:34.530><c> five</c><00:03:34.770><c> one</c><00:03:35.040><c> three</c><00:03:35.220><c> in</c>

00:03:35.510 --> 00:03:35.520 align:start position:0%
we'll type two seven five one three in
 

00:03:35.520 --> 00:03:38.300 align:start position:0%
we'll type two seven five one three in
quotation<00:03:36.120><c> marks</c><00:03:36.500><c> so</c><00:03:37.500><c> now</c><00:03:37.710><c> the</c><00:03:37.770><c> query</c><00:03:38.130><c> will</c>

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

00:03:38.310 --> 00:03:40.790 align:start position:0%
quotation marks so now the query will
show<00:03:38.520><c> customers</c><00:03:38.820><c> who</c><00:03:39.240><c> are</c><00:03:39.270><c> in</c><00:03:39.570><c> Raleigh</c><00:03:39.840><c> or</c><00:03:40.200><c> in</c>

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

00:03:40.800 --> 00:03:44.540 align:start position:0%
show customers who are in Raleigh or in
zip<00:03:41.070><c> code</c><00:03:41.280><c> 275</c><00:03:42.090><c> one</c><00:03:42.360><c> three</c><00:03:43.040><c> now</c><00:03:44.040><c> the</c><00:03:44.070><c> reason</c>

00:03:44.540 --> 00:03:44.550 align:start position:0%
zip code 275 one three now the reason
 

00:03:44.550 --> 00:03:46.190 align:start position:0%
zip code 275 one three now the reason
why<00:03:44.670><c> we</c><00:03:44.850><c> didn't</c><00:03:45.150><c> put</c><00:03:45.210><c> them</c><00:03:45.510><c> both</c><00:03:45.720><c> on</c><00:03:45.780><c> the</c><00:03:46.020><c> same</c>

00:03:46.190 --> 00:03:46.200 align:start position:0%
why we didn't put them both on the same
 

00:03:46.200 --> 00:03:48.380 align:start position:0%
why we didn't put them both on the same
line<00:03:46.560><c> is</c><00:03:46.830><c> that</c><00:03:47.400><c> the</c><00:03:47.520><c> customers</c><00:03:47.970><c> would</c><00:03:48.150><c> then</c>

00:03:48.380 --> 00:03:48.390 align:start position:0%
line is that the customers would then
 

00:03:48.390 --> 00:03:50.780 align:start position:0%
line is that the customers would then
need<00:03:48.600><c> to</c><00:03:48.660><c> meet</c><00:03:48.960><c> both</c><00:03:49.290><c> criteria</c><00:03:49.580><c> in</c><00:03:50.580><c> other</c>

00:03:50.780 --> 00:03:50.790 align:start position:0%
need to meet both criteria in other
 

00:03:50.790 --> 00:03:52.250 align:start position:0%
need to meet both criteria in other
words<00:03:51.000><c> the</c><00:03:51.180><c> customer</c><00:03:51.360><c> would</c><00:03:51.690><c> need</c><00:03:51.900><c> to</c><00:03:51.990><c> live</c><00:03:52.170><c> in</c>

00:03:52.250 --> 00:03:52.260 align:start position:0%
words the customer would need to live in
 

00:03:52.260 --> 00:03:55.180 align:start position:0%
words the customer would need to live in
Raleigh<00:03:52.470><c> and</c><00:03:52.800><c> in</c><00:03:53.250><c> zip</c><00:03:53.460><c> code</c><00:03:53.670><c> to</c><00:03:53.910><c> 751</c><00:03:54.600><c> three</c><00:03:54.960><c> in</c>

00:03:55.180 --> 00:03:55.190 align:start position:0%
Raleigh and in zip code to 751 three in
 

00:03:55.190 --> 00:03:58.370 align:start position:0%
Raleigh and in zip code to 751 three in
some<00:03:56.190><c> cases</c><00:03:56.460><c> you</c><00:03:56.700><c> may</c><00:03:56.880><c> want</c><00:03:56.910><c> that</c><00:03:57.180><c> but</c><00:03:58.020><c> in</c><00:03:58.260><c> this</c>

00:03:58.370 --> 00:03:58.380 align:start position:0%
some cases you may want that but in this
 

00:03:58.380 --> 00:04:00.020 align:start position:0%
some cases you may want that but in this
example<00:03:58.800><c> it</c><00:03:59.070><c> will</c><00:03:59.220><c> not</c><00:03:59.430><c> give</c><00:03:59.610><c> us</c><00:03:59.700><c> the</c><00:03:59.730><c> correct</c>

00:04:00.020 --> 00:04:00.030 align:start position:0%
example it will not give us the correct
 

00:04:00.030 --> 00:04:04.699 align:start position:0%
example it will not give us the correct
results<00:04:02.840><c> now</c><00:04:03.840><c> we're</c><00:04:04.080><c> finished</c><00:04:04.380><c> designing</c>

00:04:04.699 --> 00:04:04.709 align:start position:0%
results now we're finished designing
 

00:04:04.709 --> 00:04:07.490 align:start position:0%
results now we're finished designing
this<00:04:04.920><c> query</c><00:04:05.220><c> and</c><00:04:05.459><c> the</c><00:04:06.150><c> final</c><00:04:06.480><c> step</c><00:04:06.750><c> is</c><00:04:07.020><c> to</c><00:04:07.050><c> run</c>

00:04:07.490 --> 00:04:07.500 align:start position:0%
this query and the final step is to run
 

00:04:07.500 --> 00:04:10.520 align:start position:0%
this query and the final step is to run
it<00:04:08.060><c> click</c><00:04:09.060><c> the</c><00:04:09.209><c> run</c><00:04:09.420><c> command</c><00:04:09.780><c> on</c><00:04:10.050><c> the</c><00:04:10.260><c> design</c>

00:04:10.520 --> 00:04:10.530 align:start position:0%
it click the run command on the design
 

00:04:10.530 --> 00:04:13.340 align:start position:0%
it click the run command on the design
tab<00:04:10.740><c> and</c><00:04:11.390><c> the</c><00:04:12.390><c> results</c><00:04:12.750><c> will</c><00:04:12.900><c> instantly</c>

00:04:13.340 --> 00:04:13.350 align:start position:0%
tab and the results will instantly
 

00:04:13.350 --> 00:04:15.530 align:start position:0%
tab and the results will instantly
appear<00:04:13.440><c> in</c><00:04:13.950><c> datasheet</c><00:04:14.489><c> view</c><00:04:14.520><c> which</c><00:04:15.239><c> looks</c>

00:04:15.530 --> 00:04:15.540 align:start position:0%
appear in datasheet view which looks
 

00:04:15.540 --> 00:04:19.250 align:start position:0%
appear in datasheet view which looks
exactly<00:04:15.660><c> like</c><00:04:16.019><c> a</c><00:04:16.169><c> table</c><00:04:16.700><c> if</c><00:04:18.019><c> you</c><00:04:19.019><c> scroll</c>

00:04:19.250 --> 00:04:19.260 align:start position:0%
exactly like a table if you scroll
 

00:04:19.260 --> 00:04:20.720 align:start position:0%
exactly like a table if you scroll
through<00:04:19.500><c> the</c><00:04:19.590><c> results</c><00:04:19.739><c> you</c><00:04:20.190><c> can</c><00:04:20.370><c> see</c><00:04:20.549><c> that</c>

00:04:20.720 --> 00:04:20.730 align:start position:0%
through the results you can see that
 

00:04:20.730 --> 00:04:22.970 align:start position:0%
through the results you can see that
each<00:04:20.910><c> customer</c><00:04:21.209><c> lives</c><00:04:21.690><c> either</c><00:04:21.930><c> in</c><00:04:22.200><c> Raleigh</c><00:04:22.470><c> or</c>

00:04:22.970 --> 00:04:22.980 align:start position:0%
each customer lives either in Raleigh or
 

00:04:22.980 --> 00:04:28.010 align:start position:0%
each customer lives either in Raleigh or
in<00:04:23.490><c> zip</c><00:04:23.700><c> code</c><00:04:23.940><c> 275</c><00:04:24.720><c> one</c><00:04:24.960><c> three</c><00:04:25.850><c> if</c><00:04:26.850><c> you</c><00:04:27.780><c> want</c><00:04:27.900><c> to</c>

00:04:28.010 --> 00:04:28.020 align:start position:0%
in zip code 275 one three if you want to
 

00:04:28.020 --> 00:04:29.840 align:start position:0%
in zip code 275 one three if you want to
make<00:04:28.140><c> any</c><00:04:28.320><c> changes</c><00:04:28.350><c> to</c><00:04:28.890><c> the</c><00:04:28.980><c> query</c><00:04:29.160><c> you</c><00:04:29.640><c> can</c>

00:04:29.840 --> 00:04:29.850 align:start position:0%
make any changes to the query you can
 

00:04:29.850 --> 00:04:32.900 align:start position:0%
make any changes to the query you can
click<00:04:30.060><c> the</c><00:04:30.240><c> view</c><00:04:30.270><c> drop</c><00:04:30.900><c> down</c><00:04:31.169><c> arrow</c><00:04:31.470><c> and</c><00:04:31.910><c> go</c>

00:04:32.900 --> 00:04:32.910 align:start position:0%
click the view drop down arrow and go
 

00:04:32.910 --> 00:04:36.980 align:start position:0%
click the view drop down arrow and go
back<00:04:33.090><c> to</c><00:04:33.300><c> design</c><00:04:33.419><c> view</c><00:04:33.720><c> and</c><00:04:35.600><c> just</c><00:04:36.600><c> like</c><00:04:36.750><c> any</c>

00:04:36.980 --> 00:04:36.990 align:start position:0%
back to design view and just like any
 

00:04:36.990 --> 00:04:40.520 align:start position:0%
back to design view and just like any
object<00:04:37.169><c> it's</c><00:04:37.710><c> a</c><00:04:37.890><c> good</c><00:04:38.040><c> idea</c><00:04:38.160><c> to</c><00:04:38.400><c> save</c><00:04:38.669><c> it</c><00:04:39.530><c> I'll</c>

00:04:40.520 --> 00:04:40.530 align:start position:0%
object it's a good idea to save it I'll
 

00:04:40.530 --> 00:04:48.920 align:start position:0%
object it's a good idea to save it I'll
call<00:04:40.830><c> it</c><00:04:40.979><c> nearby</c><00:04:41.400><c> customers</c><00:04:47.360><c> this</c><00:04:48.360><c> was</c><00:04:48.570><c> just</c><00:04:48.810><c> a</c>

00:04:48.920 --> 00:04:48.930 align:start position:0%
call it nearby customers this was just a
 

00:04:48.930 --> 00:04:51.260 align:start position:0%
call it nearby customers this was just a
basic<00:04:49.169><c> example</c><00:04:49.560><c> and</c><00:04:50.100><c> in</c><00:04:50.640><c> the</c><00:04:50.760><c> next</c><00:04:50.970><c> video</c>

00:04:51.260 --> 00:04:51.270 align:start position:0%
basic example and in the next video
 

00:04:51.270 --> 00:04:52.580 align:start position:0%
basic example and in the next video
we're<00:04:51.479><c> going</c><00:04:51.630><c> to</c><00:04:51.720><c> talk</c><00:04:51.900><c> about</c><00:04:52.080><c> how</c><00:04:52.320><c> to</c><00:04:52.380><c> make</c><00:04:52.560><c> a</c>

00:04:52.580 --> 00:04:52.590 align:start position:0%
we're going to talk about how to make a
 

00:04:52.590 --> 00:04:55.370 align:start position:0%
we're going to talk about how to make a
query<00:04:52.950><c> with</c><00:04:53.160><c> multiple</c><00:04:53.669><c> tables</c><00:04:53.990><c> you</c><00:04:54.990><c> may</c><00:04:55.050><c> want</c>

00:04:55.370 --> 00:04:55.380 align:start position:0%
query with multiple tables you may want
 

00:04:55.380 --> 00:04:57.080 align:start position:0%
query with multiple tables you may want
to<00:04:55.440><c> practice</c><00:04:55.710><c> this</c><00:04:56.100><c> one</c><00:04:56.160><c> a</c><00:04:56.340><c> few</c><00:04:56.550><c> times</c><00:04:56.610><c> before</c>

00:04:57.080 --> 00:04:57.090 align:start position:0%
to practice this one a few times before
 

00:04:57.090 --> 00:04:58.730 align:start position:0%
to practice this one a few times before
you<00:04:57.390><c> go</c><00:04:57.510><c> on</c><00:04:57.690><c> to</c><00:04:57.900><c> make</c><00:04:58.260><c> sure</c><00:04:58.470><c> that</c><00:04:58.620><c> you're</c>

00:04:58.730 --> 00:04:58.740 align:start position:0%
you go on to make sure that you're
 

00:04:58.740 --> 00:05:05.790 align:start position:0%
you go on to make sure that you're
comfortable<00:04:58.979><c> with</c><00:04:59.280><c> the</c><00:04:59.460><c> process</c>

00:05:05.790 --> 00:05:05.800 align:start position:0%
 
 

00:05:05.800 --> 00:05:07.860 align:start position:0%
 
you