WEBVTT
Kind: captions
Language: en

00:00:03.690 --> 00:00:11.920
Creating 
a form can save you a lot of time in the long

00:00:11.920 --> 00:00:16.500
run because it makes it easier to input the
data into one or more tables.

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

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

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

00:00:30.340 --> 00:00:33.370
And you don't need to open it—just make
sure that the name is highlighted.

00:00:33.370 --> 00:00:36.309
I'm using the Customers table.

00:00:36.309 --> 00:00:42.710
Then in the Create tab… you can click the
Form command… and it will create a new form

00:00:42.710 --> 00:00:46.280
that contains all of the fields from your
table.

00:00:46.280 --> 00:00:50.059
Before you do anything else, you should save
this form.

00:00:50.059 --> 00:00:57.579
I'll call it Customers Form.

00:00:57.579 --> 00:01:00.620
Sometimes your form will include a subform.

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

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

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

00:01:13.540 --> 00:01:15.330
In many cases, this may be useful.

00:01:15.330 --> 00:01:20.080
But if you don't need the subform, you can
delete it by just clicking on it… and pressing

00:01:20.080 --> 00:01:23.350
the Delete key.

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

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

00:01:31.420 --> 00:01:36.500
To do this, you can select Add Existing Fields
from the Design tab… and this will open

00:01:36.500 --> 00:01:40.750
up the Field List, which shows all of the
fields from this table.

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

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

00:01:49.460 --> 00:01:53.050
the table and field that you want.

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

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

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

00:02:08.200 --> 00:02:09.599
they want.

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

00:02:14.390 --> 00:02:21.310
In the Design tab, find the Controls group…
and select the Combo Box command.

00:02:21.310 --> 00:02:25.620
Then you can just click on the form where
you want it to go.

00:02:25.620 --> 00:02:28.280
The Combo Box Wizard will open up.

00:02:28.280 --> 00:02:32.350
And if you have a long list of values, you
can click the first option to pull the values

00:02:32.350 --> 00:02:34.420
from a table or a query.

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

00:02:38.090 --> 00:02:42.860
I want.

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

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

00:02:53.200 --> 00:02:55.270
to the next row.

00:02:55.270 --> 00:03:01.580
And if you need to, you can adjust the width
of the column.

00:03:01.580 --> 00:03:04.440
And then click Next.

00:03:04.440 --> 00:03:06.540
Now this next step is very important.

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

00:03:11.220 --> 00:03:12.730
Customers table.

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

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

00:03:22.220 --> 00:03:28.160
the Add to Mailing List field.

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

00:03:30.800 --> 00:03:35.900
I'm going to call it "Add to Mailing List?"

00:03:35.900 --> 00:03:39.360
And click Finish.

00:03:39.360 --> 00:03:41.810
The combo box will appear here.

00:03:41.810 --> 00:03:45.920
And we don't need the original field anymore,
so we can delete it.

00:03:45.920 --> 00:03:54.069
To test the combo box, we can switch to Form
view… and you can see that our three options

00:03:54.069 --> 00:03:56.530
appear here.

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

00:04:00.480 --> 00:04:03.489
some more adjustments to it to make it better
suit our needs.