Microsoft Access 2010,Introduction to data types and field properties/Field size property/Data types in relationships and joins/Data type reference/Supported field properties



Introduction to data types and field properties

Microsoft Access 2010

Every table is made up of fields. The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store. This article describes the data types and other field properties available in Microsoft Access 2010, and includes additional information in a detailed data type reference section.
In this article

Overview

Data types can seem confusing for example, if a field's data type is Text, it can store data that consists of either text or numerical characters. But a field whose data type is Number can store only numerical data. So, you have to know what properties are used with each data type.
A field's data type determines many other important field qualities, such as the following:
  • Which formats can be used with the field.
  • The maximum size of a field value.
  • How the field can be used in expressions.
  • Whether the field can be indexed.
A field's data type can be predefined or you will select a data type depending on how you create the new field. For example, if you create a field from the Datasheet view and:
  • Use an existing field from another table, the data type is already defined in the template or in the other table.
  • Enter data in a blank column (or field), Access 2010 assigns a data type to the field based on the values that you enter or you can assign the data type and format for the field.
  • On the Modify Fields tab, in the Fields & Columns group, click Add Fields, Access 2010 displays a list of data types that you can select from.

When to use which data type

Think of a field's data type as a set of qualities that applies to all the values that are contained in the field. For example, values that are stored in a Text field can contain only letters, numbers, and a limited set of punctuation characters, and a Text field can only contain a maximum of 255 characters.
 Tip   Sometimes, the data in a field may appear to be one data type, but is actually another. For example, a field may seem to contain numeric values but may actually contain text values, such as room numbers. You can often use an expression to compare or convert values of different data types.
The available data types in Access 2010 are, Basic Types, Number, Data and Time, Yes/No, and Quick Start. The following tables show you the formats available for each data type and explain the effect of the formatting option.

Basic Types

Format
Use to display
Text
Short, alphanumeric values, such as a last name or a street address.
Number
Numeric values, such as distances. Note that there is a separate data type for currency.
Currency
Monetary values.
Yes/No
Yes and No values and fields that contain only one of two values.
Date/Time
Date and Time values for the years 100 through 9999.
Rich Text
Text or combinations of text and numbers that can be formatted using color and font controls.
Calculated Field
Results of a calculation. The calculation must refer to other fields in the same table. You would use the Expression Builder to create the calculation.
Attachment
Attached images, spreadsheet files, documents, charts, and other types of supported files to the records in your database, similar to attaching files to e-mail messages.
Hyperlink
Text or combinations of text and numbers stored as text and used as a hyperlink address.
Memo
Long blocks of text. A typical use of a Memo field would be a detailed product description.
Lookup
Displays either a list of values that is retrieved from a table or query, or a set of values that you specified when you created the field. The Lookup Wizard starts and you can create a Lookup field. The data type of a Lookup field is either Text or Number, depending on the choices that you make in the wizard.
 Note   Lookup fields have an additional set of field properties, which are located on the Lookup tab in the Field Properties pane.

Number

Format
Use to display
General
Numbers without additional formatting exactly as it is stored.
Currency
General monetary values.
Euro
General monetary values stored in the EU format.
Fixed
Numeric data.
Standard
Numeric data with decimal.
Percentage
Percentages.
Scientific
Calculations.

Date and Time

Format
Use to display
Short Date
Display the date in a short format. Depends on your regional date and time settings. For example, 3/14/2001 for USA.
Medium Date
Display the date in medium format. For example, 3-Apr-09 for USA.
Long Date
Display the date in a long format. Depends on your the regional date and time settings. For example, Wednesday, March 14, 2001 for USA.
Time am/pm
Display the time only using a 12 hour format that will respond to changes in the regional date and time settings.
Medium Time
Display the time followed by AM/PM.
Time 24hour
Display the time only using a 24 hour format that will respond to changes in the regional date and time settings

Yes/No

Data Type
Use to display
Check Box
A check box.
Yes/No
Yes or No options
True/False
True or False options.
On/Off
On or Off options.

Quick Start

Data Type
Use to display
Address
Fields for the entire postal address.
Phone
Fields for the Home Phone, Mobile Phone, and the Work Phone.
Priority
A drop-down box with the following priority options: Low, Medium, High.
Status
A drop-down box with the following options: Not Started, In Progress, Completed, Cancelled.
Tags
Displays up to three tags.
OLE Object    OLE objects, such as Word documents.

Field size property

