WEBVTT Kind: captions Language: en 00:00:11.580 --> 00:00:16.410 I'm working on a form that we can use in our bakery to view and edit the customer information. 00:00:16.410 --> 00:00:20.630 And I know the employees are going to be using this form a lot, so I want to make it as pleasant 00:00:20.630 --> 00:00:22.770 and easy to use as possible. 00:00:22.770 --> 00:00:27.230 To do that, I'm going to need to make some adjustments to the layout and formatting. 00:00:27.230 --> 00:00:31.470 The first thing I'm going to do is add a command button that the user can click to search for 00:00:31.470 --> 00:00:33.140 a specific record. 00:00:33.140 --> 00:00:37.080 To add a command button, you'll need to be in Layout view. 00:00:37.080 --> 00:00:43.210 In the Design tab, find the Controls group… click on the drop-down arrow… and make sure 00:00:43.210 --> 00:00:47.400 that Use Control Wizards is selected. 00:00:47.400 --> 00:00:49.830 And then select the Button command. 00:00:49.830 --> 00:00:55.570 Then, in the form, click where you want the button to go. 00:00:55.570 --> 00:00:58.910 There are many different actions that you can choose from, and they're organized under 00:00:58.910 --> 00:01:00.720 different categories. 00:01:00.720 --> 00:01:05.330 Most of the time, you're probably just going to use actions from the first four categories. 00:01:05.330 --> 00:01:12.000 The one that I want is in Record Navigation… and it's called Find Record. 00:01:12.000 --> 00:01:13.640 Then click Next. 00:01:13.640 --> 00:01:19.100 Here, you can choose whether you want the button to display text or a picture. 00:01:19.100 --> 00:01:24.530 In this case, I'm going to use the default binoculars picture, but you could also browse 00:01:24.530 --> 00:01:29.390 for another picture if you want. 00:01:29.390 --> 00:01:31.990 In the last step, you can type a name for the button. 00:01:31.990 --> 00:01:34.180 I'll call it Search. 00:01:34.180 --> 00:01:38.000 This text will not appear on the button, but it may be helpful if you need to edit the 00:01:38.000 --> 00:01:40.740 button later with the Property Sheet. 00:01:40.740 --> 00:01:45.360 Click Finish… and your button will appear on the form. 00:01:45.360 --> 00:01:51.220 At this point, I want to move and resize the fields so we can get a better view of everything. 00:01:51.220 --> 00:01:55.810 I think everything would fit a lot better if I put it into two columns. 00:01:55.810 --> 00:01:58.730 You can adjust the fields just like you would in a report. 00:01:58.730 --> 00:02:06.729 For example, you can click on a cell… and then drag the edge to resize the column. 00:02:06.729 --> 00:02:12.360 Next I'm going to go to the Arrange tab… and then in the Rows & Columns group, select 00:02:12.360 --> 00:02:14.870 Insert Right to add a column. 00:02:14.870 --> 00:02:19.080 I'm going to click it twice so that we have one column for the field labels, and another 00:02:19.080 --> 00:02:21.720 for the actual fields. 00:02:21.720 --> 00:02:29.440 Then I'll just click and drag the fields where I want them. 00:02:29.440 --> 00:02:33.490 You may end up with some empty rows, and you can just click on them and press the Delete 00:02:33.490 --> 00:02:37.260 key to get rid of them. 00:02:37.260 --> 00:02:40.980 And for the Other Notes field, I'd like it to be larger, so I'm going to merge it with 00:02:40.980 --> 00:02:43.160 the other cells in its row. 00:02:43.160 --> 00:02:48.770 I'll hold down the Shift key while I'm clicking each cell… and then on the Arrange tab, 00:02:48.770 --> 00:02:53.380 I'll click the Merge command. 00:02:53.380 --> 00:03:00.069 Finally, I'm going to make some adjustments to the colors and fonts, just to make it look 00:03:00.069 --> 00:03:01.520 a little nicer. 00:03:01.520 --> 00:03:06.080 And again, this is exactly like formatting a report. 00:03:06.080 --> 00:03:10.180 You can go to the Design tab to add a logo or choose a theme. 00:03:10.180 --> 00:03:13.490 But keep in mind, the theme applies to your entire database. 00:03:13.490 --> 00:03:17.260 So if you want to make changes that will only apply to this form, you can use the commands 00:03:17.260 --> 00:03:20.030 in the Format tab. 00:03:20.030 --> 00:03:24.819 Here you can adjust the colors and fonts of individual elements in the form. 00:03:24.819 --> 00:03:31.260 I'm going to Control-click the fields that I want to change… 00:03:31.260 --> 00:03:46.890 And now I can adjust the fill color… outline color… and outline weight. 00:03:46.890 --> 00:03:52.990 I'm also going to choose a background color… and add a few final touches. 00:03:52.990 --> 00:03:57.440 Ok, my form is now finished. 00:03:57.440 --> 00:03:59.870 I've added the logo for our bakery… 00:03:59.870 --> 00:04:05.140 I've added a shadow to the Search box from the shape effects menu… and I've also changed 00:04:05.140 --> 00:04:06.849 the font of the form header. 00:04:06.849 --> 00:04:12.030 Now it may take some time to get the form exactly how you want it, but once you do, 00:04:12.030 --> 00:04:15.470 you'll have a professional-looking form that's easy for people to use.