MO-500.AI1
Microsoft Access 2019 (MO-500)
Prepare & practice for the MO-500 exam with this MS Access course.
- Practice in 73 Laboratorios prácticos — nothing to install
- 12 Lecciones interactivas y 43 topics mapped to the official exam objectives
- 141 Preguntas del examen de práctica
Beginner A tu propio ritmo · 1 año de acceso 4.4/5 (22 Revisar)
73 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
12Lecciones interactivas
43Topics
73Laboratorio en vivo
141Preguntas del examen de práctica
2Vídeos
100Tarjetas didácticas
100Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
The Microsoft Access 2019 (MO-500) is a comprehensive training course that teaches you the skills needed to effectively create, manage, and analyze databases using Access. The course content is in sync with the MO-500 exam objectives, focusing on developing your knowledge and ability to create and maintain Access Database objects including tables, relationships, data entry forms, multi-level reports and multi-table queries. It has a prep engine with hands-on Labs which provide different sets of questions to prepare for the exam in the test environment. After completing this Microsoft Access 2019 course you’ll know how to manage databases, create and modify tables, create and modify queries, modify forms in layout view, and modify reports in layout view.
- Core understanding of database concepts: tables, fields, and relationships
- Use queries for data manipulation to select, insert, update, and delete data
- Design and create forms for data data entry, modification, and display
- Generate and format reports for data analysis and presentation
- Optimizing query by using techniques like indexing, grouping, and calculated fields
- Ability to customize forms and enhance detailed reports
- Utilizing macro programming for automating and streamlining repetitive tasks
- Skilled with maintenance tasks including compacting, repairing, and restoring databases
- Awareness of security best practices to protect data
Target Career Roles
- Gerente de oficina
- Asistente ejecutivo
- Especialista en bases de datos
- Técnico de soporte informático
- Ayudante Administrativo
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
12 Lecciones interactivas · 43 topics01 Introduction 1 topics +
- Course setup
02 Database fundamentals 4 topics · 4 Laboratorio en vivo +
- Module A: Understanding general database terms
- Module B: Relational databases
- Module C: Access interface and objects
- Summary
4 Laboratorio en vivo in this lesson — see the labs panel →
03 Tables 5 topics · 14 Laboratorio en vivo +
- Module A: Creating tables
- Module B: Creating fields
- Module C: Data Validation
- Module D: Relationships and keys
- Summary
14 Laboratorio en vivo in this lesson — see the labs panel →
04 Queries 4 topics · 14 Laboratorio en vivo +
- Module A: Creating basic queries
- Module B: Modifying queries
- Module C: Using calculated fields
- Summary
14 Laboratorio en vivo in this lesson — see the labs panel →
05 Forms 4 topics · 7 Laboratorio en vivo +
- Module A: Creating simple forms
- Module B: Form design
- Module C: Form controls
- Summary
7 Laboratorio en vivo in this lesson — see the labs panel →
06 Reports 4 topics · 10 Laboratorio en vivo +
- Module A: Creating Reports
- Module B: Report controls
- Module C: Formatting reports
- Summary
10 Laboratorio en vivo in this lesson — see the labs panel →
07 Introduction 1 topics +
- Course setup
08 Advanced queries 4 topics · 5 Laboratorio en vivo +
- Module A: Grouping and summarizing
- Module B: Updating, deleting, and relationships
- Module C: Indexing for performance
- Summary
5 Laboratorio en vivo in this lesson — see the labs panel →
09 Advanced forms 4 topics · 4 Laboratorio en vivo +
- Module A: Subforms
- Module B: Advanced control types
- Module C: Specialized form types
- Summary
4 Laboratorio en vivo in this lesson — see the labs panel →
10 Advanced reports 4 topics · 6 Laboratorio en vivo +
- Module A: Subreports
- Module B: Advanced grouping
- Module C: Advanced formatting
- Summary
6 Laboratorio en vivo in this lesson — see the labs panel →
11 Macros 4 topics · 5 Laboratorio en vivo +
- Module A: Creating basic macros
- Module B: Using variables
- Module C: Troubleshooting macros
- Summary
5 Laboratorio en vivo in this lesson — see the labs panel →
12 Database management 4 topics · 4 Laboratorio en vivo +
- Module A: Compact & Repair
- Module B: Restoring a database
- Module C: Other maintenance tasks
- Summary
4 Laboratorio en vivo in this lesson — see the labs panel →
Laboratorios prácticos Our edge
73 Laboratorio en vivos- Exploring a Query
- Importing a Flat File
- Creating a Database from a Template
- Using the Navigation Pane
- Creating a Blank Table
- Deleting a Table from a Database
- Renaming a Table
- Changing the Form Header using the Caption Property
- Creating a Primary Key
- Adding a Field in Datasheet View
- Modifying Fields in Design View
- Adding Records to a Database Table
- Creating and Formatting a New Table
- Changing Date/Time Controls
- Creating a Table-level Validation Rule
- Setting the Required and Default Value Properties
- Setting Validation Rules
- Creating a Relationship Between Tables
- Creating a Select Query
- Creating an Append Query
- Saving a Filter as a Query
- Creating a Totals Query
- Creating an Update Query
- Modifying a Query
- Formatting a Query
- Sorting a Query
- Creating a Make Table Query
- Creating a Delete Query
- Adding the Criteria
- Creating a Crosstab Query
- Using Date Ranges in a Report
- Using Calculated Fields
- Creating and Viewing a Form in Form View
- Creating a Form Using the Form Wizard
- Designing a Form
- Creating a Split Form
- Adding Form Controls
- Adding List Controls and Command Buttons
- Changing the Layout of Controls
- Creating a Basic Report
- Creating a New Report and Binding it to a Query
- Creating a Report Using the Report Wizard
- Controlling a Report's Data Source
- Manipulating Controls in a Report
- Creating Labels Using the Label Wizard
- Creating a Calculated Field
- Formatting a Report and an Image
- Grouping a Report and Adding a Group Summary Calculation
- Working with Themes
- Grouping and Summarizing Data
- Using the WHERE Clause
- Performing Cascading Updates and Deletions
- Deleting a Record
- Indexing a Table
- Creating a Subform and Linking Forms
- Creating a Chart Using the Chart Wizard
- Inserting a Background Image in a Form
- Working with Advanced Form Controls
- Creating Unrelated Subreports
- Adding a Related Subreport to an Existing Report
- Creating a Subreport with the Same Record Source as the Main Report
- Sorting a Field of Reports
- Adding Running Sums to a Report
- Using the Report Formatting Options
- Creating a Data Macro
- Creating an Embedded Macro
- Creating a Macro
- Exporting Objects to Other Access Databases
- Debugging a Macro
- Running Compact & Repair
- Restoring an Access Database
- Using Print Preview to Create a Print Layout
- Performing the Maintenance Tasks
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Detalles del examen
Microsoft Access 2019 (MO-500) Detalles
La certificación Microsoft Office Specialist: Access Expert demuestra las habilidades del candidato para administrar bases de datos, crear y modificar tablas; crear y modificar consultas; modificar formularios en la...
Questions
40-60
(por examen)
Duration
90 minutos
(por examen)
Passing Score
The passing score varies from exam to exam and is provided on the score report.
(puntuación escalada)
Exam Fee
USD 100
(por examen)
Delivered by
Certiport
(presencial u online)
Question Format
The exam consists of performance based questions and is...
opción única/múltiple, basado en el desempeño
Exámenes de práctica
141 Preguntas de práctica
(alineado con los objetivos oficiales del examen)
Certificación
MO-500.AI1
Microsoft credencial
¿Listo para presentar el examen?
Agrega tu MO-500.AI1 bono de examen oficial a tu pedido.
Bono oficial · Entrega rápida · Paquete de repetición disponible
El bono de examen se vende por separado y no está incluido en el curso estándar.
04 / Preguntas frecuentes
Preguntas antes de empezar
What is the Microsoft Access 2019 (MO-500) course about? +
It is an online preparatory course that helps you prepare and practice for the MO-500 certification exam. Everything from the course content to the training Lab exercises are 100% aligned with the certification exam.
What is the MO-500 certification exam? +
Mo-500 is a certification exam conducted by Microsoft to validate the database management skills of an individual. The exam covers a wide range of topics, including: database management, table creation and management, query design, form design, report creation, and advanced database management topics like using subforms, advanced controls, and specialized form types.
What is the format of the MO-500 certification exam? +
The exam format is MCQ. You’ll have to select the most appropriate answer from the given options.
Is there a time limit for completing this certification exam? +
Yes, there is a time limit. You’ll have to complete the exam within 50 minutes.
What is the Microsoft Access 2019 certification fee? +
The exam fee is $100.
What is the estimated salary range of a MS Access certified professional?+
The estimated salary range is anywhere between $37,500 to $121,000 annually depending on experience, organization and location.
¿Cuáles son los requisitos previos para este examen?+
No existen requisitos técnicos previos para el examen de certificación.
¿Cuál es la cuota de inscripción al examen?+
USD 100
¿Dónde puedo hacer el examen?+
¿Cuál es el formato del examen?+
El examen consta de preguntas basadas en el desempeño y se realiza en un entorno real o simulado.
¿Cuántas preguntas se hacen en el examen?+
El examen consta de entre 40 y 60 preguntas.
¿Cuál es la duración del examen?+
90 minutos
¿Cuál es la puntuación mínima para aprobar?+
La puntuación mínima para aprobar varía de un examen a otro y se indica en el informe de calificaciones.
¿Cuál es la política de repetición del examen?+
Política de repetición del examen de Microsoft Office Specialist (MOS)
- Si un candidato no obtiene la calificación mínima para aprobar un examen la primera vez, deberá esperar 24 horas antes de volver a presentarse.
- Si un candidato no obtiene una calificación aprobatoria la segunda vez, deberá esperar 2 días (48 horas) antes de volver a realizar el examen por tercera vez.
- Se impondrá un período de espera de dos días entre cada repetición del examen.
- No existe un límite anual en el número de intentos para realizar el mismo examen.
- Si un candidato obtiene una calificación aprobatoria en un examen de Office, puede volver a presentarse.
¿Cuál es la validez de la certificación?+
Para toda la vida
¿Dónde puedo encontrar más información sobre este examen?+
Streamline Your Data Management Tasks
Optimize your workflow and data potential with Microsoft Access 2016.
- 1 año de acceso completo
- 73 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito