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…
Month September 2013
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…
