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.
Completion Time
24 hours
Access Time
42 Days
Outcome
Individual Skill Course
Language
English
Training Level
Intermediate
Delivery Information:
Online
Asynchronous
Self-paced
Description
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
- 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
- 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: