Access 2019 Advanced
Course Schedule:
Access 2019 Advanced is scheduled for the following dates and times:
| Start Date | End Date | Start Time | Location |
|---|---|---|---|
| OCT 3 2024 | OCT 4 2024 | 08:00 AM | Virginia Beach |
| DEC 5 2024 | DEC 6 2024 | 08:00 AM | Virginia Beach |
Overview
You've covered many of the basic functions of Microsoft Office Access, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.
Microsoft Office Access 2019: Part 3 focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.
Microsoft Office Access 2019: Part 3 focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.
Objectives
Students will learn to perform the following tasks:
- Share data across applications.
- Use action, unmatched, and duplicate queries to manage data.
- Create complex reports and forms.
- Use macros to improve user interface design.
- Use VBA to extend database capabilities.
- Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.
- Implement security strategies and distribute a database to multiple users.