product_image

            Intermediate Microsoft Access

            $199.00

            Start Today!

            Add to cart

            $199.00

            Start Today!

            Add to cart

            Completion Time

            24 hours

            Access Time

            42 Days

            Outcome

            Individual Skill Course

            Language

            English

            Training Level

            Intermediate

            Delivery Information:

            Online Asynchronous Self-paced

            Description

            Microsoft Access is one of the most widely used information management systems. This course will teach you advanced techniques in this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks. From building reports to using conditional formatting, this course will teach you how to best present your data with Access 2019, 2021, and 365.

            This Intermediate Microsoft Access course is offered in collaboration with the trusted learning partner Ed2Go.

            Learning Outcomes

            What you will learn:
            • Import table data from external sources
            • Use action queries to update table data quickly and efficiently
            • Set table relationships to maintain data integrity
            • Make forms easier to use
            • Understand query joins, and common functions
            • Build a report dialog box to dynamically run database reports based on user selected criteria
            • Use Visual Basic to run reports from the report dialog box
            • Prepare a database for use by others
            How you will benefit:
            • Build your own database from scratch
            • Improve the efficiency of your existing databases
            • Build a fully functional database that tracks customer and order information
            • Create an automated dialog box that runs reports with the click of a button and filters those reports to specific user selected criteria

            $199.00

            Start Today!
            Add to cart