From the course: Access Basics for Excel Users
Join today to access over 24,700 courses taught by industry experts.
Data properties
From the course: Access Basics for Excel Users
Data properties
- [Instructor] Did you know that it's quick and easy to view and amend the properties of your data fields? Make sure that the database file for this movie is open and then double click on the table called EmploymentData. Now let's select the Table Fields menu, and what you are looking at are the properties for either the field or column that has been selected. For example, if we go ahead and select the Date column here, you'll see that the Data Type is Date/Time and the format is mmmm-yy. Now we can easily change this by selecting the dropdown box and choosing one of the default options. Or if we're looking for something a little bit more fancy, we can go ahead and select the Design View here. Then select the field that we wish to amend, which is the Date field. And in the format box here, we can change the format to mm-yy. Then go back to Datasheet View. Select Yes when prompted, and you'll see that the date format has been changed for every single record. Okay, moving right along…
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.