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. Set up a relationship between three tables.Įverything we’ve done so far with our table has been in Datasheet View.Add two more tables (for the relationship).This article is Part 2 of the Microsoft Access tutorial.

Microsoft access 2013 tutorial part 2