DATA ANALYSIS & DATABASE DALAM TABLE,QUERRY, FORM AND REPORT.

TABLE

• CLICK Creat new line.

• CLICK blank database.

• File name: INTELENGTSIAN TECH 2.
• click create.

• TABLE and click create table in design view.

• TABLE 1 taip cust_no:text(6), cust_ic:text(12), cust_name:text(50), cust_address:text(100), cust_mobile:number. And click pamery key. And save name table: CUSTOMER.

• CLICK table and click create table in design view.

• Table 2 taip IdProduct:text(6),  ProductName:text(100), CustNO:text(6). And click pamery key. AND save name table:PRODUCT.

• CLICK table and click create table in design view.

• TABLE 3 taip BookingNo:text(6), Book_date:data/time, PricePerUnit:number, Quantity:number, Grand_Total:number, Payment_Status:yes/no,  Paymet_Date:data/time,  IdProduct :text(5) and click pamery key . And save name table: BOOKING.

• CLICK table and click create table in design view.

• TABLE 4 taip IDDelivery :text(6), Delivery_Date:date/time, Delivery_status:yes/no, TypeOfDelivery:text(50),  BookingNo:text(6) and click primary key and save name table: DELIVERY.

• Relationship.

QUERRY

• Then CLICK QUERY and create query in design view.

• Show table and click Customer,Product and Booking.

•  Click field and put the box Cust_no,Cust_name,Cust_address, Cust_mobile,IdProduct, ProductName,BookingNo,Book_Date,PricePerUnit,Quantity,Grand_Total.

• Then,CLICK (CTRL S)and save query name:BOOKING RESIT.

• CLICK QUERY and create query by using wizard.

• CLICK table\query on by step first Customer,Booking and Delivery.
• Masukkan mengenai: Cust_no,Cust_address,Cust_mobile,Cust_name,BookingNO,Book_date, Grant_total,Payment_date,IdDelivery,Delivery_date,TypeOfDelivery.

• CLICK NEXT AND FINISH.

FORM

• CLICK create query by using wizard.

• CLICK table\query and click booking resit and put all.

• CLICK next dan click Button modify the form’s design and click finish.

• CLICK common button and do new record, save record and delete record, then put in form footer.

• Click and choose "go to next record" , "go to previous record" and "print operations" 
• All finish and click FORM VIEW.

REPORT

•  Last but not least how to make the "Report".
•  Click on the "Report" and then click on "Creat report Using the wizard. " 

• Required to choose the title "Source: Booking" and select the information that is in the "Available.
•  Fields" into the "Selected Fields".

1. Booking No
2. Book Date
3. Price Peru-nit
4. Quantity
5. Grant Total
    - Click on the "Next" until "Finish"

• Just click next , next and next .
• Follow the steps below .

• That's it ! Mission are completed . (form view)

LANGKAH-LANGKAH MEWUJUDKAN PANGKALAN DATA

• To start the Microsoft Access.

1. Click on the START BUTTON.
2. Point cursor at ALL Programs in the START MENU.A menu with list application software is display.
3. Move cursor to Microsoft Office and click on.
4. Click on the Microsoft Access 2003 in the list of programs.

• The three main window displays under the Getting Started task pane are:

1. Microsoft Access Office Online.
2. Open of the existing database-files and
3. Create a new database.

TITLE BAR : contains the control icon, the name program, minimize, maximize, restore  and close button.

MENU BAR : a set of options the little bar that lead to associated menus.

TOOLBAR : display button, which provide short cuts to menu.

  *  To create a new database.

1.     Click on file button.

2.     Click on new button.

3.     Select BLANK DATABASE on the new file task pane or press( CTR-N)

4.     Task name group in file name.

 


*Click table and design view.   

*TABLE

a)It stories information about special topic: DOCTOR,  PATIENT,

REGISTRATION, TREATMENT.

--> Size DOCTOR.

DocNO :text(4)

DocName : text (50)

TypeofSick : text(150)

Price :number( long integer)

MC :yes/no

TreatID:text (4)   

-->Size PATIENT.

PatientNo: text(4)

Name: text(50)

Address:text (100)

NoTEL:number( long integer)

Mobile:number( long integer)

RedID: text(4)

-->Size REGISTRATION

RegID: text(4)

RdIC: text(12)

RegDATE:

-->Size TREATMENT.

TreatID: text (4)

TreatDate: date/time

PatienNO: text(4)

*Click RELATIONSHIP and between 4 table.

*RECORD AND FINISH.

FIRST ASSIGNMENT DADD. :)

1st assignment had arrived last week and i'm thinking about how am i gonna do it.
Well, I'm using Microsoft Access 2003 :)




in chapter 2:)

CHAPTER 1 DADD.

• DATA:consists of facts,text,graphic&figure that can be recorded& that have implicit meaning
•    INFORMATION:data that have been processed&being made to be useful for user or decision makers.

