WEBVTT
Kind: captions
Language: en

00:00:06.350 --> 00:00:09.259 align:start position:0%
 
now<00:00:07.350><c> that</c><00:00:07.560><c> our</c><00:00:07.589><c> database</c><00:00:07.980><c> is</c><00:00:08.400><c> fully</c><00:00:08.639><c> populated</c>

00:00:09.259 --> 00:00:09.269 align:start position:0%
now that our database is fully populated
 

00:00:09.269 --> 00:00:11.330 align:start position:0%
now that our database is fully populated
with<00:00:09.480><c> records</c><00:00:09.960><c> it's</c><00:00:10.440><c> time</c><00:00:10.740><c> to</c><00:00:10.920><c> talk</c><00:00:11.099><c> about</c>

00:00:11.330 --> 00:00:11.340 align:start position:0%
with records it's time to talk about
 

00:00:11.340 --> 00:00:14.169 align:start position:0%
with records it's time to talk about
ways<00:00:11.580><c> we</c><00:00:11.820><c> can</c><00:00:11.969><c> look</c><00:00:12.000><c> at</c><00:00:12.420><c> or</c><00:00:12.630><c> analyze</c><00:00:13.380><c> our</c><00:00:13.650><c> data</c>

00:00:14.169 --> 00:00:14.179 align:start position:0%
ways we can look at or analyze our data
 

00:00:14.179 --> 00:00:17.090 align:start position:0%
ways we can look at or analyze our data
sorting<00:00:15.179><c> is</c><00:00:15.299><c> one</c><00:00:15.570><c> very</c><00:00:15.900><c> basic</c><00:00:16.199><c> way</c><00:00:16.590><c> to</c><00:00:16.650><c> look</c><00:00:16.980><c> at</c>

00:00:17.090 --> 00:00:17.100 align:start position:0%
sorting is one very basic way to look at
 

00:00:17.100 --> 00:00:19.760 align:start position:0%
sorting is one very basic way to look at
the<00:00:17.190><c> data</c><00:00:17.369><c> you</c><00:00:18.029><c> sort</c><00:00:18.359><c> data</c><00:00:18.660><c> every</c><00:00:19.260><c> single</c><00:00:19.590><c> day</c>

00:00:19.760 --> 00:00:19.770 align:start position:0%
the data you sort data every single day
 

00:00:19.770 --> 00:00:22.130 align:start position:0%
the data you sort data every single day
for<00:00:20.550><c> example</c><00:00:20.640><c> a</c><00:00:21.240><c> calendar</c><00:00:21.840><c> source</c>

00:00:22.130 --> 00:00:22.140 align:start position:0%
for example a calendar source
 

00:00:22.140 --> 00:00:24.170 align:start position:0%
for example a calendar source
appointments<00:00:22.920><c> and</c><00:00:23.010><c> activities</c><00:00:23.609><c> or</c><00:00:23.880><c> tracks</c>

00:00:24.170 --> 00:00:24.180 align:start position:0%
appointments and activities or tracks
 

00:00:24.180 --> 00:00:27.320 align:start position:0%
appointments and activities or tracks
birthdays<00:00:24.779><c> by</c><00:00:25.080><c> dates</c><00:00:25.519><c> email</c><00:00:26.519><c> can</c><00:00:26.760><c> sort</c><00:00:27.060><c> by</c><00:00:27.150><c> who</c>

00:00:27.320 --> 00:00:27.330 align:start position:0%
birthdays by dates email can sort by who
 

00:00:27.330 --> 00:00:29.450 align:start position:0%
birthdays by dates email can sort by who
sent<00:00:27.869><c> the</c><00:00:27.960><c> email</c><00:00:27.990><c> the</c><00:00:28.619><c> date</c><00:00:28.830><c> it</c><00:00:28.980><c> was</c><00:00:29.099><c> received</c>

00:00:29.450 --> 00:00:29.460 align:start position:0%
sent the email the date it was received
 

00:00:29.460 --> 00:00:33.080 align:start position:0%
sent the email the date it was received
or<00:00:29.849><c> the</c><00:00:29.929><c> subject</c><00:00:30.929><c> an</c><00:00:31.170><c> Excel</c><00:00:31.980><c> spreadsheet</c><00:00:32.489><c> sort</c>

00:00:33.080 --> 00:00:33.090 align:start position:0%
or the subject an Excel spreadsheet sort
 

