课程: Access 2016 Essential Training

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Setting additional field properties

Setting additional field properties

课程: Access 2016 Essential Training

开始一个月试用 购买团队方案

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…

内容