ICT August 2013 batch

[Ravichandran]

Dear ICT students of AUG 2013 batch under Dr.Ravichandran, I welcome you all this Web portal, which you will be using for your entire course. This http://as-computing.ning portal is were you will have to upload / post all the classroom based activities.

The CIE ICT task will have to be handed to be in person at the end of each CIE task class and the question paper/ CIE folder should not be take with you under any circumstances. That is, the folder should be given to me after your use in class once you complete your Cie task for that particular class.

For further doubts and queries please contact me or you can even send a message using this Web portal.

FROM NOW ON YOU WILL USE THIS WEB PORTAL. AND REMEMBER TO POST ONLY IN THE FORUM NAMED ICT JAN 2013 BATCH. NOT ON OTHER FORUMS WHICH IS MEANT FOR OTHER BATCHES.

WE WILL DO 5 TASKS OF CIE , WHICH MEANS YOU NEED TO COMPLETE, WORD, EXCEL, POWERPOINT, DATABASE AND HTML TO GET QUALIFIED FOR A DIPLOMA.

Regards,

Dr.Ravi

[tan yu yin]

today i've learnt data preseentation.it's very helpful

[Chan Hooi Mui]

This morning, Block 5 students were taught on what is database, how to create it and use it to our benefits. 

We used Microsoft Access in doing so. We first created the structure of the database by inserting all the necessary category. For eg, ID, Name, Course and etc. 

Then we keyed in all the data according to the categories we have set. By clicking on the 'Query Design', you get to create a query which means you can isolate the data you want from the rest by inserting a particular criteria.

Last but not the very least, creating a report using a report wizard. It's easy since you'll just have to click on what you wish to see on your report and how will it be presented.

Difficult feats are made easy these days by software engineers xD 

[hani hamizah bt nor hashim]

today we learnt database. it is really useful and i am looking forward to practice using it. by creating a database, we can create tables,records and field. from there we can generate reports, queries, etc. To create a database, we first of all go to Microsoft Access 2007 (now i know the use of this thing :v). 

from there, we first off all create our structure; define our fields. after that we can use the data to create tables, forms and queries. just go to "create" tab, basically everything's there. 

oh and remember, a 'primary key' is a data that is unique for example our id numbers. thus we can avoid data duplication etc :)

[Nazhatul Shahirah binti Hasbulla]

Today in ICT class, Dr Ravi taught us how to use Microsoft Access 2007 to create fields, table, create a query, a nice user interface and produce a report on the table created. This will certainly be of great help for me in the future :)

[fatihahtul hanan md nor]

23rd October 2013

Splendid! Dr Ravi manged to share with us the basic functions of Microsoft Access 2007.

This device is essential in gaining and sorting data.

There are several beneficial ways where the data can easily be sorted out.

For example, using table and query.

[Elisa Naomi Tibok]

Today, we learnt how to create a database for all our data. We first open up Microsoft Access and create a new blank database. We then enter the information called fields, then the details and then we can form a table. With the table we can create queries with specific information that we want. Lastly we learnt how to create a report from the database generated. I find it very useful, especially for future uses.

[Nabilah Binti Muhammad Najib]

I learnt database today ^.^ yay ..

By using Microsoft Access, create the body of the database by inserting categories that you prefer ; ie; Student ID, Student Name, etc. Then, key in all the data in the categories. ( Table )

To create a query, click 'create' tab, then click 'query design' and follow the steps :D ( Query )

To create a report, again click the 'create' tab, and click 'report wizard' and follow the steps :DD ( Report )

Im looking forward to use it in the future. Thanks Dr Ravi

[Helena Aishah binti Nordin]

Today's lesson was on Database, which is on Microsoft Access (first time to ever open this in Office).

So basically, this proves that it was a very new thing to me. With the help of Dr. Ravi, I could understand how database works. A database can be said as a center where all sorts of information can be gathered. This can be applied for medicine students, for example to gain access to their future patients and the drugs that they are allergic to. Apart from that, this database concept can be very useful for future accountants, where they can debit and credit business transactions easily. What I learnt today will definitely be useful! :)

[Amirah Hanoum binti Amin Ariff]

Hey guys, today we learned about database. Here are a few elements that make up a database. 

1. Fields : It has a primary key icon by the side which means that every field is unique

               eg : Name, ID, Height, Sponsor, Course

2. Records : All the different fields make up a record.

3. Tables : From all the records obtained, you can form a table.

4. Database : All the tables make up one database.

The purpose of database is to keep valid information that may be vital, allowing easy access to answer our queries.

For example, a patient is down with a flu. Before prescribing the medication needed, let say, paracetamol, the doctor or his assistant can access the database to find out more about the patient's past records to track what he has been given in the past, whether he's allergic to the medication etc.

Database can be done through Microsoft Access !   

[NUR SHAHERA BINTI YAYAH@YAHYA]

Another useful lesson today. We learnt to create database using Microsoft Access. Firstly, we have to create structure, defining the fields with necessary data. Then, we can use data we have entered to create a table, query or form. 
^_^

[NOR FATIN SHAZLIN AMELIA SALLEH]

wow!!! Today i have learnt how to create database.Data is meaning a set of valid information.These the steps to create database.

1.open microsoft access 2007 and click on create database with your own name

2.Insert some categories you want in the table, i.e:stu_id, stu_name, stu_sponsor and stu_course

3.Then click on create go to more form to change the design

4.Click on Query and insert any information that you have insert in the table whichever you want to know

5.Lastly you can change how your database look like

[Farah Nadia Abd Aziz]

database is what we focus on for today's class

get started with a blank database from Microsoft Access. then is to create the structure of the database before keying in all the information and details to form a table. from here on, a report and query based on specific criteria can be created. a good tool i must say.