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…
Category Access Blog
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…
What is Microsoft Access?
So, what is MS Access? MS Access is a tool designed for effective data management. It is used by millions the world over and is an effective substitute for Excel when the quantity of data gets too large to control effectively. MS…
Normalization
Normalization is the process of rearranging the fields and tables of a relational database to reduce data redundancy and dependency. Normalization typically consists of splitting up big tables into smaller sized (and fewer redundant) tables along with characterizing relationships between them. The objective would be to separate data to ensure that additions, deletions and alterations to a field can be made in only one table and then propagated throughout the remainder of the database through defined…