a)DATA HIERARCHY.

• for the data hierarchy ,perfomed from top-down& the left to right.
• eg:student node first then follow by these nodes
• names,ic,age,student id,adderess,college-branch.

b)DATA HIERARCHY IN A DATABASE SYSTEM.

• BITS-BYTES-FIELDS-RECORDS-FILES-DATABASE.
• EG:

1. BITS:0 (OFF) OR 1 (ON).
2. BYTES:letter,dgit /8 bits=1 bytes.
3. FIELD:character (bytes)., column of data,contains the same type of data item.
4. RECORDED: full set of data in the row,name,address of a person.
5. FILES:collection of relation recorded.
6. DATABASE:collection of related filer or table.

• DATA TYPE.

1. TEXT:text field can be from 1 to 255 character ling.
2. NUMBER: *INTEGER:a two-byte whole number from-32,768 to 32,767. EG:0,+1,-1.
3. *REAL:decimal places. EG:1.5cm,48.4kg,RM20.10,36.7.
4. BOOLEAN:2 bytes true or false.
5. CURRENCY:dolar sing are automatically added. EG:$2000.00
6. DATE/TIME: for the year 100 throug 9999.

• TRADITIONAL FILE PROCESSING.

1. PERSONAL DEPT= employer.
2. SALE DEPT=customer.
3. ACCOUNTING DEPT=sales.

• DISADVANTAGE OF FILE BASED APPROACH.

1. DUPLICATION OF DATA: some data is help by different program 7 stored in several location.

• DATA INTEGRITY PROBLEM: files are stored within each application program that access  a given that.
• LIMITED DATA SHARING: private files   7 user have little opportunity to share data outside their own application.

DEFINITION OF DATA BASE.

collection of related data,design to meet the information needed in an organization and stores it in one specific.

DEFINITION OF DATABASE MANAGEMENT SYSTEM(DBMS).

DBMS is a collection of programs that enable user to create and maintain a database in an organization & stores it in one specific location.

• USER--> APPLICATION-->DBMS---> student database,lect database, greed database.

ADVANTAGE OF DATABASE APPROACH.

a) minimal data redundancy.

b) sharing of data.

c)economy in distributing database.

d) improved data consistency.

EVOLUTION OF DATABASE.

a)1960 s= traditional files.

b)1970 s= hierarchical / network

c)1980 s=relational.

d)1990s = object oriented / object relational.

d)2000s = data mining / data warehousing.

a)1960 :file processing system were still dominat during his period. 

b)1970 : * HIERARCHICAL DBMS MODEL; 

it was use commonly for business information.

    *NETWORK DBMS MODEL.

it use physical file pointer to model the relations between files.

   *RELATIONS DBMS MODEL.

it was introduction by E.F CODD and other.

c)1980 : RELATIONAL MODEL(by E.F. CODD,1970)

become the second generation of DBMS.

d)1990 :OBJECT-RELATIONAL DATABASE(ORDB)

due to the advancement of the client 7 internet computing technology &the popularity of the multimedia data.

e)2000 :THE data warehouse, THE universal server, THE distributes database, THE content-appreciable storage, COMBINATION of database &other technology.




CHAPTER 2.

• Step open Microsoft Access 2003.
• Create database,name database,location database.
• Create table in design,field name,data type,field size,list all field properties.
• description,add primary key,insert delete row,data sheet view.
• design  view and show to highlight row.
• Create table  using wizard,personal.
• ><
• finish.
• :):):):)

WEEKLY REFLACTION 1 IN DADD.

1/2/2011

• Introduction self.
• Buat group & setiap group ada 4 org.
• Name group: INTELENGTSIA TECH.
• Motto: kreatif, ivolusi & berwawasan.
• PENERANGA CHAPTER 1:DATA VS INFORMATION.
• DATA: facts,text,graphic&figure.
• INFORMATION:data have been processed& being made to be usefull for user.
• DATA TYPE:text,numeric,boolean,currency,date/time.
• FILE SYSTEM VS DATA BASE SYSTEM:

1. non-computerize system
2. traditional file Processing Approach.
3. DEFINITION ON DATABASE:collection of related data,designed to meet the information needed in an organisation&stores it in one specific location.

• ELEMENT DATABASE:user data,meta data,indexes,application metadata.
• ADVANTAGE: minimal data,sharing data,economy in distributing database,improved data consistency.

enjoy in this chapter :)






WEEKLY REFLECTION 2 (DADD)

• Study mengenai microsoft office access dalam cara membuat DATABASE DESIGN TOOLS.
• First,open microsoft office accessand click creat new file and click blank database.
• put name file and cliak create table in Design view.
• Type and list about:DOCTOR,PATIENT,ACCOUNT,REGISTRATION AND TREATMENT and save.
• Do the RELATIONSHIPS, and finish....
• :):):):)best and enjoy.