On Demand (eLearning)

Access 2019: Database Basics

JAN 02 - Dec 31, 2022

Online

DATE

JAN 02 - DEC 31

2022

TIME

9:00 AM - 6:59 PM

WHO CAN ATTEND

All

PD HOURS

4 Hours

ETHICS HOURS

0 Hours

STATUS

Registration open until

Dec 31, 2022

EVENT DESCRIPTION

Learn database skills to help organize, customize, and interpret your data. This CPA Ontario course includes eight, beginner-level, mini courses that cover the basic structure and key elements of Access 2019. This course will enable you to save time by learning how to find and use the information you need most within Access, the database application in the Microsoft Office 2019 suite. Learn how to format and analyze your data, and create useful reports for your business needs.

KEY TAKEAWAYS

By the end of this course, participants will be able to:

1. Work with Databases:

  • Open existing databases and create new ones
  • Customize the interface

2. Save, Print, and Export Databases:

  • Save data
  • Protect your database
  • Print database items
  • Export a database
  • Send tables via email

3. Tables, Fields, and Entries:

  • Understand the structure and main elements of a database
  • Explore tables, primary keys, and relationships
  • Format and edit fields and field properties

4. Insert, Import, and Format Data:

  • Enter and import data
  • Change formatting settings
  • Create dropdown menus
  • Enforce data validation
  • Create labels with your data

5. Find and Organize Data:

  • Use the sort, filter, find and replace features

6. Create Forms and Queries:

  • Create a calculated field to better analyze your data values

7. Customize Forms:

  • Restructure individual elements
  • Change the theme to enhance the look and feel of your form

8. Use the Report and Analysis Tools:

  • Create reports quickly
  • Create custom and automatic reports to extract information
  • Clean up your database
  • Analyze the database

WHO WILL BENEFIT:

Individuals and business professionals with limited knowledge of Access 2019 who are responsible for managing databases.

PRICING

$220.80 Personal Passport

$220.80 Organization Passport

$220.80 Member

$220.80 Student

$220.80 Public

Status: Registration open until Dec 31, 2022

LOCATION

Online

SPEAKER(S) BIO

This course is presented by Skillsoft, a leading global provider of high-quality, innovative, cloud-based learning resources, enabling organizations to achieve competitive advantages through superior knowledge and skills.

SPECIAL INSTRUCTIONS

This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.

However, you will only have access to the course for 30 days after REGISTRATION.

To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.

  • Please allow at least four hours after registration for the course to appear on your BlackBoard page.

Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.