Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Personalizing Access

    Uploaded by

    atanoso.josephinegbsa1993

    Copyright:

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

    Personalizing Access

    Uploaded by

    atanoso.josephinegbsa1993
    12 views2 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    12 views2 pages

    Personalizing Access

    Uploaded by

    atanoso.josephinegbsa1993

    Copyright:

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

    Laboratory Activity

    When working in Access or another Microsoft Office application, it is useful to personalize your copy of the
    software. Personalizing your software helps credit you as the creator of the Access database or other Office
    application.
    GET READY. LAUNCH Access if it is not already running.
    1. Click the File tab.
    2. Click the Options button to display the Access Options dialog box.

    Take Note Throughout this lesson you will see information that appears in black text within brackets, such as [Press
    Enter], or [your e-mail address]. The information contained in the brackets is intended to be directions for you rather
    than something you actually type word-for-word. It will instruct you to perform an action or substitute text. Do not
    type the actual text that appears within brackets.

    3. In the Personalize your copy of Microsoft Office section of the dialog box, key [your name] in the User
    name box and key [your initials] in the Initials box.
    4. Click OK to close the dialog box.

    Project 1-2: Understanding Database Design


    You work at Margie’s Travel, a full-service travel agency that specializes in providing services to senior
    citizens. You plan to create a database of tours, cruises, adventure activities, group travel, and vacation
    packages geared toward seniors, but first you want to learn more about database design.
    GET READY. LAUNCH Access if it is not already running.
    1. Open Access Help.
    2. Search for database design.
    3. Read the article about database design basics.
    4. OPEN a new Word document.
    5. List the steps that should be taken when designing a database with a short description of each.
    6. SAVE the document as database_design and then CLOSE the file.
    LEAVE Access open for the next project.

    Project 1-3: Planning Table Fields


    You are a volunteer for the Tech Terrace Neighborhood Association that holds an annual March Madness
    5K Run. In the past, all data has been kept on paper, but you decide it would be more efficient to create a
    database. Decide what fields would make sense for a table holding data about the runners. GET READY.
    LAUNCH Access if it is not already running.
    1. Think about what fields would be useful in a database table that contains information about the runners
    in an annual 5K road race.
    2. OPEN a new Word document.
    3. In the document, key a list of the names of at least six possible field names.
    4. SAVE the document as race_fields and keep the file open.
    LEAVE Access open for the next project.

    Project 1-4: Planning Data Types for Fields

    Now that you have decided what fields to use in a database table containing information about
    runners in an annual 5K road race, you need to determine what data type should be used for each
    field.
    USE the document you used in the previous project.
    1. Beneath the name of each possible field name for the table about runners in the annual 5K road race,
    key the data type that would be used with a short explanation of why you chose that type.
    2. SAVE the document as data_type and then CLOSE the fi le.
    LEAVE Access open for the next project.

    Project 1-5: What’s New in Microsoft Access 2010


    Your supervisor at Margie’s Travel has suggested that you research what’s new in Access 2010 before you
    begin to create a database.
    GET READY. LAUNCH Access if it is not already running.
    1. Open the Backstage view and access the Help menu.
    2. Use Access Help to locate the article “What’s New in Microsoft Access.”
    3. Read the overview.
    4. In the document key a list of all new features of Microsoft Access
    5. Save the document as new features_ms access and the CLOSE the file.
    CLOSE Access.

    You might also like