00:00:33.090 --> 00:00:35.810 align:start position:0%
or the subject an Excel spreadsheet sort
data<00:00:33.329><c> to</c><00:00:33.950><c> access</c><00:00:34.950><c> lets</c><00:00:35.219><c> you</c><00:00:35.340><c> sort</c><00:00:35.610><c> your</c>

00:00:35.810 --> 00:00:35.820 align:start position:0%
data to access lets you sort your
 

00:00:35.820 --> 00:00:38.420 align:start position:0%
data to access lets you sort your
records<00:00:36.210><c> based</c><00:00:36.510><c> on</c><00:00:36.719><c> any</c><00:00:37.020><c> value</c><00:00:37.290><c> or</c><00:00:37.770><c> field</c><00:00:38.100><c> from</c>

00:00:38.420 --> 00:00:38.430 align:start position:0%
records based on any value or field from
 

00:00:38.430 --> 00:00:39.889 align:start position:0%
records based on any value or field from
which<00:00:38.610><c> you'd</c><00:00:38.879><c> like</c><00:00:38.910><c> to</c><00:00:39.270><c> pull</c><00:00:39.480><c> out</c><00:00:39.719><c> specific</c>

00:00:39.889 --> 00:00:39.899 align:start position:0%
which you'd like to pull out specific
 

00:00:39.899 --> 00:00:43.850 align:start position:0%
which you'd like to pull out specific
information<00:00:41.660><c> we</c><00:00:42.660><c> enter</c><00:00:43.050><c> new</c><00:00:43.230><c> books</c><00:00:43.530><c> into</c><00:00:43.829><c> the</c>

00:00:43.850 --> 00:00:43.860 align:start position:0%
information we enter new books into the
 

00:00:43.860 --> 00:00:46.430 align:start position:0%
information we enter new books into the
database<00:00:44.340><c> as</c><00:00:44.579><c> we</c><00:00:45.000><c> get</c><00:00:45.239><c> them</c><00:00:45.480><c> into</c><00:00:45.690><c> our</c><00:00:45.989><c> store</c>

00:00:46.430 --> 00:00:46.440 align:start position:0%
database as we get them into our store
 

00:00:46.440 --> 00:00:48.619 align:start position:0%
database as we get them into our store
which<00:00:47.039><c> means</c><00:00:47.399><c> they</c><00:00:47.610><c> are</c><00:00:47.700><c> not</c><00:00:47.910><c> in</c><00:00:48.059><c> any</c><00:00:48.239><c> kind</c><00:00:48.570><c> of</c>

00:00:48.619 --> 00:00:48.629 align:start position:0%
which means they are not in any kind of
 

00:00:48.629 --> 00:00:49.040 align:start position:0%
which means they are not in any kind of
order

00:00:49.040 --> 00:00:49.050 align:start position:0%
order
 

00:00:49.050 --> 00:00:50.959 align:start position:0%
order
they<00:00:49.530><c> aren't</c><00:00:49.739><c> stored</c><00:00:50.129><c> alphabetically</c><00:00:50.820><c> by</c>

00:00:50.959 --> 00:00:50.969 align:start position:0%
they aren't stored alphabetically by
 

00:00:50.969 --> 00:00:53.420 align:start position:0%
they aren't stored alphabetically by
title<00:00:51.000><c> or</c><00:00:51.660><c> author</c><00:00:51.690><c> and</c><00:00:52.440><c> they</c><00:00:52.800><c> aren't</c><00:00:53.129><c> groups</c>

00:00:53.420 --> 00:00:53.430 align:start position:0%
title or author and they aren't groups
 

00:00:53.430 --> 00:00:55.729 align:start position:0%
title or author and they aren't groups
according<00:00:53.879><c> to</c><00:00:54.090><c> their</c><00:00:54.270><c> category</c><00:00:54.840><c> so</c><00:00:55.500><c> how</c><00:00:55.680><c> do</c>

00:00:55.729 --> 00:00:55.739 align:start position:0%
according to their category so how do
 

00:00:55.739 --> 00:00:57.590 align:start position:0%
according to their category so how do
you<00:00:55.890><c> make</c><00:00:56.129><c> them</c><00:00:56.340><c> appear</c><00:00:56.699><c> in</c><00:00:56.879><c> some</c><00:00:57.180><c> sort</c><00:00:57.480><c> of</c>

