From the course: Access 2019 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Additional field properties
From the course: Access 2019 Essential Training
Additional field properties
- [Instructor] There are a few other field properties available in the table design view that are worth exploring. So let's take a look at those using the guests table. I'll go ahead and select it and open it up into design view. The first one I wanna look at is the field size property. Right now, I'm selected on the GuestID field. We're taking a look at the field size, and it is set to a long integer. This will allow new values to increment in whole numbers from one to two to three and so on. Long integer fields store whole numbers only, no decimals and include a range from about negative two billion to positive two billion so we have plenty of space to grow in this field. For a short text datatype such as our FirstName field, we can see that the field size is listed as 255. This is the number of characters or the maximum number of characters that we can store in this field. Now, if you know that you're only going to need a certain number of characters, you can make your databases…
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.