This MS Access for Office 365 - Essentials training course focuses on the design and construction of an Access database - viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
In MS Access for Office 365 - Intermediate training 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. This course focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
In MS Access for Office 365 - Advanced training course, 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. This course 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.
By attending MS Access for Office 365 - Essentials workshop, delegates will learn to:
- Navigate within the Access application environment, create a simple database, and customize Access configuration options.
- Organize and manage data stored within Access tables.
- Use queries to join, sort, and filter data from different tables.
- Use forms to make it easier to view, access, and input data.
- Create and format custom reports.
By attending MS Access for Office 365 - Intermediate workshop, delegates will learn to:
- 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.
For MS Access for Office 365 - Essentials
- Knowledge of Windows
For MS Access for Office 365 - Intermediate
- Microsoft Access for Office 365 - Essentials
For MS Access for Office 365 - Advanced
- Microsoft Access for Office 365 - Intermediate
The MS Access for Office 365 - Essentials class is ideal for:
- Individuals looking to establish a foundational understanding of Microsoft Access for Office 365, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
The MS Access for Office 365 - Intermediate class is ideal for:
- Individuals wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365.
The MS Access for Office 365 - Advanced class is ideal for:
- Database administrators or prospective database administrators who have experience working with Microsoft Access for Office 365 and need to learn advanced skills.