00:00:57.590 --> 00:00:57.600 align:start position:0%
you make them appear in some sort of
 

00:00:57.600 --> 00:01:00.139 align:start position:0%
you make them appear in some sort of
useful<00:00:57.780><c> order</c><00:00:58.320><c> let's</c><00:00:59.129><c> say</c><00:00:59.399><c> we</c><00:00:59.579><c> want</c><00:00:59.820><c> to</c><00:00:59.879><c> see</c>

00:01:00.139 --> 00:01:00.149 align:start position:0%
useful order let's say we want to see
 

00:01:00.149 --> 00:01:02.479 align:start position:0%
useful order let's say we want to see
what<00:01:00.390><c> categories</c><00:01:01.020><c> of</c><00:01:01.140><c> books</c><00:01:01.350><c> we</c><00:01:01.530><c> have</c><00:01:01.800><c> we</c>

00:01:02.479 --> 00:01:02.489 align:start position:0%
what categories of books we have we
 

00:01:02.489 --> 00:01:04.310 align:start position:0%
what categories of books we have we
could<00:01:02.760><c> scroll</c><00:01:03.120><c> through</c><00:01:03.390><c> the</c><00:01:03.480><c> books</c><00:01:03.690><c> table</c><00:01:03.960><c> to</c>

00:01:04.310 --> 00:01:04.320 align:start position:0%
could scroll through the books table to
 

00:01:04.320 --> 00:01:06.500 align:start position:0%
could scroll through the books table to
see<00:01:04.439><c> each</c><00:01:04.680><c> record</c><00:01:05.220><c> and</c><00:01:05.430><c> note</c><00:01:05.640><c> the</c><00:01:05.790><c> category</c><00:01:06.330><c> of</c>

00:01:06.500 --> 00:01:06.510 align:start position:0%
see each record and note the category of
 

00:01:06.510 --> 00:01:08.840 align:start position:0%
see each record and note the category of
each<00:01:06.689><c> one</c><00:01:07.080><c> but</c><00:01:07.710><c> that</c><00:01:07.950><c> could</c><00:01:08.189><c> take</c><00:01:08.430><c> a</c><00:01:08.460><c> long</c><00:01:08.790><c> time</c>

00:01:08.840 --> 00:01:08.850 align:start position:0%
each one but that could take a long time
 

00:01:08.850 --> 00:01:11.120 align:start position:0%
each one but that could take a long time
if<00:01:09.540><c> we</c><00:01:09.689><c> had</c><00:01:09.840><c> hundreds</c><00:01:10.320><c> or</c><00:01:10.470><c> thousands</c><00:01:10.799><c> of</c><00:01:10.920><c> books</c>

00:01:11.120 --> 00:01:11.130 align:start position:0%
if we had hundreds or thousands of books
 

00:01:11.130 --> 00:01:13.940 align:start position:0%
if we had hundreds or thousands of books
in<00:01:11.250><c> our</c><00:01:11.460><c> database</c><00:01:11.939><c> so</c><00:01:12.570><c> instead</c><00:01:12.990><c> we</c><00:01:13.500><c> can</c><00:01:13.650><c> sort</c>

00:01:13.940 --> 00:01:13.950 align:start position:0%
in our database so instead we can sort
 

00:01:13.950 --> 00:01:15.920 align:start position:0%
in our database so instead we can sort
the<00:01:14.100><c> records</c><00:01:14.460><c> based</c><00:01:14.700><c> on</c><00:01:14.909><c> the</c><00:01:15.060><c> category</c><00:01:15.540><c> field</c>

00:01:15.920 --> 00:01:15.930 align:start position:0%
the records based on the category field
 

00:01:15.930 --> 00:01:18.050 align:start position:0%
the records based on the category field
so<00:01:16.619><c> that</c><00:01:16.650><c> all</c><00:01:16.950><c> the</c><00:01:17.130><c> records</c><00:01:17.490><c> for</c><00:01:17.640><c> a</c><00:01:17.670><c> particular</c>

00:01:18.050 --> 00:01:18.060 align:start position:0%
so that all the records for a particular
 

00:01:18.060 --> 00:01:20.980 align:start position:0%
so that all the records for a particular
category<00:01:18.479><c> are</c><00:01:19.080><c> grouped</c><00:01:19.470><c> together</c><00:01:19.740><c> for</c><00:01:20.100><c> us</c>

00:01:20.980 --> 00:01:20.990 align:start position:0%
category are grouped together for us
 

