Tag Tables

In this post, we introduce the concept of indexes in MS Access. Open up a table in design view. You should see the Ribbon below. Click on the indexes button. The dialog box that opens up shows us all the…

In this post, we demonstrate a couple of different ways to set the primary key in MS Access. A Primary Key is defined as “a unique key that can uniquely identify each row in a table”. The actual Key itself…

In this post, we explain what the different data types in MS Access mean. Here are a list of data types in MS Access. Text (2013 Short Text) A String 0 to 255 characters long. Memo (2013 Long Text) A…

In this post, we show you how to add fields to a table. Open up an MS Access table in design view. We add fields to our table by entering field names in the Field Name column.  Each field must…

In this post, we show you how to create a new table in MS Access and give a brief explanation of the table designer. To begin with, we ask access to make a blank table for us.  Go to the…