WEBVTT
Kind: captions
Language: en

00:00:01.410 --> 00:00:11.100 align:start position:0%
 
[Music]

00:00:11.100 --> 00:00:11.110 align:start position:0%
 
 

00:00:11.110 --> 00:00:13.450 align:start position:0%
 
one<00:00:12.110><c> of</c><00:00:12.200><c> the</c><00:00:12.320><c> most</c><00:00:12.470><c> powerful</c><00:00:13.100><c> ways</c><00:00:13.250><c> of</c>

00:00:13.450 --> 00:00:13.460 align:start position:0%
one of the most powerful ways of
 

00:00:13.460 --> 00:00:15.310 align:start position:0%
one of the most powerful ways of
analyzing<00:00:13.970><c> your</c><00:00:14.060><c> data</c><00:00:14.120><c> and</c><00:00:14.480><c> access</c><00:00:14.630><c> is</c><00:00:15.020><c> by</c>

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

00:00:15.320 --> 00:00:18.040 align:start position:0%
analyzing your data and access is by
creating<00:00:15.560><c> a</c><00:00:15.950><c> query</c><00:00:16.190><c> running</c><00:00:17.180><c> a</c><00:00:17.270><c> query</c><00:00:17.600><c> is</c><00:00:17.840><c> like</c>

00:00:18.040 --> 00:00:18.050 align:start position:0%
creating a query running a query is like
 

00:00:18.050 --> 00:00:20.470 align:start position:0%
creating a query running a query is like
asking<00:00:18.470><c> your</c><00:00:18.590><c> database</c><00:00:19.010><c> a</c><00:00:19.040><c> question</c><00:00:19.640><c> a</c><00:00:19.850><c> query</c>

00:00:20.470 --> 00:00:20.480 align:start position:0%
asking your database a question a query
 

00:00:20.480 --> 00:00:22.600 align:start position:0%
asking your database a question a query
can<00:00:20.690><c> retrieve</c><00:00:21.050><c> data</c><00:00:21.260><c> from</c><00:00:21.410><c> a</c><00:00:21.830><c> single</c><00:00:22.010><c> table</c><00:00:22.460><c> or</c>

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

00:00:22.610 --> 00:00:25.300 align:start position:0%
can retrieve data from a single table or
from<00:00:23.270><c> multiple</c><00:00:23.720><c> tables</c><00:00:23.779><c> and</c><00:00:24.260><c> it</c><00:00:24.830><c> all</c><00:00:24.950><c> depends</c>

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

00:00:25.310 --> 00:00:27.909 align:start position:0%
from multiple tables and it all depends
on<00:00:25.430><c> how</c><00:00:25.640><c> complex</c><00:00:26.029><c> your</c><00:00:26.240><c> question</c><00:00:26.689><c> is</c><00:00:26.930><c> in</c><00:00:27.169><c> this</c>

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

00:00:27.919 --> 00:00:29.290 align:start position:0%
on how complex your question is in this
video<00:00:28.160><c> we're</c><00:00:28.430><c> just</c><00:00:28.460><c> going</c><00:00:28.759><c> to</c><00:00:28.820><c> focus</c><00:00:29.060><c> on</c>

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

00:00:29.300 --> 00:00:31.300 align:start position:0%
video we're just going to focus on
making<00:00:29.689><c> a</c><00:00:29.779><c> simple</c><00:00:30.050><c> query</c><00:00:30.349><c> that</c><00:00:30.680><c> uses</c><00:00:30.890><c> a</c><00:00:31.070><c> single</c>

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

00:00:31.310 --> 00:00:33.700 align:start position:0%
making a simple query that uses a single
table<00:00:31.640><c> and</c><00:00:32.000><c> this</c><00:00:32.570><c> is</c><00:00:32.689><c> sometimes</c><00:00:33.140><c> called</c><00:00:33.410><c> an</c>

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

00:00:33.710 --> 00:00:36.580 align:start position:0%
table and this is sometimes called an
advanced<00:00:34.220><c> filter</c><00:00:34.660><c> let's</c><00:00:35.660><c> suppose</c><00:00:35.990><c> our</c><00:00:36.200><c> bakery</c>

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

00:00:36.590 --> 00:00:38.680 align:start position:0%
advanced filter let's suppose our bakery
has<00:00:36.800><c> an</c><00:00:37.010><c> upcoming</c><00:00:37.160><c> event</c><00:00:37.520><c> and</c><00:00:37.880><c> I</c><00:00:38.420><c> want</c><00:00:38.570><c> to</c><00:00:38.630><c> get</c>

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

00:00:38.690 --> 00:00:40.450 align:start position:0%
has an upcoming event and I want to get
a<00:00:38.750><c> list</c><00:00:38.930><c> of</c><00:00:39.079><c> all</c><00:00:39.320><c> of</c><00:00:39.530><c> our</c><00:00:39.650><c> customers</c><00:00:39.829><c> who</c><00:00:40.280><c> live</c>

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

00:00:40.460 --> 00:00:42.640 align:start position:0%
a list of all of our customers who live
nearby<00:00:40.730><c> so</c><00:00:41.210><c> we</c><00:00:41.240><c> can</c><00:00:41.450><c> send</c><00:00:41.660><c> them</c><00:00:41.780><c> invitations</c><00:00:42.440><c> a</c>

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

00:00:42.650 --> 00:00:44.980 align:start position:0%
nearby so we can send them invitations a
query<00:00:43.580><c> is</c><00:00:43.730><c> going</c><00:00:43.940><c> to</c><00:00:44.030><c> be</c><00:00:44.120><c> able</c><00:00:44.240><c> to</c><00:00:44.360><c> go</c><00:00:44.600><c> into</c><00:00:44.900><c> the</c>

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