00:01:20.990 --> 00:01:24.200 align:start position:0%
category are grouped together for us
now<00:01:21.990><c> we</c><00:01:22.409><c> can</c><00:01:22.590><c> do</c><00:01:22.770><c> this</c><00:01:22.920><c> in</c><00:01:23.130><c> the</c><00:01:23.220><c> books</c><00:01:23.460><c> table</c><00:01:23.790><c> or</c>

00:01:24.200 --> 00:01:24.210 align:start position:0%
now we can do this in the books table or
 

00:01:24.210 --> 00:01:27.230 align:start position:0%
now we can do this in the books table or
using<00:01:24.600><c> the</c><00:01:24.689><c> books</c><00:01:24.900><c> form</c><00:01:25.400><c> first</c><00:01:26.400><c> let's</c><00:01:26.759><c> look</c><00:01:27.030><c> at</c>

00:01:27.230 --> 00:01:27.240 align:start position:0%
using the books form first let's look at
 

00:01:27.240 --> 00:01:28.940 align:start position:0%
using the books form first let's look at
sorting<00:01:27.810><c> a</c><00:01:27.930><c> text</c><00:01:28.380><c> field</c>

00:01:28.940 --> 00:01:28.950 align:start position:0%
sorting a text field
 

00:01:28.950 --> 00:01:31.219 align:start position:0%
sorting a text field
we'll<00:01:29.670><c> start</c><00:01:29.970><c> by</c><00:01:30.180><c> sorting</c><00:01:30.600><c> the</c><00:01:30.659><c> category</c>

00:01:31.219 --> 00:01:31.229 align:start position:0%
we'll start by sorting the category
 

00:01:31.229 --> 00:01:34.999 align:start position:0%
we'll start by sorting the category
fields<00:01:31.829><c> in</c><00:01:31.950><c> the</c><00:01:32.040><c> books</c><00:01:32.189><c> table</c><00:01:33.680><c> you</c><00:01:34.680><c> could</c><00:01:34.860><c> do</c>

00:01:34.999 --> 00:01:35.009 align:start position:0%
fields in the books table you could do
 

00:01:35.009 --> 00:01:36.649 align:start position:0%
fields in the books table you could do
this<00:01:35.159><c> from</c><00:01:35.340><c> the</c><00:01:35.430><c> ribbon</c><00:01:35.939><c> using</c><00:01:36.119><c> one</c><00:01:36.450><c> of</c><00:01:36.479><c> the</c>

00:01:36.649 --> 00:01:36.659 align:start position:0%
this from the ribbon using one of the
 

00:01:36.659 --> 00:01:38.600 align:start position:0%
this from the ribbon using one of the
sort<00:01:36.960><c> commands</c><00:01:37.619><c> on</c><00:01:37.770><c> the</c><00:01:37.829><c> sort</c><00:01:38.460><c> and</c><00:01:38.549><c> filter</c>

00:01:38.600 --> 00:01:38.610 align:start position:0%
sort commands on the sort and filter
 

00:01:38.610 --> 00:01:41.539 align:start position:0%
sort commands on the sort and filter
command<00:01:39.150><c> group</c><00:01:39.540><c> or</c><00:01:39.930><c> it</c><00:01:40.650><c> is</c><00:01:40.770><c> easier</c><00:01:41.159><c> to</c><00:01:41.340><c> just</c>

00:01:41.539 --> 00:01:41.549 align:start position:0%
command group or it is easier to just
 

00:01:41.549 --> 00:01:43.460 align:start position:0%
command group or it is easier to just
click<00:01:41.970><c> on</c><00:01:42.119><c> the</c><00:01:42.240><c> arrow</c><00:01:42.450><c> at</c><00:01:42.780><c> the</c><00:01:42.810><c> top</c><00:01:42.930><c> of</c><00:01:43.409><c> the</c>

00:01:43.460 --> 00:01:43.470 align:start position:0%
click on the arrow at the top of the
 

00:01:43.470 --> 00:01:46.100 align:start position:0%
click on the arrow at the top of the
category<00:01:43.950><c> column</c><00:01:44.280><c> now</c><00:01:45.210><c> this</c><00:01:45.450><c> will</c><00:01:45.659><c> bring</c><00:01:45.869><c> up</c>

00:01:46.100 --> 00:01:46.110 align:start position:0%
category column now this will bring up
 

