WEBVTT
Kind: captions
Language: en

00:00:04.490 --> 00:00:08.839 align:start position:0%
 
in<00:00:06.080><c> our</c><00:00:07.080><c> previous</c><00:00:07.620><c> lesson</c><00:00:08.160><c> we</c><00:00:08.189><c> focused</c><00:00:08.700><c> on</c>

00:00:08.839 --> 00:00:08.849 align:start position:0%
in our previous lesson we focused on
 

00:00:08.849 --> 00:00:10.430 align:start position:0%
in our previous lesson we focused on
designing<00:00:09.269><c> our</c><00:00:09.540><c> database</c>

00:00:10.430 --> 00:00:10.440 align:start position:0%
designing our database
 

00:00:10.440 --> 00:00:12.709 align:start position:0%
designing our database
we<00:00:10.769><c> said</c><00:00:11.040><c> that</c><00:00:11.219><c> we</c><00:00:11.340><c> wanted</c><00:00:11.670><c> a</c><00:00:11.790><c> customers</c><00:00:12.300><c> table</c>

00:00:12.709 --> 00:00:12.719 align:start position:0%
we said that we wanted a customers table
 

00:00:12.719 --> 00:00:15.169 align:start position:0%
we said that we wanted a customers table
and<00:00:12.929><c> orders</c><00:00:13.320><c> table</c><00:00:13.590><c> in</c><00:00:13.920><c> a</c><00:00:14.009><c> books</c><00:00:14.250><c> table</c><00:00:14.490><c> so</c>

00:00:15.169 --> 00:00:15.179 align:start position:0%
and orders table in a books table so
 

00:00:15.179 --> 00:00:17.269 align:start position:0%
and orders table in a books table so
let's<00:00:15.330><c> start</c><00:00:15.690><c> by</c><00:00:15.839><c> creating</c><00:00:15.900><c> our</c><00:00:16.470><c> books</c><00:00:16.830><c> table</c>

00:00:17.269 --> 00:00:17.279 align:start position:0%
let's start by creating our books table
 

00:00:17.279 --> 00:00:19.400 align:start position:0%
let's start by creating our books table
now<00:00:18.090><c> I</c><00:00:18.119><c> could</c><00:00:18.359><c> have</c><00:00:18.390><c> started</c><00:00:18.660><c> with</c><00:00:18.900><c> customers</c>

00:00:19.400 --> 00:00:19.410 align:start position:0%
now I could have started with customers
 

00:00:19.410 --> 00:00:22.010 align:start position:0%
now I could have started with customers
orders<00:00:19.800><c> or</c><00:00:20.039><c> books</c><00:00:20.340><c> but</c><00:00:20.640><c> in</c><00:00:21.029><c> this</c><00:00:21.240><c> case</c><00:00:21.600><c> I</c><00:00:21.900><c> think</c>

00:00:22.010 --> 00:00:22.020 align:start position:0%
orders or books but in this case I think
 

00:00:22.020 --> 00:00:24.109 align:start position:0%
orders or books but in this case I think
it<00:00:22.260><c> makes</c><00:00:22.410><c> sense</c><00:00:22.560><c> to</c><00:00:22.800><c> start</c><00:00:23.039><c> with</c><00:00:23.130><c> books</c><00:00:23.519><c> since</c>

00:00:24.109 --> 00:00:24.119 align:start position:0%
it makes sense to start with books since
 

00:00:24.119 --> 00:00:26.089 align:start position:0%
it makes sense to start with books since
we<00:00:24.330><c> need</c><00:00:24.480><c> to</c><00:00:24.660><c> have</c><00:00:24.810><c> our</c><00:00:24.840><c> inventory</c><00:00:25.619><c> of</c><00:00:25.769><c> books</c>

00:00:26.089 --> 00:00:26.099 align:start position:0%
we need to have our inventory of books
 

00:00:26.099 --> 00:00:28.269 align:start position:0%
we need to have our inventory of books
before<00:00:26.369><c> our</c><00:00:26.760><c> customers</c><00:00:27.269><c> can</c><00:00:27.449><c> place</c><00:00:27.660><c> an</c><00:00:27.840><c> order</c>

00:00:28.269 --> 00:00:28.279 align:start position:0%
before our customers can place an order
 

00:00:28.279 --> 00:00:31.279 align:start position:0%
before our customers can place an order
I've<00:00:29.279><c> already</c><00:00:29.730><c> opened</c><00:00:29.910><c> access</c><00:00:30.599><c> from</c><00:00:30.779><c> my</c><00:00:30.840><c> Start</c>

00:00:31.279 --> 00:00:31.289 align:start position:0%
I've already opened access from my Start
 

00:00:31.289 --> 00:00:33.620 align:start position:0%
I've already opened access from my Start
menu<00:00:31.380><c> so</c><00:00:32.130><c> now</c><00:00:32.340><c> we</c><00:00:32.399><c> need</c><00:00:32.640><c> to</c><00:00:32.700><c> decide</c><00:00:33.120><c> whether</c><00:00:33.450><c> we</c>

00:00:33.620 --> 00:00:33.630 align:start position:0%
menu so now we need to decide whether we
 

00:00:33.630 --> 00:00:35.810 align:start position:0%
menu so now we need to decide whether we
want<00:00:33.840><c> to</c><00:00:33.960><c> use</c><00:00:34.110><c> a</c><00:00:34.140><c> built-in</c><00:00:34.680><c> template</c><00:00:35.250><c> or</c><00:00:35.489><c> start</c>

00:00:35.810 --> 00:00:35.820 align:start position:0%
want to use a built-in template or start
 

00:00:35.820 --> 00:00:37.930 align:start position:0%
want to use a built-in template or start
from<00:00:35.969><c> scratch</c><00:00:36.360><c> using</c><00:00:36.809><c> a</c><00:00:36.989><c> blank</c><00:00:37.260><c> database</c>

00:00:37.930 --> 00:00:37.940 align:start position:0%
from scratch using a blank database
 

00:00:37.940 --> 00:00:41.240 align:start position:0%
from scratch using a blank database
let's<00:00:38.940><c> start</c><00:00:39.239><c> from</c><00:00:39.390><c> scratch</c><00:00:40.010><c> click</c><00:00:41.010><c> on</c><00:00:41.160><c> the</c>

00:00:41.240 --> 00:00:41.250 align:start position:0%
let's start from scratch click on the
 

00:00:41.250 --> 00:00:43.760 align:start position:0%
let's start from scratch click on the
blank<00:00:41.520><c> database</c><00:00:42.180><c> icon</c><00:00:42.510><c> to</c><00:00:43.200><c> open</c><00:00:43.590><c> a</c><00:00:43.739><c> new</c>

00:00:43.760 --> 00:00:43.770 align:start position:0%
blank database icon to open a new
 

00:00:43.770 --> 00:00:47.360 align:start position:0%
blank database icon to open a new
database<00:00:45.379><c> now</c><00:00:46.379><c> we</c><00:00:46.440><c> need</c><00:00:46.739><c> to</c><00:00:46.890><c> name</c><00:00:47.190><c> the</c>

00:00:47.360 --> 00:00:47.370 align:start position:0%
database now we need to name the
 

00:00:47.370 --> 00:00:50.600 align:start position:0%
database now we need to name the
database<00:00:47.750><c> by</c><00:00:48.750><c> default</c><00:00:49.320><c> access</c><00:00:49.680><c> assigns</c><00:00:50.340><c> a</c>

00:00:50.600 --> 00:00:50.610 align:start position:0%
database by default access assigns a
 

00:00:50.610 --> 00:00:53.450 align:start position:0%
database by default access assigns a
name<00:00:50.940><c> and</c><00:00:51.300><c> also</c><00:00:51.809><c> adds</c><00:00:52.050><c> the</c><00:00:52.320><c> file</c><00:00:52.710><c> extension</c>

00:00:53.450 --> 00:00:53.460 align:start position:0%
name and also adds the file extension
 

00:00:53.460 --> 00:00:55.549 align:start position:0%
name and also adds the file extension
even<00:00:54.329><c> if</c><00:00:54.449><c> you</c><00:00:54.600><c> delete</c><00:00:54.960><c> it</c><00:00:54.989><c> while</c><00:00:55.379><c> you're</c>

00:00:55.549 --> 00:00:55.559 align:start position:0%
even if you delete it while you're
 

00:00:55.559 --> 00:00:59.150 align:start position:0%
even if you delete it while you're
entering<00:00:55.860><c> your</c><00:00:55.920><c> name</c><00:00:57.050><c> just</c><00:00:58.050><c> delete</c><00:00:58.440><c> this</c><00:00:58.739><c> to</c>

00:00:59.150 --> 00:00:59.160 align:start position:0%
entering your name just delete this to
 

00:00:59.160 --> 00:01:02.810 align:start position:0%
entering your name just delete this to
name<00:00:59.340><c> your</c><00:00:59.489><c> database</c><00:00:59.940><c> in</c><00:01:01.190><c> this</c><00:01:02.190><c> case</c><00:01:02.520><c> I'll</c>

00:01:02.810 --> 00:01:02.820 align:start position:0%
name your database in this case I'll
 

00:01:02.820 --> 00:01:06.010 align:start position:0%
name your database in this case I'll
name<00:01:03.239><c> it</c><00:01:03.420><c> ready</c><00:01:03.809><c> to</c><00:01:04.080><c> read</c><00:01:04.379><c> and</c><00:01:04.680><c> click</c><00:01:04.949><c> create</c>

00:01:06.010 --> 00:01:06.020 align:start position:0%
name it ready to read and click create
 

00:01:06.020 --> 00:01:09.140 align:start position:0%
name it ready to read and click create
the<00:01:07.020><c> database</c><00:01:07.380><c> opens</c><00:01:07.920><c> in</c><00:01:08.070><c> datasheet</c><00:01:08.580><c> view</c><00:01:08.610><c> and</c>

