ITGS – Database & Spreadsheet

contactwahyu on March 12th, 2011

Sales Report A: Disc 10% B: 15% C: 20% Determine the formula to calculate sales discount depend on item =IF(C2=”A”,0.1,IF(C2=”B”,0.15,0.2)) Fomula IF is needed more than one, IF ONLY the condition have more than two values Checking the string/text value need to put inside quote, while checking the number value don’t If the formula has […]

Continue reading about Spreadsheet Sales Report

contactwahyu on March 12th, 2011

Data that has several parts can be divided into fields. For example, a computer may represent today’s date as three distinct fields: the day, the month and the year. Thus, in computer science, things are divided into fields to make it easier for the user to recognize and use them while it also makes it […]

Continue reading about Key Terms

contactwahyu on March 12th, 2011

A database driven website is a website that normally some of its contents is taken from the database. The example of this kind of website is news website, which is require everyday to update. A website that its contents comes from database is called dynamic website, while regular website is called static website Content Management […]

Continue reading about Database Driven Website

contactwahyu on March 12th, 2011

Database tables will most likely be the area you’ll become most familiar with after working with databases for a while. Now, before we go ahead and start adding tables to our new database, let’s have a look at what a database table actually is. What is a Table? In database terms, a table is responsible […]

Continue reading about Table and Query

contactwahyu on March 12th, 2011

A Database Management System (DBMS), is a software program that enables the creation and management of databases. Generally, these databases will be more complex than the text file/spreadsheet example in the previous lesson. In fact, most of today’s database systems are referred to as a Relational Database Management System (RDBMS) , because of their ability […]

Continue reading about Database Management System

contactwahyu on March 12th, 2011

A database is a collection of data. That may sound overly simplistic but it pretty much sums up what any database is. A database could be as simple as a text file with a list of names. Or it could be as complex as a large, relational database management system, complete with in-built tools to […]

Continue reading about What is a database?