00:01:46.110 --> 00:01:48.260 align:start position:0%
category column now this will bring up
some<00:01:46.259><c> options</c><00:01:46.860><c> the</c><00:01:47.130><c> same</c><00:01:47.399><c> options</c><00:01:47.970><c> you</c><00:01:48.090><c> have</c>

00:01:48.260 --> 00:01:48.270 align:start position:0%
some options the same options you have
 

00:01:48.270 --> 00:01:50.480 align:start position:0%
some options the same options you have
in<00:01:48.390><c> the</c><00:01:48.479><c> ribbon</c><00:01:48.930><c> the</c><00:01:49.439><c> first</c><00:01:49.770><c> two</c><00:01:50.100><c> are</c><00:01:50.340><c> your</c>

00:01:50.480 --> 00:01:50.490 align:start position:0%
in the ribbon the first two are your
 

00:01:50.490 --> 00:01:53.389 align:start position:0%
in the ribbon the first two are your
sorting<00:01:50.909><c> options</c><00:01:51.299><c> the</c><00:01:52.140><c> bottom</c><00:01:52.590><c> options</c><00:01:53.130><c> are</c>

00:01:53.389 --> 00:01:53.399 align:start position:0%
sorting options the bottom options are
 

00:01:53.399 --> 00:01:56.120 align:start position:0%
sorting options the bottom options are
filtering<00:01:54.060><c> options</c><00:01:54.509><c> we'll</c><00:01:55.290><c> cover</c><00:01:55.590><c> these</c><00:01:55.860><c> in</c>

00:01:56.120 --> 00:01:56.130 align:start position:0%
filtering options we'll cover these in
 

00:01:56.130 --> 00:01:56.959 align:start position:0%
filtering options we'll cover these in
another<00:01:56.250><c> lesson</c>

00:01:56.959 --> 00:01:56.969 align:start position:0%
another lesson
 

00:01:56.969 --> 00:01:58.969 align:start position:0%
another lesson
you<00:01:57.299><c> can</c><00:01:57.450><c> sort</c><00:01:57.780><c> this</c><00:01:57.960><c> text</c><00:01:58.469><c> column</c>

00:01:58.969 --> 00:01:58.979 align:start position:0%
you can sort this text column
 

00:01:58.979 --> 00:02:05.030 align:start position:0%
you can sort this text column
alphabetically<00:01:59.759><c> from</c><00:02:00.390><c> A</c><00:02:00.540><c> to</c><00:02:00.600><c> Z</c><00:02:02.119><c> or</c><00:02:03.200><c> from</c><00:02:04.200><c> Z</c><00:02:04.740><c> to</c>

00:02:05.030 --> 00:02:05.040 align:start position:0%
alphabetically from A to Z or from Z to
 

00:02:05.040 --> 00:02:09.080 align:start position:0%
alphabetically from A to Z or from Z to
a<00:02:06.110><c> now</c><00:02:07.110><c> when</c><00:02:07.530><c> you</c><00:02:07.649><c> want</c><00:02:07.860><c> to</c><00:02:08.039><c> clear</c><00:02:08.489><c> the</c><00:02:08.670><c> sorts</c>

00:02:09.080 --> 00:02:09.090 align:start position:0%
a now when you want to clear the sorts
 

00:02:09.090 --> 00:02:10.940 align:start position:0%
a now when you want to clear the sorts
you<00:02:09.270><c> have</c><00:02:09.509><c> to</c><00:02:09.660><c> do</c><00:02:09.840><c> that</c><00:02:10.110><c> from</c><00:02:10.319><c> the</c><00:02:10.440><c> ribbon</c><00:02:10.800><c> with</c>

00:02:10.940 --> 00:02:10.950 align:start position:0%
you have to do that from the ribbon with
 

00:02:10.950 --> 00:02:13.089 align:start position:0%
you have to do that from the ribbon with
the<00:02:11.069><c> clear</c><00:02:11.370><c> all</c><00:02:11.580><c> sorts</c><00:02:12.120><c> commands</c>

00:02:13.089 --> 00:02:13.099 align:start position:0%
the clear all sorts commands
 

00:02:13.099 --> 00:02:15.239 align:start position:0%
the clear all sorts commands
the<00:02:13.430><c> one</c><00:02:13.700><c> with</c><00:02:13.879><c> the</c><00:02:13.969><c> little</c><00:02:14.120><c> eraser</c><00:02:14.480><c> icon</c>

