Sorting And Filtering Forms
In this post, we will be providing you with some techniques for sorting and filtering records in a form. Just like a datasheet, we can alter the order of the records see. You can sort a form by clicking into…
Robert Austin
Using The Like Operator In Queries
In this post, we will be demonstrating how you can use the LIKE operator in queries. Being able to filter queries is an important part of effective data retrieval. Although we often want to find exact matching values, sometimes we…
The Query Designer Explained
In this post, we will be explaining the constituent parts of the query designer. To open the query designer navigate to the Create Tab of the Ribbon and click on the Query Design icon. In the image below we…
Formatting A Datasheet
In this blog post we show you how to format a datasheet in MS Access. Although, generally, datasheets are boring grey forms that we can use to sort and filter data, we can actually format them to make their appearance…
Sorting and Filtering A Record In Datasheet View
In this post, we will be showing you how to sort and filter a record in Datasheet view. Access has an array of filtering and sorting tools which are accessible in the Sort & Filter group on the Ribbon …
Deleting A Record In Datasheet View
In this post, we are going to show you how to delete a record in datasheet view. Open up a form in MS Access in datasheet view. Select the record you wish to delete by clicking in the circled…
Adding A Record In Datasheet View
In this post, we will be showing you how to add a record to a datasheet. Open up a form in datasheet view in MS Access. In the table below we have 3 fields – ItemID, Description and UnitPrice. What…
Indexes
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…
How To Set A Primary Key
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…
Field Data Types
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…
Adding Fields To A Table
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…
Using Templates and Examples
In this post, we talk you through downloading a sample database using MS Access. Access has several templates and sample database applications available for download and install. The purpose of these programs is to demonstrate the capabilities of Access. These…
How To Create A New Table In Access
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…
How To Open Up The Entity Relationship Diagram In Access
In this post, we show you how to open up the Entity Relationships Diagram in MS Access. Creating relations between tables is a fundamental part of an Access database but trying to keep all those relations in mind can get…
