How to Set the Number of Decimal Places to Appear in a Microsoft Access Table Field

Video Transcript

"Hi. My name is Dave Andrews. Today, I'm going to show you how to set the number of decimal places to appear in a Microsoft Access table field. To begin, let's open up Microsoft Access by going to All Programs, Microsoft Office, and selecting Access. Let's open up a database by clicking the Office button and going to Open. I'm just going to select Database1. Now, my database has a single table in it. Right click on that table and go to Design View. We're going to add a numeric field now that has the number of decimal places defined. Let's just call the field "My Number". And as for data type, we're just going to select Number. Now after we select Number, you'll notice here in the Field Properties area, you have an option for decimal places. It's set to auto right now, but I want it to be two, if we're dealing with money. Maybe 10, if we're dealing with large numbers less than zero, or rather, less than one. And you can go up to 15. It's that easy to set the number of decimal places in your table fields. My name is Dave Andrews, and I've just showed you how to set the number of decimal places to appear in a table field."