Microsoft® Access® for Office 365 : Part 2
This course builds on foundational Access skills and focuses on advanced features to enhance database functionality, improve usability, and support multi-user environments. Learners will gain experience using macros, VBA, data organization techniques, and user interface enhancements.
This course builds on foundational Access skills and focuses on advanced features to enhance database functionality, improve usability, and support multi-user environments. Learners will gain experience using macros, VBA, data organization techniques, and user interface enhancements.
More Information:
- Learning Style: Virtual
- Technology: Microsoft
- Difficulty: Intermediate
- 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:
Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.
Course Objectives:
-
Provide input validation features to promote the entry of quality data into a database.
-
Organize a database for efficiency and performance, and to maintain data integrity.
-
Improve the usability of Access tables.
-
Create advanced queries to join and summarize data.
-
Use advanced formatting and controls to improve form presentation.
-
Use advanced formatting and calculated fields to improve reports.
Audience:
-
Intermediate to advanced users familiar with Microsoft Access basics who want to deepen their skills and create more robust, user-friendly databases.
Prerequisites:
-
To ensure your success in this course, it is recommended you have completed Microsoft® Access® for Office 365™: Part 1 or possess equivalent knowledge.