250 likes | 697 Views
Database Software. ICTL FORM 2. What is a database?. Data: can be words, numbers, pictures etc. Database: a database is a collection of related data or information. Examples of database software. Oracle DB2 Microsoft Access Microsoft Report Server PostgreReport MyReport Reportite
E N D
Database Software ICTL FORM 2
What is a database? • Data: can be words, numbers, pictures etc. • Database: a database is a collection of related data or information.
Examples of database software • Oracle • DB2 • Microsoft Access • Microsoft Report Server • PostgreReport • MyReport • Reportite • FileMaker • Sybase Adaptive Server Enterprise
Example of database application • Sistem Maklumat Pelajar (SMP) • Sistem Pinjaman Buku (SPB)
Microsoft Access 2003 • Microsoft Access 2003 (Access 2003) is a database system management (database programs). It can store, manage, manipulate, analyze, retrieve, display or publish information from database.
Queries MICROSOFT ACCESS offers different types of queries for the data analyst. These queries are: • Select query • Append query • Update query • Delete query • Make table query • Cross tab query
Website • http://www.msaccess-skillbuildit.com/ • http://www.teach-ict.com/ks3_old/unit7_5/starters/hangman1.htm