databases and word processing iv management information systems i lecture 7, 27 march 2003 mr. greg...
TRANSCRIPT
![Page 1: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/1.jpg)
Databases and Word Processing IV
Management Information Systems I
Lecture 7, 27 March 2003
Mr. Greg Vogl
Uganda Martyrs University
![Page 2: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/2.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
2
Overview1. Databases
1. Definition, components, objects, types
2. Goals of database systems
2. Word Processing IVA. Window management
B. Table of contents, index
C. Insert menu, drawing, graphical objects
![Page 3: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/3.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
3
Database
Collection of data or informationStored in an organised wayMay be computer files, paper files, etc.Database management systems enable:Enter, update, delete info.Sort, search for, retrieve info.Define and change data structures
![Page 4: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/4.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
4
Database Components
FileCollection of related data e.g. addressbook
RecordUnit of info. about a thing e.g. a person
FieldOne fact about the thing e.g. PO BoxData types: number, text, date, yes/no, etc
![Page 5: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/5.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
5
Example Database File
Name PO Box Town Phone Date of Birth
Albert 328 Entebbe 234345 1966-03-03
Betty 192 Mbarara 789456 1977-04-04
Charles 23 Masaka 123890 1972-05-06
field
record
![Page 6: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/6.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
6
Database Objects
TableRaw data (rows=records, columns=fields)
QueryA question to collect, search for, sort info.
FormA neatly organised screen for data entry
ReportSummarised output, sent to screen/printer
![Page 7: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/7.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
7
Goals of Database Systems
Data integrity Data is valid, in an acceptable range
Data independence Data useable by more than one system
Data redundancy Do not enter/store data more than once
Data security Avoid data loss or unauthorised access
Data maintenance Procedures to add/update/delete info.
![Page 8: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/8.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
8
Types of Databases
Flat File DatabaseA collection of unrelated tables
Relational DatabaseTables are related through common fieldsReduces data redundancyE.g. Orders table relates Customers, Items
Object-Oriented DatabaseStores objects (documents, multimedia)
![Page 9: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/9.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
9
Window Management
New Window
Arrange All
Split, remove split
Resize
Switch between windows: Alt-Tab
Closing windows vs. closing Word
![Page 10: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/10.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
10
Table of Contents
Insert, Index and Tables, Table of Contents
Formats: from template, Classic, etc.
Show levels: 1, 2, 3
Show page numbers, right align
Tab leader
Options, available styles
![Page 11: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/11.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
11
Index
Insert, Index and Tables, IndexIndented/run in, number of columnsMark entryselect word(s) to include in the index
Mark AllMark all occurrences of selected text
AutoMarkuse file of words to be marked
![Page 12: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/12.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
12
Insert Menu: Automatic info.
Page numbersposition, alignment, format
Date and time format, language, update
Fieldcategories, field names
AutoTextheader/footer, parts of letters
![Page 13: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/13.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
13
Insert Menu: Other things
Breakpage, column, wrapping, section
Symbol font, shortcut keys, accents
CommentFootnotePictureClipArt, From File, AutoShapes, WordArt
![Page 14: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/14.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
14
Drawing Toolbar
What you can insertAutoShapes, line, arrow, rectangle, ovalText box, WordArt, ClipArt
Drawing OptionsFill color, line color, font colorLine style, dash style, arrow styleShadow, 3D
![Page 15: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/15.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
15
Manipulating Objects
Selecting click once
Copying select, cut, copy, paste
Deleting select, press Delete key
Moving look for four arrows, drag
Resizing two arrows, drag handles (edges, corners)
![Page 16: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/16.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
16
Draw Menu
Group and ungroupOrder front/back, forward/backward, text
GridAlign top/middle/bottom, left/center/right
Rotate and flip Rotate left/right/free, flip horizontal/vertical
Text Wrapping square, tight, in front/behind
![Page 17: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/17.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
17
Word Art
Used to make fancy text logosHow to insert Word Art Insert, Picture, Word ArtSelect a style from WordArt galleryType your text in the boxFont, size, bold, italics, click OK
Modifying with the Word Art MenuShape, rotate, vertical, alignment, spacing
![Page 18: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/18.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
18
Clip Art
Drawings that come with MS Office
How to insert Clip Art Insert, Picture, Clip ArtChoose category or use keyword searchClick picture, insert
Right-click the picture to change itBorders/shading, Caption, Format Picture
![Page 19: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/19.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
19
Picture Files
You can use many graphics file formats
How to insert pictures Insert, Picture, From FileBrowse to locate the fileOr copy and paste from Web browser, etc.
Same formatting options as Clip Art
![Page 20: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/20.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
20
Charts
How to insert and use charts Insert, Picture, ChartEnter row and column headersEnter data in cellsDouble-click rows/columns to
include/exclude them in the chart
Excel has many more charting options
![Page 21: Databases and Word Processing IV Management Information Systems I Lecture 7, 27 March 2003 Mr. Greg Vogl Uganda Martyrs University](https://reader036.vdocuments.us/reader036/viewer/2022062800/56649dea5503460f94ae58df/html5/thumbnails/21.jpg)
27 March 2003 Management Information Systems I: Databases and Word Processing IV
21
Formatting Objects
Any drawing object has several options
Right-click it and click Format ObjectColors and lines: fill/line color, arrowsSize: width, height, scale, lock aspect ratioLayout: wrapping, horizontal alignmentPicture: cropping, brightness, contrastColor: auto, grayscale, b/w, watermark