00:02:15.239 --> 00:02:15.249 align:start position:0%
the one with the little eraser icon
 

00:02:15.249 --> 00:02:18.099 align:start position:0%
the one with the little eraser icon
let's<00:02:16.249><c> sort</c><00:02:16.640><c> on</c><00:02:16.849><c> a</c><00:02:16.999><c> numerical</c><00:02:17.239><c> field</c><00:02:17.900><c> this</c>

00:02:18.099 --> 00:02:18.109 align:start position:0%
let's sort on a numerical field this
 

00:02:18.109 --> 00:02:20.830 align:start position:0%
let's sort on a numerical field this
time<00:02:18.319><c> let's</c><00:02:19.040><c> sort</c><00:02:19.310><c> our</c><00:02:19.430><c> books</c><00:02:19.760><c> by</c><00:02:19.939><c> price</c><00:02:20.299><c> if</c><00:02:20.629><c> we</c>

00:02:20.830 --> 00:02:20.840 align:start position:0%
time let's sort our books by price if we
 

00:02:20.840 --> 00:02:22.629 align:start position:0%
time let's sort our books by price if we
wanted<00:02:21.079><c> to</c><00:02:21.230><c> see</c><00:02:21.469><c> what</c><00:02:21.620><c> books</c><00:02:21.920><c> are</c><00:02:22.159><c> our</c><00:02:22.340><c> most</c>

00:02:22.629 --> 00:02:22.639 align:start position:0%
wanted to see what books are our most
 

00:02:22.639 --> 00:02:25.869 align:start position:0%
wanted to see what books are our most
expensive<00:02:22.999><c> for</c><00:02:23.450><c> example</c><00:02:24.430><c> select</c><00:02:25.430><c> the</c><00:02:25.670><c> drop</c>

00:02:25.869 --> 00:02:25.879 align:start position:0%
expensive for example select the drop
 

00:02:25.879 --> 00:02:27.670 align:start position:0%
expensive for example select the drop
down<00:02:25.909><c> arrow</c><00:02:26.480><c> at</c><00:02:26.749><c> the</c><00:02:26.780><c> top</c><00:02:26.870><c> of</c><00:02:27.349><c> the</c><00:02:27.409><c> price</c>

00:02:27.670 --> 00:02:27.680 align:start position:0%
down arrow at the top of the price
 

00:02:27.680 --> 00:02:30.849 align:start position:0%
down arrow at the top of the price
column<00:02:28.280><c> now</c><00:02:29.120><c> you</c><00:02:29.180><c> get</c><00:02:29.510><c> a</c><00:02:29.540><c> few</c><00:02:29.870><c> options</c><00:02:30.349><c> here</c><00:02:30.439><c> -</c>

00:02:30.849 --> 00:02:30.859 align:start position:0%
column now you get a few options here -
 

00:02:30.859 --> 00:02:32.530 align:start position:0%
column now you get a few options here -
just<00:02:31.250><c> like</c><00:02:31.459><c> you</c><00:02:31.609><c> did</c><00:02:31.849><c> when</c><00:02:31.939><c> we</c><00:02:32.000><c> sort</c><00:02:32.359><c> it</c><00:02:32.420><c> on</c>

00:02:32.530 --> 00:02:32.540 align:start position:0%
just like you did when we sort it on
 

00:02:32.540 --> 00:02:34.629 align:start position:0%
just like you did when we sort it on
category<00:02:33.109><c> but</c><00:02:33.680><c> notice</c><00:02:34.159><c> that</c><00:02:34.250><c> the</c><00:02:34.370><c> sort</c>

00:02:34.629 --> 00:02:34.639 align:start position:0%
category but notice that the sort
 

00:02:34.639 --> 00:02:37.270 align:start position:0%
category but notice that the sort
options<00:02:35.150><c> are</c><00:02:35.269><c> now</c><00:02:35.450><c> numerical</c><00:02:36.200><c> that's</c><00:02:36.829><c> because</c>

00:02:37.270 --> 00:02:37.280 align:start position:0%
options are now numerical that's because
 

00:02:37.280 --> 00:02:39.429 align:start position:0%
options are now numerical that's because
this<00:02:37.670><c> field</c><00:02:37.969><c> was</c><00:02:38.180><c> set</c><00:02:38.389><c> up</c><00:02:38.420><c> with</c><00:02:38.659><c> a</c><00:02:38.689><c> data</c><00:02:39.019><c> type</c>

