Cie AS Computing
ICT August 2013 batch
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
Replies to This Discussion
-
Permalink Reply by Wan Aemellia Elisha on
-
-
-
-
-
http://amyasw2020.wix.com/villageworld
my link address
-
-
Today in class we learnt how to use a database. To begin, data is defined as a set of valid information (facts). A database is a repositry of valid information, and a field refers to a particular category of information, e.g. Name, Address, ID Number etc. A primary key refers to a unique key which is used to identify a record.
Using Microsoft Access Office 2007, we learnt how to make our own database, first by keying in the fields needed. Then, double-clicking on the Table icon on the left, we can then fill in whatever data is needed in each row and column, much like Excel.
To frame a query, click on "Create" on the top bar, "Query Design". and then pick a certain field and the information needed and drag it to a table underneath. Enter a primary key or identifiable trait, e.g. a student sponsored by KPM, and all the entries containing that information will appear.
To create an individual form for each entry, click on "Create" again and then click "Form Design". Choose the fields of data you wish to display and toggle the design and settings you want to build. The resulting forms present the data in a more user-friendly manner which is easier to edit.
Finally, to create a report, simply click on "Create", followed by "Report Design". Again, shoose the fields of data you wish to display and toggle the design and settings you want to build, This creates a printable report.
Access 2007 offers an invaluable way to store and retrieve data with ease.
Chew Jian Li
7297
Block 4
-
-
Data - all the valid information (facts)
Data base- the place where all the data being dumped
under data base, we have several records which consist of different fields. All these records from tables.
Microsoft Access 2007 will help to accomplish the formation of data base.
we need to create one new documents.
- type in the fields needed with all the records required
- Also, we can form a query depend on the criteria you need
- Then, select form wizard will help to form the form which entails all the main headings
- After, we can prepare a report by selecting report wizard.
- All the design depends on personal taste and preference.
-
-
Data is all the valid information ( facts)
Data base is the place where all the data are dumped
Under data base, several fields combined together to have records and all the records will form tables
Microsoft Access 2007 will help to accomplish the information of the data base
first,create a new document
- type in the fields needed with all the records required
- form a query
- make a form using form wizard with all the main headings entailed
- prepare a report by selecting the report wizard
- choose the design you prefer
-
-
In order to create a database using Microsoft Office Access, we have to learn a few new terms.
Data is a set of valid information => Facts
Field is a tax form, for example one for your name, one for your ID no., one for your course and so on.
STEPS :
1. Open the Microsoft Office Access 2007
2. Select a blank database
3. Name the database
4. Enter all the data into the column fields
5. Select Query Design to add in the field and criteria
6. Select design view
-
Permalink Reply by Afeeq Shaszwan Bin Zambre on
-
Today we learned about databases. Data here is defined as a set of valid information (information being facts). A database is a dump of valid information, in a sense, and a field refers to a particular category of information, e.g. Name, Address, ID Number etc. A primary key refers to a unique key which is used to identify a records. (for example ID numbers where no two are identical)
Using Microsoft Access Office 2007 we can make our own database by keying in the fields needed. Then, double-clicking on the Table icon on the left, we can then fill in whatever data we want.
Making a query requires you to "Create" a "Query Design" (both found on the top panel). Drag the fields needed to the table underneath. Enter a primary key and all the entries with that information will appear.
To create an individual form for each entry, click on "Create" again and then click "Form Design". Choose the fields of data you wish to display and toggle the design and settings you want to build. The resulting forms present the data in a more user-friendly manner which is easier to edit.
Click on "Create", followed by "Report Design" to make a report. Choose the fields of data you wish to display and customize how it is done.
-
-
Today we learned a bit about Database.
So what is data? Data is a set of valid information, which are facts! In database, several Fields will combine their data to form Records >> Table.
1. Launch Microsoft Access 2007
2. Select a blank database
3. Type in the fields and its details
4. Close and save the table
5. CREATE >> QUERY DESIGN >>Add in the fields and criteria >> Closed & save >> View
6. CREATE >> MORE FORMS >> FORM WIZARD >> Select fields
7. CREATE >> REPORT WIZARD >> Select fields
:)
-
-
Today we learned how to make a database using Microsoft Access 2007. A database is a place whereupon you store key sets of data.
1. The first thing we did was to create a new blank database.
2. Then we keyed in information (fields) such as Student Name, Student Sponsor and Student ID, with all the corresponding information underneath it.
3. After that we pressed the "x" button, saving the information.
4. After double clicking the table tab (Table 1) all the information should reappear, for it has been saved to the database.
5. Then we learned about the "query" function. A query helps you find specific people. For example from a database of hundreds of people you want to find only those who are sponsored by JPA. What you do is press the Create tab and then the query design button.
6. A box should appear, highlighting Table 1. Press add.
7. Another box appears listing the fields we added previously.
8. Drag the fields we want into the ticked boxes at the bottom. Put "JPA" underneath the "Student Sponsor" section.
9. Exit the query page and double click it at the sidebar. A page appears, showing all the people who are JPA scholars.
10. Next, we learned how to make forms, for people to fill in their information (ID, Name, Sponsor etc)
11. Click the Form Design button on the Create tab.
12. Edit the form however you deem fit.
12. Press Finish and a friendly-looking form will result.
13. The next thing we learned was how to generate a report. This is basically a nice way of presenting the information found in the database.
14. Press Report Wizard on the Create Tab.
15. Tweak the settings on the report until you are satisfied.
16. A presentable-looking report of the relevant information you've selected will result.
About
© 2025 Created by Ravichandran.
Powered by
