WEBVTT
Kind: captions
Language: en

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

00:00:14.599 --> 00:00:18.840
And I know the employees are going to be using
this form a lot, so I want to make it as pleasant

00:00:18.840 --> 00:00:20.970
and easy to use as possible.

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

00:00:25.430 --> 00:00:29.660
The first thing I'm going to do is add a command
button that the user can click to search for

00:00:29.660 --> 00:00:31.340
a specific record.

00:00:31.340 --> 00:00:35.469
To add a command button, you'll need to be
in Layout view.

00:00:35.469 --> 00:00:41.610
In the Design tab, find the Controls group…
click on the drop-down arrow… and make sure

00:00:41.610 --> 00:00:45.790
that Use Control Wizards is selected.

00:00:45.790 --> 00:00:48.220
And then select the Button command.

00:00:48.220 --> 00:00:53.970
Then, in the form, click where you want the
button to go.

00:00:53.970 --> 00:00:57.320
There are many different actions that you
can choose from, and they're organized under

00:00:57.320 --> 00:00:59.120
different categories.

00:00:59.120 --> 00:01:03.739
Most of the time, you're probably just going
to use actions from the first four categories.

00:01:03.739 --> 00:01:10.400
The one that I want is in Record Navigation…
and it's called Find Record.

00:01:10.400 --> 00:01:12.110
Then click Next.

00:01:12.110 --> 00:01:17.249
Here, you can choose whether you want the
button to display text or a picture.

00:01:17.249 --> 00:01:22.719
In this case, I'm going to use the default
binoculars picture, but you could also browse

00:01:22.719 --> 00:01:27.420
for another picture if you want.

00:01:27.420 --> 00:01:30.020
In the last step, you can type a name for
the button.

00:01:30.020 --> 00:01:31.560
I'll call it Search.

00:01:31.560 --> 00:01:35.729
And this text will not appear on the button,
but it may be helpful if you need to edit

00:01:35.729 --> 00:01:38.780
the button later with the Property Sheet.

00:01:38.780 --> 00:01:43.179
Click Finish… and your button will appear
on the form.

00:01:43.179 --> 00:01:49.090
At this point, I want to move and resize the
fields so we can get a better view of everything.

00:01:49.090 --> 00:01:53.679
I think everything would fit a lot better
if I put it into two columns.

00:01:53.679 --> 00:01:56.590
You can adjust the fields just like you would
in a report.

00:01:56.590 --> 00:02:04.399
For example, you can click on a cell… and
then drag the edge to resize the column.

00:02:04.399 --> 00:02:10.099
Next I'm going to go to the Arrange tab…
and then in the Rows & Columns group, select

00:02:10.099 --> 00:02:12.599
Insert Right to add a column.

00:02:12.599 --> 00:02:16.810
I'm going to click it twice so that we have
one column for the field labels, and another

00:02:16.810 --> 00:02:19.450
for the actual fields.

00:02:19.450 --> 00:02:27.670
Then I'll just click and drag the fields where
I want them.

00:02:27.670 --> 00:02:31.710
You may end up with some empty rows, and you
can just click on them and press the Delete

00:02:31.710 --> 00:02:35.920
key to get rid of them.

00:02:35.920 --> 00:02:39.720
And the Other Notes field, I'd like it to
be larger, so I'm going to merge it with the

00:02:39.720 --> 00:02:41.810
other cells in its row.

00:02:41.810 --> 00:02:47.300
I'll hold down the Shift key while I'm clicking
each cell… and then on the Arrange tab,

00:02:47.300 --> 00:02:51.820
I'll click the Merge command.

00:02:51.820 --> 00:02:58.450
Finally, I'm going to make some adjustments
to the colors and fonts, just to make it look

00:02:58.450 --> 00:02:59.890
a little nicer.

00:02:59.890 --> 00:03:03.150
And again, this is exactly like formatting
a report.

00:03:03.150 --> 00:03:08.230
You can go to the Design tab to add a logo
or choose a theme…

00:03:08.230 --> 00:03:11.390
But keep in mind, the theme applies to your
entire database.

00:03:11.390 --> 00:03:15.170
So if you want to make changes that will only
apply to this form, you can use the commands

00:03:15.170 --> 00:03:17.750
in the Format tab.

00:03:17.750 --> 00:03:22.540
Here you can adjust the colors and fonts of
individual elements in the form.

00:03:22.540 --> 00:03:28.620
I'm going to Control-click the fields that
I want to change…

00:03:28.620 --> 00:03:44.319
And now I can adjust the fill color… outline
color… and outline weight.

00:03:44.319 --> 00:03:50.420
I'm also going to choose a background color…
and add a few final touches.

00:03:50.420 --> 00:03:55.010
Ok, my form is now finished.

00:03:55.010 --> 00:03:57.440
I've added the logo for our bakery…

00:03:57.440 --> 00:04:02.709
I've added a shadow to the Search box from
the shape effects menu… and I've also changed

00:04:02.709 --> 00:04:05.410
the font of the form header.

00:04:05.410 --> 00:04:09.600
Now it may take some time to get the form
exactly how you want it, but once you do,

00:04:09.600 --> 00:04:13.000
you'll have a professional-looking form that's
easy for people to use.