00:02:39.429 --> 00:02:39.439 align:start position:0%
this field was set up with a data type
 

00:02:39.439 --> 00:02:42.129 align:start position:0%
this field was set up with a data type
of<00:02:39.469><c> currency</c><00:02:40.099><c> which</c><00:02:41.000><c> is</c><00:02:41.299><c> a</c><00:02:41.329><c> numerical</c><00:02:41.719><c> value</c>

00:02:42.129 --> 00:02:42.139 align:start position:0%
of currency which is a numerical value
 

00:02:42.139 --> 00:02:45.190 align:start position:0%
of currency which is a numerical value
now<00:02:43.099><c> we</c><00:02:43.129><c> get</c><00:02:43.489><c> to</c><00:02:43.639><c> decide</c><00:02:43.969><c> what</c><00:02:44.419><c> order</c><00:02:44.719><c> we</c><00:02:44.989><c> want</c>

00:02:45.190 --> 00:02:45.200 align:start position:0%
now we get to decide what order we want
 

00:02:45.200 --> 00:02:47.559 align:start position:0%
now we get to decide what order we want
smallest<00:02:45.859><c> to</c><00:02:46.069><c> largest</c><00:02:46.099><c> or</c><00:02:46.939><c> largest</c><00:02:47.239><c> to</c>

00:02:47.559 --> 00:02:47.569 align:start position:0%
smallest to largest or largest to
 

00:02:47.569 --> 00:02:48.459 align:start position:0%
smallest to largest or largest to
smallest

00:02:48.459 --> 00:02:48.469 align:start position:0%
smallest
 

00:02:48.469 --> 00:02:51.339 align:start position:0%
smallest
let's<00:02:49.250><c> choose</c><00:02:49.549><c> largest</c><00:02:50.090><c> to</c><00:02:50.209><c> smallest</c><00:02:50.239><c> so</c><00:02:51.169><c> the</c>

00:02:51.339 --> 00:02:51.349 align:start position:0%
let's choose largest to smallest so the
 

00:02:51.349 --> 00:02:53.800 align:start position:0%
let's choose largest to smallest so the
most<00:02:51.560><c> expensive</c><00:02:52.189><c> book</c><00:02:52.370><c> appears</c><00:02:52.819><c> first</c><00:02:53.209><c> for</c>

00:02:53.800 --> 00:02:53.810 align:start position:0%
most expensive book appears first for
 

00:02:53.810 --> 00:03:01.059 align:start position:0%
most expensive book appears first for
each<00:02:53.930><c> category</c><00:02:54.290><c> grouping</c><00:02:59.590><c> now</c><00:03:00.590><c> what</c><00:03:00.859><c> if</c><00:03:00.949><c> we</c>

00:03:01.059 --> 00:03:01.069 align:start position:0%
each category grouping now what if we
 

00:03:01.069 --> 00:03:03.429 align:start position:0%
each category grouping now what if we
want<00:03:01.280><c> to</c><00:03:01.430><c> do</c><00:03:01.549><c> a</c><00:03:01.579><c> multi-level</c><00:03:02.540><c> sort</c><00:03:02.870><c> like</c><00:03:03.260><c> you</c>

00:03:03.429 --> 00:03:03.439 align:start position:0%
want to do a multi-level sort like you
 

00:03:03.439 --> 00:03:05.679 align:start position:0%
want to do a multi-level sort like you
do<00:03:03.709><c> in</c><00:03:03.859><c> Excel</c><00:03:04.280><c> well</c><00:03:04.879><c> access</c><00:03:05.269><c> into</c><00:03:05.599><c> a</c>

00:03:05.679 --> 00:03:05.689 align:start position:0%
do in Excel well access into a
 

00:03:05.689 --> 00:03:07.839 align:start position:0%
do in Excel well access into a
multi-level<00:03:06.349><c> sort</c><00:03:06.590><c> but</c><00:03:07.129><c> the</c><00:03:07.219><c> results</c><00:03:07.730><c> can</c>

00:03:07.839 --> 00:03:07.849 align:start position:0%
multi-level sort but the results can
 

00:03:07.849 --> 00:03:09.640 align:start position:0%
multi-level sort but the results can
turn<00:03:08.120><c> out</c><00:03:08.329><c> very</c><00:03:08.689><c> differently</c><00:03:09.349><c> than</c><00:03:09.439><c> you</c>

