| Microsoft Access Advanced provides students with the knowledge and skills they need to create custom views, functions, and security measures for their databases. Students will also learn how to optimize their databases for performance and troubleshoot any problems that may arise. |
-
Module 11: Creating Custom Views
- Demonstrate an understanding of how to create custom views.
- Identify the different types of custom views.
- Explain how to use each type of custom view effectively.
- Module 12: Creating Custom Functions
- Demonstrate an understanding of how to create custom functions.
- Identify the different types of custom functions.
- Explain how to use each type of custom function effectively.
- Module 13: Securing a Database
- Demonstrate an understanding of how to secure a database.
- Identify the different security options available in Microsoft Access.
- Explain how to use each security option effectively.
- Module 14: Optimizing a Database
- Demonstrate an understanding of how to optimize a database.
- Identify the different tools for optimizing a database.
- Explain how to use each tool effectively.
- Module 15: Troubleshooting Access Problems
- Demonstrate an understanding of how to troubleshoot Access problems.
- Identify the different tools for troubleshooting Access problems.
- Explain how to use each tool effectively.
- High school or equivalent
- Strong communication and interpersonal skills
- Interest in the course topic
- Good level of English
| 100 GLH |