From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Editing table structure in Design view
From the course: Access 2019 Essential Training
Editing 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. They're called views, and you could switch between the available views using the very first button, here on the Home tab. Let's go ahead and open up our Guest table to activate it. Now this button is actually a split button. The upper portion will toggle between the two most common States, and the bottom portion of the button, will open up a small menu to allow you to switch to other States, if there are any available for the object that you're working with. Now, tables only actually have two different views. We have the Datasheet View, which is what we're looking at right now, but we also have something called Design View. So let's go ahead and switch to that to see what it looks like. In Design View, the fields for the table are listed down a column here, the very first column. Next we have a column that displays the Data Type for each field. We can see that all the…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.