by Harshana Weerasinghe

Access Database and Database Objects

• Introduction
• Know it before start
• Table Creation
• Table Templates
• Field Templates
• Summery

Introduction

Know it before start

 Before start the table creation, better should be know about these things.

There were some highlighted fields in above image. See properly to get an idea about these things.

1. Data Type

Objects that contain data have an associated data type that defines the kind of data; for example, character, integer, or binary, the object can contain. Data Type depend whatever the requirement. There were some specific data types for specified DB engines.

This is the main/common data type list compare with most popular DB engines.

    2. Format

Can be used this to customize the way numbers, dates and times are displayed and printed.

     1. Unique

Checked, the column contains Unique Data

2. Is Required

Checked, Column must contain Value. Shouldn’t contain NULL value, but should be empty/Blank.

Table Creation

How to keep Employee information in table?

Step 1: Define which information collect

Step 2: Define Data Types

E.G.

Step 3: Go to the Datasheet View. And add columns whatever decided.

Step 4: to set Max Length, use View -> Design View.

Select the specific Column and change the value in Field Size Property.

Step 5: to add sample data or change the existing data can be used Datasheet View.

Table Templates

Microsoft Access provides some sample data tables. It’s very easy to use just Click one of table template in Table Templates in Create Tab.

Field Templates

Like table template can be use Field templates too. To use Field templates Create or Open Table in Datasheet View and click on New Field Button in the Datasheet Tab. After that you can see the small Window called Field Templates. To add field template to table Drag and Drop selected Field to your table or Double click on it.

Summery

Data Type decides the values keep the Column and Column data types depend on the requirement. Format property used to customize the input and output data in data table and it minimize the mistakes. When select the Unique, the column data cannot be duplicated. And also select the isRequired column values shouldn’t be NULL. Tables can be design using Design View or Datasheet View, but there was limitations in Datasheet View. To edit advance can be used Design View. Datasheet View is using to View/Add/Edit/Delete data. Table Templates and Field Templates is good feature in Access and it can be use to design data table quickly and easily.

Drop a mail to mail@harshana.net for more clarifications.

                                                                                                         Previous article