00:00:44.990 --> 00:00:47.350 align:start position:0%
query is going to be able to go into the
customers<00:00:45.470><c> table</c><00:00:45.680><c> and</c><00:00:45.980><c> find</c><00:00:46.610><c> the</c><00:00:46.760><c> names</c><00:00:47.030><c> and</c>

00:00:47.350 --> 00:00:47.360 align:start position:0%
customers table and find the names and
 

00:00:47.360 --> 00:00:50.140 align:start position:0%
customers table and find the names and
addresses<00:00:47.690><c> of</c><00:00:47.870><c> the</c><00:00:48.050><c> nearby</c><00:00:48.500><c> customers</c><00:00:49.150><c> to</c>

00:00:50.140 --> 00:00:50.150 align:start position:0%
addresses of the nearby customers to
 

00:00:50.150 --> 00:00:52.420 align:start position:0%
addresses of the nearby customers to
create<00:00:50.450><c> a</c><00:00:50.480><c> query</c><00:00:50.750><c> go</c><00:00:51.140><c> to</c><00:00:51.200><c> the</c><00:00:51.470><c> create</c><00:00:51.740><c> tab</c><00:00:52.100><c> and</c>

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

00:00:52.430 --> 00:00:55.950 align:start position:0%
create a query go to the create tab and
then<00:00:53.360><c> click</c><00:00:53.600><c> the</c><00:00:53.750><c> query</c><00:00:54.020><c> design</c><00:00:54.380><c> command</c><00:00:54.830><c> and</c>

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

00:00:55.960 --> 00:00:58.540 align:start position:0%
then click the query design command and
then<00:00:56.960><c> you'll</c><00:00:57.110><c> need</c><00:00:57.230><c> to</c><00:00:57.290><c> select</c><00:00:57.560><c> the</c><00:00:57.950><c> table</c><00:00:58.160><c> or</c>

00:00:58.540 --> 00:00:58.550 align:start position:0%
then you'll need to select the table or
 

00:00:58.550 --> 00:00:59.770 align:start position:0%
then you'll need to select the table or
tables<00:00:58.970><c> that</c><00:00:59.090><c> you</c><00:00:59.210><c> want</c><00:00:59.360><c> to</c><00:00:59.420><c> retrieve</c><00:00:59.660><c> the</c>

00:00:59.770 --> 00:00:59.780 align:start position:0%
tables that you want to retrieve the
 

00:00:59.780 --> 00:01:02.080 align:start position:0%
tables that you want to retrieve the
data<00:00:59.960><c> from</c><00:01:00.340><c> we're</c><00:01:01.340><c> just</c><00:01:01.550><c> using</c><00:01:01.730><c> the</c><00:01:01.940><c> customers</c>

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

00:01:02.090 --> 00:01:06.130 align:start position:0%
data from we're just using the customers
table<00:01:02.690><c> for</c><00:01:02.900><c> now</c><00:01:03.489><c> click</c><00:01:04.489><c> Add</c><00:01:04.670><c> and</c><00:01:05.000><c> then</c><00:01:05.869><c> you</c><00:01:05.960><c> can</c>

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

00:01:06.140 --> 00:01:08.280 align:start position:0%
table for now click Add and then you can
close<00:01:06.350><c> this</c><00:01:06.500><c> window</c>

00:01:08.280 --> 00:01:08.290 align:start position:0%
close this window
 

00:01:08.290 --> 00:01:10.140 align:start position:0%
close this window
when<00:01:08.830><c> working</c><00:01:09.070><c> with</c><00:01:09.220><c> queries</c><00:01:09.610><c> there</c><00:01:09.940><c> are</c><00:01:10.120><c> a</c>

00:01:10.140 --> 00:01:10.150 align:start position:0%
when working with queries there are a
 

00:01:10.150 --> 00:01:11.460 align:start position:0%
when working with queries there are a
couple<00:01:10.420><c> of</c><00:01:10.570><c> different</c><00:01:10.930><c> views</c><00:01:11.140><c> that</c><00:01:11.350><c> we're</c>

00:01:11.460 --> 00:01:11.470 align:start position:0%
couple of different views that we're
 

00:01:11.470 --> 00:01:13.800 align:start position:0%
couple of different views that we're
going<00:01:11.620><c> to</c><00:01:11.740><c> use</c><00:01:11.980><c> if</c><00:01:12.190><c> you</c><00:01:13.090><c> click</c><00:01:13.300><c> on</c><00:01:13.390><c> the</c><00:01:13.540><c> view</c>

00:01:13.800 --> 00:01:13.810 align:start position:0%
going to use if you click on the view
 

00:01:13.810 --> 00:01:15.870 align:start position:0%
going to use if you click on the view
drop<00:01:14.110><c> down</c><00:01:14.320><c> arrow</c><00:01:14.590><c> then</c><00:01:15.130><c> you</c><00:01:15.280><c> can</c><00:01:15.430><c> see</c><00:01:15.610><c> that</c><00:01:15.760><c> we</c>

00:01:15.870 --> 00:01:15.880 align:start position:0%
drop down arrow then you can see that we
 

00:01:15.880 --> 00:01:18.720 align:start position:0%
drop down arrow then you can see that we
are<00:01:15.940><c> in</c><00:01:16.030><c> design</c><00:01:16.570><c> view</c><00:01:17.100><c> when</c><00:01:18.100><c> we</c><00:01:18.130><c> finish</c><00:01:18.550><c> the</c>

00:01:18.720 --> 00:01:18.730 align:start position:0%
are in design view when we finish the
 

00:01:18.730 --> 00:01:20.010 align:start position:0%
are in design view when we finish the
query<00:01:18.880><c> we're</c><00:01:19.180><c> going</c><00:01:19.390><c> to</c><00:01:19.450><c> be</c><00:01:19.570><c> viewing</c><00:01:19.840><c> the</c>

