From the course: Access 2016 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Editing table structure in Design view
From the course: Access 2016 Essential Training
Editing table structure in Design view
- 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 very first button here on the Home tab, which is this View button here. Let's go ahead and double-click on the Guests table to open it up to activate that button here. And you'll notice that it's a split button. I have a toggle here on the top that'll toggle between the two default states. And then if I click on the bottom half of the button here, you'll see some additional options, if there are any for the particular item that you're working with here. In this case, tables only have two Views. We have Datasheet View, and we have Design View. Currently, we're in Datasheet View, so that's why you see the upper half of the button will switch you into Design View. And if you click on that, it'll take you into something called Design View, and we'll talk about this in a moment. And you'll notice that that…
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
-
-
-
-
-
Establishing relationships and maintaining referential integrity6m 15s
-
Editing table structure in Design view4m 52s
-
Controlling input with masks6m 9s
-
Setting the default value2m 35s
-
Establishing validation rules4m 6s
-
Creating lookup fields3m 51s
-
Setting additional field properties5m 12s
-
Challenge: Creating tables44s
-
Solution: Creating tables5m 50s
-
-
-
-
-
-
-
-
-
-
-