00:01:09.140 --> 00:01:09.150 align:start position:0%
the database opens in datasheet view and
 

00:01:09.150 --> 00:01:10.910 align:start position:0%
the database opens in datasheet view and
you'll<00:01:09.299><c> see</c><00:01:09.510><c> table</c><00:01:09.900><c> 1</c><00:01:10.170><c> listed</c><00:01:10.799><c> in</c><00:01:10.860><c> the</c>

00:01:10.910 --> 00:01:10.920 align:start position:0%
you'll see table 1 listed in the
 

00:01:10.920 --> 00:01:13.969 align:start position:0%
you'll see table 1 listed in the
navigation<00:01:11.340><c> pane</c><00:01:11.700><c> and</c><00:01:12.090><c> on</c><00:01:12.960><c> the</c><00:01:13.170><c> table</c><00:01:13.530><c> tab</c><00:01:13.740><c> to</c>

00:01:13.969 --> 00:01:13.979 align:start position:0%
navigation pane and on the table tab to
 

00:01:13.979 --> 00:01:16.910 align:start position:0%
navigation pane and on the table tab to
the<00:01:14.070><c> right</c><00:01:14.659><c> table</c><00:01:15.659><c> 1</c><00:01:15.930><c> is</c><00:01:16.170><c> the</c><00:01:16.290><c> default</c><00:01:16.710><c> name</c>

00:01:16.910 --> 00:01:16.920 align:start position:0%
the right table 1 is the default name
 

00:01:16.920 --> 00:01:21.050 align:start position:0%
the right table 1 is the default name
access<00:01:17.460><c> assigned</c><00:01:17.790><c> to</c><00:01:17.970><c> your</c><00:01:18.060><c> first</c><00:01:18.360><c> table</c><00:01:20.060><c> to</c>

00:01:21.050 --> 00:01:21.060 align:start position:0%
access assigned to your first table to
 

00:01:21.060 --> 00:01:23.749 align:start position:0%
access assigned to your first table to
give<00:01:21.270><c> the</c><00:01:21.420><c> table</c><00:01:21.659><c> a</c><00:01:21.930><c> unique</c><00:01:22.380><c> name</c><00:01:22.890><c> click</c><00:01:23.610><c> the</c>

00:01:23.749 --> 00:01:23.759 align:start position:0%
give the table a unique name click the
 

00:01:23.759 --> 00:01:25.910 align:start position:0%
give the table a unique name click the
Microsoft<00:01:24.119><c> Office</c><00:01:24.450><c> button</c><00:01:24.689><c> and</c><00:01:25.200><c> select</c><00:01:25.560><c> save</c>

00:01:25.910 --> 00:01:25.920 align:start position:0%
Microsoft Office button and select save
 

00:01:25.920 --> 00:01:29.630 align:start position:0%
Microsoft Office button and select save
from<00:01:26.310><c> the</c><00:01:26.460><c> menu</c><00:01:27.140><c> it's</c><00:01:28.140><c> I</c><00:01:28.350><c> log</c><00:01:28.619><c> box</c><00:01:28.920><c> will</c><00:01:29.189><c> open</c>

00:01:29.630 --> 00:01:29.640 align:start position:0%
from the menu it's I log box will open
 

00:01:29.640 --> 00:01:33.319 align:start position:0%
from the menu it's I log box will open
asking<00:01:29.820><c> you</c><00:01:30.360><c> to</c><00:01:30.570><c> name</c><00:01:30.840><c> your</c><00:01:31.140><c> table</c><00:01:31.880><c> I'll</c><00:01:32.880><c> name</c>

00:01:33.319 --> 00:01:33.329 align:start position:0%
asking you to name your table I'll name
 

00:01:33.329 --> 00:01:37.399 align:start position:0%
asking you to name your table I'll name
it<00:01:33.360><c> books</c><00:01:34.020><c> and</c><00:01:34.380><c> then</c><00:01:35.100><c> click</c><00:01:35.340><c> OK</c><00:01:35.900><c> the</c><00:01:36.900><c> new</c><00:01:37.140><c> name</c>

00:01:37.399 --> 00:01:37.409 align:start position:0%
it books and then click OK the new name
 

00:01:37.409 --> 00:01:39.740 align:start position:0%
it books and then click OK the new name
changes<00:01:37.950><c> in</c><00:01:38.070><c> the</c><00:01:38.130><c> navigation</c><00:01:38.700><c> pane</c><00:01:38.909><c> and</c><00:01:39.270><c> on</c>

00:01:39.740 --> 00:01:39.750 align:start position:0%
changes in the navigation pane and on
 

00:01:39.750 --> 00:01:42.410 align:start position:0%
changes in the navigation pane and on
the<00:01:39.900><c> table</c><00:01:40.200><c> tab</c><00:01:40.470><c> it</c><00:01:41.400><c> looks</c><00:01:41.670><c> like</c><00:01:41.820><c> I</c><00:01:41.939><c> misspelled</c>

00:01:42.410 --> 00:01:42.420 align:start position:0%
the table tab it looks like I misspelled
 

00:01:42.420 --> 00:01:45.679 align:start position:0%
the table tab it looks like I misspelled
books<00:01:42.890><c> to</c><00:01:43.890><c> rename</c><00:01:44.369><c> a</c><00:01:44.430><c> table</c><00:01:44.880><c> go</c><00:01:45.420><c> to</c><00:01:45.479><c> the</c>

00:01:45.679 --> 00:01:45.689 align:start position:0%
books to rename a table go to the
 

00:01:45.689 --> 00:01:48.469 align:start position:0%
books to rename a table go to the
navigation<00:01:45.899><c> pane</c><00:01:46.619><c> right</c><00:01:47.490><c> click</c><00:01:47.909><c> on</c><00:01:48.090><c> the</c><00:01:48.210><c> table</c>

00:01:48.469 --> 00:01:48.479 align:start position:0%
navigation pane right click on the table
 

00:01:48.479 --> 00:01:51.980 align:start position:0%
navigation pane right click on the table
and<00:01:48.899><c> select</c><00:01:49.320><c> rename</c><00:01:49.680><c> if</c><00:01:50.329><c> your</c><00:01:51.329><c> table</c><00:01:51.600><c> to</c><00:01:51.899><c> the</c>

00:01:51.980 --> 00:01:51.990 align:start position:0%
and select rename if your table to the
 

00:01:51.990 --> 00:01:53.899 align:start position:0%
and select rename if your table to the
right<00:01:52.020><c> is</c><00:01:52.500><c> open</c><00:01:52.979><c> you'll</c><00:01:53.250><c> receive</c><00:01:53.549><c> a</c><00:01:53.579><c> message</c>

00:01:53.899 --> 00:01:53.909 align:start position:0%
right is open you'll receive a message
 

00:01:53.909 --> 00:01:55.789 align:start position:0%
right is open you'll receive a message
telling<00:01:54.450><c> you</c><00:01:54.570><c> to</c><00:01:54.720><c> close</c><00:01:55.020><c> it</c><00:01:55.200><c> before</c><00:01:55.530><c> you</c><00:01:55.649><c> can</c>

00:01:55.789 --> 00:01:55.799 align:start position:0%
telling you to close it before you can
 

00:01:55.799 --> 00:01:59.929 align:start position:0%
telling you to close it before you can
rename<00:01:56.329><c> just</c><00:01:57.329><c> click</c><00:01:57.540><c> OK</c><00:01:58.189><c> to</c><00:01:59.189><c> close</c><00:01:59.460><c> a</c><00:01:59.490><c> data</c>

00:01:59.929 --> 00:01:59.939 align:start position:0%
rename just click OK to close a data
 

00:01:59.939 --> 00:02:03.020 align:start position:0%
rename just click OK to close a data
table<00:02:00.240><c> to</c><00:02:00.960><c> the</c><00:02:01.079><c> right</c><00:02:01.350><c> right</c><00:02:02.280><c> click</c><00:02:02.700><c> on</c><00:02:02.909><c> the</c>

00:02:03.020 --> 00:02:03.030 align:start position:0%
table to the right right click on the
 

00:02:03.030 --> 00:02:07.490 align:start position:0%
table to the right right click on the
table<00:02:03.240><c> tab</c><00:02:03.689><c> and</c><00:02:04.079><c> select</c><00:02:04.590><c> close</c><00:02:06.500><c> now</c>

00:02:07.490 --> 00:02:07.500 align:start position:0%
table tab and select close now
 

00:02:07.500 --> 00:02:09.529 align:start position:0%
table tab and select close now
right-click<00:02:08.250><c> on</c><00:02:08.640><c> the</c><00:02:08.819><c> table</c><00:02:09.360><c> in</c><00:02:09.479><c> the</c>

00:02:09.529 --> 00:02:09.539 align:start position:0%
right-click on the table in the
 

00:02:09.539 --> 00:02:13.370 align:start position:0%
right-click on the table in the
navigation<00:02:10.140><c> pane</c><00:02:10.319><c> and</c><00:02:10.649><c> select</c><00:02:11.129><c> rename</c>

00:02:13.370 --> 00:02:13.380 align:start position:0%
navigation pane and select rename
 

00:02:13.380 --> 00:02:14.990 align:start position:0%
navigation pane and select rename
sir<00:02:13.560><c> appears</c><00:02:14.010><c> which</c><00:02:14.250><c> means</c><00:02:14.550><c> we</c><00:02:14.670><c> can</c><00:02:14.790><c> start</c>

00:02:14.990 --> 00:02:15.000 align:start position:0%
sir appears which means we can start
 

00:02:15.000 --> 00:02:18.110 align:start position:0%
sir appears which means we can start
typing<00:02:15.680><c> left</c><00:02:16.680><c> click</c><00:02:16.980><c> anywhere</c><00:02:17.190><c> outside</c><00:02:17.670><c> of</c>

00:02:18.110 --> 00:02:18.120 align:start position:0%
typing left click anywhere outside of
 

