Scribd Logo
Upload

Welcome to Scribd!

  • 44 views

    Prachi

    Uploaded by

    Jatin Dua
    This document provides an overview of databases and Microsoft Access. It defines what a database is and how Access works by storing related information in tables and allowing connections between tables. It then compares Access and Excel, noting that Access is for databases with tables and relationships while Excel is for calculations and graphs. Finally, it outlines some key Access concepts like forms, queries, reports and using tables to store customer, product and order information.

    Copyright:

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

    Prachi

    Uploaded by

    Jatin Dua
    44 views36 pages
    This document provides an overview of databases and Microsoft Access. It defines what a database is and how Access works by storing related information in tables and allowing connections between tables. It then compares Access and Excel, noting that Access is for databases with tables and relationships while Excel is for calculations and graphs. Finally, it outlines some key Access concepts like forms, queries, reports and using tables to store customer, product and order information.

    Original Title

    prachi

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of databases and Microsoft Access. It defines what a database is and how Access works by storing related information in tables and allowing connections between tables. It then compares Access and Excel, noting that Access is for databases with tables and relationships while Excel is for calculations and graphs. Finally, it outlines some key Access concepts like forms, queries, reports and using tables to store customer, product and order information.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    44 views36 pages

    Prachi

    Uploaded by

    Jatin Dua
    This document provides an overview of databases and Microsoft Access. It defines what a database is and how Access works by storing related information in tables and allowing connections between tables. It then compares Access and Excel, noting that Access is for databases with tables and relationships while Excel is for calculations and graphs. Finally, it outlines some key Access concepts like forms, queries, reports and using tables to store customer, product and order information.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 36

    A

    PRACTICAL FILE
    ON
    DBMS
    (Session:2014-17)

    Submitted to: Submitted By:


    Miss Nidhi Sheoran Prachi wadhwa
    Assistant Prof. Uni. Roll No. ____
    KAIM BBA 4 th Sem.

    KEDARNATH AGGARWAL INSTITUTE OF MANAGEMENT

    Affiliated to M.D.University, Rohtak


    RESUME
    Prachi wadhwa
    prachiwadwa26@gmail.com

    OBJECTIVE:

    To achieve worthy position in management at which I will be placed


    and industrial growth & utilize my skills by serving the industry and
    get recognized for the same.
    BRIEF OVERVIEW:

     Dedicated worker.
     Ability to innovate and adapt to new situations.
     An effective team member with strong troubleshooting and problem solving
    skills.
     A dynamic and hardworking go-getter with abilities to accept challenges and
    deliver results.
     Accept challenges.

    Personal Data
    Father’s Name : Mr. Hansraj wadhwa
    Mother’s Name : Mrs. Renu wadhwa
    Date of Birth : 03 july 1997
    Gender : Female
    Language : English, Hindi
    Mobile-No : 8607256050
    Address : shubhash chowk near gurudwara Charkhi dadri ,bhiwani
    Academic

     10th C.B.S.E Board


    J.D.K.D.E.S Public School, Charkhi Dadri, Haryana

     12th C.B.S.E Board


    D.R.K.A.V.M charkhi dadri , Haryana

     Pursuing BBA KAIM, Charkhi Dadri


    Class/Standard Year of Passing percentage Remarks

    12th 2014 65% Pass

    10th 2012 86% Pass

    Hobbies

     Creativity
     Listening music
     Dancing
     Makeup artist

    Place: Charkhi Dadri


    Content
    1.Access Basic
    2.Table (Customer)
    3.Form
    4.Split Form
    5.Multiple Form
    6. Query & Report
    INTRODUCTION
    A database is a list of items stored somewhere to make
    their values easy to access or retrieve. This means that a
    database can exist anywhere, including human or non-
    human memory. A computer database is a list or a group
    of lists created as a project. There are various ways and
    various types of applications used to create such a list. To
    make it more useful, special computer applications are
    formally developed to help create and manage computer
    databases.
    How does a Microsoft Access database work?
    Microsoft Access works in the same manner any
    database does, by storing related information together,
    and letting you create connections (commonly called
    relationships) between different things.  The
    relationships between two different things can be very
    simple (such as a contact at a customer and the customer
    itself) or complex.  In the example below, the blue boxes
    represent the major things we're tracking in our MS
    Access database tables, and the reports at right show
    how you can join the related information for analysis and
    reporting.
    DIFFERENCE BETWEEN EXCEL AND ACCESS
    Before knowing the difference between MS Excel and MS
    Access you must know that both of these application
    softwares are developed by Microsoft Corporation, in
    addition to these Microsoft Office packages
    include MS Word, MS PowerPoint, MS FrontPage MS
    Outlook. All of this software has different usability and
    functions.

    MS Access, in fact is a database that is used to store data


    in the form of tables, here the data inside the table is
    stored in the form of columns and rows and one
    complete set of data is called a record. In Ms Access you
    can query the database and can see only your required
    data in the form of Reports (A printable format
    containing the result of query.
    Both are for different purposes
    1)MS-Access has rdbms concept but ms-excel doesn't.
    2)Ms-excel is used for calculation and making graphs etc
    but in access we dont have such a facility;
    3)We have a table in access but in excel we have sheets
    however it is possible to transfer data between excel and
    access .
    Moreover ms-access has a relational concept for making
    relationship between tables.
    Access is mainly for handling databases not for
    Customer information.
    Form
    Multiple form
    Split form
    Report
    Product

    Product Query
    Form 1
    Split Form
    Multiple Form
    Customer order
    Customer Report
    Form 1
    Split form
    Multiple form
    Customer detail
    Query
    Form 1
    Split Form
    Bibliography
    1.www.wikipedia.com
    2.www.encyclopedia.com
    3.S.K.Singh

    You might also like