Scribd Logo
Upload

Welcome to Scribd!

    • 15 views

    Access Tutorial 1 Creating A Database: First Course

    Uploaded by

    nebiyu
    The document introduces Microsoft Access and how to create and manage databases. It covers defining database terms like fields, records, tables and relationships. It provides steps to create a blank database, build a table, enter records, and save the table. It also explains how to open databases, navigate tables, build simple queries, forms and reports, and print reports. Finally, it discusses compacting, backing up and restoring databases for management.

    Copyright:

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

    Access Tutorial 1 Creating A Database: First Course

    Uploaded by

    nebiyu
    15 views28 pages
    The document introduces Microsoft Access and how to create and manage databases. It covers defining database terms like fields, records, tables and relationships. It provides steps to create a blank database, build a table, enter records, and save the table. It also explains how to open databases, navigate tables, build simple queries, forms and reports, and print reports. Finally, it discusses compacting, backing up and restoring databases for management.

    Original Description:

    cvbnm

    Original Title

    Access 01

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document introduces Microsoft Access and how to create and manage databases. It covers defining database terms like fields, records, tables and relationships. It provides steps to create a blank database, build a table, enter records, and save the table. It also explains how to open databases, navigate tables, build simple queries, forms and reports, and print reports. Finally, it discusses compacting, backing up and restoring databases for management.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    15 views28 pages

    Access Tutorial 1 Creating A Database: First Course

    Uploaded by

    nebiyu
    The document introduces Microsoft Access and how to create and manage databases. It covers defining database terms like fields, records, tables and relationships. It provides steps to create a blank database, build a table, enter records, and save the table. It also explains how to open databases, navigate tables, build simple queries, forms and reports, and print reports. Finally, it discusses compacting, backing up and restoring databases for management.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 28

    Access Tutorial 1

    Creating a
    Database

    FIRST COURSE

    Objectives

    XP

    Define the terms field, record, table,


    relational database, primary key, and
    foreign key
    Create a blank database
    Identify the components of the Microsoft
    Access window
    Create and save a table in Datasheet view
    Enter field names and records in a table
    datasheet
    Open a table using the Navigation Pane
    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Objectives

    XP

    Open an Access database


    Copy and paste records from another Access
    database
    Navigate a table datasheet
    Create and navigate a simple query
    Create and navigate a simple form
    Create, preview, navigate, and print a simple
    report
    Learn how to manage a database by compacting,
    backing up, and restoring a database

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Organizing Data

    XP

    Your first step in organizing data is to


    identify the individual fields
    The specific value, or content, of a field is
    called the field value
    Record

    Next, you group related fields together


    into tables

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Databases and Relationships XP


    A collection of related tables is called a
    database, or a relational database
    You connect the records in the separate tables
    through a common field
    A primary key is a field, or a collection of
    fields, whose values uniquely identify each
    record in a table
    When you include the primary key from one
    table as a field in a second table to form a
    relationship between the two tables, it is called
    a foreign key in the second table
    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Databases and Relationships XP

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Relational Database
    Management Systems

    XP

    A database management system


    (DBMS) is a software program that lets
    you create databases and then
    manipulate data in them
    In a relational database
    management system, data is
    organized as a collection of tables

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Exploring the
    Microsoft Access Window

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    Creating a Table in Datasheet


    View

    XP

    Click the Create tab on the Ribbon


    In the Tables group, click the Table button
    Accept the default ID primary key field with
    the AutoNumber data type, or rename the
    field and change its data type, if necessary
    Double-click the Add New Field column
    heading, and then type the name for the
    field you are adding to the table
    Press the Tab key or the Enter key
    New Perspectives on Microsoft Office 2007: Windows XP Edition

    Creating a Table in Datasheet


    View

    XP

    Add all the fields to your table by typing the field


    names in the column headings and pressing the Tab
    key or the Enter key to move to the next column
    In the first row below the field names, enter the
    value for each field in the first record, pressing the
    Tab key or the Enter key to move from field to field
    After entering the value for the last field in the first
    record, press the Tab key or the Enter key to move
    to the next row, and then enter the values for the
    next record. Continue this process until you have
    entered all the records for the table
    Click the Save button on the Quick Access Toolbar,
    enter a name for the table, and then click the OK
    button

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    10

    Creating a Table in Datasheet


    View

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    11

    Entering Records

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    12

    Saving a Table

    XP

    Click the Save button on the Quick


    Access Toolbar. The Save As dialog box
    opens
    In the Table Name text box, type the
    name for the table
    Click the OK button

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    13

    Opening a Database

    XP

    Start Access and display the Getting


    Started with Microsoft Office Access
    page
    Click the More option to display the
    Open dialog box
    Navigate to the database file you want
    to open, and then click the file
    Click the Open button

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    14

    Opening a Database

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    15

    Navigating a Datasheet

    XP

    The navigation buttons provide


    another way to move vertically through
    the records

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    16

    Creating a Simple Query

    XP

    A query is a question you ask about


    the data stored in a database
    The Simple Query Wizard allows you
    to select records and fields quickly

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    17

    Creating a Simple Query

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    18

    Creating a Simple Form

    XP

    A form is an object you use to enter,


    edit, and view records in a database
    You can design your own forms, use the
    Form Wizard, or use the Form tool to
    create a simple form with one mouse
    click

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    19

    Creating a Simple Report

    XP

    A report is a formatted printout (or


    screen display) of the contents of one
    or more tables in a database
    The Report tool places all the fields
    from a selected table (or query) on a
    report, making it the quickest way to
    create a report

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    20

    Creating a Simple Report

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    21

    Creating a Simple Report

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    22

    Creating a Simple Report

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    23

    Printing a Report

    XP

    Open the report in any view, or select the


    report in the Navigation Pane
    To print the report with the default print
    settings, click the Office Button, point to Print,
    and then click Quick Print
    or
    To display the Print dialog box and select the
    options you want for printing the report, click
    the Office Button, point to Print, and then click
    Print (or, if the report is displayed in Print
    Preview, click the Print button in the Print
    group on the Print Preview tab)
    New Perspectives on Microsoft Office 2007: Windows XP Edition

    24

    Viewing Objects in the


    Navigation Pane

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    XP

    25

    Compacting and Repairing a


    Database

    XP

    Compacting a database rearranges


    the data and objects in a database to
    decrease its file size

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    26

    Compacting and Repairing a


    Database

    XP

    Make sure the database file you want


    to compact and repair is open
    Click the Office Button, point to
    Manage, and then click Compact and
    Repair Database

    New Perspectives on Microsoft Office 2007: Windows XP Edition

    27

    Backing Up and Restoring a


    Database

    XP

    Backing up a database is the process of


    making a copy of the database file to
    protect your database against loss or
    damage
    The Back Up Database command enables
    you to back up your database file from
    within the Access program, while you are
    working on your database
    To restore a backup database file, you
    simply copy the backup from the drive on
    which it is stored to your hard drive
    New Perspectives on Microsoft Office 2007: Windows XP Edition

    28

    You might also like