Introduction to databases
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Microsoft Access PowerPoint PPT Presentation


  • 86 Views
  • Uploaded on
  • Presentation posted in: General

Introduction to Databases. Microsoft Access. Overview. What is a Database? What is a Database Management System? How is information organized in a database? What is Access? Database terminology. What is a Database?.

Download Presentation

Microsoft Access

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Introduction to databases

Introduction to Databases

Microsoft Access


Overview

Overview

  • What is a Database?

  • What is a Database Management System?

  • How is information organized in a database?

  • What is Access?

  • Database terminology


What is a database

What is a Database?

  • A database is a collection of data that is related to a particular topic or purpose.

  • Examples:

    • Library

    • Telephone Book

    • School Records

    • Business Database - Visa


What are database management systems

What are Database Management Systems?

  • A database management system (DBMS) is the software that lets you enter, maintain, retrieve, and output data from a database.


Understanding databases

Understanding Databases

Filing Cabinet

Drawer #1

Customers

Drawer #2

Suppliers

Drawer #3

Employees

Supplier #1

Supplier #2

Supplier #100

Name, Address, City, Phone #, etc.


How data is organized

How Data is Organized

Database

Table 1

Table 2

Table 3

Record 1

Record 2

Field 1

Field 2

Field 3

Field 1

Field 2

Field 3


What is access

What is Access?

  • Access is a database management system developed by Microsoft. It is part of the Microsoft Office software package (Word, Excel, Access, PowerPoint, etc.).

  • Access 2003 is the database management system we will be using.


Organizing information in access

Organizing information in Access

  • In Access, the database is organized into tables. For example:

    DATABASE

    Customer Employee SupplierOrders

Table

Table

Table

Table


Access 2003

Access 2003

  • Data in a table (or tables) is organized into columns (called fields) and rows (called records)

    FieldFieldField

    Record


Terminology

Terminology

  • Words to know:

    • Table: a storage structure of data that is composed of columns of information (fields) and repeated in rows (records).

    • Query: a question asked of the data contained in tables or other queries. (e.g., What students passed the final?).


Terminology1

Terminology

  • Form: a screen used to format the output of a query or table for display or to allow for data entry.

  • Report: Formatted output of data for printing – it receives data from tables and queries


Terminology2

Terminology

  • Field: A column of data in a table. (e.g. Last Name in a table of names and addresses)

  • Primary Key: The field on which a table can be related to another table to join the two together. (e.g. Your account number at your bank ties you to a table of transactions, loans, personal data, etc.).


  • Login