Microsoft Access 2021 avanzado: Trabajo con objetos ocultos

Name: Microsoft Access 2021 avanzado: Trabajo con objetos ocultos
Author: John Varan

In this course, you will learn which database objects can be hidden, when you should and should not hide objects, and how to do so. You will learn the…

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 hidden objects. In this lesson, I will show you what hidden objects are and how to know when to use and not use them. Hidden objects are just normal Microsoft Access database objects which are temporarily not visible. All of the database objects that show up in the navigation pane can be hidden. To do so, simply right -click on the item and choose hide. This will remove it from the navigation pane view. In order to show the hidden object again, right -click somewhere else in the navigation pane and choose navigation options. In this options window, select the checkbox that says show hidden objects and click OK. Previously hidden objects will now show up, but they will be lighter and faded. You can now right -click on one of those and choose unhide. You can also use the same method to hide and unhide entire groups. When you're done, if you want, you can go back and uncheck show hidden objects or you can leave it on. It just depends what you prefer seeing. There are several reasons why you may want to hide objects in the database, but first let me talk about a couple of reasons why you should not use hidden objects. Security and authorization. Security refers to hiding sensitive information. If your database has potentially sensitive information, such as social security numbers, simply hiding the tables where they are stored is not the correct way to handle it since anyone could just unhide those tables. There are much better and more secure ways to deal with sensitive data. Authorization has to do with controlling who has access to which information. If users are not supposed to have access to certain tables, you cannot simply hide the tables from them. There isn't a simple solution to this in Microsoft Access, but there are some possible workarounds. As to why you should use hidden objects, there are multiple scenarios where they can be useful. The simplest reason is for organizational purposes. If you have some tables that users do not need to see or use, you can hide them. Or if you have a lot of database objects while you're designing and developing the database, showing and hiding certain subsets as you work can keep things organized. Another reason to hide objects can be for administrative purposes. If some of the database objects are not relevant for end users and exist only for administrative purposes, they can be hidden most of the time and only unhidden when you need to use them. Keeping users from getting confused or overwhelmed can be another valid reason for hiding database objects. If your database is designed or structured in such a way that there are a lot of intermediate objects but users only work with the end result objects, then all of the intermediate database objects could potentially be hidden. A final situation for using hidden objects is actually the reverse of the others. It has to do with objects that are normally hidden but that you may want to unhide at certain times. Microsoft Access has certain tables called system tables, which are tables created and maintained by Microsoft Access itself. These are not tables that you would normally have to worry about at all. In fact, you normally can't even see them. They maintain information about the database itself. For example, there's a table that holds the name and information about all of the tables you create in the database. If you ever need or want to look at these tables, you would go to the navigation options like before and check show system objects. They'll show up looking like hidden tables with a faded light gray and they will all start with m sys. And then feel free to open and look at them. Some of the information in here can look fairly cryptic. However, make sure you never change the data in these tables. Thanks for watching. Stay tuned for the next lesson where I will show you about hidden forms.

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

Descripción del curso

There are multiple scenarios where hiding database objects can be advantageous, which is why this course will explore each of these different scenarios with examples that you can follow along with to learn how to use them. You will be able to better manage databases by learning the difference between various database objects, such as forms, tables, and fields, and the difference between hiding each of them and what they can do for your database application. This course will build on your understanding of Microsoft Access by explaining Microsoft Access System Tables and how to show them when you need them.

In this course, you will learn which database objects can be hidden, when you should and should not hide objects, and how to do so. You will learn the difference between hiding forms, tables, and table fields. You will also learn what system tables are and how to work with them.

Lo que aprenderás

Discutir mejores prácticas para objetos ocultos y cuándo usarlos
Identificar qué objetos de base de datos se pueden ocultar y cuándo debe o no ocultarlos
Ocultar formularios, tablas y campos de tabla en Microsoft Access
Distinguir entre ocultar formularios, tablas y campos y lo que cada uno hace por su aplicación de base de datos
Trabajar con Tablas del Sistema de Microsoft Access y mostrarlas cuando sea necesario

Puntos clave

Hay múltiples escenarios donde ocultar objetos de base de datos puede ser ventajoso, y este curso explora cada uno con ejemplos de seguimiento.
Ocultar formularios, tablas y campos de tabla funciona de manera diferente y sirve un propósito diferente en una aplicación de base de datos.
Conocer la diferencia entre objetos de base de datos como formularios, tablas y campos lo ayuda a administrar mejor las bases de datos.
Las Tablas del Sistema de Microsoft Access se pueden mostrar cuando las necesite, y el curso explica cómo trabajar con ellas.
El curso cubre cuándo debe y no debe ocultar objetos, no solo cómo ocultarlos.

Preguntas frecuentes

¿Qué aprenderé en este curso?

Aprenderá qué objetos de base de datos se pueden ocultar, cuándo debe y no debe ocultar objetos, y cómo hacerlo, incluida la diferencia entre ocultar formularios, tablas y campos de tabla, y cómo trabajar con tablas del sistema.

¿Es este curso adecuado para principiantes en Microsoft Access?

El curso se basa en su comprensión existente de Microsoft Access, explicando conceptos como Tablas del Sistema de Microsoft Access y la diferencia entre formularios, tablas y campos.

¿Qué lecciones incluye este curso?

El curso incluye las lecciones: Cuándo Ocultar y Cuándo No Ocultar, Formularios Ocultos, Tablas Ocultas y Campos Ocultos.

¿El curso incluye ejemplos prácticos?

Sí, el curso explora diferentes escenarios para ocultar objetos de base de datos con ejemplos que puede seguir.

¿Qué habilidades cubre este curso?

Cubre habilidades que incluyen Controles de Acceso, Lenguajes de Consulta de Acceso, Microsoft Access, Componentes de Acceso a Datos de Microsoft, Métodos de Acceso a Objetos y Acceso Simple a Base de Datos de Objetos.