From the course: Access 2016 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Setting additional field properties

Setting additional field properties

From the course: Access 2016 Essential Training

Start my 1-month free trial Buy for my team

Setting additional field properties

“

- There are a few other Field Properties available in the Table Design View that are worth exploring, and I'd like to take a look at them inside of our Guest Table, so I'll go over here in the Navigation Pane, and I'll right-click on it and choose Design View. Now the very first field here is called the GuestID. The Data Type is this AutoNumber field, and if I take a look at the Field Properties down here on the bottom, you'll see that it's set to a Long Integer value. The Long Integer will only store whole numbers, so no decimals here. It'll also include a range from about negative two billion to positive two billion, so we have plenty of space to grow in this field size. Also, if you take a look down below, we have this New Values is set to Increment. That's part of the AutoNumber Data Type so that every Guest that we add into this table will automatically get a new GuestID assigned to them. If we go down a field here to the FirstName field, you'll notice it's listed as Short Text…

Contents