00:02:18.120 --> 00:02:21.620 align:start position:0%
typing left click anywhere outside of
the<00:02:18.300><c> field</c><00:02:18.540><c> to</c><00:02:18.720><c> make</c><00:02:18.870><c> the</c><00:02:19.020><c> change</c><00:02:20.630><c> next</c>

00:02:21.620 --> 00:02:21.630 align:start position:0%
the field to make the change next
 

00:02:21.630 --> 00:02:25.280 align:start position:0%
the field to make the change next
double-click<00:02:22.080><c> on</c><00:02:22.530><c> the</c><00:02:22.710><c> table</c><00:02:23.160><c> to</c><00:02:23.310><c> reopen</c><00:02:24.290><c> by</c>

00:02:25.280 --> 00:02:25.290 align:start position:0%
double-click on the table to reopen by
 

00:02:25.290 --> 00:02:28.010 align:start position:0%
double-click on the table to reopen by
default<00:02:25.860><c> XO</c><00:02:26.550><c> starting</c><00:02:26.940><c> us</c><00:02:27.090><c> out</c><00:02:27.270><c> with</c><00:02:27.720><c> one</c>

00:02:28.010 --> 00:02:28.020 align:start position:0%
default XO starting us out with one
 

00:02:28.020 --> 00:02:31.220 align:start position:0%
default XO starting us out with one
table<00:02:28.620><c> to</c><00:02:28.860><c> create</c><00:02:29.430><c> additional</c><00:02:30.270><c> tables</c><00:02:30.720><c> click</c>

00:02:31.220 --> 00:02:31.230 align:start position:0%
table to create additional tables click
 

00:02:31.230 --> 00:02:35.840 align:start position:0%
table to create additional tables click
on<00:02:31.410><c> the</c><00:02:31.530><c> create</c><00:02:31.710><c> tab</c><00:02:32.370><c> and</c><00:02:33.260><c> then</c><00:02:34.260><c> table</c><00:02:34.920><c> in</c><00:02:35.130><c> the</c>

00:02:35.840 --> 00:02:35.850 align:start position:0%
on the create tab and then table in the
 

00:02:35.850 --> 00:02:40.460 align:start position:0%
on the create tab and then table in the
tables<00:02:36.270><c> group</c><00:02:36.570><c> a</c><00:02:37.460><c> new</c><00:02:38.460><c> table</c><00:02:38.700><c> tab</c><00:02:39.060><c> appears</c><00:02:39.660><c> now</c>

00:02:40.460 --> 00:02:40.470 align:start position:0%
tables group a new table tab appears now
 

00:02:40.470 --> 00:02:42.740 align:start position:0%
tables group a new table tab appears now
from<00:02:40.680><c> the</c><00:02:40.770><c> Microsoft</c><00:02:41.250><c> Office</c><00:02:41.730><c> button</c><00:02:41.760><c> select</c>

00:02:42.740 --> 00:02:42.750 align:start position:0%
from the Microsoft Office button select
 

00:02:42.750 --> 00:02:46.160 align:start position:0%
from the Microsoft Office button select
save<00:02:43.110><c> to</c><00:02:43.620><c> name</c><00:02:43.830><c> your</c><00:02:43.980><c> table</c><00:02:44.750><c> we'll</c><00:02:45.750><c> name</c><00:02:45.990><c> this</c>

00:02:46.160 --> 00:02:46.170 align:start position:0%
save to name your table we'll name this
 

00:02:46.170 --> 00:02:50.720 align:start position:0%
save to name your table we'll name this
one<00:02:46.350><c> customers</c><00:02:48.470><c> we</c><00:02:49.470><c> have</c><00:02:49.650><c> one</c><00:02:50.040><c> more</c><00:02:50.220><c> table</c><00:02:50.610><c> to</c>

00:02:50.720 --> 00:02:50.730 align:start position:0%
one customers we have one more table to
 

00:02:50.730 --> 00:02:52.400 align:start position:0%
one customers we have one more table to
add<00:02:50.910><c> and</c><00:02:51.330><c> that's</c><00:02:51.540><c> going</c><00:02:51.720><c> to</c><00:02:51.810><c> be</c><00:02:51.900><c> the</c><00:02:52.020><c> orders</c>

00:02:52.400 --> 00:02:52.410 align:start position:0%
add and that's going to be the orders
 

00:02:52.410 --> 00:02:58.220 align:start position:0%
add and that's going to be the orders
table<00:02:55.580><c> you</c><00:02:56.580><c> can</c><00:02:56.730><c> always</c><00:02:57.000><c> tell</c><00:02:57.420><c> which</c><00:02:57.690><c> table</c>

00:02:58.220 --> 00:02:58.230 align:start position:0%
table you can always tell which table
 

00:02:58.230 --> 00:03:00.140 align:start position:0%
table you can always tell which table
you're<00:02:58.380><c> in</c><00:02:58.650><c> by</c><00:02:58.920><c> seeing</c><00:02:59.310><c> which</c><00:02:59.580><c> tab</c><00:02:59.880><c> is</c>

00:03:00.140 --> 00:03:00.150 align:start position:0%
you're in by seeing which tab is
 

00:03:00.150 --> 00:03:03.140 align:start position:0%
you're in by seeing which tab is
highlighted<00:03:00.800><c> so</c><00:03:01.800><c> currently</c><00:03:02.310><c> we're</c><00:03:02.700><c> in</c><00:03:02.730><c> the</c>

00:03:03.140 --> 00:03:03.150 align:start position:0%
highlighted so currently we're in the
 

00:03:03.150 --> 00:03:07.820 align:start position:0%
highlighted so currently we're in the
orders<00:03:03.660><c> table</c><00:03:05.270><c> I'm</c><00:03:06.270><c> going</c><00:03:07.020><c> to</c><00:03:07.170><c> go</c><00:03:07.260><c> back</c><00:03:07.560><c> to</c><00:03:07.590><c> the</c>

00:03:07.820 --> 00:03:07.830 align:start position:0%
orders table I'm going to go back to the
 

00:03:07.830 --> 00:03:11.590 align:start position:0%
orders table I'm going to go back to the
books<00:03:08.100><c> table</c><00:03:08.400><c> by</c><00:03:08.610><c> clicking</c><00:03:08.730><c> on</c><00:03:09.390><c> the</c><00:03:09.600><c> books</c><00:03:09.870><c> tab</c>

00:03:11.590 --> 00:03:11.600 align:start position:0%
books table by clicking on the books tab
 

00:03:11.600 --> 00:03:14.960 align:start position:0%
books table by clicking on the books tab
now<00:03:12.600><c> let's</c><00:03:13.080><c> start</c><00:03:13.350><c> adding</c><00:03:13.500><c> some</c><00:03:13.800><c> fields</c><00:03:14.430><c> by</c>

00:03:14.960 --> 00:03:14.970 align:start position:0%
now let's start adding some fields by
 

00:03:14.970 --> 00:03:17.090 align:start position:0%
now let's start adding some fields by
default<00:03:15.510><c> access</c><00:03:15.750><c> starts</c><00:03:16.290><c> us</c><00:03:16.380><c> off</c><00:03:16.530><c> with</c><00:03:16.740><c> an</c><00:03:16.890><c> ID</c>

00:03:17.090 --> 00:03:17.100 align:start position:0%
default access starts us off with an ID
 

00:03:17.100 --> 00:03:20.060 align:start position:0%
default access starts us off with an ID
field<00:03:17.580><c> the</c><00:03:18.420><c> ID</c><00:03:18.600><c> field</c><00:03:19.080><c> is</c><00:03:19.320><c> already</c><00:03:19.710><c> set</c><00:03:20.040><c> to</c>

00:03:20.060 --> 00:03:20.070 align:start position:0%
field the ID field is already set to
 

00:03:20.070 --> 00:03:22.550 align:start position:0%
field the ID field is already set to
auto<00:03:20.430><c> number</c><00:03:20.940><c> which</c><00:03:21.540><c> will</c><00:03:21.810><c> give</c><00:03:21.960><c> each</c><00:03:22.200><c> record</c>

00:03:22.550 --> 00:03:22.560 align:start position:0%
auto number which will give each record
 

00:03:22.560 --> 00:03:26.720 align:start position:0%
auto number which will give each record
a<00:03:22.950><c> unique</c><00:03:23.490><c> number</c><00:03:24.350><c> remember</c><00:03:25.350><c> each</c><00:03:25.740><c> record</c><00:03:26.280><c> is</c>

00:03:26.720 --> 00:03:26.730 align:start position:0%
a unique number remember each record is
 

00:03:26.730 --> 00:03:31.490 align:start position:0%
a unique number remember each record is
one<00:03:27.180><c> row</c><00:03:27.480><c> of</c><00:03:27.720><c> information</c><00:03:29.750><c> each</c><00:03:30.750><c> table</c><00:03:31.230><c> you</c>

00:03:31.490 --> 00:03:31.500 align:start position:0%
one row of information each table you
 

00:03:31.500 --> 00:03:33.290 align:start position:0%
one row of information each table you
creates<00:03:31.890><c> and</c><00:03:32.100><c> access</c><00:03:32.550><c> will</c><00:03:32.700><c> have</c><00:03:32.880><c> this</c><00:03:33.090><c> ID</c>

00:03:33.290 --> 00:03:33.300 align:start position:0%
creates and access will have this ID
 

00:03:33.300 --> 00:03:35.720 align:start position:0%
creates and access will have this ID
field<00:03:33.810><c> so</c><00:03:34.350><c> it's</c><00:03:34.500><c> a</c><00:03:34.560><c> good</c><00:03:34.740><c> idea</c><00:03:34.800><c> to</c><00:03:35.310><c> give</c><00:03:35.460><c> this</c>

00:03:35.720 --> 00:03:35.730 align:start position:0%
field so it's a good idea to give this
 

