Microsoft® Access® for Office 365™ : Part 3
More Information:
- Learning Style: Online Instructor-Led
- Technology: Microsoft
- Difficulty: Advanced
- Course Duration: 1 Day
- Course Info: Download PDF
- Certificate: See Sample
Need Training for 5 or More People?
Customized to your team's need:
- Annual Subscriptions
- Private Training
- Flexible Pricing
- Enterprise LMS
- Dedicated Customer Success Manager
Course Information
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