Scribd Logo
Upload

Welcome to Scribd!

  • 135 views

    Tani

    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 highlights some key differences between Excel and Access, noting that Access has database and relational concepts while Excel is meant for calculations. The document then provides examples of Access objects like forms, split forms, multiple forms and reports based on sample library and book information tables.

    Copyright:

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

    Tani

    Uploaded by

    Jatin Dua
    135 views33 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 highlights some key differences between Excel and Access, noting that Access has database and relational concepts while Excel is meant for calculations. The document then provides examples of Access objects like forms, split forms, multiple forms and reports based on sample library and book information tables.

    Original Title

    tani

    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 highlights some key differences between Excel and Access, noting that Access has database and relational concepts while Excel is meant for calculations. The document then provides examples of Access objects like forms, split forms, multiple forms and reports based on sample library and book information tables.

    Copyright:

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

    Tani

    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 highlights some key differences between Excel and Access, noting that Access has database and relational concepts while Excel is meant for calculations. The document then provides examples of Access objects like forms, split forms, multiple forms and reports based on sample library and book information tables.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 33

    A

    PRACTICAL FILE
    ON

    DBMS
    (Session: 2014-17)

    Submitted to: Submitted By:


    Miss Nidhi Sheoran Taniya Jain
    Assistant Prof. Uni. Roll No.____
    KAIM BBA 4 th Sem.

    KEDARNATH AGGARWAL INSTITUTE OF MANAGEMENT

    Affiliated to M.D.University, Rohtak


    RESUME
    Taniya Jain
    [email protected]

    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. Vinod Kumar Jain
    Mother’s Name : Mrs. Santosh Jain
    Date of Birth : 15-dec-1996
    Gender : Female
    Language : English, Hindi
    Mobile-No : 8607998008
    Address : Hira Chowk charkhi dadri charkhi gate, Bhiwani
    Academic

     10th Board H.B.S.E.


    Vaish Girls Sr. Sec. School, Charkhi Dadri, Haryana

     12th Board H.B.S.E.


    Vaish Girls Sr. Sec. School, Charkhi Dadri, Haryana

     Pursuing BBA KAIM, Charkhi Dadri


    Class/Standard Year of Passing percentage Remarks

    12th 2014 82% Pass

    10th 2012 84% Pass

    Hobbies

     Creativity
     Listening music
     Dancing
     Makeup artist

    Place: Charkhi Dadri


    Content
    1. Access Basic
    2. Table (Library)
    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 don’t 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
    calculation.
    Book Information Table
    Form
    Split form
    Multiple Form
    Book Information
    Report :Table 1
    Authors Information
    Form
    Split form
    Multiple form
    QUERY:TABLE 2
    Library Information
    Form
    Split form
    Multiple form
    Biblography
    1.www.wikipedia.com
    2.www.encyclopedia.com
    3.S.K. Singh

    You might also like