00:03:35.730 --> 00:03:38.900 align:start position:0%
field so it's a good idea to give this
field<00:03:36.120><c> a</c><00:03:36.450><c> unique</c><00:03:36.930><c> name</c><00:03:37.380><c> in</c><00:03:37.800><c> each</c><00:03:38.310><c> table</c>

00:03:38.900 --> 00:03:38.910 align:start position:0%
field a unique name in each table
 

00:03:38.910 --> 00:03:40.850 align:start position:0%
field a unique name in each table
because<00:03:39.570><c> it</c><00:03:39.690><c> will</c><00:03:39.810><c> be</c><00:03:39.900><c> much</c><00:03:40.170><c> easier</c><00:03:40.380><c> to</c>

00:03:40.850 --> 00:03:40.860 align:start position:0%
because it will be much easier to
 

00:03:40.860 --> 00:03:45.140 align:start position:0%
because it will be much easier to
understand<00:03:41.370><c> later</c><00:03:42.590><c> we'll</c><00:03:43.590><c> name</c><00:03:43.860><c> this</c><00:03:44.250><c> book</c><00:03:44.850><c> ID</c>

00:03:45.140 --> 00:03:45.150 align:start position:0%
understand later we'll name this book ID
 

00:03:45.150 --> 00:03:48.260 align:start position:0%
understand later we'll name this book ID
by<00:03:45.750><c> clicking</c><00:03:46.260><c> on</c><00:03:46.410><c> the</c><00:03:46.560><c> ID</c><00:03:46.740><c> header</c><00:03:47.280><c> and</c><00:03:47.580><c> then</c>

00:03:48.260 --> 00:03:48.270 align:start position:0%
by clicking on the ID header and then
 

00:03:48.270 --> 00:03:50.990 align:start position:0%
by clicking on the ID header and then
click<00:03:48.750><c> on</c><00:03:48.900><c> rename</c><00:03:49.650><c> in</c><00:03:50.010><c> the</c><00:03:50.100><c> fields</c><00:03:50.520><c> &amp;</c><00:03:50.670><c> columns</c>

00:03:50.990 --> 00:03:51.000 align:start position:0%
click on rename in the fields &amp; columns
 

00:03:51.000 --> 00:03:55.190 align:start position:0%
click on rename in the fields &amp; columns
group<00:03:51.270><c> on</c><00:03:51.600><c> the</c><00:03:51.720><c> ribbon</c><00:03:53.210><c> let's</c><00:03:54.210><c> add</c><00:03:54.540><c> our</c><00:03:54.840><c> other</c>

00:03:55.190 --> 00:03:55.200 align:start position:0%
group on the ribbon let's add our other
 

00:03:55.200 --> 00:03:58.850 align:start position:0%
group on the ribbon let's add our other
fields<00:03:56.060><c> to</c><00:03:57.060><c> do</c><00:03:57.240><c> this</c><00:03:57.450><c> double</c><00:03:57.990><c> click</c><00:03:58.290><c> on</c><00:03:58.470><c> add</c>

00:03:58.850 --> 00:03:58.860 align:start position:0%
fields to do this double click on add
 

00:03:58.860 --> 00:04:03.230 align:start position:0%
fields to do this double click on add
new<00:03:59.520><c> field</c><00:04:00.710><c> the</c><00:04:01.710><c> text</c><00:04:02.160><c> will</c><00:04:02.310><c> disappear</c><00:04:02.910><c> so</c><00:04:03.180><c> you</c>

00:04:03.230 --> 00:04:03.240 align:start position:0%
new field the text will disappear so you
 

00:04:03.240 --> 00:04:04.910 align:start position:0%
new field the text will disappear so you
can<00:04:03.450><c> enter</c><00:04:03.660><c> your</c><00:04:03.960><c> fields</c><00:04:04.410><c> name</c>

00:04:04.910 --> 00:04:04.920 align:start position:0%
can enter your fields name
 

00:04:04.920 --> 00:04:08.960 align:start position:0%
can enter your fields name
we'll<00:04:05.310><c> start</c><00:04:05.580><c> with</c><00:04:05.850><c> title</c><00:04:07.550><c> once</c><00:04:08.550><c> you've</c><00:04:08.760><c> added</c>

00:04:08.960 --> 00:04:08.970 align:start position:0%
we'll start with title once you've added
 

00:04:08.970 --> 00:04:11.930 align:start position:0%
we'll start with title once you've added
this<00:04:09.300><c> new</c><00:04:09.570><c> fields</c><00:04:10.320><c> you</c><00:04:10.710><c> can</c><00:04:10.740><c> press</c><00:04:11.130><c> a</c><00:04:11.160><c> tab</c><00:04:11.550><c> key</c>

00:04:11.930 --> 00:04:11.940 align:start position:0%
this new fields you can press a tab key
 

00:04:11.940 --> 00:04:14.620 align:start position:0%
this new fields you can press a tab key
on<00:04:11.970><c> your</c><00:04:12.240><c> keyboard</c><00:04:12.510><c> to</c><00:04:13.140><c> add</c><00:04:13.650><c> other</c><00:04:14.040><c> fields</c>

00:04:14.620 --> 00:04:14.630 align:start position:0%
on your keyboard to add other fields
 

00:04:14.630 --> 00:04:17.180 align:start position:0%
on your keyboard to add other fields
repeat<00:04:15.630><c> these</c><00:04:15.810><c> steps</c><00:04:15.990><c> until</c><00:04:16.350><c> all</c><00:04:16.739><c> of</c><00:04:16.799><c> your</c>

00:04:17.180 --> 00:04:17.190 align:start position:0%
repeat these steps until all of your
 

00:04:17.190 --> 00:04:20.870 align:start position:0%
repeat these steps until all of your
field<00:04:17.520><c> headers</c><00:04:17.970><c> have</c><00:04:18.150><c> been</c><00:04:18.330><c> entered</c><00:04:19.700><c> so</c><00:04:20.700><c> I'm</c>

00:04:20.870 --> 00:04:20.880 align:start position:0%
field headers have been entered so I'm
 

00:04:20.880 --> 00:04:24.050 align:start position:0%
field headers have been entered so I'm
going<00:04:21.120><c> to</c><00:04:21.180><c> quickly</c><00:04:21.510><c> add</c><00:04:22.080><c> all</c><00:04:22.710><c> of</c><00:04:22.740><c> my</c><00:04:23.060><c> field</c>

00:04:24.050 --> 00:04:24.060 align:start position:0%
going to quickly add all of my field
 

00:04:24.060 --> 00:04:26.950 align:start position:0%
going to quickly add all of my field
headers<00:04:24.510><c> here</c>

00:04:26.950 --> 00:04:26.960 align:start position:0%
 
 

00:04:26.960 --> 00:04:31.040 align:start position:0%
 
in<00:04:28.610><c> access</c><00:04:29.610><c> we</c><00:04:29.760><c> can</c><00:04:29.790><c> work</c><00:04:30.120><c> in</c><00:04:30.330><c> datasheet</c><00:04:30.810><c> view</c>

00:04:31.040 --> 00:04:31.050 align:start position:0%
in access we can work in datasheet view
 

00:04:31.050 --> 00:04:34.360 align:start position:0%
in access we can work in datasheet view
which<00:04:31.710><c> is</c><00:04:31.860><c> our</c><00:04:32.010><c> current</c><00:04:32.580><c> view</c><00:04:32.790><c> or</c><00:04:33.090><c> design</c><00:04:33.810><c> view</c>

00:04:34.360 --> 00:04:34.370 align:start position:0%
which is our current view or design view
 

00:04:34.370 --> 00:04:36.830 align:start position:0%
which is our current view or design view
datasheet<00:04:35.370><c> view</c><00:04:35.400><c> is</c><00:04:35.970><c> kind</c><00:04:36.180><c> of</c><00:04:36.360><c> like</c><00:04:36.510><c> working</c>

00:04:36.830 --> 00:04:36.840 align:start position:0%
datasheet view is kind of like working
 

00:04:36.840 --> 00:04:39.800 align:start position:0%
datasheet view is kind of like working
with<00:04:36.990><c> cells</c><00:04:37.410><c> in</c><00:04:37.800><c> Excel</c><00:04:37.970><c> where</c><00:04:38.970><c> a</c><00:04:39.000><c> design</c><00:04:39.360><c> view</c>

00:04:39.800 --> 00:04:39.810 align:start position:0%
with cells in Excel where a design view
 

00:04:39.810 --> 00:04:41.900 align:start position:0%
with cells in Excel where a design view
gives<00:04:40.230><c> you</c><00:04:40.380><c> more</c><00:04:40.590><c> control</c><00:04:40.950><c> over</c><00:04:41.100><c> the</c>

00:04:41.900 --> 00:04:41.910 align:start position:0%
gives you more control over the
 

00:04:41.910 --> 00:04:45.230 align:start position:0%
gives you more control over the
information<00:04:42.750><c> you</c><00:04:42.900><c> enter</c><00:04:43.470><c> in</c><00:04:43.650><c> two</c><00:04:43.980><c> cells</c><00:04:44.430><c> which</c>

00:04:45.230 --> 00:04:45.240 align:start position:0%
information you enter in two cells which
 

00:04:45.240 --> 00:04:49.250 align:start position:0%
information you enter in two cells which
in<00:04:45.480><c> this</c><00:04:45.720><c> case</c><00:04:46.080><c> are</c><00:04:46.470><c> actually</c><00:04:46.920><c> fields</c><00:04:48.260><c> let's</c>

00:04:49.250 --> 00:04:49.260 align:start position:0%
in this case are actually fields let's
 

00:04:49.260 --> 00:04:52.040 align:start position:0%
in this case are actually fields let's
take<00:04:49.500><c> a</c><00:04:49.530><c> look</c><00:04:49.860><c> at</c><00:04:50.010><c> the</c><00:04:50.100><c> design</c><00:04:50.280><c> view</c><00:04:50.850><c> the</c><00:04:51.600><c> views</c>

