--- title: Intermediate Microsoft Access 2019 description: Learn advanced techniques in Microsoft Access 2019, 2021, and 365. Master data presentation. image: https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Software%20and%20Applications.png --- [Home](https://aspire.loyola.edu/?hsLang=en) [Categories](https://aspire.loyola.edu/products?hsLang=en) Data Science and Technology [Intermediate Microsoft Access](https://aspire.loyola.edu/products/2463524376#) ![product_image](https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Software%20and%20Applications.png) # Intermediate Microsoft Access #### $199.00 Start Today! [Add to cart](https://aspire-cart.loyola.edu/simple_order?catalogid=TC_E2G_A_Int_Mic_Acc&return=https%3A%2F%2Faspire.loyola.edu) #### [ Professional Credits: ](https://aspire.loyola.edu/credit_terminology?hsLang=en) CEU: 2.4 #### $199.00 Start Today! [Add to cart](https://aspire-cart.loyola.edu/simple_order?catalogid=TC_E2G_A_Int_Mic_Acc&return=https%3A%2F%2Faspire.loyola.edu) ![](https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Completion.png) Completion Time 24 hours ![](https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Access%20time.png) Access Time 42 Days ![](https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Outcome.png) Outcome Individual Skill Course ![](https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Language.png) Language English ![](https://aspire.loyola.edu/hubfs/ASPIRE%20Assets/Icons/Training%20level.png) 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](https://aspire-cart.loyola.edu/simple_order?catalogid=TC_E2G_A_Int_Mic_Acc&return=https%3A%2F%2Faspire.loyola.edu) ##### Option 2 Contact us to explore enrollment options, including potential discounts! [Contact Us](https://aspire.loyola.edu/individuals-contact-form?hsLang=en) ### $199.00 ##### Start Today! [Add to cart](https://aspire-cart.loyola.edu/simple_order?catalogid=TC_E2G_A_Int_Mic_Acc&return=https%3A%2F%2Faspire.loyola.edu)