Microsoft® Access® for Office 365™ : Part 3

About This Course:

You've covered many of the basic functions of Microsoft® 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 separates database professionals from the casual database users or occasional designers.

Course Objectives:

• 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.

Audience:

• Individuals with basic to intermediate knowledge of database management.

• Office professionals, data analysts, and anyone looking to improve productivity with Access.

• Students or learners aiming to strengthen their practical database skills.

Prerequisites:

• To ensure your success in this course, you should have experience working with Access, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships