MSACCESS.AD1
Microsoft Access 2021
Upscale your database management skills with this beginner-friendly course. Learn the skills required to create, manage, and analyze data effectively.
- Practice in 25 Laboratorios prácticos — nothing to install
- 7 Lecciones interactivas y 18 topics mapped to the official exam objectives
- 90 Preguntas del examen de práctica
Beginner A tu propio ritmo · 1 año de acceso
25 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
7Lecciones interactivas
18Topics
25Laboratorio en vivo
90Preguntas del examen de práctica
44Tarjetas didácticas
44Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
This Microsoft Access 2021 course and Lab activities are designed for those who want to learn essential database management skills. The comprehensive course starts with the fundamentals including launching Access, opening databases, and navigating the user interface. Whether you're a beginner or an experienced professional, this course will help you master Microsoft Access for creating, managing, and analyzing data effectively. Additionally, you’ll gain much-needed practical skills with our hands-on exercises that mirror real-world examples.
- Create and structure tables for storing data
- Understanding of the relationships between tables to ensure data integrity
- Perform data normalization to reduce redundancy and improve efficiency
- Query creation and optimization to retrieve and improve performance
- Ability to apply data filtering, sorting, and aggregation
- Create and customize forms for data entry, modification, formatting, and validation
- Create and format reports to visualize, analyze, format, group, and sort data
- Complete knowledge of navigation pane, ribbon interface, and database tools
Course Highlights
-
7 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
25 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
90 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
7 Lecciones interactivas · 18 topics01 About This Course 1 topics +
- Course Description
02 Getting Started with Access 2021 6 topics · 7 Laboratorio en vivo +
- Topic A: Launch Access and Open a Database
- Topic B: Use Tables to Store Data
- Topic C: Use Queries to Combine, Find, Filter, and Sort Data
- Topic D: Use Forms to View, Add, and Update Data
- Topic E: Use Reports to Present Data
- Topic F: Get Help and Configure Options in Microsoft Access
7 Laboratorio en vivo in this lesson — see the labs panel →
03 Creating Tables 4 topics · 4 Laboratorio en vivo +
- Topic A: Plan an Access Database
- Topic B: Start a New Access Database
- Topic C: Create a New Table
- Topic D: Establish Table Relationships
4 Laboratorio en vivo in this lesson — see the labs panel →
04 Creating Queries 3 topics · 7 Laboratorio en vivo +
- Topic A: Create Basic Queries
- Topic B: Perform Calculations in a Query
- Topic C: Sort and Filter Data in a Query
7 Laboratorio en vivo in this lesson — see the labs panel →
05 Creating Forms 2 topics · 4 Laboratorio en vivo +
- Topic A: Start a New Form
- Topic B: Enhance a Form
4 Laboratorio en vivo in this lesson — see the labs panel →
06 Creating Reports 2 topics · 3 Laboratorio en vivo +
- Topic A: Start a New Report
- Topic B: Enhance Report Layout
3 Laboratorio en vivo in this lesson — see the labs panel →
07 Appendix A: Microsoft® Office Access® 2021 Common Keyboard Shortcuts +
Laboratorios prácticos Our edge
25 Laboratorio en vivos- Revising and Entering Table Data
- Preventing AutoCorrect Corrections
- Using the Find and Replace Feature
- Adding a Total Row to a Datasheet
- Sorting and Filtering Records
- Using Queries
- Using Reports
- Creating a New Database
- Creating a New Table
- Preparing Keys for Table Relationships
- Establishing Table Relationships
- Creating a Query Using the Query Wizard
- Creating a Query Using Query Design
- Performing Calculations in a Query
- Sorting a Query and Reordering Fields
- Filtering a Query Using a Comparison Operator
- Filtering a Query Using Dates
- Prompting a User for Query Parameters
- Creating a Form by Using the Form Wizard
- Creating and Testing a Form Based on a Selected Table
- Filtering and Sorting Data in a Form
- Configuring a Form Lookup Field
- Creating a Simple Report
- Using the Report Wizard
- Enhancing a Report Layout
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
Who should take this course?+
Learning Microsoft Access 2021 can be beneficial for many people including:
- Beginners wanting to learn database management skills
- Small business owners and entrepreneurs wanting to analyze and manage their data
- Working professionals wanting to enhance their skills
- Data enthusiasts working with data sets
Does it require any prior knowledge to take this course?+
No, this is a beginner-friendly course that does not require any previous experience.
How is Microsoft Access 2021 different from the previous version?+
Microsoft Access 2021 has several advanced features and enhancements that make it different and better than the previous version. Some of the advanced features include:
- Large Address Aware (LAA)
- Modern Interface
- Improved Touch Support
- Enhanced Security
- Compatibility
- Bug Fixes and Stability
What is Microsoft Access 2021 used for in professional settings?+
It is often used as a versatile database management tool in small- and medium-sized businesses. Some of the common applications include inventory management, CRM, project management, record keeping, and accounting.
Is Microsoft Access similar to Excel?+
Microsoft Excel is best used for smaller datasets, calculations and analysis whereas Access works with larger data sets, complex data relationships and data management. To simplify, Excel works like a notebook for storing numbers and doing calculations. Access on the hand, works as a filing cabinet for storing and organizing data in a structured way.
Can we use MS Access 2021 for automating tasks?+
Yes, it has many features like Macros, VBAs, and more that can be used for automating tasks.
What are the professional benefits of learning Microsoft Access 2021?+
Learning MS Access can significantly impact your career in a number of ways:
- Enhanced data management skills will give you a competitive edge to aim for exciting job opportunities with higher income potential.
- Open door to apply for data management job roles in various industries, including IT, finance, healthcare, and more.
- It will enhance your problem-solving and critical-thinking ability for making better professional decisions.
Master Data Management Skills
Learn Microsoft Access 2021 and start your data journey today!
- 1 año de acceso completo
- 25 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito