Seba Computer Science Project Class 10
Project Report on MS Access, HTML and C Programming
-
Rating
-
Date
June 2018 -
Size
1.1MB -
Views
8,351 -
Categories
Transcript
PROJECT REPORT ON COMPUTER SCIENCE H.S.L.C. Examination 2013 A Project study submitted in partial p artial fulfillment of the requirements of Elective Computer Science of the Board of Secondary Education, Assam for the H.S.L.C. Examination 2013 TOPICS COVERED a) M.S. Access b) HTML c) C Programming Submitted By Name: Anshuman Dutta Centre No: B13-346 Registration No: 13/RP/0880/188327/11 Roll No: 0520 Certificate by The Principal This is to certify that Sri Anshuman Dutta, Roll No: 0520, Registration No: 13/RP/0880/188327/11 is a student of Spring Dale School, Jorhat has prepared this project report on elective Computer Science in partial fulfillment of the requirements of Elective Computer Science of the Board of Secondary Education, Assam for the H.S.L.C. Examination 2013. I wish him a bright future. (Signature of The Principal) Spring Dale School, Jorhat Date: …………………………… …………………………… Certificate by The Guide This is to certify that Sri Anshuman Dutta, Roll No: 0520, Registration No: 13/RP/0880/188327/11 is a student of Spring Dale School, Jorhat has prepared this project report on elective Computer Science in partial fulfillment of the requirements of Elective Computer Science of the Board of Secondary Education, Assam for the H.S.L.C. Examination 2013 under my direct s upervision. I wish him a bright future. Mr. Rajesh Singh Computer Teacher ACKNOWLEDGEMENT As per syllabus of the project required to be submitted in connection with the interval valuation in the H.S.L.C. Exam-2012 of Computer Science for class-X as directed by Board of Secondary Education (S.E.B.A), I have prepared this Project Report for the purpose of my own efforts. My heartiest thanks go to Secondary Education Board of Assam (SEBA) to give an opportunity to learn computer subject in our syllabus, as it is an important part of education now-a-days. I also owe to our school Principal for maintaining strict discipline and allowing us to do computer practical classes with all the necessary equipments. Beside this, I express my gratitude to our Class Teacher and all others teachers of our school. In fine, I do hereby acknowledgement the receipt of necessary guidance prolific instruction given by our respected Computer Teacher Rajesh Sir of our Spring Dale High School for which this project could be bought out to such a grand getup with all required points as incorporated therein as lucidly as possible. Anshuman Dutta CONTENTS Sl.No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 INDEX General Introduction to the Project Introduction to M.S. Access Creating a database Design View of Table1 Design View of Table2 Design View of Table3 Query in M S Access Output of the Query Forms in M S Access Output of the Forms Reports in M S Access Output of the Reports Utility of the created Database Introduction to HTML Creating the Home page with Links Browser View of the Home Page nd Source Code of the 2 Page Browser View of the 2nd Page rd Source Code of the 3 Page rd Browser View of the 3 Page th Source Code of the 4 Page th Browser View of the 4 Page Utility of the Website Introduction to C Flow Chart of the Program Algorithm Source Code of the Program Output of the Program Utility of the program General Conclusion Bibliography Page No. 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 11 11 12 13 14 14 16 15 16 17 18 21 22 23 24 General Introduction to the Project Welcome to the “Introduction Age” throughout th e world of computer. This is a project report on Microsoft Access, HTML and ‘C’ Language as recommended by S.E.B.A. I am very thankful to S.E.B.A. for introducing Microsoft Access, HTML and ‘C’ Language, in our syllabus. Microsoft Access allows us to store and organize information in sets of tables, which can be displayed in the form of columns and rows to look like a table or an index card. I have designed one database system “Employee Records Database System” to keep the records of all Employees in an organization. It is computerized so that it will be easy for us to maintain the everyday records in a computerized system. All the required Tables, Queries, Forms and Reports are designed. HTML is the acronym for Hyper Text Markup Language. It is a computer language that is used for creating Web pages. It is a language for describing the structure of a document. It defines a set of common styles for Web pages. In this report I have tried to design a Web site on HTML on the topic “India Tourism” containing six web pages including the home page. I have created hyperlinks to link all those web pages so that we can easily navigate through the website. I also used all the possible HTML TAGs and ATTRIBUTEs that can be useful to develop this project. The ‘C’ complier combines the capabilities of an assembly language with the features of a high-level language and therefore it is well suited for writings both system software and business packages. Programs written in ‘C’ are efficient and fast. This is due to its variety of data types and powerful operators. It is many times faster than BASIC. There are only 32 keywords and its strength lies in its build in functions. Several standard functions are available which can be used for developing programs. I have tried to design a program in ‘C’ Language and its flowchart and the program will give the output, when a user enters any data from the keyboard. Introduction to M. S. Access M S Access is a RDBMS package from Microsoft. Microsoft Corporation, which is the largest producer of software in the world, in the 90’s, introduced the concept of M.S. Access, to take care of most of our database requirements. It allows us to store and organize information in sets of tables, which can be displayed in the form of columns and rows to look like a table or an index card. What’s more it allows us to perform calculations and find for our simple statistics like totals and averages. It allows us to sort the data in any fo rm and extract the required information based on the key given by us. Creating the Database The Database helps us to extract specific information from the MS Access. This is the best way to create Database. Steps to create the table: 1. Select Create table by using wizard, in the Database dialog box. 2. Click on either Business or Personal, depending upon the kind of table that we want to create. 3. Scroll the ‘Sample Tables’ list. Click on the required table and see the sample fields of the chosen table in the ‘Sample Field’ list. 4. To add a field from the sample list, double click on the field name and then on ‘>’ button present on the dialog box. To include all the fields from the list, click on the ‘>>’ button. 5. To remove a field after initially including it, click on it in the rightmost list, then click on the ‘<’ button. Clicking on ‘<<’ button removes all the fields. 6. After including all the required fields in the New table, click Next. 7. Wizard asks us to name the table. It even suggests a name. We have to t ype the name and click Next. 8. A final dialog box with three main options appears. Click Finish. Design View of Table 1 Employee Table Design View of Table 2 Department Table Design View of Table 3 Salary Table Query in M S Access The Query helps us to extract specific information from the database. It is like asking a question to the Access and finding fi nding out the answer. Steps to create a query: 1. Click the Query tab in the Database window. 2. Click the New button on the Database window to olbar. 3. In the New Query dialog box, select D esign View. 4. Click OK. 5. In the Show Table dialog box that opens, select the tables we want to include in our Query, clicking Add after each. 6. After we have added all the tables we want included, click Close. 7. Double click a field in the field box in the upper portion of the select Query dialog box to add it to the query design grid. 8. The Show check boxes in the grid should be checked for all the fields that we want to display in the resulting datasheet. 9. To sort the records in the resulting datasheet, click for the Field that we want to sort and then select Ascending or Descending from the drop-down list. Output of the Query Employee Table Salary Query Forms in M S Access Forms give us the interface which enables the users to view as wel as enter records easily into the tables. The output of the forms Employee Form Salary Form Reports in M S Access A Report will print our database in a format, which looks best on the paper using the printer attached to our computer. This is no doubt the quickest way of creating a Report. The output of the reports Employee Report Salary Report Utility of the created Database Creating database is probably the easiest and fastest method of creating a database where we have to fill up some information and the database is ready for us. It not only creates Tables for us but all the Forms, Reports, etc., connected with it are done too. Introduction to HTML HTML is the acronym for Hyper Text Markup Language. It is a computer language that is used for creating Web pages. It is a language for describing the structure of a document. It defines a set of common styles for f or Web pages. Hypertext is a text stored in electronic form with cross-reference links to other pages or documents. Markup means we start with the text of our page and markup (or add) special tags around words and paragraphs. The tags indicate different parts of the page, add extra features and produce different effects when the f ile is opened in the browser. Language provides Rules and Syntax for the tags and tags. It is a scripting language, which differs completely from programming language. HTML is across platform language, i.e., HTML documents can be used on any type of computer or platform like l ike Macintosh Computer, IBM Computer, UNIX, Windows etc. HTML tags do not specify the exact font sizes, line spacing, indents etc. which are the formatting features generally used to control the appearance of a document in a word processor or publishing software . Creation of the Home Page with Links Browser View of the Home Page (index.html file) Source Code of the Home Page (index.html) fileNew Seven WondersThe New 7 Wonders Foundation is a private organization established in 2001, which is dedicated to investing in good causes related with the monument preservation and reconstruction around the world. This organization prepared a global contest on Internet whose goal was to find the New Seven Wonders of the World. This election was made through a global vote on its website. Finally, on July 07, 2007 the election’s election’s results were announced and these are the proclaimed New Seven Wonders of the World | |||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||
colspan="2"> | |
Home href="index.html">Home | Taj Mahal | C the Redeemer | Petra | Great Wall | Machu Picchu | Chichen Itza | Roman Colosseum | |
iTAJ class="style3">iTAJ MAHAL, INDIA | |
The align="justify">The Taj Mahal is standing majestically on the right bank of River Yamuna at a point where it takes a sharp turn and flows eastwards; the Taj Mahal is synonymous of love and romance. The Taj Mahal complex is organized in a rectangle, measuring approximately approximately 310 x 550 meters. It comprises a number of buildings and structures, all functioning together as the funerary monument for Mumtaz Mahal. This align="justify">This immense mausoleum mausoleum was built built on the orders of Shah Jahan, the fifth Muslim Mogul emperor, to honor the memory of his beloved late wife. Built out of white marble and standing in formally laid-out walled gardens, the Taj Mahal is regarded as the most perfect jewel of Muslim art in India. The emperor was consequently jailed and, it is said, could then only see the Taj Mahal out of his small cell window. | |
colspan="2"> | |
Copyright@Seven bgcolor="#0099FF">Copyright@Seven Wonders Designed By Anshuman Dutta |
colspan="2"> | |
Home href="index.html">Home | Taj Mahal | C the Redeemer | Petra | Great Wall | Machu Picchu | Chichen Itza | Roman Colosseum | |
iCHRIST class="style3">iCHRIST THE REDEEMER, BRAZIL | |
Cristo valign="top"> Cristo Redentor Redentor | |
colspan="2"> | |
Copyright@Seven bgcolor="#0099FF">Copyright@Seven Wonders Designed By Anshuman Dutta |
colspan="3"> | ||
Home href="index.html">Home | Taj Mahal | C the Redeemer | Petra | Great Wall | Machu Picchu | Chichen Itza | Roman Colosseum | ||
iGREAT class="style3">iGREAT WALL OF CHINA | ||
valign="top"> | The Great Wall of China is a series of fortifications fortifications made of stone, brick, tamped earth, wood, and other materials, materials, generally built along an east-to-west line across the historical northern northern borders borders of China in part to protect the Chinese Empire Empire or its prototypical prototypical states states against intrusions by various nomadic nomadic groups or or military incursions incursions by various various warlike warlike peoples or or forces. Several Several walls were being built as early early as the 7th century BC; these, later joined together and made bigger, stronger, and unified are now collectively referred to as the Great Wall. Especially famous is the wall built between 220–206 BC by the first Emperor of China, Qin Shi Huang. Little of that wall remains. Since Since then, the Great Wall has on and off been rebuilt, rebuilt, maintained, and enhanced; enhanced; the majority of the existing wall wall was reconstructed during the Ming Dynasty. | |
Other align="justify">Other purposes of the Great Wall have included border controls, allowing allowing the imposition imposition of duties on goods transported transported along along the Silk Road, regulation or encouragement encouragement of trade trade and the control of immigration and emigration. emigration. | ||
colspan="3"> | ||
Copyright@Seven bgcolor="#0099FF">Copyright@Seven Wonders Designed By Anshuman Dutta |
Home href="index.html">Home | Taj Mahal | C the Redeemer | Petra | Great Wall | Machu Picchu | Chichen Itza | Roman Colosseum |
iCHICHEN class="style3">iCHICHEN ITZA, MEXICO |
Chichen Itza was a major focal point in the northern northern Maya lowlands lowlands from the Late Classic (c.600–900 AD) through the Terminal Classic Classic (c.800–900) (c.800–900) and into the early portion of the Early Early Postclassic period (c.900–1200). (c.900–1200). The site exhibits a multitude of architectural styles, reminiscent reminiscent of styles styles seen in in central Mexico and of the Puuc and Chenes styles of the northern Maya lowlands. lowlands. The presence of central Mexican styles was once thought to have been representative of direct migration or even conquest from central Mexico, but most contemporary interpretations view the presence of these non-Maya styles more as the result of cultural diffusion. | year.
Copyright@Seven bgcolor="#0099FF">Copyright@Seven Wonders Designed By Anshuman Dutta |