00:04:52.040 --> 00:04:52.050 align:start position:0%
take a look at the design view the views
 

00:04:52.050 --> 00:04:54.410 align:start position:0%
take a look at the design view the views
option<00:04:52.530><c> appears</c><00:04:52.920><c> under</c><00:04:53.250><c> the</c><00:04:53.370><c> Home</c><00:04:53.640><c> tab</c><00:04:53.670><c> and</c>

00:04:54.410 --> 00:04:54.420 align:start position:0%
option appears under the Home tab and
 

00:04:54.420 --> 00:04:56.840 align:start position:0%
option appears under the Home tab and
the<00:04:54.660><c> datasheet</c><00:04:54.960><c> tab</c><00:04:55.440><c> which</c><00:04:56.100><c> is</c><00:04:56.220><c> a</c><00:04:56.250><c> tab</c><00:04:56.580><c> that</c><00:04:56.790><c> is</c>

00:04:56.840 --> 00:04:56.850 align:start position:0%
the datasheet tab which is a tab that is
 

00:04:56.850 --> 00:04:59.990 align:start position:0%
the datasheet tab which is a tab that is
currently<00:04:57.300><c> open</c><00:04:58.040><c> click</c><00:04:59.040><c> the</c><00:04:59.190><c> drop</c><00:04:59.460><c> down</c><00:04:59.490><c> arrow</c>

00:04:59.990 --> 00:05:00.000 align:start position:0%
currently open click the drop down arrow
 

00:05:00.000 --> 00:05:03.020 align:start position:0%
currently open click the drop down arrow
under<00:05:00.720><c> the</c><00:05:00.840><c> views</c><00:05:01.230><c> option</c><00:05:01.860><c> and</c><00:05:02.040><c> select</c><00:05:02.430><c> design</c>

00:05:03.020 --> 00:05:03.030 align:start position:0%
under the views option and select design
 

00:05:03.030 --> 00:05:05.660 align:start position:0%
under the views option and select design
view<00:05:03.540><c> the</c><00:05:04.530><c> benefit</c><00:05:04.980><c> of</c><00:05:05.010><c> setting</c><00:05:05.400><c> up</c><00:05:05.520><c> our</c>

00:05:05.660 --> 00:05:05.670 align:start position:0%
view the benefit of setting up our
 

00:05:05.670 --> 00:05:08.090 align:start position:0%
view the benefit of setting up our
fields<00:05:06.240><c> here</c><00:05:06.720><c> is</c><00:05:06.870><c> that</c><00:05:07.200><c> we</c><00:05:07.350><c> can</c><00:05:07.500><c> tell</c><00:05:07.680><c> access</c>

00:05:08.090 --> 00:05:08.100 align:start position:0%
fields here is that we can tell access
 

00:05:08.100 --> 00:05:09.950 align:start position:0%
fields here is that we can tell access
to<00:05:08.190><c> allow</c><00:05:08.460><c> only</c><00:05:08.670><c> certain</c><00:05:09.180><c> types</c><00:05:09.390><c> of</c><00:05:09.600><c> data</c><00:05:09.840><c> to</c>

00:05:09.950 --> 00:05:09.960 align:start position:0%
to allow only certain types of data to
 

00:05:09.960 --> 00:05:12.680 align:start position:0%
to allow only certain types of data to
be<00:05:10.200><c> entered</c><00:05:10.560><c> into</c><00:05:10.590><c> a</c><00:05:10.770><c> field</c><00:05:11.160><c> for</c><00:05:11.940><c> example</c><00:05:12.060><c> I</c>

00:05:12.680 --> 00:05:12.690 align:start position:0%
be entered into a field for example I
 

00:05:12.690 --> 00:05:16.220 align:start position:0%
be entered into a field for example I
need<00:05:13.680><c> to</c><00:05:13.800><c> add</c><00:05:13.980><c> a</c><00:05:14.010><c> price</c><00:05:14.550><c> field</c><00:05:14.970><c> I</c><00:05:15.390><c> can</c><00:05:15.930><c> do</c><00:05:16.050><c> that</c>

00:05:16.220 --> 00:05:16.230 align:start position:0%
need to add a price field I can do that
 

00:05:16.230 --> 00:05:22.130 align:start position:0%
need to add a price field I can do that
here<00:05:16.560><c> under</c><00:05:16.590><c> field</c><00:05:17.190><c> name</c><00:05:19.880><c> if</c><00:05:20.880><c> I</c><00:05:21.360><c> press</c><00:05:21.630><c> tab</c><00:05:21.930><c> on</c>

00:05:22.130 --> 00:05:22.140 align:start position:0%
here under field name if I press tab on
 

00:05:22.140 --> 00:05:24.170 align:start position:0%
here under field name if I press tab on
my<00:05:22.170><c> keyboard</c><00:05:22.260><c> I'm</c><00:05:23.040><c> now</c><00:05:23.280><c> in</c><00:05:23.490><c> the</c><00:05:23.610><c> data</c><00:05:23.850><c> type</c>

00:05:24.170 --> 00:05:24.180 align:start position:0%
my keyboard I'm now in the data type
 

00:05:24.180 --> 00:05:28.070 align:start position:0%
my keyboard I'm now in the data type
field<00:05:24.660><c> this</c><00:05:25.650><c> field</c><00:05:26.190><c> is</c><00:05:26.580><c> used</c><00:05:27.000><c> to</c><00:05:27.270><c> define</c><00:05:27.750><c> the</c>

00:05:28.070 --> 00:05:28.080 align:start position:0%
field this field is used to define the
 

00:05:28.080 --> 00:05:31.430 align:start position:0%
field this field is used to define the
type<00:05:28.320><c> of</c><00:05:28.380><c> data</c><00:05:28.860><c> that</c><00:05:29.070><c> can</c><00:05:29.220><c> be</c><00:05:29.280><c> entered</c><00:05:30.440><c> we'll</c>

00:05:31.430 --> 00:05:31.440 align:start position:0%
type of data that can be entered we'll
 

00:05:31.440 --> 00:05:33.470 align:start position:0%
type of data that can be entered we'll
talk<00:05:31.650><c> about</c><00:05:31.800><c> data</c><00:05:32.130><c> integrity</c><00:05:32.520><c> and</c><00:05:32.820><c> validation</c>

00:05:33.470 --> 00:05:33.480 align:start position:0%
talk about data integrity and validation
 

00:05:33.480 --> 00:05:36.560 align:start position:0%
talk about data integrity and validation
later<00:05:33.720><c> by</c><00:05:34.560><c> default</c><00:05:35.100><c> the</c><00:05:35.280><c> data</c><00:05:35.490><c> type</c><00:05:35.790><c> is</c><00:05:36.000><c> text</c>

00:05:36.560 --> 00:05:36.570 align:start position:0%
later by default the data type is text
 

00:05:36.570 --> 00:05:39.740 align:start position:0%
later by default the data type is text
if<00:05:36.750><c> I</c><00:05:37.440><c> click</c><00:05:37.770><c> the</c><00:05:37.920><c> drop</c><00:05:38.190><c> down</c><00:05:38.220><c> arrow</c><00:05:38.790><c> I</c><00:05:39.240><c> can</c><00:05:39.570><c> see</c>

00:05:39.740 --> 00:05:39.750 align:start position:0%
if I click the drop down arrow I can see
 

00:05:39.750 --> 00:05:40.940 align:start position:0%
if I click the drop down arrow I can see
additional<00:05:40.140><c> options</c>

00:05:40.940 --> 00:05:40.950 align:start position:0%
additional options
 

00:05:40.950 --> 00:05:43.910 align:start position:0%
additional options
since<00:05:41.670><c> price</c><00:05:42.030><c> deals</c><00:05:42.480><c> with</c><00:05:42.690><c> money</c><00:05:42.990><c> I'll</c><00:05:43.500><c> change</c>

00:05:43.910 --> 00:05:43.920 align:start position:0%
since price deals with money I'll change
 

00:05:43.920 --> 00:05:48.560 align:start position:0%
since price deals with money I'll change
my<00:05:44.010><c> data</c><00:05:44.310><c> types</c><00:05:44.700><c> of</c><00:05:44.910><c> currency</c><00:05:47.030><c> you</c><00:05:48.030><c> won't</c><00:05:48.300><c> see</c>

00:05:48.560 --> 00:05:48.570 align:start position:0%
my data types of currency you won't see
 

00:05:48.570 --> 00:05:50.780 align:start position:0%
my data types of currency you won't see
any<00:05:48.840><c> immediate</c><00:05:49.350><c> changes</c><00:05:49.590><c> by</c><00:05:50.190><c> changing</c><00:05:50.670><c> the</c>

00:05:50.780 --> 00:05:50.790 align:start position:0%
any immediate changes by changing the
 

00:05:50.790 --> 00:05:52.910 align:start position:0%
any immediate changes by changing the
data<00:05:50.940><c> type</c><00:05:51.330><c> but</c><00:05:51.810><c> you'll</c><00:05:52.020><c> notice</c><00:05:52.260><c> it</c><00:05:52.560><c> later</c>

00:05:52.910 --> 00:05:52.920 align:start position:0%
data type but you'll notice it later
 

00:05:52.920 --> 00:05:56.030 align:start position:0%
data type but you'll notice it later
when<00:05:53.250><c> we</c><00:05:53.340><c> start</c><00:05:53.610><c> entering</c><00:05:54.000><c> data</c><00:05:55.040><c> the</c>

00:05:56.030 --> 00:05:56.040 align:start position:0%
when we start entering data the
 

00:05:56.040 --> 00:05:57.740 align:start position:0%
when we start entering data the
information<00:05:56.670><c> here</c><00:05:56.970><c> at</c><00:05:57.060><c> the</c><00:05:57.180><c> bottom</c><00:05:57.570><c> will</c><00:05:57.720><c> be</c>

