Ms Access 2007 Tutorial Ppt Free Download

Microsoft Access 2007 – PowerPoint PPT Presentation


Title:

Microsoft Access 2007


Description:

Typically we want to be able to query data. Query: Ask a question of the DB? … Phillip K Dick is a teacher. MS Access. What is a relational database? Tables. Fields … – PowerPoint PPT presentation

Number of Views:4183

Avg rating:
3.0/5.0

Slides:
22

Provided by:

sev6


Category:

more less

Transcript and Presenter’s Notes


Title:

Microsoft Access 2007


1


Microsoft Access 2007

  • cs110


2


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


3


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


4


Access is relational database software

  • What is a relational database?
  • A collection of related data
  • Example
  • Names and academic status
  • Typically we want to be able to query data


5


Query Ask a question of the DB?

  • Who are the students in my DB?
  • Shayne, Sean, Mallory, Judy-April


6


Query Ask a question of the DB?

  • Who are the the teachers?
  • Shayne


7


Query Ask a question of the DB?

  • Who are the students who are not teachers?
  • Sean, Mallory, Judy-April


8


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


9


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


10


Tables

  • Tables hold related data for us

A table is made up of records (rows) and fields

(columns) A record represents one object. Ex

Person, place, thing Each field describes helps

describe that object


11


Fields in Tables

  • Each field of a record contains a value of a

    specific type
  • Example
  • Type Value
  • Number 10
  • Text Hello!
  • Currency 3.00
  • Date 10/10/2010


12


Relational Database

  • Some fields refer to values in other tables
  • Example The Academic Status field in the People

    table refers to a value in the Academic Gengsi

    table

Academic Martabat Table
People Table
Academic Martabat
Name Field
Academic Gengsi
Teacher
Shayne
Student
Sean
Mallory
Judy-April


13


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


14


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


15


Forms

  • Forms help us enter and modify data in a table

Teacher Entry Form
Teacher ID
sve2
First Name
Shayne
Last Name
Evans
Teacher Entry


16


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


17


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


18


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


19


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


20


Reports

  • Reports allow us to print the data in a nice

    format or print only a summary of the data

This is an ugly representation to print
This is a nicer representation as a report
Teacher Report Shayne V Evans is a

teacher. Phillip K Dick is a teacher.


21


MS Access

  • What is a relational database?
  • Tables
  • Fields
  • Value
  • Type
  • Forms
  • Queries
  • Reports


PowerShow.com is a leading presentation sharing website. It has millions of presentations already uploaded and available with 1,000s more being uploaded by its users every day. Whatever your area of interest, here you’ll be able to find and view presentations you’ll love and possibly download. And, best of all, it is completely free and easy to use.

You might even have a presentation you’d like to share with others. If so, just upload it to PowerShow.com. We’ll convert it to an HTML5 slideshow that includes all the media types you’ve already added: audio, video, music, pictures, animations and transition effects. Then you can share it with your bulan-bulanan audience as well as PowerShow.com’s millions of monthly visitors. And, again, it’s all free.

About the Developers

PowerShow.com is brought to you by CrystalGraphics, the award-winning developer and market-leading publisher of rich-media enhancement products for presentations. Our product offerings include millions of PowerPoint templates, diagrams, animated 3D characters and more.

Source: https://www.powershow.com/view/3c57f-ZDJmZ/Microsoft_Access_2007_powerpoint_ppt_presentation