Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    MS Access Lecture 03

    Uploaded by

    shazia Tariq
    The document discusses creating and working with databases, tables, queries, forms and reports in Microsoft Access 2007. It explains how to create a database using a template or blank file, add fields to a table with different data types including setting a primary key, and design and run basic queries to filter and sort data from tables. Practical instructions are provided to build a sample database with a table of employee records and a query to retrieve records based on salary, area, and employee ID fields.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    MS Access Lecture 03

    Uploaded by

    shazia Tariq
    33 views15 pages
    The document discusses creating and working with databases, tables, queries, forms and reports in Microsoft Access 2007. It explains how to create a database using a template or blank file, add fields to a table with different data types including setting a primary key, and design and run basic queries to filter and sort data from tables. Practical instructions are provided to build a sample database with a table of employee records and a query to retrieve records based on salary, area, and employee ID fields.

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses creating and working with databases, tables, queries, forms and reports in Microsoft Access 2007. It explains how to create a database using a template or blank file, add fields to a table with different data types including setting a primary key, and design and run basic queries to filter and sort data from tables. Practical instructions are provided to build a sample database with a table of employee records and a query to retrieve records based on salary, area, and employee ID fields.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    33 views15 pages

    MS Access Lecture 03

    Uploaded by

    shazia Tariq
    The document discusses creating and working with databases, tables, queries, forms and reports in Microsoft Access 2007. It explains how to create a database using a template or blank file, add fields to a table with different data types including setting a primary key, and design and run basic queries to filter and sort data from tables. Practical instructions are provided to build a sample database with a table of employee records and a query to retrieve records based on salary, area, and employee ID fields.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 15

    Computer Science

    Ch: MS Access 2007 CLASS VIII

    Topic : Query
    Apply and Run Query
    Introduction to MS Access
     Database: arrangement of data to retrieve
    and understand easily.
     Viewing information

    Terminology
    ◦ Database
    ◦ Database Management system
    ◦ Table
    ◦ Record
    ◦ Field
    Pages 20 and 21
    Database Objects
     Table: stores data in the form of columns and
    rows
     Query: uses to filter and sorting out the data
     Forms: Customize screen to view data
     Reports: Table ,query or Form in a printable

    way.
    MS Access Window

    Page No 26 and 27 to be
    read
    MS Access 2007
     Starting MS Access
     Creating Database : Two ways
    ◦ Using a template
    ◦ Using blank Database
    Pages 23 and 24 to be read
    Data Type used in MS Access
    Page 27 to be read
    Text: stores alphanumeric Product ID: iuy789
    numbers. Address: H.no A-90 survey 478
    Maximum 255 Character Karachi
    Auto Number: stores integer S.No
    Generates automatically ID numbers
    Increasing and decreasing order
    Memo: For lengthy and details text Definition, description notes

    Number: Holds number both Phone number, weight, height


    decimal or without decimal. Temperature etc

    Page 27
    Primary key
      Primary key is a field in a table which
    uniquely identifies each row/record in a
    database table. 
     Primary keys must contain unique values.
     A table can have only one primary key, which

    may consist of single or multiple fields.


    Assign primary key

    Tab: Design
    Group: Tools
    Option: Primary key
    How to Choose a Primary Key
     Good primary keys are usually short and
    include all numbers.
     Avoid using special characters or a

    combination of uppercase and lowercase


    letters.
     Some things that do NOT make good primary

    keys are zip codes, email addresses and


    Name or Phone numbers.
    Query in MS Access
     A query is a question pertaining to the data
    with a specific answer to it.
     They way to filter and retrieve data from

    tables of the database

    Page 39
    To raise a query
    Click on
    create tab

    Click on design
    query option

    Click on add
    option

    Click on add
    option

    Steps: 1)Create tab –2)design query—3)add—4)table Page 39


    To raise a query

    Double click on every field name


    Page 39
    Run a Query Page 41

    Design
    Grid
    Result
    MS Access Practical
    Task to be performed
     Open Blank database
     Choose name of the database
     Open Datasheet view
     Create 7 fields
     Field name ( S.no, EmpID, Name, Office Area, Salary,
    Joining date , Email ID)
     Set data type
     Apply primary key
     Enter 10 records
     Design and run Query ( Salary, Area, EmpID)
     Save the table and query

    You might also like