After you create a field and set its data type, you can set additional field properties. The field's data type determines which other properties that you can set. For example, you can control the size of a Text field by setting its Field Size property.
For Number and Currency fields, the Field Size property is especially important, because it determines the range of field values. For example, a one-bit Number field can store only integers ranging from 0 to 255.
The Field Size property also determines how much disk space each Number field value requires. Depending on the field size, the number can use exactly 1, 2, 4, 8, 12, or 16 bytes.
 Note   Text and Memo fields have variable field value sizes. For these data types, Field Size sets the maximum space available for any one value.
For more details about field properties and how they work with the different data types go to the Reference for data types section. Also read the article Set the field size.

Data types in relationships and joins

A table relationship is an association between common fields in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.
A join is a SQL operation that combines data from two sources into one record in a query recordset based on values in a specified field that the sources have in common. A join can be an inner join, a left outer join, or a right outer join.
When you create a table relationship or add a join to a query, the fields that you connect must have the same or compatible data types. For example, you cannot create a join between a Number field and a Text field, even if the values in those fields match.
In a relationship or a join, fields that are set to the AutoNumber data type are compatible with fields that are set to the Number data type if the Field Size property of the latter is Long Integer.
You cannot change the data type or the Field Size property of a field that is involved in a table relationship. You can temporarily delete the relationship to change the Field Size property. However, if you change the data type, you won't be able to re-create the relationship without first also changing the data type of the related field. For more information on tables see the article, Introduction to tables.

Data type reference

When you apply a data type to a field, it contains a set of properties that you can select. Click on data types below for more information.

Attachment

AutoNumber

Currency

Date/Time

Hyperlink

Memo

Number

OLE Object

Text

Yes/No


Attachment

Purpose    Used in a field that allows attaching files or images to a record. For example, if you have a job contacts database, you can use an attachment field to attach a photo of the contact, or attach documents such as a resume. For some file types, Access compresses each attachment as you add it.
Description: ShowTypes of attachments that Access compresses
You can attach many kinds of files to a record. However, some file types that may pose security risks are blocked. As a rule, you can attach any file that was created in one of the 2007 Microsoft Office system programs. You can also attach log files (.log), text files (.text, .txt), and compressed .zip files. For a list of supported image file formats, see the table later in this section.
Description: ShowList of blocked file types

Supported field properties

Property
Use
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Required
Requires that each record has at least one attachment for the field.

Supported image file formats

Access supports the following graphic file formats without the need for additional software being installed on your computer.
  • Windows Bitmap (.bmp files)
  • Run Length Encoded Bitmap (.rle files)
  • Device Independent Bitmap (.dib files)
  • Graphics Interchange Format (.gif files)
  • Joint Photographic Experts Group (.jpe, .jpeg, and .jpg files)
  • Exchangeable File Format (.exif files)
  • Portable Network Graphics (.png files)
  • Tagged Image File Format (.tif and .tiff files)
  • Icon (.ico and .icon files)
  • Windows Metafile (.wmf files)
  • Enhanced Metafile (.emf files)

File naming conventions

