WEBVTT
Kind: captions
Language: en

00:00:11.940 --> 00:00:16.910
I'm working on a form that we can use in our
bakery to view and edit the customer information.

00:00:16.910 --> 00:00:19.560
And I know the employees are going to be using
this form a lot,

00:00:19.560 --> 00:00:23.250
so I want to make it as pleasant
and easy to use as possible.

00:00:23.250 --> 00:00:27.610
To do that, I'm going to need to make some
adjustments to the layout and formatting.

00:00:27.610 --> 00:00:29.840
The first thing I'm going to do is add a
Command Button

00:00:29.840 --> 00:00:33.530
that the user can click to search for a
specific record.

00:00:33.530 --> 00:00:35.570
To add a command button, you'll need to be
in

00:00:35.570 --> 00:00:37.260
Layout view.

00:00:37.260 --> 00:00:40.410
In the Design tab, find the Controls group,

00:00:40.410 --> 00:00:42.219
click on the drop-down arrow,

00:00:42.219 --> 00:00:46.940
and make sure that Use Control Wizards
is selected.

00:00:46.940 --> 00:00:49.499
And then select the Button command.

00:00:49.499 --> 00:00:52.370
Then, in the Form, click where you want the
button

00:00:52.370 --> 00:00:57.019
to go.

00:00:57.019 --> 00:00:58.469
There are many different actions that you
can

00:00:58.469 --> 00:00:59.559
choose from,

00:00:59.559 --> 00:01:01.899
and they're organized under different categories.

00:01:01.899 --> 00:01:03.739
Most of the time, you're probably just going
to

00:01:03.739 --> 00:01:06.530
use actions from the first four categories.

00:01:06.530 --> 00:01:09.520
The one that I want is in Record Navigation,
and

00:01:09.520 --> 00:01:12.229
it's called Find Record.

00:01:12.229 --> 00:01:13.420
Then click Next.

00:01:13.420 --> 00:01:15.590
Here, you can choose whether you want the
button

00:01:15.590 --> 00:01:17.960
to display text or a picture.

00:01:17.960 --> 00:01:22.280
In this case, I'm going to use the default
binoculars picture,

00:01:22.280 --> 00:01:26.830
but you could also browse for
another picture if you want.

00:01:26.830 --> 00:01:28.860
In the last step, you can type a name for
the

00:01:28.860 --> 00:01:29.360
button.

00:01:29.360 --> 00:01:30.810
I'll call it Search.

00:01:30.810 --> 00:01:33.330
And this text will not appear on the button,

00:01:33.330 --> 00:01:35.170
but it may be helpful if you need to edit
the

00:01:35.170 --> 00:01:37.720
button later with the Property Sheet.

00:01:37.720 --> 00:01:40.640
Click Finish, and your button will appear
on the

00:01:40.640 --> 00:01:42.360
form.

00:01:42.360 --> 00:01:45.220
At this point, I want to move and resize the
fields

00:01:45.220 --> 00:01:47.000
so that we can get a better view of everything.

00:01:47.000 --> 00:01:49.310
I think everything would fit a lot better
if I put

00:01:49.310 --> 00:01:51.380
it into two columns.

00:01:51.380 --> 00:01:53.250
You can adjust the fields just like you would
in a

00:01:53.250 --> 00:01:54.230
report.

00:01:54.230 --> 00:01:56.790
For example, you can click on a cell and then
drag

00:01:56.790 --> 00:01:59.830
the edge to resize the column.

00:01:59.830 --> 00:02:03.520
Next, I'm going to go to the Arrange tab,

00:02:03.520 --> 00:02:08.340
and then in the Rows & Columns group,
select Insert Right to add a column.

00:02:08.340 --> 00:02:10.509
I'm going to click it twice so we have one
column

00:02:10.509 --> 00:02:11.780
for the field labels

00:02:11.780 --> 00:02:14.980
and another for the actual fields.

00:02:14.980 --> 00:02:16.870
Then I'll just click and drag the fields where
I

00:02:16.870 --> 00:02:22.720
want them.

00:02:22.720 --> 00:02:24.890
You may end up with some empty rows,

00:02:24.890 --> 00:02:31.340
and you can just click on them and press the
Delete key to get rid of them.

00:02:31.340 --> 00:02:33.640
And I'd like the Other Notes field to be larger,

00:02:33.640 --> 00:02:35.840
so I'm going to merge it with the other cells
in

00:02:35.840 --> 00:02:37.080
its row.

00:02:37.080 --> 00:02:39.170
I'll hold down the shift key while I'm clicking
on

00:02:39.170 --> 00:02:40.440
each cell,

00:02:40.440 --> 00:02:44.800
and then on the Arrange tab, I'll click
the Merge command.

00:02:44.800 --> 00:02:48.160
Finally, I'm going to make some adjustments
to the

00:02:48.160 --> 00:02:49.150
colors and fonts,

00:02:49.150 --> 00:02:51.209
just to make it look a little nicer.

00:02:51.209 --> 00:02:53.200
And again, this is exactly like formatting
a

00:02:53.200 --> 00:02:54.920
report.

00:02:54.920 --> 00:02:57.319
You can go to the Design tab to add a logo
or

00:02:57.319 --> 00:02:59.180
choose a theme.

00:02:59.180 --> 00:03:01.230
But keep in mind, the theme applies to your
entire

00:03:01.230 --> 00:03:02.510
database,

00:03:02.510 --> 00:03:05.540
so if you want to make changes that will only
apply to this form,

00:03:05.540 --> 00:03:07.990
you can use the commands in the Format tab.

00:03:07.990 --> 00:03:10.810
Here, you can adjust the colors and fonts
of

00:03:10.810 --> 00:03:13.240
individual elements in the form.

00:03:13.240 --> 00:03:15.590
I'm going to control-click the fields that
I want

00:03:15.590 --> 00:03:18.950
to change,

00:03:18.950 --> 00:03:25.950
and now I can adjust the fill color, outline
color, and outline weight.

00:03:31.480 --> 00:03:34.030
I'm also going to choose a background color
and

00:03:34.030 --> 00:03:36.870
add a few final touches.

00:03:36.870 --> 00:03:40.360
Okay, my form is now finished.

00:03:40.360 --> 00:03:43.410
I've added the logo for our bakery, I've added
a

00:03:43.410 --> 00:03:45.040
shadow to the Search box from the

00:03:45.040 --> 00:03:48.160
Shape Effects menu, and I've also changed
the

00:03:48.160 --> 00:03:49.970
font of the form header.

00:03:49.970 --> 00:03:52.760
It may take some time to get the form exactly
how

00:03:52.760 --> 00:03:53.860
you want it,

00:03:53.860 --> 00:03:56.560
but once you do, you'll have a
professional-looking form

00:03:56.560 --> 00:04:03.560
that's easy for people 
to use.