00:01:20.010 --> 00:01:20.020 align:start position:0%
query we're going to be viewing the
 

00:01:20.020 --> 00:01:22.470 align:start position:0%
query we're going to be viewing the
results<00:01:20.410><c> in</c><00:01:20.560><c> datasheet</c><00:01:21.280><c> view</c><00:01:21.310><c> and</c><00:01:21.760><c> you</c><00:01:22.450><c> can</c>

00:01:22.470 --> 00:01:22.480 align:start position:0%
results in datasheet view and you can
 

00:01:22.480 --> 00:01:24.240 align:start position:0%
results in datasheet view and you can
use<00:01:22.750><c> this</c><00:01:22.930><c> menu</c><00:01:23.200><c> to</c><00:01:23.320><c> switch</c><00:01:23.530><c> views</c><00:01:23.950><c> whenever</c>

00:01:24.240 --> 00:01:24.250 align:start position:0%
use this menu to switch views whenever
 

00:01:24.250 --> 00:01:26.010 align:start position:0%
use this menu to switch views whenever
you<00:01:24.370><c> want</c>

00:01:26.010 --> 00:01:26.020 align:start position:0%
you want
 

00:01:26.020 --> 00:01:28.560 align:start position:0%
you want
the<00:01:26.680><c> customers</c><00:01:27.159><c> table</c><00:01:27.369><c> appears</c><00:01:27.909><c> as</c><00:01:28.119><c> a</c><00:01:28.149><c> small</c>

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

00:01:28.570 --> 00:01:30.719 align:start position:0%
the customers table appears as a small
window<00:01:28.930><c> in</c><00:01:28.960><c> the</c><00:01:29.170><c> object</c><00:01:29.460><c> relationship</c><00:01:30.460><c> pane</c>

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

00:01:30.729 --> 00:01:33.210 align:start position:0%
window in the object relationship pane
which<00:01:31.060><c> is</c><00:01:31.210><c> this</c><00:01:31.360><c> area</c><00:01:31.600><c> here</c><00:01:31.990><c> and</c><00:01:32.079><c> it</c><00:01:33.070><c> has</c><00:01:33.189><c> a</c>

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

00:01:33.220 --> 00:01:34.770 align:start position:0%
which is this area here and it has a
list<00:01:33.490><c> of</c><00:01:33.610><c> all</c><00:01:33.790><c> of</c><00:01:33.850><c> the</c><00:01:34.060><c> fields</c><00:01:34.420><c> that</c><00:01:34.509><c> are</c><00:01:34.689><c> in</c>

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

00:01:34.780 --> 00:01:37.020 align:start position:0%
list of all of the fields that are in
this<00:01:34.930><c> table</c><00:01:35.170><c> such</c><00:01:35.770><c> as</c><00:01:35.950><c> first</c><00:01:36.220><c> name</c><00:01:36.340><c> last</c><00:01:36.850><c> name</c>

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

00:01:37.030 --> 00:01:39.600 align:start position:0%
this table such as first name last name
and<00:01:37.210><c> street</c><00:01:37.930><c> address</c><00:01:38.229><c> and</c><00:01:38.470><c> I'm</c><00:01:39.369><c> going</c><00:01:39.580><c> to</c>

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

00:01:39.610 --> 00:01:42.020 align:start position:0%
and street address and I'm going to
resize<00:01:40.090><c> it</c><00:01:40.119><c> so</c><00:01:40.450><c> I</c><00:01:40.479><c> can</c><00:01:40.689><c> see</c><00:01:40.840><c> all</c><00:01:40.990><c> of</c><00:01:41.020><c> the</c><00:01:41.229><c> fields</c>

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

00:01:42.030 --> 00:01:44.249 align:start position:0%
resize it so I can see all of the fields
what<00:01:43.030><c> we're</c><00:01:43.180><c> going</c><00:01:43.360><c> to</c><00:01:43.390><c> do</c><00:01:43.570><c> is</c><00:01:43.810><c> double-click</c>

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

00:01:44.259 --> 00:01:46.320 align:start position:0%
what we're going to do is double-click
each<00:01:44.649><c> field</c><00:01:45.130><c> that</c><00:01:45.340><c> we</c><00:01:45.429><c> want</c><00:01:45.640><c> to</c><00:01:45.759><c> include</c><00:01:46.030><c> in</c>

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

00:01:46.330 --> 00:01:49.139 align:start position:0%
each field that we want to include in
the<00:01:46.450><c> query</c><00:01:46.740><c> we</c><00:01:47.740><c> need</c><00:01:47.920><c> the</c><00:01:48.039><c> customers</c><00:01:48.520><c> name</c><00:01:48.820><c> and</c>

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

00:01:49.149 --> 00:01:51.210 align:start position:0%
the query we need the customers name and
address<00:01:49.539><c> so</c><00:01:49.810><c> we'll</c><00:01:50.470><c> double</c><00:01:50.799><c> click</c><00:01:51.009><c> on</c><00:01:51.039><c> the</c>

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

00:01:51.220 --> 00:01:55.620 align:start position:0%
address so we'll double click on the
first<00:01:51.429><c> name</c><00:01:51.759><c> last</c><00:01:52.600><c> name</c><00:01:53.070><c> street</c><00:01:54.070><c> address</c><00:01:54.630><c> city</c>

00:01:55.620 --> 00:01:55.630 align:start position:0%
first name last name street address city
 

00:01:55.630 --> 00:01:59.969 align:start position:0%
first name last name street address city
state<00:01:56.399><c> and</c><00:01:57.399><c> zip</c><00:01:57.750><c> code</c><00:01:58.750><c> and</c><00:01:58.959><c> we're</c><00:01:59.830><c> not</c>

