1 of 12

INTRODUCTION TO �MICROSOFT ACCESS

  1. OVERVIEW OF DATA, DATABASES AND ‘IS’
  2. FILE PROCESSING SYSTEMS AND DATABASES
  3. DATABASE MANAGEMENT SYSTEM
  4. APPLICATION DEVELOPMENT LANGUAGE AND TOOLS

2 of 12

OVERVIEW OF DATA, DATABASES

AND INFORMATION SYSTEM

Overview of Data

Definition of data :

  • It refers simply to raw facts and figures.
  • The real goal is to turn data into information.

​

Example of data : name, age, height, weight

3 of 12

OVERVIEW OF DATA, DATABASES

AND INFORMATION SYSTEM

Overview of Database and Information System

  • It is a part of a larger whole known as an information system (IS).
  • It provides for data collection, storage, and retrieval; facilitates the transformation of data into information; and manages both data and information
  • composed of people, hardware, the DBMS and other software, database(s), application programs, and procedures
  • Current information systems should always be integrated with the company’s enterprise-wide information systems architecture.

​

4 of 12

FILE PROCESSING SYSTEM AND DATABASE

FILE SYSTEM

DATABASE

  • A software that manages and organizes the files in a storage medium

​

  • No recovery system

​

  • High inconsistency of data

​

  • Not support for complicated transactions

​

  • No concurrency facility
  • A software application that is used for accessing, creating, and managing databases

​

  • Provides recovery system

​

  • Low inconsistency of data

​

  • SQL – for complicated transactions

​

  • Provides concurrency facility

5 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

DBMS is a collection of programs

​

    • Manage structure and control access to data
    • As an intermediary between the user and the database
    • Database structure stored as file collection
    • Access database through the DBMS
    • Enables data to be shared
    • Integrates many users’ views of the data

6 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

7 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

Advantages of a DBMS:

    • Improved data sharing
    • Improved data security
    • Better data integration
    • Minimized data inconsistency
    • Improved data access
    • Improved decision making
    • Increased end-user productivity

8 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

Types of Database:

Databases can be classified according to:

    • Number of users
    • Database location(s)
    • Expected type and extent of use

​

Single-user database supports only one user at a time

    • Desktop database – single-user, runs on PC

​

Multiuser database supports multiple users at the same time

    • Workgroup database supports a small number
    • Enterprise database supports a large number

9 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

Types of Database:

​

  • Centralized database: data located at a single site
  • Distributed database: data distributed across several different sites
  • Operational database: supports a company’s day-to-day operations

- Transactional or production database

  • Data warehouse: stores data used for tactical or strategic decisions

10 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

The Database System Environment

Database system: defines and regulates the collection, storage, management, use of data

​

Five major parts of a database system:

    • Hardware
    • Software
    • People
    • Procedures
    • Data

11 of 12

DATABASE MANAGEMENT SYSTEM (DBMS)

StudentID

Student’s Name

Phone Num

Address

1202432

Boboi

0192223333

No.134, Jln Kiara

1202433

Abu

0192658956

No.153, Jln Sata

12 of 12

APPLICATION DEVELOPMENT LANGUAGE AND TOOLS

DATABASE LANGUAGE & TOOLS

SQL

SQL

SERVER

MySQL

ORACLE

JAVA

C++

MariaDB

Microsoft Access