00:05:57.740 --> 00:05:57.750 align:start position:0%
information here at the bottom will be
 

00:05:57.750 --> 00:05:59.330 align:start position:0%
information here at the bottom will be
discussed<00:05:58.230><c> later</c><00:05:58.320><c> so</c><00:05:58.830><c> there's</c><00:05:58.980><c> no</c><00:05:59.130><c> need</c><00:05:59.310><c> to</c>

00:05:59.330 --> 00:05:59.340 align:start position:0%
discussed later so there's no need to
 

00:05:59.340 --> 00:06:00.470 align:start position:0%
discussed later so there's no need to
worry<00:05:59.580><c> about</c><00:05:59.730><c> it</c><00:06:00.030><c> right</c><00:06:00.060><c> now</c>

00:06:00.470 --> 00:06:00.480 align:start position:0%
worry about it right now
 

00:06:00.480 --> 00:06:03.140 align:start position:0%
worry about it right now
I'm<00:06:01.470><c> going</c><00:06:01.830><c> to</c><00:06:01.920><c> switch</c><00:06:02.130><c> back</c><00:06:02.160><c> to</c><00:06:02.490><c> datasheet</c>

00:06:03.140 --> 00:06:03.150 align:start position:0%
I'm going to switch back to datasheet
 

00:06:03.150 --> 00:06:05.030 align:start position:0%
I'm going to switch back to datasheet
view<00:06:03.180><c> to</c><00:06:03.600><c> finish</c><00:06:03.930><c> setting</c><00:06:04.200><c> up</c><00:06:04.380><c> the</c><00:06:04.530><c> fields</c><00:06:04.920><c> and</c>

00:06:05.030 --> 00:06:05.040 align:start position:0%
view to finish setting up the fields and
 

00:06:05.040 --> 00:06:08.750 align:start position:0%
view to finish setting up the fields and
my<00:06:05.130><c> tables</c><00:06:06.320><c> whoops</c><00:06:07.320><c> looks</c><00:06:07.950><c> like</c><00:06:08.160><c> I</c><00:06:08.310><c> have</c><00:06:08.550><c> to</c>

00:06:08.750 --> 00:06:08.760 align:start position:0%
my tables whoops looks like I have to
 

00:06:08.760 --> 00:06:12.890 align:start position:0%
my tables whoops looks like I have to
save<00:06:09.060><c> my</c><00:06:09.270><c> table</c><00:06:09.660><c> before</c><00:06:09.780><c> I</c><00:06:10.020><c> move</c><00:06:10.290><c> on</c><00:06:11.840><c> now</c><00:06:12.840><c> we</c>

00:06:12.890 --> 00:06:12.900 align:start position:0%
save my table before I move on now we
 

00:06:12.900 --> 00:06:15.610 align:start position:0%
save my table before I move on now we
can<00:06:13.170><c> switch</c><00:06:13.380><c> back</c><00:06:13.500><c> to</c><00:06:13.800><c> the</c><00:06:14.040><c> datasheet</c><00:06:14.310><c> view</c>

00:06:15.610 --> 00:06:15.620 align:start position:0%
can switch back to the datasheet view
 

00:06:15.620 --> 00:06:18.200 align:start position:0%
can switch back to the datasheet view
now<00:06:16.620><c> let's</c><00:06:16.860><c> add</c><00:06:17.040><c> fields</c><00:06:17.490><c> to</c><00:06:17.580><c> the</c><00:06:17.610><c> customers</c>

00:06:18.200 --> 00:06:18.210 align:start position:0%
now let's add fields to the customers
 

00:06:18.210 --> 00:06:20.510 align:start position:0%
now let's add fields to the customers
table<00:06:18.630><c> now</c><00:06:19.110><c> as</c><00:06:19.230><c> I</c><00:06:19.380><c> said</c><00:06:19.440><c> before</c><00:06:19.620><c> the</c><00:06:20.220><c> first</c>

00:06:20.510 --> 00:06:20.520 align:start position:0%
table now as I said before the first
 

00:06:20.520 --> 00:06:24.020 align:start position:0%
table now as I said before the first
field<00:06:20.970><c> is</c><00:06:21.180><c> the</c><00:06:21.360><c> ID</c><00:06:21.510><c> field</c><00:06:21.990><c> by</c><00:06:22.530><c> default</c><00:06:23.070><c> we'll</c>

00:06:24.020 --> 00:06:24.030 align:start position:0%
field is the ID field by default we'll
 

00:06:24.030 --> 00:06:25.970 align:start position:0%
field is the ID field by default we'll
rename<00:06:24.390><c> this</c><00:06:24.630><c> field</c><00:06:24.990><c> by</c><00:06:25.260><c> clicking</c><00:06:25.770><c> on</c><00:06:25.890><c> the</c>

00:06:25.970 --> 00:06:25.980 align:start position:0%
rename this field by clicking on the
 

00:06:25.980 --> 00:06:28.370 align:start position:0%
rename this field by clicking on the
datasheet<00:06:26.250><c> tab</c><00:06:26.730><c> under</c><00:06:27.210><c> table</c><00:06:27.390><c> tools</c><00:06:27.840><c> and</c><00:06:28.230><c> then</c>

00:06:28.370 --> 00:06:28.380 align:start position:0%
datasheet tab under table tools and then
 

00:06:28.380 --> 00:06:32.110 align:start position:0%
datasheet tab under table tools and then
rename<00:06:28.800><c> and</c><00:06:29.100><c> the</c><00:06:29.160><c> fields</c><00:06:29.460><c> and</c><00:06:29.550><c> columns</c><00:06:29.850><c> group</c>

00:06:32.110 --> 00:06:32.120 align:start position:0%
 
 

00:06:32.120 --> 00:06:35.630 align:start position:0%
 
so<00:06:33.120><c> now</c><00:06:33.630><c> we're</c><00:06:33.840><c> going</c><00:06:33.930><c> to</c><00:06:34.020><c> call</c><00:06:34.230><c> this</c><00:06:34.640><c> customer</c>

00:06:35.630 --> 00:06:35.640 align:start position:0%
so now we're going to call this customer
 

00:06:35.640 --> 00:06:39.140 align:start position:0%
so now we're going to call this customer
ID

00:06:39.140 --> 00:06:39.150 align:start position:0%
 
 

00:06:39.150 --> 00:06:41.570 align:start position:0%
 
I'll<00:06:39.570><c> go</c><00:06:39.780><c> ahead</c><00:06:39.930><c> and</c><00:06:40.229><c> add</c><00:06:40.470><c> all</c><00:06:40.979><c> of</c><00:06:41.040><c> my</c><00:06:41.400><c> other</c>

00:06:41.570 --> 00:06:41.580 align:start position:0%
I'll go ahead and add all of my other
 

00:06:41.580 --> 00:06:49.310 align:start position:0%
I'll go ahead and add all of my other
fields<00:06:46.880><c> now</c><00:06:47.880><c> once</c><00:06:48.120><c> I've</c><00:06:48.330><c> added</c><00:06:48.570><c> all</c><00:06:48.900><c> of</c><00:06:49.139><c> my</c>

00:06:49.310 --> 00:06:49.320 align:start position:0%
fields now once I've added all of my
 

00:06:49.320 --> 00:06:51.920 align:start position:0%
fields now once I've added all of my
fields<00:06:49.949><c> I</c><00:06:50.100><c> can</c><00:06:50.370><c> reorder</c><00:06:51.030><c> these</c><00:06:51.330><c> fields</c><00:06:51.810><c> by</c>

00:06:51.920 --> 00:06:51.930 align:start position:0%
fields I can reorder these fields by
 

00:06:51.930 --> 00:06:54.260 align:start position:0%
fields I can reorder these fields by
dragging<00:06:52.470><c> and</c><00:06:52.560><c> dropping</c><00:06:52.880><c> here</c><00:06:53.880><c> I'll</c><00:06:54.000><c> show</c><00:06:54.210><c> you</c>

00:06:54.260 --> 00:06:54.270 align:start position:0%
dragging and dropping here I'll show you
 

00:06:54.270 --> 00:06:57.790 align:start position:0%
dragging and dropping here I'll show you
how<00:06:54.449><c> to</c><00:06:54.510><c> do</c><00:06:54.720><c> it</c><00:06:55.550><c> click</c><00:06:56.550><c> on</c><00:06:56.669><c> the</c><00:06:56.880><c> field</c><00:06:57.180><c> header</c>

00:06:57.790 --> 00:06:57.800 align:start position:0%
how to do it click on the field header
 

00:06:57.800 --> 00:07:00.530 align:start position:0%
how to do it click on the field header
move<00:06:58.800><c> your</c><00:06:59.040><c> mouse</c><00:06:59.310><c> in</c><00:06:59.639><c> the</c><00:06:59.729><c> area</c><00:07:00.180><c> of</c><00:07:00.389><c> the</c>

00:07:00.530 --> 00:07:00.540 align:start position:0%
move your mouse in the area of the
 

00:07:00.540 --> 00:07:03.350 align:start position:0%
move your mouse in the area of the
header<00:07:00.840><c> and</c><00:07:01.160><c> when</c><00:07:02.160><c> you</c><00:07:02.310><c> see</c><00:07:02.490><c> a</c><00:07:02.520><c> cross</c><00:07:03.000><c> with</c>

00:07:03.350 --> 00:07:03.360 align:start position:0%
header and when you see a cross with
 

00:07:03.360 --> 00:07:06.170 align:start position:0%
header and when you see a cross with
arrows<00:07:03.810><c> hold</c><00:07:04.710><c> down</c><00:07:05.010><c> your</c><00:07:05.040><c> left</c><00:07:05.250><c> click</c><00:07:05.880><c> mouse</c>

00:07:06.170 --> 00:07:06.180 align:start position:0%
arrows hold down your left click mouse
 