00:01:59.969 --> 00:01:59.979 align:start position:0%
state and zip code and we're not
 

00:01:59.979 --> 00:02:01.889 align:start position:0%
state and zip code and we're not
emailing<00:02:00.459><c> or</c><00:02:00.789><c> calling</c><00:02:00.819><c> them</c><00:02:01.270><c> so</c><00:02:01.600><c> we</c><00:02:01.750><c> don't</c>

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

00:02:01.899 --> 00:02:05.309 align:start position:0%
emailing or calling them so we don't
need<00:02:02.080><c> those</c><00:02:02.289><c> fields</c><00:02:02.940><c> each</c><00:02:03.940><c> field</c><00:02:04.479><c> now</c><00:02:04.780><c> appears</c>

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

00:02:05.319 --> 00:02:07.289 align:start position:0%
need those fields each field now appears
in<00:02:05.500><c> the</c><00:02:05.590><c> area</c><00:02:05.860><c> below</c><00:02:06.159><c> which</c><00:02:06.640><c> is</c><00:02:06.819><c> called</c><00:02:07.090><c> the</c>

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

00:02:07.299 --> 00:02:10.320 align:start position:0%
in the area below which is called the
design<00:02:07.450><c> grid</c><00:02:08.220><c> below</c><00:02:09.220><c> the</c><00:02:09.369><c> field</c><00:02:09.670><c> names</c><00:02:09.970><c> is</c><00:02:10.299><c> the</c>

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

00:02:10.330 --> 00:02:13.020 align:start position:0%
design grid below the field names is the
table<00:02:10.989><c> row</c><00:02:11.200><c> which</c><00:02:11.739><c> shows</c><00:02:12.069><c> which</c><00:02:12.400><c> table</c><00:02:12.850><c> each</c>

00:02:13.020 --> 00:02:13.030 align:start position:0%
table row which shows which table each
 

00:02:13.030 --> 00:02:14.759 align:start position:0%
table row which shows which table each
field<00:02:13.330><c> comes</c><00:02:13.600><c> from</c><00:02:13.900><c> and</c><00:02:14.110><c> this</c><00:02:14.500><c> will</c><00:02:14.650><c> become</c>

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

00:02:14.769 --> 00:02:16.080 align:start position:0%
field comes from and this will become
more<00:02:14.950><c> important</c><00:02:15.519><c> when</c><00:02:15.610><c> we</c><00:02:15.700><c> start</c><00:02:15.940><c> dealing</c>

00:02:16.080 --> 00:02:16.090 align:start position:0%
more important when we start dealing
 

00:02:16.090 --> 00:02:18.600 align:start position:0%
more important when we start dealing
with<00:02:16.360><c> multiple</c><00:02:16.600><c> tables</c><00:02:17.019><c> and</c><00:02:17.440><c> we're</c><00:02:18.280><c> going</c><00:02:18.489><c> to</c>

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

00:02:18.610 --> 00:02:20.610 align:start position:0%
with multiple tables and we're going to
modify<00:02:18.970><c> some</c><00:02:19.360><c> of</c><00:02:19.390><c> these</c><00:02:19.600><c> blank</c><00:02:19.660><c> cells</c><00:02:20.319><c> to</c>

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

00:02:20.620 --> 00:02:23.580 align:start position:0%
modify some of these blank cells to
refine<00:02:20.980><c> our</c><00:02:21.010><c> query</c><00:02:21.780><c> we</c><00:02:22.780><c> want</c><00:02:23.049><c> the</c><00:02:23.140><c> results</c><00:02:23.560><c> to</c>

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

00:02:23.590 --> 00:02:26.309 align:start position:0%
refine our query we want the results to
be<00:02:23.769><c> sorted</c><00:02:23.799><c> by</c><00:02:24.220><c> last</c><00:02:24.340><c> name</c><00:02:25.000><c> so</c><00:02:25.690><c> in</c><00:02:25.959><c> the</c><00:02:26.049><c> sort</c>

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

00:02:26.319 --> 00:02:28.440 align:start position:0%
be sorted by last name so in the sort
row<00:02:26.410><c> we'll</c><00:02:26.830><c> click</c><00:02:27.040><c> the</c><00:02:27.190><c> cell</c><00:02:27.430><c> under</c><00:02:27.700><c> last</c><00:02:28.120><c> name</c>

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

00:02:28.450 --> 00:02:30.870 align:start position:0%
row we'll click the cell under last name
and<00:02:28.660><c> a</c><00:02:29.620><c> drop-down</c><00:02:29.860><c> arrow</c><00:02:30.220><c> will</c><00:02:30.400><c> appear</c><00:02:30.730><c> you</c>

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

00:02:30.880 --> 00:02:33.000 align:start position:0%
and a drop-down arrow will appear you
can<00:02:31.630><c> click</c><00:02:32.019><c> it</c><00:02:32.140><c> and</c><00:02:32.320><c> then</c><00:02:32.530><c> choose</c><00:02:32.799><c> how</c><00:02:32.829><c> you</c>

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

00:02:33.010 --> 00:02:36.420 align:start position:0%
can click it and then choose how you
want<00:02:33.250><c> it</c><00:02:33.310><c> to</c><00:02:33.370><c> be</c><00:02:33.519><c> sorted</c><00:02:34.980><c> next</c><00:02:35.980><c> we're</c><00:02:36.190><c> going</c><00:02:36.340><c> to</c>

00:02:36.420 --> 00:02:36.430 align:start position:0%
want it to be sorted next we're going to
 