The names of your attached files can contain any Unicode character supported by the NTFS file system that is used in Microsoft Windows NT. In addition, file names must follow the following guidelines:
  • Names must not exceed 255 characters, including the file name extensions.
  • Names cannot contain the following characters: question marks (?), quotation marks ("), forward or backward slashes (/ \), opening or closing brackets (< >), asterisks (*), vertical bars or pipes (|), colons (:), or paragraph marks (¶).

AutoNumber

Purpose    Use an AutoNumber field to provide a unique value that serves no other purpose than to make each record unique. The most common use for an AutoNumber field is as a primary key, especially when no suitable natural key (a key that is based on a data field) is available.
An AutoNumber field value requires 4 or 16 bytes, depending on the value of its Field Size property.
Suppose that you have a table that stores contacts' information. You can use contact names as the primary key for that table, but how do you handle two contacts with exactly the same name? Names are unsuitable natural keys, because they are often not unique. If you use an AutoNumber field, each record is guaranteed to have a unique identifier.
 Note   You should not use an AutoNumber field to keep a count of the records in a table. AutoNumber values are not reused, so deleted records can result in gaps in your count. Moreover, an accurate count of records can be easily obtained by using a Totals row in a datasheet.

Supported field properties

Property
Use
Field Size
Determines the amount of space that is allocated for each value. For AutoNumber fields, only two values are allowed:
  • The Long Integer field size is used for AutoNumber fields that are not used as replication IDs. This is the default value. You should not change this value unless you are creating a replication ID field.
 Note   Replication is not supported in databases that use a new file format, such as .accdb.
This setting makes AutoNumber fields compatible with other Long Integer Number fields when they are used in relationships or joins. Each field value requires 4 bytes of storage.
  • The Replication ID field size is used for AutoNumber fields that are used as replication IDs in a database replica. Do not use this value unless you are working in or implementing the design of a replicated database.
Each field value requires 16 bytes of storage.
New Values
Determines whether AutoNumber field increments with each new value or uses random numbers. Select one of the following:
  • Increment   Starts with the value 1 and incrementally increases by 1 for each new record.
  • Random   Starts with a random value and assigns a random value to each new record. Values are of the Long Integer field size, and range from -2,147,483,648 to 2,147,483,647.
Format
If you are using an AutoNumber field as a primary key or as a Replication ID, you should not set this property. Otherwise, choose a number format that meets your specific needs.
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key. Without a unique index, it is possible to enter duplicate values, which can break any relationships in which the key is a part.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.

Currency

Purpose    Use to store monetary data.
Data in a Currency field is not rounded off during calculations. A Currency field is accurate to 15 digits to the left of the decimal point and 4 digits to the right. Each Currency field value requires 8 bytes of storage.

Supported field properties

Property
Use
Format
Determines the way that the field appears when it is displayed or printed in datasheets or in forms or reports that are bound to the field. You can use any valid number format. In most cases, you should set the Format value to Currency.
Decimal Places
Specifies the number of decimal places to use when displaying numbers.
Input Mask
Displays editing characters to guide data entry. For example, an input mask might display a dollar sign ($) at the beginning of the field.
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.
Required
Requires that data be entered in the field.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.

Date/Time

Purpose    Use to store time-based data.

Supported field properties

Property
Use
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Format
Determines the way that the field appears when it is displayed or printed in datasheets, or in forms or reports that are bound to the field. You can use a predefined format or build your own custom format.
Description: ShowList of predefined formats
Description: ShowLists of components that you can use in custom formats
IME Mode
Controls the conversion of characters in East Asian versions of Windows.
IME Sentence Mode
Controls the conversion of sentences in East Asian versions of Windows.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Input Mask
Displays editing characters to guide data entry. For example, an input mask might display a dollar sign ($) at the beginning of the field.
Required
Requires that data be entered in the field.
Show Date Picker
Specifies whether to show the Date Picker control.
 Note   If you use an input mask for a Date/Time field, the Date Picker control is unavailable regardless of how you set this property.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.

Hyperlink

Purpose    Use to store a hyperlink, such as an e-mail address or a Web site URL.
A hyperlink can be a UNC path or a URL. It can store up to 2048 characters.

Supported field properties

Property
Use
Allow Zero Length
Allows entry (by setting to Yes) of a zero-length string ("") in a Hyperlink, Text, or Memo field.
Append Only
Determines whether to track field value changes. There are two settings:
  • Yes Tracks changes. To view the field value history, right-click the field, and then click Show column history.
  • No Does not track changes.
 Warning    Warning Setting this property to No deletes any existing field value history.
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Format
Determines the way that the field appears when it is displayed or printed in datasheets or in forms or reports that are bound to the field. You can define a custom format for a Hyperlink field.
IME Mode
Controls the conversion of characters in East Asian versions of Windows.
IME Sentence Mode
Controls the conversion of sentences in East Asian versions of Windows.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Required
Requires that data be entered in the field.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.
Unicode Compression
Compresses text that is stored in this field when less than 4,096 characters are stored.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.

Memo

Purpose    Use to store a block of text that is more than 255 characters long and is formatted text.

Supported field properties

Property
Use
Allow Zero Length
Allows entry (by setting to Yes) of a zero-length string ("") in a Hyperlink, Text, or Memo field.
Append Only
Determines whether to track field value changes. There are two settings:
  • Yes   Tracks changes. To view the field value history, right-click the field, and then click Show column history.
  • No   Does not track changes.
 Warning   Setting this property to No deletes any existing field value history.
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Format
Determines the way that the field appears when it is displayed or printed in datasheets or in forms or reports that are bound to the field. You can define a custom format for a Memo field.
IME Mode
Controls the conversion of characters in East Asian versions of Windows.
IME Sentence Mode
Controls the conversion of sentences in East Asian versions of Windows.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Required
Requires that data be entered in the field.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.
Unicode Compression
Compresses text that is stored in this field when less than 4,096 characters are stored.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.
Description: Top of PageTop of Page

Number

Purpose    Use to store a numeric value that isn't a monetary value. If you might use the values in the field to perform a calculation, use the Number data type.

Supported field properties

Property
Use
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Decimal Places
Specifies the number of decimal places to use when displaying numbers.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Field Size
Select one of the following:
  • Byte — Use for integers that range from 0 to 255. Storage requirement is 1 byte.
  • Integer — Use for integers that range from -32,768 to 32,767. Storage requirement is 2 bytes.
  • Long Integer — Use for integers that range from -2,147,483,648 to 2,147,483,647. Storage requirement is 4 bytes.
 Tip   Use Long Integer when you create a foreign key to relate to another table's AutoNumber primary key field.
  • Single   Use for numeric floating point values that range from -3.4 x 1038 to 3.4 x 1038 and up to seven significant digits. Storage requirement is 4 bytes.
  • Double   Use for numeric floating point values that range from -1.797 x 10308 to 1.797 x 10308 and up to fifteen significant digits. Storage requirement is 8 bytes.
  • Replication ID   Use for storing a globally unique identifier required for replication. Storage requirement is 16 bytes. Note that replication is not supported using the .accdb file format.
  • Decimal   Use for numeric values that range from -9.999... x 1027 to 9.999... x 1027. Storage requirement is 12 bytes.
 Tip   For best performance, always specify the smallest sufficient Field Size.
Format
Determines the way that the field appears when it is displayed or printed in datasheets, or in forms or reports that are bound to the field. You can use any valid number format.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Input Mask
Displays editing characters to guide data entry. For example, an input mask might display a dollar sign ($) at the beginning of the field.
Required
Requires that data be entered in the field.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.
Description: Top of PageTop of Page

OLE Object

Purpose    Use to attach an OLE Object, such as a Microsoft Office Excel spreadsheet, to a record. If you want to use OLE features, you must use the OLE Object data type.
In most cases, you should use an Attachment field instead of an OLE Object field. OLE Object fields support fewer file types than Attachment fields support. In addition, OLE Object fields do not let you attach multiple files to a single record.

Supported field properties

Property
Use
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Required
Requires that data be entered in the field.
Text Align
Specifies the default alignment of text within a control.
Description: Top of PageTop of Page

Text

Purpose    Use to store up to 255 characters of text.

Supported field properties

Property
Use
Allow Zero Length
Allows entry (by setting to Yes) of a zero-length string ("") in a Hyperlink, Text, or Memo field.
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Field Size
Enter a value from 1 to 255. Text fields can range from 1 to 255 characters. For larger text fields, use the Memo data type.
 Tip   For best performance, always specify the smallest sufficient Field Size.
For example, if you are storing postal codes of a known length, you should specify that length as the Field Size.
Format
Determines the way that the field appears when it is displayed or printed in datasheets or in forms or reports that are bound to the field. You can define a custom format for a Text field.
IME Mode
Controls the conversion of characters in East Asian versions of Windows.
IME Sentence Mode
Controls the conversion of sentences in East Asian versions of Windows.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Required
Requires that data be entered in the field.
Smart Tags
Attaches a smart tag to the field.
Text Align
Specifies the default alignment of text within a control.
Unicode Compression
Compresses text that is stored in this field when less than 4,096 characters are stored.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.
Description: Top of PageTop of Page

Yes/No

Purpose    Use to store a Boolean value.

Supported field properties

Property
Use
Caption
The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.
 Tip   An effective caption is usually brief.
Default Value
Automatically assigns the specified value to this field when a new record is added.
Format
Determines the way that the field appears when it is displayed or printed in datasheets, or in forms or reports that are bound to the field. Select one of the following:
  • True/False   Displays the value as either True or False.
  • Yes/No   Displays the value as either Yes or No.
  • On/Off   Displays the value as either On or Off.
Indexed
Specifies whether the field has an index. There are three available values:
  • Yes (No duplicates)   Creates a unique index on the field.
  • Yes (Duplicates OK)   Creates a non-unique index on the field.
  • No   Removes any index on the field.
 Note   Do not change this property for a field that is used in a primary key.
Although you can create an index on a single field by setting the Indexed field property, some kinds of indexes cannot be created in this manner. For example, you cannot create a multi-field index by setting this property.
Text Align
Specifies the default alignment of text within a control.
Validation Rule
Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.
Validation Text
Enter a message to display when a value that is entered violates the expression in the Validation Rule property.

No comments:

Bollywood Hot Photo Gallery

 

Other Posts >>

Transforming Numerical Systems (5) What is (3) Features (2) "मैग्नेटिक हिल" साइंस के पास भी नहीं है जवाब (1) '43 (1) 'घाघरा' गाने पर इस बाला के ठुमके देख माधुरी भी रह जाएंगी दंग (1) 10 Amazing Animal Disguises (w/ video) (1) 10 Point Checklist for creating a WordPress Theme (1) 10 Ways to Get Traffic for Free (1) 10 ऐसे क्रिकेटर जो खेलते-खेलते मैदान से ही दुनिया छोड़ गये (1) 1000 से ज्यादा लोगों को कोर्ट में घसीटा (1) 2 मुंह वाला सांप (1) 20 Creepiest Ghost (1) 200' बार हुआ युवती से रेप (1) 25 हजार रुपये में ओला में रजिस्‍टर करें (1) 302/Day And You Will Not Believe How He's Doing It! India News investigates Work From Home Opportunities. (1) 33 साल पुराने मर्डर का रहस्य खुला जब खूनी ने खुद फ़ोन कर के अपना जुर्म कबूला (1) 4 साल में देश के 11 परमाणु वैज्ञानिकों की संदिग्ध हालात में मौत (1) 40 Magic Tricks in 4 Minutes - Day 279 of 365 (1) 4G से मत होइए खुश (1) 4जी की 10 जरूरी बातें जो आपको भी जाननी चाहिए (1) 5 Prestashop Theme Generators (1) 5 जगहों से जुड़े सच जानकर आपके रोंगटे खड़े हो जाएंगे (1) 5 बातें और हर लड़की आपके पीछे आएगी (1) 8 Ways to Spot a Liar (1) 8085 Microprocessor (1) ADBMS (1) Aishwarya Rai Photos Gallery (1) Aishwarya Rai Sexy look (1) Alia bhatt Bollywood Actress Hot Images (1) All Banks Official Missed call balance enquiry number (1) Amazing Magic Show: One Of The Best Magic Shows (1) Amisha Patel Hottest Photos (1) Amitabh Bachchan (1) Architechture of 8085 (1) Architecture of Database Systems (1) Artisteer 4.2 RC v4.2.0 build 60559... (1) Ayesha takia Bollywood Actress Hot Images (1) BREAKING NEWS: New Delhi Man Makes Rs.6 (1) Best Answer to explain OOPS (1) Best Free WordPress Hosting options (1) Best Love Shayari (1) Best Tool for Freelancers in Web Development (1) Binary 2 Decimal (1) Binary Numbers (1) Blog Directories To Submit Your Blog for geting traffic (1) Bollywood Actress Bipasha Basu Romantic Photos (1) Bollywood Actress Kareena Kapoor Hot Photos (1) Bollywood Actress Sonam Kapoor Hot Photos (1) Boost WiFi Modem speed (1) Browser (1) C++ Program To display the half pyramid of * (1) Casting Director: Dharmendra K. (1) Choosing an Internet service (1) Configure Your PC to a Local Area Network (1) Create your own Ethernet cables with this simple training (1) DBMS Architecture (1) DBMS Concurrency Control (1) DBMS Normalization (1) Data Warehouse Design Approaches (1) Decimal 2 Binary (1) Decimal 2 Decimal Transforming Numerical Systems (1) Decimal 2 Hexadecimal (1) Decimal System (1) Differences or Compare Data Warehouse database and OLTP database? (1) Discus (1) Discuss the top down vs bottom up approach to data warehouse (1) Display ads and Make Money (1) Download Artisteer 4.3 Full Version + Keygen Crack Patch (1) E-mail (1) ER Diagram Representation (1) Easy Magic Tricks for Everyone (1) Email Messages (1) Email protocols: POP (1) English Hindi Vocabulary…. (1) Example (1) Explain The structure of E-mail addresss ? (1) Explain various protocols used in E-mails (1) FREE SMS collection... “You only live once (1) FREE WordPress Plugins (1) Features and types (1) Features of Java Programming Language (1) First live video at Facebook head quarter by Facebook CEO Mark Zuckerberg (1) Free Acting Audition In Ajmer (1) Funny Pictures (1) General Post Office(GPO) (1) Ghost Photos (1) Hansika motwani latest hot unseen photos (1) Hardware needed (1) Hex 2 Binary 2 Octal Transforming Numerical Systems (1) Hexadecimal 2 Decimal Transforming Numerical Systems (1) Hot & Sexy Wallpaper (1) Hot Photos and Wallpapers (1) How To Submit Blogger Sitemap To Google Webmaster Tools? (1) How a Browser Retrieves a Web Page (1) How do I connect to the Internet (1) How do I disable the video autoplay ? (1) How to Get Free Wi-Fi Access Anywhere (1) How to Hack Wi-Fi Passwords (1) How to Make Money Online with Google Adsense (1) How to Make Popcorn at Home (1) How to Make a Website without Learning HTML and CSS (1) How to Make an Ethernet Cable - Cat5 (1) How to Read Minds (1) How to Spot a Liar (1) How to get Traffic from Social Bookmarking sites (1) How to register a free domain name? (1) IMAP and MAPI (1) ISO 32 Bit and 64 Bit 2015 (1) ISP (1) Indian girls in saree (1) Indian glamour actress sunny leone hot Images-Sexy Wallpapers (1) Internet Service Provider (1) Is data warehouse normalized or denormalized (1) Java characteristics & features (1) Kajol (1) Kangna Ranaut Indian Actress hot Wallpapers Pictures (1) Katrina Kaif Hot Photo (1) Katrina Kaif Images (1) Katrina Kaif Pics (1) Katrina Kaif Pictures (1) Katrina Kaif Sexy Photos (1) Katrina Wallpapers (1) Keyboard (1) Latest Hot Photos of Sonakshi Sinha ~ Bollywood (1) Local Area Network (1) Lose 3 kgs of Stomach Fat EVERY Week with Just 2 Diet Tips. Bollywood Stars use this simple trick to melt fat off their bodies! (1) Love (1) Lucknow (1) MMC Console Window Keyboard (1) Madhuri Dixit Hot Sexy Photo Gallery (1) Make free internet calls (1) Mallika Sherawat Photo Gallery (1) Mars planet facts news & images (1) Most Beautiful Photos of Deepika Padukone (1) NASA confirms that liquid water flows on Mars (1) Nasa scientists find evidence of flowing water on Mars (1) Negative Binary Numbers (1) OOPS Concept (1) Octal System (1) Online transaction processing (1) Open X Ad Server (1) PHP Script. (1) PHP-based online shopping cart (1) Phir Jee Le Zara Ye Zindagi (1) Photos (1) Photos For Smile (1) Pics ... (1) Priyanka chopra bollywood (1) Programming Language (1) Protect Your Facebook Account from Spam and Scams (1) Protect Your WordPress Website against Spamming (1) RARE PHOTOS (1) RJ45 Connectors (1) Rani Mukherjee Hot Sexy Bikini Images (1) Rare Bollywood Pics You’ve Never Seen! Part (1) Reasons for creating a data mart (1) Relational Algebra (1) SEXY भारतीय लड़किया साड़ी में (1) Sexy Bollywood Actress Anushka Sharma Hot Pics (1) Sexy Celina Jaitley Photos and Pictures (1) Sexy Photos Gallery (1) Shayari Collections (1) Shayari on Human Feeling (1) Shortcuts (1) Speech In English / Hindi (1) Sri Divya Latest Hot Stills (1) Stills (1) Sweet and Sexy Pics Of Bollywood Actress Shilpa Shetty ... (1) Switching from decimal to binary numbers (1) TAX saving (1) TELNET (1) TELecommunication NETwork (1) Teachers' Day (1) Thank you teacher (1) Top 5 Animation/VFX Tools of the Year (1) Top 5 Joomla Template Generators (1) Top Sexy Pictures of Preity Zinta (1) Toshiba launches Android-powered TV (1) Uniform Resource Locator (1) Unity 4.6.1 Final + Patch Free Download (1) Untold stories of postmortem room (1) VFX (1) Very Sad Love Shayari for Broken Heart हिंदी में ... (1) Video Full video (1) Vidya balan bollywood actress hot and sexy image gallery (1) Web (1) What are the responsibilities of a data warehouse project manager? (1) What do you understand by Business intelligence (1) What do you understand by OLTP ? (1) What is FTP (1) What is GOPHER ? (1) What is a Search Engine? (1) What is a Web Browser (1) What is the Data mart (1) Which CMS is best as Content Manager ? (1) While You’re in Your 20s (1) Why (1) Why To Use Content Management System ? (1) Why You Hate the Sound of Your Own Voice (1) Windows 10 All Editions (1) Windows 10 Free Download (1) Wish you a Happy Teachers Day. (1) Wordpress Plugins (1) Xara Web Designer Premium v9.2.3.29638 (x32bit / x64bit) Full With Crack (1) Xender For PC free download Windows XP/7/8/8.1 (1) and how do I use it to transfer files? (1) bollywood actress (1) bollywood actress hot and sexy image gallery (1) but if you do it right (1) ca (1) data-warehouse (1) denormalization process for creating data warehouse (1) designs (1) explain with example (1) fb (1) form (1) ftp (1) hot indian bride pictures (1) hot alia bhatt (1) hot and sexy photos (1) hot sexy indian actress (1) how-attract-shy-girl-dating (1) indian (1) information life cycle management (ILM) definition (1) java (1) latest (1) learn english (1) linux (1) mehndi (1) mysql (1) numbers and character C++ Program to print half pyramid as using * as shown in figure below. (1) once is enough.” “In three words I can sum up everything I've (1) online dating tips (1) or OLTP (1) ost (1) php (1) pics and wallpapers collection ... (1) save tax (1) shah rukh khan house (1) spoken English (1) structure (1) the concept of information life cycle (1) tips-for-save-internet-data-pack (1) top down vs bottom up (1) trans (1) types of Database Users in Oracle or data base (1) watch Magic..Video (1) webking (1) webking host (1) website hosting cheep hosting (1) what is ISP (1) what is url (1) windows 10 key (1) www.webkinghost.in (1) you have never seen (1) अगर लड़की को हुआ है आपसे प्‍यार तो करेगी ये चीज़ें (1) अगले जन्म में क्या होंगे (1) अब मात्र 45 मिनट में बनेगा पासपोर्ट जानिए कैसे? (1) अभिनव से श्वेता ने की थी दूसरी शादी (1) अमेरिकी स्‍पेस एजेंसी नासा (1) अस्पताल जहां भूत-प्रेत करते हैं इलाज (1) आ रही है (1) आंखो की रोशनी बढ़ाने के 10 टिप्स (1) आत्माओं से बात करने का चौथा तरीका आप भी जानिए.. (1) आत्माओं से बात करने का तीसरा तरीका आप भी जानिए.. (1) आत्माओं से बात करने का दूसरा तरीका आप भी जानिए.. (1) आत्माओं से बात करने का पहला तरीका आप भी जानिए... (1) आत्माओं से बात करने का पांचवां तरीका आप भी जानिए.. (1) आत्माओं से बात करने के सरल तरीके आप भी जानिए... (1) आदमी की पर्सनालिटी उसके (1) आपबीती (1) इन देशों में चल रहा है 10G (1) इन महिलाओं के इशारे पर नाचता था अंडरवर्ल्ड. (1) इस झील में बहता है झाग (1) इस तरह से पता चलता है कि होने वाली हैं आपकी मौत... (1) उबालने पर दोगुना पोषण देंगी यह 10 सब्जियां (1) ऊप्स: एक ही समय में दीपिका की इतनी अदाएं (1) एक सैनिक की आत्मा जो कर रही 50 साल से देश की रक्षा (1) एकसाथ भेजें मेसेज (1) एमेजॉन (1) ऐसे पार्टनर ढ़ूंढ़ती हैं महिलाएं (1) ऐसे बढ़ाएं अपनी सेविंग (1) ऑनलाइन डेटिंग के लिये 5 टिप्‍स (1) काला नहीं हरा जादू है VFX (1) कुंभ (1) कुरुक्षेत्र (1) कैसे पाएं निजात मुंहासों से (1) क्या आप जानते है (1) क्रिकेट इतिहास के वे सुनहरे पल (1) खुलेआम हो रही है लूट (1) गंजेपन का नया इलाज (1) गले लगकर सोने के लिए 1 घंटे में लेती हैं 3 हजार रुपये (1) घड़ी बनाकर गिरफ्तार हुए छात्र ने छोड़ा अमेरिका (1) घर की गरीबी ने बना दिया था बार डांसर (1) घर-परिवार में झगड़ों का कारण बनते हैं ये 9 वास्तु दोष (1) चल रहा है 10G internet (1) चेहरे की चमक बढ़ाने के लिए (1) जानने के लिए जरूर पढ़ें (1) जानवरों को इंसानों से ज़्यादा फ़ोटो खिंचवाने का शौक (1) जानिए VFX की हकीकत (1) जानिए कैसे... (1) जानें कब पढ़ा गया आपका मेसेज (1) जुगाड़ के तो भईया हम ही हैं किंग (1) जो बन गए बेहद खास (1) टैक्स छूट पाने के हैं कई रास्ते (1) ट्रीटमेंट के 10 दिन बाद शुरू हो जाएगी बालों की ग्रोथ (1) डिलीट हुए मेसेज वापस पाएं (1) तीन साल बाद कार आपकी (1) तुलसी (1) तुलसी किस तरह (1) थप्पड़ मारती है आत्मा (1) दिमाग भी लेता है सांस (1) दीपावली (1) दुनिया का पहला अमर इंसान (1) दुनिया की ‘सबसे सेक्सी महिला’ (1) देखिए लोट-पोट करती तस्वीरें (1) नागा साधु (1) निराशा से निकलने और खुद को motivate करने के 16 तरीके (1) पत्नी का आरोप (1) पब्लिक ट्रांसपोर्ट में कैसे नमूने सफ़र करते हैं (1) पहली बार किसी लड़की से बात कैसे करें (1) पहली बार लड़कियाँ लड़को में क्या देखती हैं ? (1) पार्टनर के साथ ईजी हो जाएगी लाइफ (1) पूर्व जन्म में क्या थे (1) पेन ड्राइव से करें डाटा रिकवरी (1) पोस्टमॉर्टम रूम के भीतर की सच्चाई क्या है (1) पढ़ें ये टिप्स (1) फ्री मिलेगा यह फोन (1) बना दिया प्राइवेट पार्ट (1) बस के सामने दिखा भूत! फोटो हुई वायरल (1) बिग बी (1) बिग बी (Amitabh Bachchan) की लाइफ के RARE PHOTOS (1) बिना VISA 59 देशों में ट्रैवल (1) बिना मेकअप ऐसी नजर आती हैं बॉलीवुड एक्ट्रेसेस (1) बिना सिम के कैसे एक और फ़ोन नंबर रखें (1) बियर के खाली कैन से भी ऐसे बढ़ाई जा सकती है WIFI मॉडम की स्पीड... (1) बुजुर्ग की पिटाई कर टाइपराइटर तोड़ने वाला दारोगा (1) भारतीय दुल्हन (1) मंगल ग्रह पर बहता पानी होने के संकेत (1) मंगेतर ने न्यूड सेल्फ़ी भेजने से किया इंकार तो लड़के ने तोड़ी शादी (1) मछुआरे और मगरमच्छ में अनूठी दोस्ती बच्चों की तरह मगरमच्छ के साथ खेलता है (1) मजेदार तस्वीरें (1) मरे हुए बच्‍चों को फिर जिंदा करने का दावा! (1) महाभारत काल में परमाणु बम (1) महाभारत काल्पनिक नहीं (1) महिलाएं भी करतीं है यह गंदा काम... (1) माथा देखकर जानिए आप बनेंगे अधिकारी या भाग्य करेगा कंजूसी (1) मुर्गी पहले आई या अंडा (1) यह फोटोशॉप का कमाल नहीं है (1) यह है दो मुंह वाला व्यक्ति (1) यहां जुड़वां बच्चों का जन्म होना आम बात है (1) यहां हमले हुए तो खत्म हो जाएगा इंटरनेट (1) यूपी पुलिस ने महिला को निर्वस्त्र कर (1) ये बात लड़के भी नहीं जानते! (1) रखें इन 10 बातों का ध्यान (1) रहस्यमयी है यह मंदिर अंग्रेज भी नहीं खोज पाए इसके पीछे का राज (1) लग जाती है आग (1) लड़की पटाने के टिप्स या तरीके (1) लड़की पटाने के तरीके (1) लड़कों की ये 11 अदाएं लड़कियों के दिल को छू जाती हैं (1) लड़कियाँ क्या करती है जब वो किसी को पसंद करती है ! (1) वैज्ञानिकों के उड़े होश (1) वो 5 खजाने....जो बन गए रहस्य (1) शर्मीली लड़की को कैसे करें आ​कर्षित? (1) शादी से पहले पार्टनर से पूछे ये 5 सवाल... (1) शाहरुख के बंगले ( 'मन्नत' ) की INSIDE PHOTOS (1) शिष्यों की पत्नियां भी हड़प लेता था नारायण सांई (1) संकट के संकेत (1) संगीत सेरेमनी में बेटी ने किया था डांस (1) संपत्ति ही नहीं (1) सचिन तेंदुलकर (1) सड़कों पर दौड़ाई बिना ड्राइवर वाली बसें! (1) सरकार आपके अकाउंट पर रखेगी नज़र तो फेसबुक करेगा आगाह (1) सरकार देती है इसकी इजाजत (1) साउथ अफ्रीका की गुफा में मिला इंसान का नया 'रिश्तेदार' (1) सावधान! आसमान से आ रही है बड़ी आफत (1) सुलझ गई है पहेली (1) सैकड़ों सालों से इस नदी से निकल रहा है सोना (1) हर लड़की आपके पीछे आएगी (1) हिंदी में शायरी (1) हैरतअंगेज सीन्स (1)