00:07:06.180 --> 00:07:08.990 align:start position:0%
arrows hold down your left click mouse
button<00:07:06.780><c> and</c><00:07:06.960><c> drag</c><00:07:07.830><c> the</c><00:07:07.860><c> column</c><00:07:08.520><c> to</c><00:07:08.699><c> another</c>

00:07:08.990 --> 00:07:09.000 align:start position:0%
button and drag the column to another
 

00:07:09.000 --> 00:07:16.129 align:start position:0%
button and drag the column to another
location<00:07:09.419><c> I</c><00:07:13.130><c> can</c><00:07:14.130><c> also</c><00:07:14.520><c> delete</c><00:07:14.850><c> a</c><00:07:15.270><c> field</c><00:07:15.600><c> by</c>

00:07:16.129 --> 00:07:16.139 align:start position:0%
location I can also delete a field by
 

00:07:16.139 --> 00:07:18.200 align:start position:0%
location I can also delete a field by
clicking<00:07:16.169><c> on</c><00:07:16.770><c> the</c><00:07:16.860><c> fields</c><00:07:17.310><c> I</c><00:07:17.370><c> want</c><00:07:17.669><c> to</c><00:07:17.789><c> get</c><00:07:17.970><c> rid</c>

00:07:18.200 --> 00:07:18.210 align:start position:0%
clicking on the fields I want to get rid
 

00:07:18.210 --> 00:07:20.510 align:start position:0%
clicking on the fields I want to get rid
of<00:07:18.270><c> and</c><00:07:18.810><c> from</c><00:07:19.229><c> the</c><00:07:19.350><c> fields</c><00:07:19.740><c> and</c><00:07:19.830><c> columns</c><00:07:20.160><c> group</c>

00:07:20.510 --> 00:07:20.520 align:start position:0%
of and from the fields and columns group
 

00:07:20.520 --> 00:07:24.830 align:start position:0%
of and from the fields and columns group
on<00:07:20.699><c> the</c><00:07:21.150><c> ribbon</c><00:07:21.360><c> click</c><00:07:21.990><c> delete</c><00:07:23.539><c> now</c><00:07:24.539><c> if</c><00:07:24.720><c> you</c>

00:07:24.830 --> 00:07:24.840 align:start position:0%
on the ribbon click delete now if you
 

00:07:24.840 --> 00:07:27.050 align:start position:0%
on the ribbon click delete now if you
inherit<00:07:25.410><c> this</c><00:07:25.680><c> database</c><00:07:26.010><c> means</c><00:07:26.490><c> someone</c><00:07:26.820><c> else</c>

00:07:27.050 --> 00:07:27.060 align:start position:0%
inherit this database means someone else
 

00:07:27.060 --> 00:07:29.900 align:start position:0%
inherit this database means someone else
set<00:07:27.570><c> it</c><00:07:27.690><c> up</c><00:07:27.840><c> for</c><00:07:28.169><c> you</c><00:07:28.380><c> you</c><00:07:28.889><c> want</c><00:07:29.100><c> to</c><00:07:29.220><c> be</c><00:07:29.280><c> careful</c>

00:07:29.900 --> 00:07:29.910 align:start position:0%
set it up for you you want to be careful
 

00:07:29.910 --> 00:07:31.700 align:start position:0%
set it up for you you want to be careful
if<00:07:30.120><c> you</c><00:07:30.240><c> decide</c><00:07:30.570><c> to</c><00:07:30.780><c> delete</c><00:07:31.050><c> anything</c><00:07:31.410><c> in</c><00:07:31.650><c> a</c>

00:07:31.700 --> 00:07:31.710 align:start position:0%
if you decide to delete anything in a
 

00:07:31.710 --> 00:07:33.770 align:start position:0%
if you decide to delete anything in a
database<00:07:32.039><c> because</c><00:07:32.760><c> it</c><00:07:32.910><c> could</c><00:07:33.150><c> impact</c><00:07:33.539><c> other</c>

00:07:33.770 --> 00:07:33.780 align:start position:0%
database because it could impact other
 

00:07:33.780 --> 00:07:38.150 align:start position:0%
database because it could impact other
parts<00:07:34.680><c> of</c><00:07:34.830><c> the</c><00:07:34.919><c> database</c><00:07:36.889><c> we're</c><00:07:37.889><c> almost</c>

00:07:38.150 --> 00:07:38.160 align:start position:0%
parts of the database we're almost
 

00:07:38.160 --> 00:07:40.909 align:start position:0%
parts of the database we're almost
finished<00:07:38.550><c> now</c><00:07:39.300><c> we</c><00:07:39.330><c> need</c><00:07:39.720><c> to</c><00:07:39.840><c> add</c><00:07:39.990><c> fields</c><00:07:40.710><c> to</c>

00:07:40.909 --> 00:07:40.919 align:start position:0%
finished now we need to add fields to
 

00:07:40.919 --> 00:07:41.719 align:start position:0%
finished now we need to add fields to
the<00:07:40.949><c> orders</c><00:07:41.310><c> table</c>

00:07:41.719 --> 00:07:41.729 align:start position:0%
the orders table
 

00:07:41.729 --> 00:07:46.719 align:start position:0%
the orders table
I'll<00:07:41.940><c> start</c><00:07:42.479><c> by</c><00:07:42.630><c> changing</c><00:07:42.900><c> the</c><00:07:43.260><c> ID</c><00:07:43.410><c> field</c>

00:07:46.719 --> 00:07:46.729 align:start position:0%
 
 

00:07:46.729 --> 00:07:49.490 align:start position:0%
 
earlier<00:07:47.729><c> we</c><00:07:47.970><c> talked</c><00:07:48.240><c> about</c><00:07:48.389><c> the</c><00:07:48.630><c> ID</c><00:07:48.780><c> fields</c>

00:07:49.490 --> 00:07:49.500 align:start position:0%
earlier we talked about the ID fields
 

00:07:49.500 --> 00:07:52.070 align:start position:0%
earlier we talked about the ID fields
and<00:07:49.650><c> how</c><00:07:49.860><c> they</c><00:07:50.070><c> assign</c><00:07:50.490><c> a</c><00:07:50.760><c> unique</c><00:07:51.210><c> number</c><00:07:51.660><c> to</c>

00:07:52.070 --> 00:07:52.080 align:start position:0%
and how they assign a unique number to
 

00:07:52.080 --> 00:07:55.610 align:start position:0%
and how they assign a unique number to
each<00:07:52.110><c> record</c><00:07:53.070><c> for</c><00:07:53.729><c> our</c><00:07:53.880><c> orders</c><00:07:54.389><c> table</c><00:07:54.720><c> we</c><00:07:55.440><c> want</c>

00:07:55.610 --> 00:07:55.620 align:start position:0%
each record for our orders table we want
 

00:07:55.620 --> 00:07:58.250 align:start position:0%
each record for our orders table we want
to<00:07:55.800><c> figure</c><00:07:55.979><c> out</c><00:07:56.250><c> who</c><00:07:56.729><c> is</c><00:07:57.090><c> ordering</c><00:07:57.660><c> our</c><00:07:57.810><c> books</c>

00:07:58.250 --> 00:07:58.260 align:start position:0%
to figure out who is ordering our books
 

00:07:58.260 --> 00:08:01.250 align:start position:0%
to figure out who is ordering our books
so<00:07:59.130><c> the</c><00:07:59.250><c> first</c><00:07:59.610><c> field</c><00:08:00.120><c> I'm</c><00:08:00.539><c> going</c><00:08:00.810><c> to</c><00:08:00.930><c> create</c>

00:08:01.250 --> 00:08:01.260 align:start position:0%
so the first field I'm going to create
 

00:08:01.260 --> 00:08:06.350 align:start position:0%
so the first field I'm going to create
is<00:08:01.680><c> the</c><00:08:01.889><c> customer</c><00:08:02.400><c> ID</c><00:08:02.610><c> field</c><00:08:04.970><c> this</c><00:08:05.970><c> is</c><00:08:06.030><c> where</c><00:08:06.330><c> a</c>

00:08:06.350 --> 00:08:06.360 align:start position:0%
is the customer ID field this is where a
 

00:08:06.360 --> 00:08:09.070 align:start position:0%
is the customer ID field this is where a
customer's<00:08:06.930><c> unique</c><00:08:07.410><c> ID</c><00:08:07.710><c> number</c><00:08:07.979><c> will</c><00:08:08.520><c> reside</c>

00:08:09.070 --> 00:08:09.080 align:start position:0%
customer's unique ID number will reside
 

00:08:09.080 --> 00:08:12.890 align:start position:0%
customer's unique ID number will reside
the<00:08:10.080><c> next</c><00:08:10.440><c> fields</c><00:08:10.830><c> will</c><00:08:10.949><c> be</c><00:08:11.039><c> the</c><00:08:11.160><c> book</c><00:08:11.400><c> ID</c><00:08:11.900><c> this</c>

00:08:12.890 --> 00:08:12.900 align:start position:0%
the next fields will be the book ID this
 

00:08:12.900 --> 00:08:15.409 align:start position:0%
the next fields will be the book ID this
will<00:08:13.139><c> tell</c><00:08:13.380><c> me</c><00:08:13.560><c> which</c><00:08:13.860><c> book</c><00:08:13.919><c> my</c><00:08:14.760><c> customer</c>

00:08:15.409 --> 00:08:15.419 align:start position:0%
will tell me which book my customer
 

00:08:15.419 --> 00:08:19.939 align:start position:0%
will tell me which book my customer
ordered<00:08:17.449><c> I'll</c><00:08:18.449><c> explain</c><00:08:18.960><c> more</c><00:08:19.320><c> about</c><00:08:19.380><c> the</c>

00:08:19.939 --> 00:08:19.949 align:start position:0%
ordered I'll explain more about the
 