00:02:36.430 --> 00:02:38.400 align:start position:0%
want it to be sorted next we're going to
use<00:02:36.489><c> the</c><00:02:36.820><c> criteria</c><00:02:37.030><c> row</c><00:02:37.570><c> to</c><00:02:37.630><c> filter</c><00:02:38.260><c> the</c>

00:02:38.400 --> 00:02:38.410 align:start position:0%
use the criteria row to filter the
 

00:02:38.410 --> 00:02:40.140 align:start position:0%
use the criteria row to filter the
records<00:02:38.530><c> so</c><00:02:39.100><c> that</c><00:02:39.130><c> it's</c><00:02:39.370><c> only</c><00:02:39.609><c> showing</c><00:02:39.760><c> the</c>

00:02:40.140 --> 00:02:40.150 align:start position:0%
records so that it's only showing the
 

00:02:40.150 --> 00:02:42.690 align:start position:0%
records so that it's only showing the
customers<00:02:40.600><c> who</c><00:02:40.720><c> live</c><00:02:40.930><c> nearby</c><00:02:41.489><c> first</c><00:02:42.489><c> of</c><00:02:42.609><c> all</c>

00:02:42.690 --> 00:02:42.700 align:start position:0%
customers who live nearby first of all
 

00:02:42.700 --> 00:02:44.759 align:start position:0%
customers who live nearby first of all
we<00:02:42.910><c> want</c><00:02:43.090><c> to</c><00:02:43.209><c> send</c><00:02:43.450><c> invitations</c><00:02:43.660><c> to</c><00:02:44.230><c> everyone</c>

00:02:44.759 --> 00:02:44.769 align:start position:0%
we want to send invitations to everyone
 

00:02:44.769 --> 00:02:46.650 align:start position:0%
we want to send invitations to everyone
who<00:02:44.920><c> lives</c><00:02:45.100><c> in</c><00:02:45.220><c> Raleigh</c><00:02:45.459><c> so</c><00:02:46.239><c> we'll</c><00:02:46.480><c> type</c>

00:02:46.650 --> 00:02:46.660 align:start position:0%
who lives in Raleigh so we'll type
 

00:02:46.660 --> 00:02:49.289 align:start position:0%
who lives in Raleigh so we'll type
Raleigh<00:02:47.049><c> in</c><00:02:47.410><c> the</c><00:02:47.560><c> city</c><00:02:47.769><c> column</c><00:02:48.160><c> and</c><00:02:48.340><c> since</c>

00:02:49.289 --> 00:02:49.299 align:start position:0%
Raleigh in the city column and since
 

00:02:49.299 --> 00:02:51.060 align:start position:0%
Raleigh in the city column and since
we're<00:02:49.450><c> looking</c><00:02:49.570><c> for</c><00:02:49.870><c> an</c><00:02:49.959><c> exact</c><00:02:50.290><c> match</c><00:02:50.410><c> it</c><00:02:50.890><c> will</c>

00:02:51.060 --> 00:02:51.070 align:start position:0%
we're looking for an exact match it will
 

00:02:51.070 --> 00:02:53.819 align:start position:0%
we're looking for an exact match it will
need<00:02:51.190><c> to</c><00:02:51.250><c> be</c><00:02:51.340><c> in</c><00:02:51.489><c> quotation</c><00:02:52.030><c> marks</c><00:02:52.620><c> so</c><00:02:53.620><c> far</c>

00:02:53.819 --> 00:02:53.829 align:start position:0%
need to be in quotation marks so far
 

00:02:53.829 --> 00:02:55.199 align:start position:0%
need to be in quotation marks so far
this<00:02:54.010><c> query</c><00:02:54.310><c> will</c><00:02:54.489><c> show</c><00:02:54.670><c> all</c><00:02:54.940><c> of</c><00:02:54.970><c> the</c>

00:02:55.199 --> 00:02:55.209 align:start position:0%
this query will show all of the
 

00:02:55.209 --> 00:02:57.330 align:start position:0%
this query will show all of the
customers<00:02:55.239><c> who</c><00:02:55.780><c> live</c><00:02:55.900><c> in</c><00:02:56.019><c> Raleigh</c><00:02:56.230><c> but</c><00:02:57.040><c> none</c>

00:02:57.330 --> 00:02:57.340 align:start position:0%
customers who live in Raleigh but none
 

00:02:57.340 --> 00:02:59.880 align:start position:0%
customers who live in Raleigh but none
of<00:02:57.370><c> the</c><00:02:57.579><c> customers</c><00:02:58.030><c> in</c><00:02:58.239><c> other</c><00:02:58.420><c> cities</c><00:02:58.840><c> but</c><00:02:59.650><c> one</c>

00:02:59.880 --> 00:02:59.890 align:start position:0%
of the customers in other cities but one
 

00:02:59.890 --> 00:03:02.009 align:start position:0%
of the customers in other cities but one
of<00:02:59.920><c> the</c><00:03:00.130><c> ZIP</c><00:03:00.370><c> codes</c><00:03:00.640><c> in</c><00:03:00.850><c> Cary</c><00:03:01.150><c> is</c><00:03:01.420><c> close</c><00:03:01.780><c> to</c>

00:03:02.009 --> 00:03:02.019 align:start position:0%
of the ZIP codes in Cary is close to
 

00:03:02.019 --> 00:03:04.110 align:start position:0%
of the ZIP codes in Cary is close to
Raleigh<00:03:02.230><c> and</c><00:03:02.560><c> let's</c><00:03:03.190><c> say</c><00:03:03.370><c> we'd</c><00:03:03.579><c> like</c><00:03:03.760><c> to</c><00:03:03.910><c> send</c>

00:03:04.110 --> 00:03:04.120 align:start position:0%
Raleigh and let's say we'd like to send
 

