Introduction to databases
1 / 12

Microsoft Access - PowerPoint PPT Presentation

  • Uploaded on

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?.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Microsoft Access' - ely

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


  • 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


Drawer #2


Drawer #3


Supplier #1

Supplier #2

Supplier #100

Name, Address, City, Phone #, etc.

How data is organized
How Data is Organized


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:


    Customer Employee Supplier Orders





Access 2003
Access 2003

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

    Field FieldField



  • 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?).


  • 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


  • 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.).