Word Processing and Database 2024 PDF

WORD PROCESSING AND DATABASE BY PROF. (MRS) S.F. USIFOH BPharm, PharmD, MHPM, PhD DEPT. OF CLINICAL PHARMACY & PHARMACY PRACTICE WORD PROCESSING What is Word Processing ?  It is also known as a Then Now document preparatio...

WORD PROCESSING AND DATABASE BY PROF. (MRS) S.F. USIFOH BPharm, PharmD, MHPM, PhD DEPT. OF CLINICAL PHARMACY & PHARMACY PRACTICE WORD PROCESSING What is Word Processing ?  It is also known as a Then Now document preparation System  It is a programme where you can type and print documents  Word processing describes the process of creating or editing a document using a word processor, such as Microsoft Word, Google Docs, or Open Office Writer Historical Background  Before computers, people used typewriters to write reports or other documents Some early word processors are: 1. WordStar 2. MacWrite 3. Easy Writer 4. Bank Street Writer Application areas of word processing :  Business - Legal Copies, Letterheads, Letters, Memos, Circulars etc.  Education - To develop word processing skills from the very beginning  Home - Dealing with assignments being completed at home, or occasionally recreational e.g. Maintaining diary  Word Processing  Disadvantages  Advantages 1. Equipment costs, 1. Faster expensive to buy 2. Can edit documents 2. Electricity required 3. Change font style, size, colour 4. Change layout 3. Upgrade software 5. Print many copies 4. Train staff 6. Less noise 5. More complicated 7. Format documents, Add images/ 6. Virus, popup pictures 8. Make tables 9. Email documents 10. Save ink and paper Introduction to parts of a word window  Below is the table, describing parts of Word Windows: Title Bar Displays the name of the currently active word document. Ruler Bar Allows you to format the vertical and horizontal alignment of text in a document. Tool Bars Word has a number of tool bars that help you perform task faster and with great ease. Example : Standard Tool Bar, Formatting Tool Bar Status Bar Displays information about the currently active document. Scroll Bar Allows scrolling the content or body of document. Workspace Area in the document window where text can be entered. Menu Bar Contains menus doing separate tasks.  Features of word processor  Editing Font it is used for making changes  Formatting 1. Text Alignment Left, Right, Centre 2. Alter Text style Arial, Calibri, Times New Roman, Georgia 3. Line Spacing single, double 4. Page style and layout A3, A4 ,Portrait ,Landscape 5. Set margins 6. Page Breaks Start a new page 7. Tabulations and tables- Makes Text easier to read  Search and Replace We can use this feature to replace a word a number of times in a document.  Spell Checker It works by comparing the words typed by us to the words in computer’s internal dictionary. Any word not recognized it will place a red line underneath.  Features of Word Processor  Grammar Check  This feature works by highlighting sentences with grammatical errors, for example  I seen everyone coming along  Standard Paragraph  A standard paragraph is a piece of text that has been typed up, saved to backing storage and inserted into a document a number of times  How to enter and edit text  You can enter text by using the keyboard  Editing text may involve inserting, deleting, or amending  Other possible methods are using a scanner and optical character recognition (OCR)  You can do this by speaking into a microphone or using voice recognition software Word Wrap  With a word processor, when you reach the end of a line you don’t need to use the return key to make a new line.  Word processor will make a new line automatically and it will move partly completed words at the end of one line to the start of the next line Word Count  It is very useful if you are writing an essay or an article containing a certain amount of words  Instead of using spell checker to count words use word count it saves time. To insert clip Inserting Clip Art art Click on insert Then and then click on picture Clip art Some pictures from Clip art  Mail merge The process of linking the fields in a database to a standard letter. It can be accessed by pressing the “Tools” tab and selecting Mail Merge. Steps  Create the standard letter  Create the database with fields  Merge the fields into the standard letter  Print Text Alignment  Text can be aligned in three different ways  Left  Right  Centre Features of Word Processor  Template  A template is a ready made document, with placeholders for items like text and graphics Templates of Resumes and Cover letters  What You See Is What You Get WYSIWYG  Development of higher-resolution monitors allowed them to provide limited WYSIWYG - What You See Is What You Get, to the extent that typographical features like bold and italics, indentation, justification and margins were approximated on screen.  MacWrite, Microsoft Word and other word processing programs for the bit-mapped Apple Macintosh screen, introduced in 1984, were probably the first true WYSIWYG word processors to become known to many people until the introduction of Microsoft Windows. The evolution of Word 2002-2010 Word XP Word 2003 Word 2007 Word 2010 New features in Word 2007  The Microsoft Office Button  The Quick Access Toolbar Customizable  The Ribbon Application Areas of Word Processing 1. Business - Legal copies, Letter heads, letters, Memos. Circulars etc. 2. Education - To develop word processing skills from the very beginning 3. Home - Dealing with assignments being completed at home, or occasionally recreational e.g. Maintaining diary In Summary In a recent study, word processing was ranked as the primary software need for teachers and students. DATABASE  Learning Outcomes  Student will be able to understand what is data base  Studentwill be able to describe the important of good database  Student will have basic understanding of types of databases Why Study Databases? Databases are useful Many computing applications deal with large amounts of information Database systems give a set of tools for storing, searching and managing this information What is a Database? “A set of information held in a computer” Oxford English Dictionary “One or more large structured sets of persistent data, usually associated with software to update and query the data” Free On-Line Dictionary of Computing “A collection of data arranged for ease and speed of search and retrieval” Dictionary.com Databases  Web indexes  Train timetables  Library catalogues  Airline bookings  Medical records  Credit card details  Bank accounts  Student records  Stock control  Customer histories  Personnel systems  Stock market prices  Product catalogues  Discussion boards  Telephone directories  and so on… Database Systems A database  Database systems system consists allow users to of  Store Data (the  Update database)  Retrieve Software  Organise Hardware  Protect Users their data. Database Users  End users  Database  Use the database Administrator (DBA) system to achieve  Designs& manages some goal the database  Application system developers  Database  Write systems software to allow end users to programmer interface with the  Writes the database database system software itself Database Management Systems  A database is a collection of information A database management system (DBMS) is the software than controls that information  Examples:  Oracle  DB2 (IBM)  MS SQL Server  MS Access  Ingres  PostgreSQL  MySQ What the DBMS does  Provides users with  DBMS provides  Data  Persistence definition language (DDL)  Concurrency  Datamanipulation  Integrity language (DML)  Security  Datacontrol  Data independence language (DCL)  Data Dictionary  Oftenthese are all  Describes the database the same language itself Data Dictionary - Metadata  The dictionary or  The dictionary holds catalog stores  Descriptions of database objects (tables, users, information about rules, views, indexes,…) the database itself  Information about who is  This is data about using which data (locks)  data or ‘metadata’ Schemas and mappings  Almost every aspect of the DBMS uses the dictionary File Based Systems  File based systems Problems:  Data is stored in No standards files  Each Data duplication file has a specific format Data  Programs that use dependence these files depend No way to on knowledge about that format generate ad hoc queries THANK YOU