Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Access 365 Advanced
Explore advanced database tools and integration.Preview the first lesson free — get full access to all 48 lessons.
Advanced Provider : Douglas Bush 8 chapters · 48 Lessons · 2h 55m in Arabic, German, English, Spanish, French, Portuguese, Thai, Chinese
Course Description
Explore the advanced topics and tools of Access 365. After this course, you will be able to use Microsoft Access for all of your database needs.
What You'll Learn
- Design and plan a multi-table database in Access 365
- Build table relationships including one-to-one, one-to-many, and many-to-many
- Apply referential integrity using cascade delete and cascade update
- Create and edit macros, including converting macros to VBA code
- Build and edit switchboards to navigate a database
- Manage databases by printing reports, analyzing performance, backing up, restoring, and compacting & repairing
Key Takeaways
- This course covers the advanced topics and tools of Microsoft Access 365.
- It teaches relationship design across one-to-one, one-to-many, and many-to-many table relationships, as well as relationships with joins.
- Referential integrity is addressed through cascade delete and cascade update.
- The course covers automation with macros, including filtering with macros and converting macros to VBA code.
- Database management topics include object dependencies, the Performance Analyzer, backing up and restoring, and compact & repair.
Frequently Asked Questions
What does the Microsoft Access 365 Advanced course cover?
It explores the advanced topics and tools of Access 365, including database design, table relationships, referential integrity, macros, switchboards, and database management tasks such as printing reports, performance analysis, backups, and compact & repair.
What will I be able to do after completing this course?
After this course, you will be able to use Microsoft Access for all of your database needs.
What types of table relationships does the course teach?
It covers one-to-one, one-to-many, and many-to-many relationships, as well as relationships with joins and using referential integrity with cascade delete and cascade update.
Does the course cover automation in Access?
Yes. It includes working with and creating macros, filtering using macros, and converting macro to VBA code.
What database management skills are included?
The course covers printing database document and relationships reports, using object dependencies, using the Performance Analyzer, backing up and restoring databases, and compact & repair.
