Microsoft Access: Preparation and Access to the Official MO-500 Certification
Microsoft Access: Preparation and Access to the Official MO-500 Certification
This Microsoft Access course prepares participants to take the official Microsoft MO-500 (Microsoft Access Expert) certification exam. Throughout the training, participants will learn how to create and manage relational databases, work with tables, queries, forms, reports, macros, and security tools. The activity includes access to the official Microsoft MO-500 certification process, enabling participants to validate advanced skills in the professional use of Microsoft Access.
Specific goals | Temary
OBJECTIVES
- Master Basic and Advanced Microsoft Access Features
- Automate Tasks and Improve Efficiency
- Apply Microsoft Access in Real Projects
COURSE CONTENT
- Introduction to Microsoft Access
- Differences between Access and Excel
- Basic database concepts
- Types of objects
- Table structure
- Creating tables
- Data types
- Primary key
- Relationships between tables
- Types of relationships (one-to-many, many-to-many)
- Referential integrity
- Types of relationships (one-to-many, many-to-many)
- Referential integrity
- Introduction to queries
- Queries
- Select queries
- Creating queries
- Types of criteria
- Subtotals
- Crosstab queries
- Action queries
- Update, append, delete, and make-table queries
- Forms
- Creating and designing forms
- Grouping and sorting data
- Reports
- Creating and designing reports
- Grouping and sorting data
- Macros and Automation
- Introduction to macros
- Automating common tasks
- Preparation for the MO-500 Exam
Editions
General information
>> This activity prepares participants to take the official MO-500 certification exam from MICROSOFT . Barcelona Activa will offer one free attempt at the official certification exam to participants who attend all activity sessions and successfully pass the established self-assessment test.
>> In the case of live virtual sessions held via ZOOM, registered participants will not receive any link in the automatic email. The email instructions indicate that access will be enabled in the Personal Area between 1 and 2 hours before the activity begins. Please consult the rules and FAQs for more information.
>> If the format is a live virtual session delivered through the free Microsoft Teams platform, registered participants will receive an email with the invitation link and access instructions before the session starts.
>> Entry to the classroom will not be permitted more than 15 minutes after the activity has started.
>> The language used in each session is specified in the description of each activity.
Trainer's person
