From the course: Office 365: Access Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Solution: Creating forms - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
Solution: Creating forms
(bright music) - I hope you had fun creating a form to display and edit your menu items. Here's how I would approach the task. Typically I like to create all of my forms using the full designer, rather than starting out with something that Access has predesigned for me. I find it just gives me a little bit more flexibility in the final output. I'm going to go up, and we're going to connect our table, here. So go to the Design tab, and open up the Properties sheet. And in the Data tab we're going to connect our record source to the room service menu orders, right there. Now that that's connected, I can start adding in the different fields, here, so I'll select these items here, and we'll drag and drop these in. Now it's all about just arranging things here on the page. I'm going to add my image, going to move this over here, and I'm going to put it in the top right hand corner, and I don't need a label here, it'll be obvious that that's a picture. So go ahead and make that, and I'm…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Creating forms in Design view4m 29s
-
(Locked)
Exploring the form property sheet4m 55s
-
(Locked)
Setting data sources6m 8s
-
(Locked)
Adding components with form controls11m 28s
-
(Locked)
Understanding input boxes5m 24s
-
(Locked)
Record navigation4m 2s
-
(Locked)
Adding buttons4m 21s
-
(Locked)
Assigning a tab order4m 36s
-
(Locked)
Checking out the More Forms options5m 57s
-
(Locked)
Creating a navigation form4m 25s
-
(Locked)
Challenge: Creating forms46s
-
(Locked)
Solution: Creating forms4m 29s
-
(Locked)
-
-
-
-
-