Microsoft Access 2021 avanzado: División de una base de datos

Name: Microsoft Access 2021 avanzado: División de una base de datos
Author: John Varan

In this course, you will learn about the different reasons why you should split a database in Microsoft Access 2021. We will explain how to create a split…

Preview the first lesson free — get full access to all 1 lessons.

Solicitar una demo Iniciar sesión

Curso: bajo demanda

Hello, my name is John Varon, and in these lessons, you will learn about splitting a database. In this lesson, I will show you why you may need to split a database. Splitting a database refers to taking an existing database and separating the objects in it into two or more different databases. These different databases are then linked back together so that functionally they act like a single database again. While it is possible to split a database into more than two parts, by far the most common approach is to use only two parts. The complication resulting from using more than two parts usually tends to not make up for the benefits, but sometimes it does. As to why you would want to split a database, there are several scenarios where it can be useful. One reason could be to save on storage space. If your database is getting bigger and bigger over time, it can have a significant impact on performance, especially with Microsoft Access. This is because Microsoft Access doesn't have a client -server architecture, and instead is meant to be opened as a single file. This means it has no functionality for handling large data transfers across network connections. In this case, you could split the database and put the larger tables into a different database, possibly even one that's not Microsoft Access and which has a client -server architecture. The remaining Microsoft Access database would use table links to connect to this server database. Another potential reason to split a database is for separation of concerns. Separation of concerns means splitting database objects based on who will be responsible for them and using them. Users who perform different roles would use different databases. Usually, this separation is based on the difference between administrative users versus end users. Security can be another reason to split a database. This split would be done very similarly to the previous one, the separation of concerns. In fact, it could be argued that it is just a different version of separation of concerns. This time, it's just between users that have access to secured information and users that do not. In this scenario, tables that contain sensitive or secured data would be stored in the back -end database, while the other tables would be stored in the front -end database. Users of the front -end database would have only read -only access to the link tables in the back -end database, and only users with secure access would have access to the editable tables in the back -end database. While these are the most common reasons why one might want to split a database, there could potentially be others depending on your specific needs. It can be a very useful tool for solving problems that can't be easily solved by other means. Thanks for watching. Stay tuned for the next lesson, where I will show you how to create a front -end database.

Avanzado Proveedor : John Varan 1 lección · 18m en Árabe, Alemán, Inglés, Español, Francés, Portugués, Chinese

Descripción del curso

Splitting a database is a common technique that is used for solving various issues that can arise with database applications, which is why this course will explain what these different issues or problems are and discuss how splitting the database can resolve each situation. Knowing how to create front-end and back-end databases is an important skill for anyone using Microsoft Access, and this course will show you how to do this by offering a step-by-step example of how to create each, starting from the initial backup of a single database. This course will also build on your understanding of Microsoft Access 2021 databases by showing you how to connect and link the two halves of a split database together to make a functioning database application that behaves as a single database.

In this course, you will learn about the different reasons why you should split a database in Microsoft Access 2021. We will explain how to create a split database with step-by-step examples for both front-end databases and back-end databases. We will also discuss how to connect the two split portions of the database to function as a single database again.

Lo que aprenderás

Entiende por qué debes dividir una base de datos de Microsoft Access 2021 y cómo hacerlo
Crea una base de datos front-end siguiendo un ejemplo paso a paso
Crea una base de datos back-end comenzando desde una copia de seguridad de una sola base de datos
Conecta y vincula las mitades front-end y back-end para que funcionen como una sola base de datos
Identifica los diferentes problemas que la división de una base de datos puede resolver

Puntos clave

Dividir una base de datos es una técnica común usada para resolver varios problemas que pueden surgir con aplicaciones de base de datos.
El curso explica las diferentes razones por las que debes dividir una base de datos en Microsoft Access 2021.
Demuestra cómo crear bases de datos front-end y back-end con ejemplos paso a paso, comenzando desde la copia de seguridad inicial de una sola base de datos.
Muestra cómo conectar las dos porciones divididas de una base de datos para que la aplicación se comporte como una sola base de datos que funciona.
Saber cómo crear bases de datos front-end y back-end se presenta como una habilidad importante para cualquiera que use Microsoft Access.

Preguntas frecuentes

¿Para quién es este curso?

Es para cualquiera que use Microsoft Access que desee aprender cómo dividir una base de datos, ya que saber cómo crear bases de datos front-end y back-end se describe como una habilidad importante para usuarios de Microsoft Access.

¿Qué cubre este curso?

Cubre por qué debes dividir una base de datos en Microsoft Access 2021, cómo crear bases de datos front-end y back-end con ejemplos paso a paso, y cómo conectar las dos porciones divididas para que funcionen como una sola base de datos de nuevo.

¿Qué habilidades ganaré de este curso?

El curso cubre habilidades incluyendo Microsoft Access, aplicación de base de datos, desarrollo de base de datos, partición de base de datos, programación de base de datos y componentes de acceso a datos de Microsoft.

¿Qué lecciones se incluyen?

El curso incluye tres lecciones: ¿Por qué dividir una base de datos?, creando la base de datos front-end, y creando la base de datos back-end.

¿Muestra el curso cómo reconectar la base de datos dividida?

Sí. Analiza cómo agregar vínculos entre bases de datos front-end y back-end y conectar las dos porciones divididas para que la base de datos funcione como una sola base de datos nuevamente.