WEBVTT
Kind: captions
Language: en

00:00:12.400 --> 00:00:16.180
Creating a form can save you a lot of time
in the long run because it makes it easier

00:00:16.180 --> 00:00:18.980
to input the data into one or more tables.

00:00:18.980 --> 00:00:22.570
And in this video, we're just going to go
over the basics of creating a form from a

00:00:22.570 --> 00:00:28.430
table, adding additional fields, and inserting
a drop-down menu into the form.

00:00:28.430 --> 00:00:32.320
In the Navigation pane, you'll need to select
the table that you want to use.

00:00:32.320 --> 00:00:35.330
And you don't need to open it, just make sure
that the name is highlighted.

00:00:35.330 --> 00:00:37.320
I'm using the Customers table.

00:00:37.320 --> 00:00:42.989
Then, in the Create tab, you can click the
Form command, and it will create a new form

00:00:42.989 --> 00:00:46.150
that contains all of the fields from your
table.

00:00:46.150 --> 00:00:49.900
Before you do anything else, you should save
this form.

00:00:49.900 --> 00:00:55.909
I'll call it Customers Form.

00:00:55.909 --> 00:00:58.750
Sometimes the form will include a subform.

00:00:58.750 --> 00:01:02.729
Access will create one of these if your table
is linked to another table.

00:01:02.729 --> 00:01:06.600
For example, here, our Customers table is
linked to the Orders table.

00:01:06.600 --> 00:01:11.369
So this subform will include a list of any
orders that the customer has placed.

00:01:11.369 --> 00:01:15.299
In many cases, this may be useful, but if
you don't need the subform you can delete

00:01:15.299 --> 00:01:19.440
it by clicking on it and then pressing the
delete key.

00:01:19.440 --> 00:01:24.250
Now if we later decided to add a field to
the Customers table, it would not appear automatically

00:01:24.250 --> 00:01:27.190
in this form, so we would need to add it manually.

00:01:27.190 --> 00:01:32.170
To do this, you can select Add Existing Fields
from the Design tab, and this will open up

00:01:32.170 --> 00:01:36.380
the Field List, which shows all of the fields
from this table.

00:01:36.380 --> 00:01:39.240
You can just double-click a field to add it
to the form.

00:01:39.240 --> 00:01:44.890
Or, if you want to add a field from a different
table, click Show all tables, and then locate

00:01:44.890 --> 00:01:47.910
the table and field that you want.

00:01:47.910 --> 00:01:53.090
But for now, we have all of the fields that
we need, so I'm just going to close this pane.

00:01:53.090 --> 00:01:58.450
With some fields, you may want to add a drop-down
menu, which Access calls a combo box.

00:01:58.450 --> 00:02:02.160
This can make the form easier to use because
the user can just click on the value that

00:02:02.160 --> 00:02:03.350
they want.

00:02:03.350 --> 00:02:07.850
I'm going to create a combo box for the Add
to Mailing List field.

00:02:07.850 --> 00:02:13.470
In the Design tab, find the Controls group,
and select the Combo Box command.

00:02:13.470 --> 00:02:18.590
Then, you can just click on the form where
you want it to go.

00:02:18.590 --> 00:02:21.459
The Combo Box Wizard will open up.

00:02:21.459 --> 00:02:25.469
If you have a long list of values, you can
click the first option to pull the values

00:02:25.469 --> 00:02:27.709
from a table or a query.

00:02:27.709 --> 00:02:31.219
But I'm going to select the second option,
so that I can type in the exact values that

00:02:31.219 --> 00:02:33.269
I want.

00:02:33.269 --> 00:02:40.879
Here, you can type in each value, and in most
cases, you'll just use the first column.

00:02:40.879 --> 00:02:45.079
I'm typing three different values, and I'm
pressing the tab key after each one to go

00:02:45.079 --> 00:02:48.069
to the next row.

00:02:48.069 --> 00:02:50.980
If you need to, you can adjust the width of
the column.

00:02:50.980 --> 00:02:54.420
Then, click Next.

00:02:54.420 --> 00:02:56.510
Now this next step is very important.

00:02:56.510 --> 00:03:01.189
When the user chooses a value from the combo
box, we want the value to be stored in the

00:03:01.189 --> 00:03:02.709
Customers table.

00:03:02.709 --> 00:03:07.249
We'll need to select the second option and
pick the field that we want.

00:03:07.249 --> 00:03:11.550
In this case, our combo box is going to be
asking about the mailing list, so I'll choose

00:03:11.550 --> 00:03:16.260
the Add to Mailing List field.

00:03:16.260 --> 00:03:18.870
And then in the last step, you can type a
label.

00:03:18.870 --> 00:03:22.549
I'm going to call it Add to Mailing List.

00:03:22.549 --> 00:03:25.989
And click Finish.

00:03:25.989 --> 00:03:30.730
The combo box will appear, and we don't need
the original field anymore, so we can delete

00:03:30.730 --> 00:03:32.050
it.

00:03:32.050 --> 00:03:36.980
To test the combo box, we can switch to Form
view.

00:03:36.980 --> 00:03:41.480
And you can see that our three options appear
here.

00:03:41.480 --> 00:03:45.440
So now we have a working form, and in the
next couple of videos we're going to make

00:03:45.440 --> 00:04:11.149
some more adjustments to it to make it better
suit our needs.