Spreadsheet Sales Report

BY IN ITGS - Database & Spreadsheet Comments Off on Spreadsheet Sales Report

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 …

Key Terms

BY IN ITGS - Database & Spreadsheet Comments Off on Key Terms

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 …

Database Driven Website

BY IN ITGS - Database & Spreadsheet Comments Off on Database Driven Website

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 …

Table and Query

BY IN ITGS - Database & Spreadsheet Comments Off on Table and Query

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 …

Database Management System

BY IN ITGS - Database & Spreadsheet Comments Off on Database Management System

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 …

What is a database?

BY IN ITGS - Database & Spreadsheet Comments Off on What is a database?

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 …