14.20: Putting It Together- Microsoft Access Advanced Skills

Computer Applications for Managers · LibreTexts

0%

Contents

    Text

    Size
    100%
    Theme
    Typeface
    Line length
    Spacing

    Read aloud

    How

    Speed: 1×
    Light up
    Highlight

    Symbols: Mulberry Symbols, © 2018–2026 Steve Lee, CC BY-SA 4.0 (licence, the set), the site's own copies.

    From LibreTexts, under CC BY 4.0, as the source states it; its equations are written in TeX, which the PDF shows typeset. This page at LibreTexts.

    14.20: Putting It Together- Microsoft Access Advanced Skills

    In this section we explored some of the advanced features of MS Access. First, we learned about external data and several methods with which we could use the capabilities of Access to utilize it. We discovered multiple methods to both import and export data from the Access database.

    Then we explored the all-important concept of the query—how to create, modify, save, and print using Access’s tools and wizards. Following the discussion of the query, we moved on to forms and reports. We saw the robust capabilities of Access to create forms using multiple views and tools. Just as important, we explored Access’s capabilities to create reports using wizards to present data in the most effective fashion. Finally, we discussed how Access could assist in the analyzing of data using powerful, built-in functions and calculations.

    Databases are the backbone of technology applications today. From social media, banking, cloud storage solutions, fantasy sport apps, and online gaming, databases are indispensable. Even if we are not dealing with high-profile applications, most businesses today could not run without a database system keeping track of inventory, sales, employees or other mission-critical information.

    Contributors and Attributions

    CC licensed content, Original
    • Putting it Together: Microsoft Access Advanced Skills. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    This page titled 14.20: Putting It Together- Microsoft Access Advanced Skills was last modified on Sun, 07 Mar 2021 18:26:12 GMT and is shared under a CC BY 4.0 license and was authored, remixed, and/or curated by Lumen Learning via source content that was edited to the style and standards of the LibreTexts platform.