Weekly Reflection 2

Today 2nd week of DADD classroom. Today Mis Ayuni tought us about the Queries. I would understand clearly due to i do own revision by searching from internet about this subject. I got learn more about it. Another mideline in my lecture. The careful thought us the important of every detail. The exercise that Mis Ayuni gave help me to understand more about the usage of the programming language. With more exercise  i think i should able to understand more.

Blog Tutorial 1 - Table and Relationship

TABLE AND RELATIONSHIP

To create Table by using Design View

Create table

v  Select Table > click on Create table in Design View > you will see a Table properties

·         Field Name           -               Identifies the information within a field

·         Data Type             -               Determine the type of information you can enter in a field, such as text,
                                                       numbers or dates.

To create Student table

 

v  Type the data at Field Name column , choose the Data Type and change the field size as below:

Field Name                Data Type                    

StudentID                     Text (15)

StudentIC                     Text (50)

StudentName               Text (100)

Attendance                   Yes/No

To Insert Row

v  To insert Row > highlight the column that you want to insert the row > than right click at the column that you highlight > choose Insert Rows.

               

To Delete row

v  To delete the row that you insert > highlight the column that you want to delete > than right click at the column that you highlight > choose delete Row

To Insert primary key

v  Before you save the table you need to insert Primary key. To insert Primary key > highlight the first column > right click > choose the Primary Key > and you will see the Primary Key sign

 

To Save

v  To save > click on to save button > you will see a save as dialog box >  type Student > click to OK button > you will see the title of the table.

To create Relationship

v  To create relationship > click Relationship icon > you will see a few tables below > choose one by one and click add > than click close button.

v  Choose doctor , Patient , Registration and Treatment as below:

v  Click RegID (Foreign Key) and drag to RegID (Primary Key) > choose Enforce Referential Integrity and click > than click ok > than save

To Enter Data

v  Open the Doctor > click the first empty cell > enter the data for a record at first cell  > and press enter to move to next cell . As per below data > than click close

·         DoctorID – D001

·         DoctorName – Anusha

·         TypeOfSick – Fewer

·         Price – 20

·         MedicalLeave – tick

·         TreatID – T001

To create Table by Using Wizard

To Create table

v  Click Table > choose and click Create Table By Using Wizard > you will see Table Wizard below

v  Choose the table category > choose the sample table > choose the sample table as per below that you want to include in your table > and click next button.

·         Students                     - StudentClassID

                                        - ClassID

                                        - StudentID

                                        - Grade

·         Students and Classes - FirstName

                                        - LastName

                                        - Address

                                        - PhoneNumber

v  Once you click the next button, you will see another box > give a name for your table > and click next

    button again.

v  Click next to continue > choose enter data directly into the table options > click finish button

To enter data

v  To enter the data into the table > click on the empty cell > the first cell is auto update > Update the data as per below:

·         Student Class ID   - auto update

·         First Name           - sara

·         Last Name           - Charu

·         Address               - Skudai

·         Phone Number     - 0123456677

·         Class ID              - 1234

·         Student ID           - 1

v  Click close button > when you finish entering the data

Blog Tutorial 1 - Database

DATABASE

To create Database

v  Go to Start button > click All Program > than choose Microsoft Office > and choose Microsoft Office Access 2003 > you will see the Microsoft Office Access 2003 Database Window below.

Title Bar        - contains control icon, the name of program, minimize, maximize, restore and close button
Menu Bar      - A set of options below the title bar that lead to associated menus.
Tool Bar        - Displays buttons, which provide shortcuts to menus. 

To create New File

v  Click to Create A New File > than select and click on Blank Database > you will find a File New Database Dialog Box > type your database name that you want save eg: week 1 > than click Create to open the database.

Title Bar   - shows the name and file format of the database
Open         - use to work with existing objects
Design      - use to modify existing objects
New          - use to create new objects

Weekly Reflection 1

 Hi i'm Paul mark here. My first day on the database subject DADD. I got so excited to learn this subject because it will be a new experince for me. I love to learn Database. Learn about new language to do programming. I know this subject be tought but i ready to learn. I need to put my attention in the classroom and need to concentrated with my class lecture teaching. The most important thing, if you not clear ask the help from the lecturer.