Information Technology 402

143 flashcards · Other · by Rudra Mina

cell The intersection point between a row and a column is a cell.
Cropping an image ""
resizing an image ""
predefined template "These are the steps to use predefined template: Go to 'file' tab and click 'new'. Now select 'templates & documents' options. Predefined Template. Choose your template and press 'open' button. "
preparing for printing To prepare mailing labels for printing: â Choose File > New > Labels. â On the Options tab
ensure that the Synchronize contents option is selected. â On the Labels tab ()
printing â Choose File > Print. The message shown in appears. Click Yes to print. â In the Mail Merge dialog ()
you can choose to print all records or selected records. To select records to be printed
data consolidation In OpenOffice
data consolidation refers to the combining of data from various sources or sheets into a single area for easy analysis and manipulation. It helps when working with data that is spread across multiple files or sheets and enhances productivity
advantages of data consolidation Saves time by combining information from various sources into one document. reduces the possibility of errors that could happen when manually copying data
which increases accuracy. allows you to examine and interact with the combined data in one place
data consolidation steps "To use the Consolidate tool in OpenOffice, follow these steps:Open a new or existing spreadsheet in OpenOffice. Select the cell where you want the consolidated data to appear. Click on Data > Consolidate from the menu bar. In the Consolidate dialog box, select the range of cells or sheets you want to consolidate. Choose the function you want to use to consolidate the data (such as sum or average). Specify any additional settings, such as whether to include labels or em…
subtotal Subtotal in OpenOffice electronic spreadsheet refers to a function that calculates the subtotal of a range of values within a list or table. This function can be used to summarize data by category or group
allowing you to quickly see the total for each group.
advantages of subtotal Easy data analysis by grouping and summarizing data based on criteria. Improved accuracy by automating subtotal calculations and reducing errors. Increased efficiency by saving time and effort. Enhanced organization by grouping data into categories and subcategories. Customizable grouping and calculation criteria for flexibility in data analysis.
subtotal steps "To use the Subtotal function in OpenOffice, follow these steps:Open a new or existing spreadsheet in OpenOffice. Select the range of data you want to subtotal. Click on Data > Subtotals from the menu bar. In the Subtotals dialog box, select the column you want to group by and the function you want to use (such as sum or count). Click OK to apply the subtotals. "
what if scenarios âwhat-ifâ analysis in scenarios
you can test different possibilities and explore the potential impact of changes to your data
scenarios Scenarios in OpenOffice electronic spreadsheet refer to a feature that allows you to create and compare different sets of data to explore different outcomes or possibilities. Scenarios are useful when you want to explore how changes in data will affect your calculations
such as in financial modeling or forecasting
advantages of using scenarios Provides a way to compare and contrast different sets of data and their potential impact. Can save time by allowing you to easily create and test different scenarios. Allows you to explore different outcomes or possibilities based on changes to your data. Helps you to better understand your data and make more informed decisions.
what if scenarios steps Open a new or existing spreadsheet in OpenOffice. Enter the original data that you want to use as the basis for your scenarios. Click on Tools > Scenarios from the menu bar. In the Scenarios dialog box
click on Add to create a new scenario. Give your scenario a name and select the cells you want to vary in your scenario. Enter the new values for each cell in your scenario. Click OK to save your scenario. Repeat steps 4-7 to create additional scenarios. To compare scenarios
goal seek Goal Seek in electronic spreadsheet refers to a feature that allows you to find the input value needed to achieve a specific output value. This can be useful when you know the desired result of a calculation
but you are not sure what input value is needed to achieve that result. For example
goal seek steps To use Goal Seek in an electronic spreadsheet
follow these steps:Enter the formula that you want to use in the cell where you want the output value to appear. Enter an initial value for the input cell that you want to change. Click on Tools > Goal Seek from the menu bar. In the Goal Seek dialog box
solver The Solver is a more advanced version of Goal Seek. While Goal Seek is designed to find a single variable solution
Solver can handle equations with multiple unknown variables. It is used to find the best possible outcome that meets a set of defined conditions
solver steps Place the cursor in the cell where the formula is entered. Now Click on Tools â Solver Now
a solver dialog box. Select the optimized result to option
inserting new sheet Steps for Creating New Sheet âChoose Insert > Sheet from the menu bar
Insert the sheet by right-clicking on the tab
renaming sheets Step 1 : Double-click on the name of a current worksheet. Step 2 : Use the context menu that appears when you right-click on the name of an existing worksheet to select Rename. Step 3 : Click on the worksheet tab to choose the worksheet you want to rename
and then choose the Sheet option from the Format menu. The Rename option should be chosen from the submenu that is displayed when you do this.
insert new sheet kb shift + F11
cell styles Cell styles include fonts
alignment
cell referencing Cell referencing in a spreadsheet is the process of referring to a specific cell or range of cells within a worksheet by using a unique identifier. This unique identifier is called a cell reference and it is made up of a combination of a column letter and a row number that identifies the location of a particular cell.
relative hyperlink Relative hyperlinks are links that are specified in relation to the current cellâs location.
absolute hyperlink Absolute hyperlinks
on the other hand
external data dialog box Using the External Data dialog: Go to âDataâ > âExternal Dataâ
select the source of the data
navigator (external data) Using the Navigator: Click on the âNavigatorâ icon or press F5
expand the âData Sourcesâ section
linking to registered source ""
saving a shared worksheet ""
adding comment select the cell you want to add a comment in. Insert => comment from the menu bar type the desired comment click outside the box to close it
editing comments right click the cell that contains the comment. a context menu appears. select show comments option from the context menu double click the box to edit comments blinking cursor appears edit the comment as you like click outside after editing the comment.
formatting the comment right click the cell that contains the comment. a context menu appears. select show comments option from the context menu select the box that contains the comment formatting toolbar changes to formatting the comment click outside the box after completeing the formatting
record changes ""
steps to record chages ""
viewing changes ""
filter changes in calc "you can filter based on "
accepting or rejecting a change ""
merging worksheets ""
comparing documents " "
macro ""
using a macro recorder ""
advantages of using a macro ""
using a macro as a function open a new or exisiting worksheet that contains a macro select the cell in which you want to add the macro type =Addition() in the desired cell press the Enter key
create a macro with argument open a new or existing spreadheet save the spread sheet select tools =>macros=> organize macros => openoffice basic option form the menu bar click the organizer button to open the oo basic macro organizer click the libraries tab in the oo basic macro organizer. click the new button in the library type the name of the module in the name text box click the OK button. click the edit button to edit the library modify the code as per your liking click the save button on…
passing arguments to a macro "open a new or existing spreadsheet that contains a macro selec the cell in which you want to call the macro type the =""macroFunctionname""(arg1,arg2,...) press the ENTER key "
sorting colums using macros ""
Database A database is an organized collection of data. For example:- In a stationary shop
detailed records of the materials available in the shop is database. Similarly in a computerized system
Database Management System (DBMS) A database management system is a software package with computer programs that controls the creation
maintenance and use of a database. A DBMS allows different user application programs to concurrently access the same database. Some of the DBMSs are Oracle
Advantages of Database Reduces Data Redundancy : no chance of encountering duplicate data Sharing of Data : the users of the database can share the data among themselves Data Integrity : Data integrity means that the data is accurate and consistent in the database Data Security : Only authorised users are allowed to access the database and their identity is authenticated using a username and password Privacy : The privacy rule in a database states that only the authorized users can access a dat…
Realtionships ""
Data can be organized into two types:- Flat File: Data is stored in a single table. Usually suitable for less amount of data. Relational: Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.
Database Servers Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Databases on the database servers are accessed through command line or graphic user interface tools referred to as Frontends; database servers are referred to as Back-ends. Such type of data access is referred to as Client-server model.
RDBMS:- A relational database management system (RDBMS) is a database management system that is based on the relational model. In the relational model of a database
all data is represented in terms of tuples (rows)
Database Concepts:- "Database contains objects that are used for storing and managing information. 1. Item : - Item is about which information is stored in the database. 2. Field:- Each question that we ask about our item is a Field. 3. Record:- Record is a set of information (made up of fields) stored in your database about one of the items. 4. Value:- Value is the actual text or numerical amount or date that you put in while adding information to your database. 5. Key Field :- Key Field is a…
How data is organized in a RDBMS ? In RDBMS
data is organized in the form of inter linked tables.
TABLE A table is a set of data elements that is organized using a model of vertical columns and horizontal rows. Each row is identified by a unique key index or the key field.
COLUMNS OR FIELD A column is a set of data values of a particular simple type
one for each row of the table. For eg. Emp_Code
ROWS OR RECORDS OR TUPLES A row represents a single
data items in a table. Each row in a table represents a set of related data
DATA TYPES :-Datatypes are used to identify the type of data we are going to store in the database. Categories of data types:- Data types can be broadly classified into five categories:- 1. Numeric Types 2. Alphanumeric Types 3. Binary Types 4. Date Time 5. Other variable Types
NUMERIC TYPES:- " They are used for describing numeric values like mobile number, age, etc. "
ALPHANUMERIC TYPES:- The list of different datatypes available in alphanumeric types are 1. LongVarChar (Memo) (Long Text) 2. Char (Text-fix) (Small Text) 3. VarChar (Text) (Text of specified Length) 4. VarChar_IgnoreCase (Text) (Comparisions are not case sensitive)
BINARY TYPES:- Binary types are used for storing data in binary formats. It can be used for storing photos
music files or (in general file of any format) etc. The list of different datatypes available in Binary types are :- 1. LongVarBinary (Image) 2. Binary (Binary (fix) 3. VarBinary (Binary)
DATE TIME:- Date time data types are used for describing date and time values for the field used in the table of a database. It can be used for storing information such as date of birth
date of admission etc. The list of different data types available in Date Time type are :- 1. Date (Stores month
PRIMARY KEY:- A primary key is a unique value that identifies a row in a table. These keys are also indexed in the database
making it faster for the database to search a record.
FOREIGN KEY:- The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.
relation between primary key and foreign key Note:- The âoneâ side of a relation is always the parent
and provides the PK(Primary Key) Attributes to be copied. The âmanyâ side of a relation is always the child
Option to set primary key Table Data View dialog box 1. Right Click the name of the table in the OpenOffice Base window in which you want to set the primary key. A context menu appears. 2. Select the Edit option from the context menu The table design widow of the selected table appears 3. Right-click the row head of the field that you want to make as primary key 4. select the primary key option from the context menu 5. click the save button to save the table
inserting data into a table ""
Editing records in the table ""
deleting records from the table ""
Sorting Data in a table Select the column based on which you want to sort the data of the table Select sort ascending or descending The whole table is sorted
Field Properties : Steps to set field properties â Select the table > Right-click > Select the option Edit > the table will open in Design View. There are various properties of fields according to the data type set for each field in the design view.
AutoValue Field Properties if set to yes then the field will get the auto numeric values. if set to no then the field will not get the auto numeric values.
Length Field Properties By default length of the field is 10 but the size of the field can be set to maximum length.
Default value (field properties) A default value can be set for a field if the user doesnât provide any value while entering the values in the table.
Remove relationship ""
Data Definition Language ""
Data Manipulation Language ""
Select Statement ""
Update Statement ""
performing calculations ""
A query It alloes you to extract data from single or multiple tables as well as summarize and filter it.
Entry Required if set to yes then it will be a must to insert the value in the field.
FORM A form provides the user with a systematic way of storing information in the database. It is an interface in a user-specified layout that lets users view
enter
REPORT: A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format.
Options to enter or remove data from forms When you complete all the steps of form wizard
you will get a form navigation toolbar at bottom of the form window. In this form navigation
Modifying Form Modifying form is a simple process. Click on the record box whatever you want to modify and then save the record. To navigate through different records use form navigation control and modify it.
Changing Label and background The form created through the wizard is not allowing to modify the labels directly
because the displayed label and text box showing the field value are grouped together by default. Ungroup them first and then you can change it. Follow these steps: Right-click on the displayed field value in the form. Choose Group > Ungroup. Now click on the double click on the label. Field label properties will open. Find the label text and type your desired text. Now close the properties window. Adjust the label accordingly. Save the form. In a similar manner you can change the background
Searching records using the form To search a record using form
follow these steps: Click on Find Record button from the navigation toolbar. A new dialog box appears with the title âRecord Searchâ. Type text you want to search in the search for option and in the box available at the front of Text. Select the fields whether all the fields or single field from the box. Apply the desired settings and click on search button. Now the record that you have searched
numbering styles Numbering styles apply similar alignment
numbering or bullet characters
frame styles Frame styles are used to format graphic and text frames
including wrapping type
character styles Character styles affect selected text within a paragraph
such as the font and size of text
paragraph styles Paragraph styles control all aspects of a paragraphâs appearance
such as text alignment
page styles Page styles include margins
headers and footers
Format property of the field in a table This property helps to set the format of the data entered in the field
There are three types of relationships ""
insert picture dialog box steps Click in the Open Office document where you want the image to appear. â¢ Choose Insert > Picture > From File from the menu bar. â¢ On the Insert Picture dialog (see Figure 5)
navigate to the file to be inserted
Inserting An Image From The Clipboard 1. Open both the source document and the target document. 2. In the source document
select the image to be copied. 3. Move the mouse pointer over the selected image and press Control+C to copy the image to the clipboard. 4. Switch to the target document. 5. Click to place the cursor where the graphic is to be inserted. 6. Press Control+V to insert the image.