00:08:19.949 --> 00:08:22.430 align:start position:0%
ordered I'll explain more about the
customer<00:08:20.310><c> ID</c><00:08:20.699><c> field</c><00:08:20.880><c> in</c><00:08:21.240><c> the</c><00:08:21.360><c> book</c><00:08:21.599><c> ID</c><00:08:21.840><c> fields</c>

00:08:22.430 --> 00:08:22.440 align:start position:0%
customer ID field in the book ID fields
 

00:08:22.440 --> 00:08:26.870 align:start position:0%
customer ID field in the book ID fields
in<00:08:22.530><c> our</c><00:08:22.650><c> next</c><00:08:23.039><c> lesson</c><00:08:25.370><c> remember</c><00:08:26.370><c> the</c><00:08:26.490><c> point</c><00:08:26.760><c> of</c>

00:08:26.870 --> 00:08:26.880 align:start position:0%
in our next lesson remember the point of
 

00:08:26.880 --> 00:08:29.390 align:start position:0%
in our next lesson remember the point of
our<00:08:27.000><c> orders</c><00:08:27.479><c> table</c><00:08:27.930><c> is</c><00:08:28.050><c> to</c><00:08:28.199><c> see</c><00:08:28.410><c> who</c><00:08:28.770><c> ordered</c>

00:08:29.390 --> 00:08:29.400 align:start position:0%
our orders table is to see who ordered
 

00:08:29.400 --> 00:08:32.269 align:start position:0%
our orders table is to see who ordered
what<00:08:29.729><c> and</c><00:08:30.030><c> when</c><00:08:30.389><c> so</c><00:08:31.080><c> we</c><00:08:31.229><c> need</c><00:08:31.440><c> to</c><00:08:31.590><c> add</c><00:08:31.770><c> a</c><00:08:31.800><c> date</c>

00:08:32.269 --> 00:08:32.279 align:start position:0%
what and when so we need to add a date
 

00:08:32.279 --> 00:08:37.190 align:start position:0%
what and when so we need to add a date
field<00:08:34.940><c> now</c><00:08:35.940><c> we</c><00:08:36.000><c> just</c><00:08:36.330><c> learned</c><00:08:36.630><c> how</c><00:08:36.930><c> to</c><00:08:36.959><c> use</c>

00:08:37.190 --> 00:08:37.200 align:start position:0%
field now we just learned how to use
 

00:08:37.200 --> 00:08:39.920 align:start position:0%
field now we just learned how to use
design<00:08:37.860><c> view</c><00:08:38.219><c> to</c><00:08:38.400><c> change</c><00:08:38.700><c> the</c><00:08:38.880><c> data</c><00:08:39.060><c> type</c><00:08:39.450><c> but</c>

00:08:39.920 --> 00:08:39.930 align:start position:0%
design view to change the data type but
 

00:08:39.930 --> 00:08:41.990 align:start position:0%
design view to change the data type but
we<00:08:40.020><c> can</c><00:08:40.169><c> also</c><00:08:40.349><c> do</c><00:08:40.860><c> it</c><00:08:41.010><c> from</c><00:08:41.250><c> the</c><00:08:41.339><c> ribbon</c><00:08:41.789><c> and</c>

00:08:41.990 --> 00:08:42.000 align:start position:0%
we can also do it from the ribbon and
 

00:08:42.000 --> 00:08:45.230 align:start position:0%
we can also do it from the ribbon and
the<00:08:42.120><c> data</c><00:08:42.360><c> type</c><00:08:42.719><c> and</c><00:08:42.930><c> formatting</c><00:08:43.500><c> group</c><00:08:44.029><c> to</c><00:08:45.029><c> do</c>

00:08:45.230 --> 00:08:45.240 align:start position:0%
the data type and formatting group to do
 

00:08:45.240 --> 00:08:49.190 align:start position:0%
the data type and formatting group to do
this<00:08:45.450><c> click</c><00:08:46.050><c> on</c><00:08:46.260><c> a</c><00:08:46.320><c> field</c><00:08:46.709><c> header</c><00:08:47.190><c> and</c><00:08:48.200><c> then</c>

00:08:49.190 --> 00:08:49.200 align:start position:0%
this click on a field header and then
 

00:08:49.200 --> 00:08:51.590 align:start position:0%
this click on a field header and then
click<00:08:49.560><c> on</c><00:08:49.740><c> the</c><00:08:49.950><c> drop-down</c><00:08:50.220><c> menu</c><00:08:50.910><c> beside</c><00:08:51.270><c> data</c>

00:08:51.590 --> 00:08:51.600 align:start position:0%
click on the drop-down menu beside data
 

00:08:51.600 --> 00:08:52.850 align:start position:0%
click on the drop-down menu beside data
type

00:08:52.850 --> 00:08:52.860 align:start position:0%
type
 

00:08:52.860 --> 00:08:56.480 align:start position:0%
type
automatically<00:08:53.459><c> defaults</c><00:08:54.060><c> to</c><00:08:54.089><c> text</c><00:08:55.010><c> but</c><00:08:56.010><c> since</c>

00:08:56.480 --> 00:08:56.490 align:start position:0%
automatically defaults to text but since
 

00:08:56.490 --> 00:08:58.400 align:start position:0%
automatically defaults to text but since
we<00:08:56.610><c> want</c><00:08:56.850><c> to</c><00:08:56.910><c> know</c><00:08:57.120><c> the</c><00:08:57.209><c> order</c><00:08:57.420><c> dates</c><00:08:57.839><c> we're</c>

00:08:58.400 --> 00:08:58.410 align:start position:0%
we want to know the order dates we're
 

00:08:58.410 --> 00:09:01.639 align:start position:0%
we want to know the order dates we're
going<00:08:58.529><c> to</c><00:08:58.589><c> change</c><00:08:58.860><c> it</c><00:08:59.040><c> to</c><00:08:59.070><c> dates</c><00:08:59.430><c> and</c><00:08:59.700><c> time</c><00:09:00.649><c> now</c>

00:09:01.639 --> 00:09:01.649 align:start position:0%
going to change it to dates and time now
 

00:09:01.649 --> 00:09:03.680 align:start position:0%
going to change it to dates and time now
immediately<00:09:02.040><c> you</c><00:09:02.459><c> don't</c><00:09:02.610><c> see</c><00:09:02.730><c> any</c><00:09:02.970><c> changes</c><00:09:03.510><c> at</c>

00:09:03.680 --> 00:09:03.690 align:start position:0%
immediately you don't see any changes at
 

00:09:03.690 --> 00:09:05.810 align:start position:0%
immediately you don't see any changes at
all<00:09:03.839><c> but</c><00:09:04.440><c> once</c><00:09:04.620><c> we</c><00:09:04.769><c> start</c><00:09:04.980><c> entering</c><00:09:05.339><c> our</c><00:09:05.430><c> data</c>

00:09:05.810 --> 00:09:05.820 align:start position:0%
all but once we start entering our data
 

00:09:05.820 --> 00:09:08.660 align:start position:0%
all but once we start entering our data
later<00:09:06.240><c> you'll</c><00:09:07.019><c> see</c><00:09:07.260><c> this</c><00:09:07.410><c> calendar</c><00:09:07.950><c> icon</c><00:09:08.370><c> come</c>

00:09:08.660 --> 00:09:08.670 align:start position:0%
later you'll see this calendar icon come
 

00:09:08.670 --> 00:09:10.819 align:start position:0%
later you'll see this calendar icon come
up<00:09:08.880><c> again</c><00:09:09.660><c> we'll</c><00:09:09.990><c> talk</c><00:09:10.170><c> about</c><00:09:10.440><c> this</c><00:09:10.589><c> a</c><00:09:10.649><c> little</c>

00:09:10.819 --> 00:09:10.829 align:start position:0%
up again we'll talk about this a little
 

00:09:10.829 --> 00:09:13.310 align:start position:0%
up again we'll talk about this a little
later<00:09:11.360><c> setting</c><00:09:12.360><c> up</c><00:09:12.480><c> tables</c><00:09:12.690><c> and</c><00:09:13.019><c> fields</c><00:09:13.140><c> in</c>

00:09:13.310 --> 00:09:13.320 align:start position:0%
later setting up tables and fields in
 

00:09:13.320 --> 00:09:15.889 align:start position:0%
later setting up tables and fields in
Access<00:09:13.829><c> is</c><00:09:13.860><c> just</c><00:09:14.339><c> the</c><00:09:14.459><c> beginning</c><00:09:14.610><c> now</c><00:09:15.510><c> we</c><00:09:15.630><c> need</c>

00:09:15.889 --> 00:09:15.899 align:start position:0%
Access is just the beginning now we need
 

00:09:15.899 --> 00:09:18.170 align:start position:0%
Access is just the beginning now we need
to<00:09:16.110><c> link</c><00:09:16.500><c> them</c><00:09:16.709><c> all</c><00:09:16.890><c> together</c><00:09:17.130><c> to</c><00:09:17.760><c> build</c><00:09:18.029><c> the</c>

00:09:18.170 --> 00:09:18.180 align:start position:0%
to link them all together to build the
 

00:09:18.180 --> 00:09:20.269 align:start position:0%
to link them all together to build the
relationships<00:09:18.930><c> in</c><00:09:19.079><c> our</c><00:09:19.200><c> relational</c><00:09:19.800><c> database</c>

00:09:20.269 --> 00:09:20.279 align:start position:0%
relationships in our relational database
 

00:09:20.279 --> 00:09:22.579 align:start position:0%
relationships in our relational database
because<00:09:20.880><c> that</c><00:09:21.209><c> is</c><00:09:21.420><c> where</c><00:09:21.600><c> the</c><00:09:21.690><c> real</c><00:09:21.930><c> power</c><00:09:22.260><c> is</c>

00:09:22.579 --> 00:09:22.589 align:start position:0%
because that is where the real power is
 

00:09:22.589 --> 00:09:25.430 align:start position:0%
because that is where the real power is
in<00:09:22.920><c> Access</c>