WEBVTT
Kind: captions
Language: en

00:00:12.150 --> 00:00:14.160
When you're creating a form, Access allows
you to

00:00:14.160 --> 00:00:15.940
make some very detailed changes

00:00:15.940 --> 00:00:17.970
using the Property Sheet.

00:00:17.970 --> 00:00:20.200
To open the Property Sheet, first make sure
that

00:00:20.200 --> 00:00:21.840
you're in Layout view,

00:00:21.840 --> 00:00:25.990
and then in the Design tab,
select the Property Sheet command.

00:00:25.990 --> 00:00:27.949
There are several tabs that you can choose
from.

00:00:27.949 --> 00:00:31.300
On each row, you'll see the property name
on the

00:00:31.300 --> 00:00:34.250
left, and the value on the right.

00:00:34.250 --> 00:00:36.860
Sometimes, you'll need to type the new value
that

00:00:36.860 --> 00:00:37.960
you want,

00:00:37.960 --> 00:00:42.829
but some properties have one or more
buttons that you can click to choose a value.

00:00:42.829 --> 00:00:44.650
You should always pay close attention when
you're

00:00:44.650 --> 00:00:45.970
making changes.

00:00:45.970 --> 00:00:50.360
Since there are so many options, it may be
difficult to remember exactly what you've

00:00:50.360 --> 00:00:50.940
changed,

00:00:50.940 --> 00:00:53.049
and what the original values were.

00:00:53.049 --> 00:00:55.330
But if you don't remember what each property
does,

00:00:55.330 --> 00:00:56.760
you can just click on it

00:00:56.760 --> 00:00:58.540
and then a brief description will appear in
the

00:00:58.540 --> 00:01:01.110
bottom-left corner of the screen.

00:01:01.110 --> 00:01:03.040
This property controls the vertical position
of

00:01:03.040 --> 00:01:06.850
the object, relative to the top of the form.

00:01:06.850 --> 00:01:09.939
In this form, I'd like to hide the ID field.

00:01:09.939 --> 00:01:15.689
I'll select it, and then in the Property Sheet
I'll go to the Format tab.

00:01:15.689 --> 00:01:18.650
And then find the property that says 'Visible'.

00:01:18.650 --> 00:01:19.830
Right now it's set to Yes,

00:01:19.830 --> 00:01:25.190
but you can click on it and then use
the drop-down menu to change it to no.

00:01:25.190 --> 00:01:30.870
We can switch to Form view to test it.

00:01:30.870 --> 00:01:32.430
And this field is now invisible.

00:01:32.430 --> 00:01:35.570
At any time, if we want to make it visible
again,

00:01:35.570 --> 00:01:39.120
we could go back to the Property Sheet
and change it.

00:01:39.120 --> 00:01:42.530
Now I'd also like to modify the Orders form.

00:01:42.530 --> 00:01:47.310
I'll first switch to Layout view.

00:01:47.310 --> 00:01:49.520
In this form, I'd like the Pickup Date field
to

00:01:49.520 --> 00:01:51.130
default to the current date

00:01:51.130 --> 00:01:53.460
whenever we create a new order.

00:01:53.460 --> 00:01:58.780
I'll select the field, and then in the Property
Sheet I'll click the Data tab,

00:01:58.780 --> 00:02:01.640
and then find the Default Value property.

00:02:01.640 --> 00:02:03.280
In order to get the current date, we'll need
to

00:02:03.280 --> 00:02:05.310
add an expression.

00:02:05.310 --> 00:02:08.720
Click this button to open up the Expression
Builder.

00:02:08.720 --> 00:02:12.450
In the lower left, there is a box called
Expression Elements.

00:02:12.450 --> 00:02:14.810
There are several different options, and click
on

00:02:14.810 --> 00:02:17.659
the one that says Common Expressions.

00:02:17.659 --> 00:02:22.969
And then to the right, we can choose either
Current Date, or Current Date and Time.

00:02:22.969 --> 00:02:25.680
We'll just choose the first one.

00:02:25.680 --> 00:02:28.489
To the right of that, double-click Date, and
it

00:02:28.489 --> 00:02:30.819
will appear in the area above.

00:02:30.819 --> 00:02:35.879
Then, when you click OK, the expression will
appear in the Property Sheet.

00:02:35.879 --> 00:02:38.879
We can now close this.

00:02:38.879 --> 00:02:44.189
And let's switch to Form view so we can test
it.

00:02:44.189 --> 00:02:46.620
When we create a new order, it clears all
of the

00:02:46.620 --> 00:02:47.609
fields,

00:02:47.609 --> 00:02:51.029
but the Pickup Date field will default to
the current date.

00:02:51.029 --> 00:02:53.159
We can still change it if we want to,

00:02:53.159 --> 00:02:56.129
but for most orders we're probably
not going to need to,

00:02:56.129 --> 00:02:59.989
and that's definitely going to
save time in the long run.

00:02:59.989 --> 00:03:02.730
In the next video we're going to finish the
Customers form

00:03:02.730 --> 00:03:09.730
by making some adjustments to the
layout 
and 
the formatting.