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.