Buy Now Contact Us My Courses
    Buy Now Contact Us My Courses
            Home Categories Data Science and Technology Intermediate Microsoft Access
            product_image

            Intermediate Microsoft Access

            $199.00

            Start Today!

            Add to cart

            Professional Credits:

            CEU: 2.4

            $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

            Requirements

            Technology Requirements

            Hardware Requirements: This course can be taken on either a PC, Mac, or Chromebook.

            Software Requirements: Software must be installed and fully operational before the course begins.

            • PC: Windows 8 or later.
            • Mac: macOS 10.6 or later.
            • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible. Cookies and JavaScript must be enabled
            • The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )
            • Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
            Other:
            • Reliable internet connection. Broadband cable or highspeed DSL is recommended for optimal experience.
            • E-mail account (to be able to register and to receive e-mail from the course system regarding registration, course status, etc.)
            Prerequisites

            A basic understanding of Microsoft Access objects and their use or completion of Introduction to Microsoft Access is required.

            Enroll My Team

            Are you looking to enroll your team in this training Course? You Can:

            Option 1

            Click "Add to Cart" and then update the number of seats you'd like to purchase in yout cart.

            Add to Cart
            Option 2

            Contact us to explore enrollment options, including potential discounts!

            Contact Us

            $199.00

            Start Today!
            Add to cart