DATA ANALYSIS & DATABASE DESIGN: February 2011

LANGKAH -LANGKAH MEWUJUDKAN PANGKALANAN DATA

1. Start button,then clik Microsoft Office and clik Microsoft Access 2003 0or 2007

2. Create database

-create a new file

-clik blank database

-create a folder (Name your folder as a group)

- locate folder

-file name (week 2)

-and clik create

Table

1. Create table in design view

- Insert Field name and data type

2. Field properties with its description

Field size -the maximum number of character you can enter in the field. the largest maximum you can set is 255. Press F1 for help on field size.
Format -The dispaly layout for the field. Select a pre - defined format or enter a custom format. Press F1 for help on format.
Input Mask - A pattern for all data to be entered in this field.
Caption - The label for the field whem used on a form. If you don't enter a caption,the field name used as the label. Press F1 for help on caption.
Default Value - a value that is automatically entered in this field for new records.
Vadilation Rule - An expression that limits the value that can be entered in the field. Press F1 for help on vadilation rule.
Vadilation Text - the error message that appears when you enter a value prohibited by the vadilation rule. Press F1 for help on vadilation text.
Required - Require date entry in this field?
Allow Zero Lenghtt - Allow zero lenght as this field?
Indexed - An index speeds up searches and sorting on the field, but may slow updates. Selecting "yes - no Duplicate"prohibits duplicate value in the field. Press F1 for help Indexed.
Unicode Compression - Allow unicode compression for this field?
IME Mode - Which IME Mode do you want to set when the focus is moved to the field?
IME Sentence Mode -Which IME SentenceMode do you want to set when the focus is moved to the field?
Smart Tags - Smart tags to be applied to this field.