By setting it to =Now() we tell Access to automatically set the field to the current date and time when the record is created. The Default Value tells Access to set the field to that value whenever a new record is created. By using General Date, we tell Access to store this field in a general date format. The Format property tells Access what format to store the data in. Here they are again in case that’s too small to read: Property Select the DateCreated field by clicking on it, then set the following properties: Clicking on a field name in Design View displays that field’s properties in the bottom frame. When you click on a field, the field’s properties will be displayed in the bottom frame. Once in Design View, you will see the fields listed vertically alongside their data type. If the table doesn’t already have a name, you must provide a name now. Name it Customers: When switching to Design View, you will be prompted to save any changes. The first time you do this, you will be prompted to provide a name for your table. When you switch to Design View, you will be prompted to save your changes (if you haven’t already done so). You can switch between views as often as you like by clicking the applicable button/icon.
To switch to Design View, click the View button in the Ribbon, or click the Design View icon at the bottom of the screen: You can switch between views using the button on the Ribbon or the icons at the bottom. It can make it a bit easier to set up the fields. Datasheet View displays our table as a grid – like a worksheet in Excel.Īccess also provides another view of our table – Design View.ĭesign view is just another way of looking at the table when setting it up.
Add two more tables (for the relationship).
This article is Part 2 of the Microsoft Access tutorial.