00:03:04.120 --> 00:03:06.900 align:start position:0%
Raleigh and let's say we'd like to send
those<00:03:04.359><c> customers</c><00:03:04.900><c> an</c><00:03:05.079><c> invitation</c><00:03:05.620><c> as</c><00:03:05.739><c> well</c><00:03:05.950><c> to</c>

00:03:06.900 --> 00:03:06.910 align:start position:0%
those customers an invitation as well to
 

00:03:06.910 --> 00:03:08.190 align:start position:0%
those customers an invitation as well to
do<00:03:07.090><c> this</c><00:03:07.120><c> we're</c><00:03:07.540><c> going</c><00:03:07.690><c> to</c><00:03:07.810><c> need</c><00:03:07.959><c> to</c><00:03:08.079><c> add</c>

00:03:08.190 --> 00:03:08.200 align:start position:0%
do this we're going to need to add
 

00:03:08.200 --> 00:03:11.610 align:start position:0%
do this we're going to need to add
another<00:03:08.380><c> criteria</c><00:03:09.250><c> under</c><00:03:09.430><c> zip</c><00:03:09.880><c> code</c><00:03:10.620><c> instead</c>

00:03:11.610 --> 00:03:11.620 align:start position:0%
another criteria under zip code instead
 

00:03:11.620 --> 00:03:13.559 align:start position:0%
another criteria under zip code instead
of<00:03:11.709><c> using</c><00:03:11.859><c> the</c><00:03:12.100><c> criteria</c><00:03:12.609><c> row</c><00:03:12.819><c> we're</c><00:03:13.269><c> going</c><00:03:13.480><c> to</c>

00:03:13.559 --> 00:03:13.569 align:start position:0%
of using the criteria row we're going to
 

00:03:13.569 --> 00:03:16.220 align:start position:0%
of using the criteria row we're going to
use<00:03:13.660><c> the</c><00:03:13.870><c> row</c><00:03:14.019><c> below</c><00:03:14.230><c> it</c><00:03:14.410><c> which</c><00:03:15.010><c> is</c><00:03:15.040><c> the</c><00:03:15.400><c> or</c><00:03:15.609><c> row</c>

00:03:16.220 --> 00:03:16.230 align:start position:0%
use the row below it which is the or row
 

00:03:16.230 --> 00:03:19.170 align:start position:0%
use the row below it which is the or row
we'll<00:03:17.230><c> type</c><00:03:17.440><c> two</c><00:03:17.769><c> seven</c><00:03:18.190><c> five</c><00:03:18.400><c> one</c><00:03:18.639><c> three</c><00:03:18.850><c> in</c>

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

00:03:19.180 --> 00:03:21.960 align:start position:0%
we'll type two seven five one three in
quotation<00:03:19.780><c> marks</c><00:03:20.130><c> so</c><00:03:21.130><c> now</c><00:03:21.340><c> the</c><00:03:21.400><c> query</c><00:03:21.760><c> will</c>

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

00:03:21.970 --> 00:03:24.420 align:start position:0%
quotation marks so now the query will
show<00:03:22.180><c> customers</c><00:03:22.750><c> who</c><00:03:22.900><c> are</c><00:03:22.930><c> in</c><00:03:23.200><c> Raleigh</c><00:03:23.500><c> or</c><00:03:23.799><c> in</c>

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

00:03:24.430 --> 00:03:27.479 align:start position:0%
show customers who are in Raleigh or in
zip<00:03:24.700><c> code</c><00:03:24.970><c> two</c><00:03:25.239><c> seventy-five</c><00:03:25.600><c> one</c><00:03:25.989><c> three</c><00:03:26.489><c> now</c>

00:03:27.479 --> 00:03:27.489 align:start position:0%
zip code two seventy-five one three now
 

00:03:27.489 --> 00:03:29.129 align:start position:0%
zip code two seventy-five one three now
the<00:03:27.549><c> reason</c><00:03:28.000><c> why</c><00:03:28.120><c> we</c><00:03:28.150><c> didn't</c><00:03:28.600><c> put</c><00:03:28.780><c> them</c><00:03:28.959><c> both</c>

00:03:29.129 --> 00:03:29.139 align:start position:0%
the reason why we didn't put them both
 

00:03:29.139 --> 00:03:31.410 align:start position:0%
the reason why we didn't put them both
on<00:03:29.200><c> the</c><00:03:29.410><c> same</c><00:03:29.500><c> line</c><00:03:29.980><c> is</c><00:03:30.280><c> that</c><00:03:30.850><c> the</c><00:03:30.970><c> customers</c>

00:03:31.410 --> 00:03:31.420 align:start position:0%
on the same line is that the customers
 

00:03:31.420 --> 00:03:33.660 align:start position:0%
on the same line is that the customers
would<00:03:31.600><c> then</c><00:03:31.840><c> need</c><00:03:32.049><c> to</c><00:03:32.109><c> meet</c><00:03:32.410><c> both</c><00:03:32.739><c> criteria</c><00:03:33.069><c> in</c>

00:03:33.660 --> 00:03:33.670 align:start position:0%
would then need to meet both criteria in
 

00:03:33.670 --> 00:03:35.490 align:start position:0%
would then need to meet both criteria in
other<00:03:34.269><c> words</c><00:03:34.479><c> the</c><00:03:34.690><c> customer</c><00:03:35.079><c> would</c><00:03:35.199><c> need</c><00:03:35.380><c> to</c>

00:03:35.490 --> 00:03:35.500 align:start position:0%
other words the customer would need to
 

00:03:35.500 --> 00:03:38.099 align:start position:0%
other words the customer would need to
live<00:03:35.650><c> in</c><00:03:35.769><c> Raleigh</c><00:03:35.949><c> and</c><00:03:36.220><c> in</c><00:03:36.729><c> zip</c><00:03:36.970><c> code</c><00:03:37.180><c> to</c><00:03:37.389><c> 751</c>

