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

[Koh Yun Xin]

Database-

The flow in database goes like this- Database >Table >Record > Fields

We learnt to create a database..

1) go to Microsoft Access 2007

2) Blank database

3) Create . Type in the name ( not to insert space: "block3" , not "block 3"

4) Right click. Design View

5) enter the name of the table.

6) key in the title of the data

7) then , click the cross at the corner, and "save changes"

8) Double click at the "table XX" at the column on the right side of the screen

9) Now , key in the data

10) save changes. 

11) u can also go to " create", "query design", "add" , "close" ,drag and insert the items u need under "criteria"

12) close and save changes again.

13) u can always go to "report wizard" to change the design of ur table.

[nurul asnida binti aziz]

basically, database is all about information that we need to save by using  microsoft access..thats all...

but, truly that it is very useful to me and other medical student...chill!!!!

[Anis Suraya binti Kamaruddin]

Today, I learned about database. You can create a database using Microsoft access. Here are the steps that need to follow to create a database.

Step:-

1.  Open Microsoft Access and choose blank doc

2.  Create the name of your database file. e.g: Block3(without spacing, please!)

3.  Right-click the word table1:table at your LHS and click "design view"

4.  Type down your data in the field name e.g: stu_id or stu_name

5.  Select the correct data type for each field name that you want to list down

6.  Save it and click database view on the top of your LHS

7.  Type out the data at the correct column

8.  Go to "create" and click "more forms". Choose "form wizard" and your favourite template. Save it.

9.  Click query design and choose table 1 in table tab. A table with your field name will appear. Drag the field that you wanted to use for your convenience like you want all your field name to appear except stu_dob. something like that.

10.  In the criteria box, type what you a searching for e.g:medicine, JPA. Save it.

11.  Click report wizard and choose your template. A report will be display for you and your done.

[Elleroy bin Yick Sing]

Today I have learned database, which is using Microsoft Office Access. It is a powerful tool which can gather and present information  in a very neat and arranged way, even we can store information with only little edits but shows the whole information!

1) Click on Microsoft Office Access

2) Create a new blank database

3) Left click once and you see a box at the right side. Name your document and create.

4) You see the left side box listing Table1: Table. Right click on it and click design view.Name your table and press OK to save.

5) You can see the field name and data type columns. Type your category in the box below field name e.g. stu_id, stu_course etc. and customize your data type. It can be in text, date/time or numbers for your field.

6) Click 'Save' and press 'View'. A table will come out and fill up the table based on the respective fields. Click 'Save'.

7) Click 'Create' at upper options and click 'More Forms'. Click 'Form Wizard'. Include what fields you want to include and press 'Next'. Costumize your tables and finally click 'Finish'.

8) If you want to find using certain fields only, click 'Create' and click 'Query Design'. A box comes out and click 'Add'.

9) Close the box and you see a smaller box listing your fields. Drag which fields you want to use to a table below and type what you want to find with typing before and after of quote ( ' ).

10) Click 'Save' and click 'OK'. You see your query of search.

11) If you want to display your data, click 'Create' and click 'Report Wizard'. Costumize and finally click 'Finish'.

12) Then you can see your report and you can print.

~Finish~

[Nor Syahira Khusni]

a bit late, but still i would like to share the website i created.

http://syirajunmjeje.wix.com/gods-of-the-east

[Ong Wuey Ching]

[Ong Wuey Ching]

[Ong Wuey Ching]

[Ong Wuey Ching]

[Ong Wuey Ching]

[Ong Wuey Ching]

[Ong Wuey Ching]