00:03:09.640 --> 00:03:09.650 align:start position:0%
turn out very differently than you
 

00:03:09.650 --> 00:03:12.039 align:start position:0%
turn out very differently than you
expect<00:03:10.159><c> so</c><00:03:10.730><c> we</c><00:03:10.849><c> recommend</c><00:03:11.180><c> that</c><00:03:11.540><c> if</c><00:03:11.689><c> you</c><00:03:11.810><c> want</c>

00:03:12.039 --> 00:03:12.049 align:start position:0%
expect so we recommend that if you want
 

00:03:12.049 --> 00:03:14.050 align:start position:0%
expect so we recommend that if you want
to<00:03:12.109><c> sort</c><00:03:12.379><c> based</c><00:03:12.620><c> on</c><00:03:12.859><c> more</c><00:03:13.159><c> than</c><00:03:13.280><c> one</c><00:03:13.459><c> fields</c>

00:03:14.050 --> 00:03:14.060 align:start position:0%
to sort based on more than one fields
 

00:03:14.060 --> 00:03:16.030 align:start position:0%
to sort based on more than one fields
that<00:03:14.389><c> you</c><00:03:14.569><c> either</c><00:03:14.780><c> do</c><00:03:15.079><c> an</c><00:03:15.199><c> advanced</c><00:03:15.769><c> filter</c>

00:03:16.030 --> 00:03:16.040 align:start position:0%
that you either do an advanced filter
 

00:03:16.040 --> 00:03:18.610 align:start position:0%
that you either do an advanced filter
which<00:03:16.760><c> we'll</c><00:03:16.969><c> cover</c><00:03:17.209><c> in</c><00:03:17.329><c> the</c><00:03:17.509><c> next</c><00:03:17.540><c> lesson</c><00:03:18.409><c> or</c>

00:03:18.610 --> 00:03:18.620 align:start position:0%
which we'll cover in the next lesson or
 

00:03:18.620 --> 00:03:21.520 align:start position:0%
which we'll cover in the next lesson or
write<00:03:19.250><c> a</c><00:03:19.280><c> query</c><00:03:19.639><c> for</c><00:03:19.970><c> that</c><00:03:20.030><c> we'll</c><00:03:20.989><c> get</c><00:03:21.199><c> to</c><00:03:21.379><c> both</c>

00:03:21.520 --> 00:03:21.530 align:start position:0%
write a query for that we'll get to both
 

00:03:21.530 --> 00:03:23.589 align:start position:0%
write a query for that we'll get to both
filtering<00:03:22.040><c> data</c><00:03:22.280><c> and</c><00:03:22.579><c> queries</c><00:03:23.180><c> and</c><00:03:23.389><c> later</c>

00:03:23.589 --> 00:03:23.599 align:start position:0%
filtering data and queries and later
 

00:03:23.599 --> 00:03:26.740 align:start position:0%
filtering data and queries and later
lessons<00:03:24.609><c> sorts</c><00:03:25.609><c> pull</c><00:03:25.849><c> some</c><00:03:26.060><c> very</c><00:03:26.299><c> basic</c>

00:03:26.740 --> 00:03:26.750 align:start position:0%
lessons sorts pull some very basic
 

00:03:26.750 --> 00:03:28.689 align:start position:0%
lessons sorts pull some very basic
information<00:03:26.810><c> out</c><00:03:27.560><c> of</c><00:03:27.590><c> your</c><00:03:27.799><c> database</c><00:03:27.949><c> for</c><00:03:28.579><c> you</c>

00:03:28.689 --> 00:03:28.699 align:start position:0%
information out of your database for you
 

00:03:28.699 --> 00:03:30.729 align:start position:0%
information out of your database for you
our<00:03:29.090><c> next</c><00:03:29.659><c> lesson</c><00:03:30.049><c> will</c><00:03:30.169><c> show</c><00:03:30.199><c> you</c><00:03:30.439><c> how</c><00:03:30.709><c> to</c>

00:03:30.729 --> 00:03:30.739 align:start position:0%
our next lesson will show you how to
 

00:03:30.739 --> 00:03:34.120 align:start position:0%
our next lesson will show you how to
filter<00:03:31.189><c> the</c><00:03:31.400><c> data</c><00:03:31.579><c> in</c><00:03:31.819><c> a</c><00:03:31.939><c> table</c>