00:03:38.099 --> 00:03:38.109 align:start position:0%
live in Raleigh and in zip code to 751
 

00:03:38.109 --> 00:03:39.480 align:start position:0%
live in Raleigh and in zip code to 751
three<00:03:38.440><c> and</c>

00:03:39.480 --> 00:03:39.490 align:start position:0%
three and
 

00:03:39.490 --> 00:03:41.670 align:start position:0%
three and
cases<00:03:39.880><c> you</c><00:03:40.000><c> may</c><00:03:40.150><c> want</c><00:03:40.180><c> that</c><00:03:40.480><c> but</c><00:03:41.320><c> in</c><00:03:41.530><c> this</c>

00:03:41.670 --> 00:03:41.680 align:start position:0%
cases you may want that but in this
 

00:03:41.680 --> 00:03:43.320 align:start position:0%
cases you may want that but in this
example<00:03:42.100><c> it</c><00:03:42.370><c> will</c><00:03:42.490><c> not</c><00:03:42.700><c> give</c><00:03:42.910><c> us</c><00:03:43.000><c> the</c><00:03:43.030><c> correct</c>

00:03:43.320 --> 00:03:43.330 align:start position:0%
example it will not give us the correct
 

00:03:43.330 --> 00:03:46.530 align:start position:0%
example it will not give us the correct
results<00:03:44.700><c> now</c><00:03:45.700><c> we're</c><00:03:45.910><c> finished</c><00:03:46.240><c> designing</c>

00:03:46.530 --> 00:03:46.540 align:start position:0%
results now we're finished designing
 

00:03:46.540 --> 00:03:49.290 align:start position:0%
results now we're finished designing
this<00:03:46.750><c> query</c><00:03:47.080><c> and</c><00:03:47.320><c> the</c><00:03:48.010><c> final</c><00:03:48.340><c> step</c><00:03:48.580><c> is</c><00:03:48.880><c> to</c><00:03:48.910><c> run</c>

00:03:49.290 --> 00:03:49.300 align:start position:0%
this query and the final step is to run
 

00:03:49.300 --> 00:03:51.810 align:start position:0%
this query and the final step is to run
it<00:03:49.510><c> click</c><00:03:50.350><c> the</c><00:03:50.530><c> run</c><00:03:50.740><c> command</c><00:03:51.100><c> on</c><00:03:51.370><c> the</c><00:03:51.550><c> design</c>

00:03:51.810 --> 00:03:51.820 align:start position:0%
it click the run command on the design
 

00:03:51.820 --> 00:03:55.050 align:start position:0%
it click the run command on the design
tab<00:03:52.060><c> and</c><00:03:53.100><c> the</c><00:03:54.100><c> results</c><00:03:54.430><c> will</c><00:03:54.610><c> instantly</c>

00:03:55.050 --> 00:03:55.060 align:start position:0%
tab and the results will instantly
 

00:03:55.060 --> 00:03:57.240 align:start position:0%
tab and the results will instantly
appear<00:03:55.480><c> in</c><00:03:55.660><c> datasheet</c><00:03:56.050><c> view</c><00:03:56.230><c> which</c><00:03:56.950><c> looks</c>

00:03:57.240 --> 00:03:57.250 align:start position:0%
appear in datasheet view which looks
 

00:03:57.250 --> 00:03:59.760 align:start position:0%
appear in datasheet view which looks
exactly<00:03:57.520><c> like</c><00:03:57.730><c> a</c><00:03:57.880><c> table</c><00:03:58.270><c> if</c><00:03:58.530><c> you</c><00:03:59.530><c> scroll</c>

00:03:59.760 --> 00:03:59.770 align:start position:0%
exactly like a table if you scroll
 

00:03:59.770 --> 00:04:01.230 align:start position:0%
exactly like a table if you scroll
through<00:03:59.830><c> the</c><00:04:00.100><c> results</c><00:04:00.370><c> you</c><00:04:00.700><c> can</c><00:04:00.730><c> see</c><00:04:00.880><c> that</c>

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

00:04:01.240 --> 00:04:03.240 align:start position:0%
through the results you can see that
each<00:04:01.420><c> customer</c><00:04:01.690><c> lives</c><00:04:02.170><c> either</c><00:04:02.440><c> in</c><00:04:02.710><c> Raleigh</c><00:04:02.980><c> or</c>

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

00:04:03.250 --> 00:04:06.880 align:start position:0%
each customer lives either in Raleigh or
in<00:04:03.970><c> zip</c><00:04:04.210><c> code</c><00:04:04.420><c> to</c><00:04:04.690><c> 751</c><00:04:05.470><c> 3</c>

00:04:06.880 --> 00:04:06.890 align:start position:0%
in zip code to 751 3
 

00:04:06.890 --> 00:04:08.920 align:start position:0%
in zip code to 751 3
if<00:04:06.950><c> you</c><00:04:07.730><c> want</c><00:04:07.910><c> to</c><00:04:08.000><c> make</c><00:04:08.120><c> any</c><00:04:08.300><c> changes</c><00:04:08.690><c> to</c><00:04:08.750><c> the</c>

00:04:08.920 --> 00:04:08.930 align:start position:0%
if you want to make any changes to the
 

00:04:08.930 --> 00:04:10.930 align:start position:0%
if you want to make any changes to the
query<00:04:09.200><c> you</c><00:04:09.410><c> can</c><00:04:09.650><c> click</c><00:04:10.069><c> the</c><00:04:10.250><c> view</c><00:04:10.280><c> drop</c><00:04:10.730><c> down</c>

00:04:10.930 --> 00:04:10.940 align:start position:0%
query you can click the view drop down
 

