From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Join today to access over 24,700 courses taught by industry experts.
Additional field properties
From the course: Microsoft Access Essential Training (Office 2021/LTSC)
Additional field properties
- [Instructor] There are a few additional field properties available in table Design view that are worth exploring. Let's open up the customer's table in Design view and this time I'll do it in a slightly different way, in the navigation pane, I'll just right click on the customer's table and we'll jump straight into Design view. The first property that I want to look at is called field size. For the customer ID field, which is an auto number data type, the field size is set to long integer. Long integer fields store whole numbers only, no decimals, and include a range from about - 2 billion to positive 2 billion, so we have plenty of space to grow with this field size. For the auto number data type, we also have a property for new values and it's currently set to increment. This is what allows our customer ID numbers to automatically step from one to two to three and so on as we add new customers to this data table.…
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.