Join Gini von Courter for an in-depth discussion in this video Modifying a view, part of Creating Access Web Apps in SharePoint 2013.
- Let's make some modifications to this list view for the employees table in our app. I'm going to click the Edit button. And notice I'm clicking the button in the view itself, and it opens this particular view for editing. If I wanted to add fields to this form, I can. They're right here. So, if I wanted, for example, the ID field to be exposed, it's not right now, but I could bring it in. And notice, as I do, everything else moves around so that there's a place for it. If I don't want it, I simply delete it after I drop it somewhere.
If I want to change this so it says, "Employee Number", I select it. Notice that it says "Employee Number Label". That's the control name. And if I double click it, it will allow me to change it. I'll know that I'm on a label because it will say "label". If I right click here, it says it's a text box, and text boxes are used to enter and view data. So there's my employee number. Now I'd like to have my first and last name in the same place. That would be really good. If I choose first and last name, I can hold control and grab them both.
And notice that as I pull them over here, everything else moves to make room for them. That's a feature I actually like a lot. And I'm going to grab my company and drag it up to line it up with my Employee Name, which allows me then, and notice it automatically adjusted along this gutter between the labels and the text boxes. This will give me space, then, to move my last name. I can also lasso here if I wish. It's a little more difficult, but anything I touch, notice I don't need to include everything, so if I simply touch on both of those, they're both selected.
And now I have my first and last name, and again, I can just drop it somewhere close to there, and I'll be in pretty good shape. I'd like to move the job title, and notice that if I select only the text box, the label does not move with it. There's no assumption that I have to take the two of them together. And I have a space now for my email, my work phone, my home phone, and so on. Let me show you a couple of other things that you might like to do in terms of adjustments. Here's my emergency contact name and phone number. What I'd really like to do is set up a section here for emergency contact, those items of note.
So, I'm just going to lasso all three of those and use my arrow keys or my mouse to drag them down a bit. Notice as I do, they stay aligned, so I don't have to worry about my microalignment here. And when I do that, then, I have the ability to have space to add a label. And you'll notice now that I have a whole group of controls that I can use. So I have a text box for data. I have a label that I can use right now, because that's red like. I'm going to take that label, drag it up here. I can adjust the width of any of these.
Simply point and drag. It does not automatically adjust them if I leave them some place that its state is uncertain, like right here, but if I get it pretty close to that right edge, it will adjust it out for me. And then I can put Emergency Contact here, and perhaps I'll even want to put that in caps. I also have the ability to use different colors for my text right here, so I could use a dark red for that if I wished, and that's already bold. Now I can rename this to be Name or Contact Name, whichever I prefer.
Relationship in my second box, and then we have Notes. I could use all the same techniques to be able to adjust the address to be a block like Emergency Contact is. It's also, I believe, worth knowing that you can change the width of any of the text boxes. That's actually a clue for users. These numbers, none of them are more than four digits long, so I'd actually like to keep it relatively short and provide longer spaces for anything that requires more room.
Oh, I missed the Emergency Contact Phone. Let me go grab it, put it right there. There we go. And if I wanted to make sure that it was known that all the rest of these went together, I could, you know, color them all in that nice emergency or Red Cross red for their labels or not. I also have access to font size. I have access to alignment and basic formatting. Let's take a look at these other controls just so we know what they are. I have a button. These are buttons, for example. I have the ability to add a combo box, so if I have a drop down list that can be edited, I might want to use that.
I have checkboxes. I have an image control. I have an Autocomplete control. The Autocomplete control is actually used in the issues form so that when you begin entering information about an employee, for example, it will help fill in the rest of the information. So it's a special type of text box control. We have the ability to display hyperlinks and have people enter hyperlinks. We can create a subview, and that's the view that we're seeing down here, a view that's actually filtered by the view that it is placed within.
We can add a multiline text box. That's what the notes are. We can add a related items control, as you see down below. So we have lots of choices, a good, healthy set of controls that we can use for our form. And many of these are the same controls that you will see in Microsoft Access. Once you're done editing the view, we'll want to save it. And I'm simply going to close that tab, and notice there are my changes. And those same changes will be reflected when we launch the app.
- Creating a new app
- Building tables from different sources
- Creating relationships between tables
- Working with views
- Using macros for automation
- Saving your app in an app package
Skill Level Intermediate
Q: The "Using the If macro action" movie seems to end in the middle of troubleshooting. What am I missing?
Q: This course was updated on 08/25/2017. What changed?
A: New videos were added that cover changes for Access Web Apps and migrating Access Web App data to SharePoint Online.