00:04:10.940 --> 00:04:15.270 align:start position:0%
query you can click the view drop down
arrow<00:04:11.180><c> and</c><00:04:11.530><c> go</c><00:04:12.530><c> back</c><00:04:12.709><c> to</c><00:04:12.920><c> design</c><00:04:13.250><c> view</c>

00:04:15.270 --> 00:04:15.280 align:start position:0%
arrow and go back to design view
 

00:04:15.280 --> 00:04:17.759 align:start position:0%
arrow and go back to design view
and<00:04:15.370><c> just</c><00:04:16.299><c> like</c><00:04:16.480><c> any</c><00:04:16.660><c> object</c><00:04:17.200><c> it's</c><00:04:17.410><c> a</c><00:04:17.590><c> good</c>

00:04:17.759 --> 00:04:17.769 align:start position:0%
and just like any object it's a good
 

00:04:17.769 --> 00:04:19.699 align:start position:0%
and just like any object it's a good
idea<00:04:17.889><c> to</c><00:04:18.040><c> save</c><00:04:18.400><c> it</c>

00:04:19.699 --> 00:04:19.709 align:start position:0%
idea to save it
 

00:04:19.709 --> 00:04:24.629 align:start position:0%
idea to save it
I'll<00:04:20.220><c> call</c><00:04:20.519><c> it</c><00:04:20.699><c> nearby</c><00:04:21.239><c> customers</c>

00:04:24.629 --> 00:04:24.639 align:start position:0%
 
 

00:04:24.639 --> 00:04:27.629 align:start position:0%
 
this<00:04:25.270><c> was</c><00:04:25.479><c> just</c><00:04:25.659><c> a</c><00:04:25.810><c> basic</c><00:04:26.050><c> example</c><00:04:26.800><c> and</c><00:04:26.979><c> in</c><00:04:27.550><c> the</c>

00:04:27.629 --> 00:04:27.639 align:start position:0%
this was just a basic example and in the
 

00:04:27.639 --> 00:04:29.219 align:start position:0%
this was just a basic example and in the
next<00:04:27.849><c> video</c><00:04:28.180><c> we're</c><00:04:28.389><c> going</c><00:04:28.509><c> to</c><00:04:28.599><c> talk</c><00:04:28.780><c> about</c><00:04:28.960><c> how</c>

00:04:29.219 --> 00:04:29.229 align:start position:0%
next video we're going to talk about how
 

00:04:29.229 --> 00:04:31.679 align:start position:0%
next video we're going to talk about how
to<00:04:29.289><c> make</c><00:04:29.469><c> a</c><00:04:29.500><c> query</c><00:04:29.800><c> with</c><00:04:30.039><c> multiple</c><00:04:30.580><c> tables</c><00:04:30.789><c> you</c>

00:04:31.679 --> 00:04:31.689 align:start position:0%
to make a query with multiple tables you
 

00:04:31.689 --> 00:04:33.240 align:start position:0%
to make a query with multiple tables you
may<00:04:31.750><c> want</c><00:04:32.080><c> to</c><00:04:32.139><c> practice</c><00:04:32.409><c> this</c><00:04:32.800><c> one</c><00:04:33.009><c> a</c><00:04:33.039><c> few</c>

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

00:04:33.250 --> 00:04:35.309 align:start position:0%
may want to practice this one a few
times<00:04:33.520><c> before</c><00:04:34.000><c> you</c><00:04:34.120><c> go</c><00:04:34.240><c> on</c><00:04:34.389><c> to</c><00:04:34.599><c> make</c><00:04:34.990><c> sure</c><00:04:35.199><c> that</c>

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

00:04:35.319 --> 00:04:39.869 align:start position:0%
times before you go on to make sure that
you're<00:04:35.469><c> comfortable</c><00:04:35.710><c> with</c><00:04:35.979><c> the</c><00:04:36.099><c> process</c><00:04:38.879><c> like</c>

00:04:39.869 --> 00:04:39.879 align:start position:0%
you're comfortable with the process like
 

00:04:39.879 --> 00:04:43.200 align:start position:0%
you're comfortable with the process like
what<00:04:40.090><c> you</c><00:04:40.240><c> just</c><00:04:40.270><c> saw</c><00:04:41.310><c> radix</c><00:04:42.310><c> add</c><00:04:42.789><c> a</c><00:04:42.849><c> comment</c>

00:04:43.200 --> 00:04:43.210 align:start position:0%
what you just saw radix add a comment
 

00:04:43.210 --> 00:04:46.529 align:start position:0%
what you just saw radix add a comment
subscribe<00:04:43.930><c> to</c><00:04:44.379><c> our</c><00:04:44.469><c> channel</c><00:04:44.969><c> the</c><00:04:45.969><c> freedom</c><00:04:46.389><c> to</c>

00:04:46.529 --> 00:04:46.539 align:start position:0%
subscribe to our channel the freedom to
 

00:04:46.539 --> 00:04:51.469 align:start position:0%
subscribe to our channel the freedom to
learn<00:04:47.340><c> what</c><00:04:48.340><c> you</c><00:04:48.550><c> want</c><00:04:49.020><c> when</c><00:04:50.020><c> you</c><00:04:50.050><c> want</c>

00:04:51.469 --> 00:04:51.479 align:start position:0%
learn what you want when you want
 

00:04:51.479 --> 00:04:56.600 align:start position:0%
learn what you want when you want
absolutely<00:04:52.479><c> free</c>

00:04:56.600 --> 00:04:56.610 align:start position:0%
 
 

00:04:56.610 --> 00:05:00.240 align:start position:0%
 
GCF<00:04:57.610><c> learn</c><00:04:58.210><c> free.org</c>