From the course: Access Essential Training (Office 365/Microsoft)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Edit table structure in Design view

Edit table structure in Design view

From the course: Access Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Edit table structure in Design view

- [Instructor] All of the objects that we're going to be creating in Access have multiple ways to work with them. These are called views and you can switch between the available views by using the first button, here on the Home tab. The upper half of the button will toggle between two default views, or you can use the bottom half of the button to select from additional views, if any are available, for the object that you're working with. Let's go ahead and open up one of our tables, here. I'll double-click on the guest table to take a look at it. With tables, there's actually only two different views to look at, there's Datasheet View, which is what we've been working with, and then there's another view called Design View. The upper portion of the button will toggle back and forth between Design View, that I'm seeing now, and the Datasheet View that we have here. So, let's take a look at Design View and see if some of the features of working with our tables in that view. In Design…

Contents