77-730
Microsoft Access 2016 (77-730)
Become a certified Microsoft Access 2016 professional with this online training program. Learn with our fully interactive learning features & Live Labs.
- Practice in 36 Laboratorios prácticos — nothing to install
- 15 Lecciones interactivas y 65 topics mapped to the official exam objectives
- 116 Preguntas del examen de práctica
Beginner A tu propio ritmo · 1 año de acceso 4.4/5 (56 Revisar)
36 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
15Lecciones interactivas
65Topics
36Laboratorio en vivo
116Preguntas del examen de práctica
35Vídeos
82Tarjetas didácticas
82Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
Enroll for our Microsoft Access 2016 online training program to prepare and practice for the 77-730 certification exam. The course curriculum focuses on creating, modifying, and managing Microsoft Access Database objects. It has been equipped with 124+ video tutorials and 36+ hands-on lab exercises to make your learning more interactive. By the end of this Microsoft Access training course, you’ll be able to create and organize databases for storing information, design user-friendly interfaces for data entry, perform complex data manipulations, and optimize database performance and security.
- Create database tables with entry fields and data types
- Manage relationship between data tables to ensure integrity and consistency
- Use queries and forms to add, update, delete, and retrieve data
- Execute data calculations using sum, average, count
- Perform data manipulation for sorting, filtering, and grouping
- Extract information from database by creating simple & complex queries
- Ability to build parameterized queries for dynamic data retrieval
- Automate data manipulation with action queries
- Ability to create, design & customize forms and reports
- Using subqueries to perform nested queries within a query
- Encrypting and decrypting databases for data protection
- Knowledge of database maintenance best practices
Target Career Roles
- Gerente de oficina
- Analista de investigación
- Coordinador del proyecto
- Asistente ejecutivo
- Especialista en bases de datos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
15 Lecciones interactivas · 65 topics01 Introduction to Access 2016 3 topics · 2 Laboratorio en vivo +
- Getting Started
- Working in the Access Interface
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
02 Creating Database Tables 4 topics · 2 Laboratorio en vivo +
- Introducing Tables
- Creating a Table
- Saving and Modifying a Table
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
03 Working with Tables and Database Records 7 topics · 6 Laboratorio en vivo +
- Navigating Specific Records
- Adding, Updating, and Deleting Records
- Working with Primary Keys
- Finding and Replacing Data
- Sorting and Filtering Data and Setting Field Viewing Options Within a Table
- Understanding Table Relationships
- Summary
6 Laboratorio en vivo in this lesson — see the labs panel →
04 Modifying Tables and Fields 3 topics · 5 Laboratorio en vivo +
- Creating Fields and Modifying Field Properties
- Modifying Database Tables and Fields
- Summary
5 Laboratorio en vivo in this lesson — see the labs panel →
05 Creating Forms 3 topics · 2 Laboratorio en vivo +
- Creating a Form
- Sorting and Filtering Data in a Form
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
06 Creating Reports 3 topics · 2 Laboratorio en vivo +
- Creating a Report
- Working With Reports
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
07 Creating and Modifying Queries 5 topics · 2 Laboratorio en vivo +
- Creating a Query
- Modifying a Query
- Sorting and Filtering Data in a Query
- Format Fields Within Queries
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
08 Using Controls in Forms and Reports 6 topics · 4 Laboratorio en vivo +
- Controls
- Defining Control Tab Order
- Formatting Controls
- Arranging Control Alignment, Size, and Position
- Adjusting Page Margins and Changing Page Orientations for Forms and Reports
- Summary
4 Laboratorio en vivo in this lesson — see the labs panel →
09 Understanding Advanced Forms 4 topics · 1 Laboratorio en vivo +
- Creating Advanced Forms
- Using Application Parts to Create Blank Forms
- Creating and Modifying a Navigation Form
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
10 Creating Advanced Reports 6 topics · 1 Laboratorio en vivo +
- Defining Groups
- Creating Aggregate Fields
- Creating a Subform on a Report
- Creating the Print Layout
- Using the Label Wizard
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
11 Creating Advanced Queries 6 topics · 3 Laboratorio en vivo +
- Creating Crosstab Queries
- Creating a Subquery
- Filtering and Saving a Filter as a Query
- Creating Action Queries
- Understanding Advanced Query Modification
- Summary
3 Laboratorio en vivo in this lesson — see the labs panel →
12 Displaying and Sharing Data 5 topics · 1 Laboratorio en vivo +
- Creating a Chart Using the Chart Wizard
- Formatting a Chart
- Changing Chart Types
- Saving a Database Object as Another File Type and Printing
- Summary
1 Laboratorio en vivo in this lesson — see the labs panel →
13 Importing and Exporting Data 4 topics · 2 Laboratorio en vivo +
- Importing Data
- Exporting Data
- Saving and Running Import/Export Specifications
- Summary
2 Laboratorio en vivo in this lesson — see the labs panel →
14 Understanding Database Tools 6 topics · 3 Laboratorio en vivo +
- Maintaining a Database
- Using Database Tools
- Encrypting and Decrypting a Database
- Navigating in Access Database
- Improving User Interface Design by Using Macros
- Summary
3 Laboratorio en vivo in this lesson — see the labs panel →
15 Appendix: 3D Avatar-based Simulation +
Laboratorios prácticos Our edge
36 Laboratorio en vivos- Creating a Blank Database
- Creating a Database from a Template
- Creating a New Table and Changing its Font Style and Size
- Changing Gridlines to Vertical
- Deleting a Record
- Adding Records to a Database Table
- Finding and Replacing a Specific Value
- Calculating Average and Exporting a Table in Text Format
- Hiding the Fields
- Creating a Relationship Between Tables
- Opening a Table in Design View and Editing its Field Properties
- Renaming a Table
- Deleting a Table from a Database
- Changing the Title Bar Text with the Caption Property
- Creating Multivalued Lookup Fields
- Creating and Viewing a Form in Form View
- Using the Filter By Form Option
- Creating a New Report and Binding it to a Query
- Sorting a Field of Reports
- Using a Find Duplicates Query Wizard
- Finding Unmatched Records
- Changing Date/Time Controls
- Changing the Width of a Form
- Creating a Basic Form and Applying Themes
- Inserting a Background Image in a Form
- Creating a Split Form
- Creating Labels Using the Label Wizard
- Creating Crosstab Queries
- Saving a Filter as a Query
- Creating an Append Query
- Printing a Database Object
- Importing a Table from Another Access Database
- Exporting Objects to Other Access Databases
- Compacting and Repairing a Database
- Backing Up a Database
- Splitting a Database
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Detalles del examen
Microsoft Access 2016 (77-730) Detalles
Obtén la certificación para el examen MOS 77-730 con el curso y laboratorio de Microsoft Access 2016. El laboratorio está basado en la nube, habilitado para dispositivos y se puede integrar fácilmente con un LMS. El curso de formación y laboratorio de Microsoft Access cubre los objetivos del examen 77-730 e imparte las habilidades necesarias para crear y administrar una base de datos, crear tablas, crear consultas, crear formularios y crear informes.
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
116 Preguntas de práctica
(alineado con los objetivos oficiales del examen)
Certificación
77-730
Microsoft credencial
¿Listo para presentar el examen?
Agrega tu 77-730 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 this Microsoft Access course about? +
It is an online training course that is especially designed to equip you with the skills needed to pass the 77-730 certification exam. It gives you access to our interactive learning content and lab activities focused on creating and managing databases, creating queries, building tables, and creating forms and reports.
Who should take this Microsoft Access 2016 training course? +
All those wanting to improve their data management skills and demonstrate their ability to use the Access 2016 features for passing the 77-730 exam should take up this course. Professionals who need to manage databases for their jobs include Database administrators, Data analysts, Business analysts, Accountants, Researchers, and Office administrators.
What are the prerequisites for taking this course? +
As a prerequisite, you should have understanding of the basic data concepts: data types, fields, records, and tables is recommended for better understanding. Expertise in Microsoft Office applications is an added advantage.
What is the average salary of a Microsoft Access 2016 certified professional? +
The average annual salary of a Microsoft office specialist in data management roles ranges from $78,000 to $100,000.
Is this Access 2016 course appropriate for beginners? +
Yes, it is a beginner friendly course that helps you build on your data management skills gradually.
What is the fee for this Microsoft 77-730 certification?+
The certification fee is $100.
¿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 hago 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
- 36 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito