Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Business Driven 3E Technology Plug-In T8 - Decision Making Using Access

    Uploaded by

    Thao Trung
    This document provides instructions for creating forms and reports in Microsoft Access. It includes steps for using the Form Wizard and Report Wizard to create forms and reports from tables. It also describes how to modify form and report properties. Finally, it provides examples of creating forms and reports for different business scenarios, like a customer form with a subform for a recycling company database.

    Copyright:

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

    Business Driven 3E Technology Plug-In T8 - Decision Making Using Access

    Uploaded by

    Thao Trung
    14 views10 pages
    This document provides instructions for creating forms and reports in Microsoft Access. It includes steps for using the Form Wizard and Report Wizard to create forms and reports from tables. It also describes how to modify form and report properties. Finally, it provides examples of creating forms and reports for different business scenarios, like a customer form with a subform for a recycling company database.

    Original Title

    TechnologyPlugInT8IM.doc

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for creating forms and reports in Microsoft Access. It includes steps for using the Form Wizard and Report Wizard to create forms and reports from tables. It also describes how to modify form and report properties. Finally, it provides examples of creating forms and reports for different business scenarios, like a customer form with a subform for a recycling company database.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    14 views10 pages

    Business Driven 3E Technology Plug-In T8 - Decision Making Using Access

    Uploaded by

    Thao Trung
    This document provides instructions for creating forms and reports in Microsoft Access. It includes steps for using the Form Wizard and Report Wizard to create forms and reports from tables. It also describes how to modify form and report properties. Finally, it provides examples of creating forms and reports for different business scenarios, like a customer form with a subform for a recycling company database.

    Copyright:

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

    Instructor’s Manual

    BUSINESS DRIVEN 3e TECHNOLOGY PLUG-IN T8 – DECISION


    MAKING USING ACCESS

    LEARNING OUTCOMES

    1. Describe the steps for creating a form using the Form Wizard using Access.
    To create a form using the Form Wizard:
     Click the Create tab. Click the More Forms button, and then click Form Wizard.
     Click the Tables/Queries drop-down arrow and select the table you want to create a form for.
     Add all the fields you want to include in the form.
     Click Next to go to the next step.
     Select the form layout you want to use.
     Click Next.
     Select the graphic style you want to use.
     Click Next.
     Type in a title for the form.
     Click Finish to open the form and begin entering data.

    2. Describe the steps for creating and saving AutoForms using Access.
    To use the AutoForm:
     Select a table you want to create a form for.
     Click the Create tab and then click on the Form button
     Access automatically creates a Columnar Form based on the CUSTOMER table you
    selected.
     Close the form by clicking the Close box in the upper right corner.
     Access will automatically prompt you to save the form.

    3. Describe the steps to modify the properties of a form using Access.


    Here is a description on how to modify the properties of a form:
     Select a form in the Navigation Pane, right-click, and click on Design View.
     Click the Arrange tab, click the AutoFormat group, and then click the AutoFormat design you
    want to apply
     To change other form properties, open the Properties dialog box by clicking the Design tab
    and then click the Property Sheet button.
     Make sure that you are viewing the properties for the form by looking at the box at the top of
    the dialog.
     Scroll through the list of properties.
     Click the box next to the property that you want to change.

    4. Describe the steps for creating a report using the Report Wizard using Access.
    To create a report using the Report Wizard:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 1 of 10


    Instructor’s Manual

    Click the Create tab, and then click the Report Wizard button in the Reports group.
    Click the Tables/Queries drop-down arrow. Select the table and fields you want to include in
    your report.
     Click Next to go to the next step
     The next wizard asks how you want to view the report.
     Select a Grouping.
     Click Next.
     Specify a data sort.
     Click Next.
     Select a report layout and orientation.
     Click Next.
     Select a graphic style for the report.
     Click Next.
     Type in a title and select View the report.
     Click Finish.
    5. Describe the steps to modify the properties of a report using Access.
    To modify the report design:
     Double-click the Report you want to modify. Switch to Design view by clicking the Design
    View button.
     Review the layout of the report and select the properties, titles, headings and the like that you
    want to change.
     Switch back to Report View to see the effects of your changes.

    EXTENDING THE CORE MATERIAL


    Create a form that contains a subform (a one-to-many form) - http://office.microsoft.com/en-
    us/access/HA100986741033.aspx
     Create a grouped or summary report - http://office.microsoft.com/en-
    us/access/HA100068941033.aspx
    MAKING BUSINESS DECISIONS

    1. WasteNot Recycling

    Project Purpose: Get students comfortable creating forms and reports.

    Solution: Review T8_WasteNotRecycling_Solution.mdb


     Customer Form: Students can use the Form Wizard, select both tables and all the fields.
    When asked how to view the data, have students select Forms with subform(s). Or they
    can create a separate form for each table.

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 2 of 10


    Instructor’s Manual

     Customer Weights Report: There will be a variety of report formats. Make sure that
    students group the report by customer last name and first name. Here is one example of
    a report that has been modified:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 3 of 10


    Instructor’s Manual

    2. It’s A Grind Coffee Shop

    Project Purpose: Get students comfortable creating forms and reports.

    Solution: Review T8_ItsAGrindCoffee_Solution.mdb


     Books Form: This is a very basic layout:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 4 of 10


    Instructor’s Manual

     Books By Author Report: The reports should vary only slightly. All reports should look like
    the following:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 5 of 10


    Instructor’s Manual

     Publishers Report: The reports should vary only slightly. All reports should look like the
    following:

    3. TechIT Seminars

    Project Purpose: Get students comfortable creating forms and reports.

    Solution: Review T8_TechITSeminars_Solution.mdb


     Facilitators Form: This is a very basic layout:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 6 of 10


    Instructor’s Manual

     Student By Seminar Report: The final report should look exactly like Figure T8.7.

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 7 of 10


    Instructor’s Manual

    4. Scale Classic Cars

    Project Purpose: Get students comfortable creating forms and reports.

    Solution: Review T8_ScaleClassicCars_Solution.mdb


     Catalogue Form: This is a very basic layout. However, you should encourage students to
    add a graphic, lines, a heading, and the like. At the very least students forms should look
    like:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 8 of 10


    Instructor’s Manual

     Cars By Model Report: The reports should vary only slightly. All reports should look like
    the following:

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 9 of 10


    Instructor’s Manual

    APPLY YOUR KNOWLEDGE

    PROJECT 30: Sales Pipeline

    TECHNOLOGY PLUG-IN T8 – DECISION MAKING USING ACCESS Page 10 of 10

    You might also like