Microsoft Access 2021 avançado: Trabalhando com objetos ocultos

Name: Microsoft Access 2021 avançado: Trabalhando com objetos ocultos
Author: John Varan

Learn how to use hidden database objects to your advantage

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

Curso: sob 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.

Avançado Fornecedor : John Varan 4 lições · 21m em Árabe, Alemão, Inglês, Espanhol, Francês, Português, Chinese

Descrição do 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.

O Que Você Vai Aprender

Discutir as melhores práticas para objetos ocultos e quando usá-los
Identificar quais objetos de banco de dados podem ser ocultos e quando você deve ou não ocultá-los
Ocultar formulários, tabelas e campos de tabela no Microsoft Access
Distinguir entre ocultar formulários, tabelas e campos e o que cada um faz para sua aplicação de banco de dados
Trabalhar com Tabelas do Sistema do Microsoft Access e exibi-las quando necessário

Principais Conclusões

Existem múltiplos cenários onde ocultar objetos de banco de dados pode ser vantajoso, e este curso explora cada um com exemplos práticos.
Ocultar formulários, tabelas e campos de tabela funciona de formas diferentes e serve para um propósito diferente em uma aplicação de banco de dados.
Conhecer a diferença entre objetos de banco de dados como formulários, tabelas e campos ajuda você a gerenciar melhor os bancos de dados.
Tabelas do Sistema do Microsoft Access podem ser exibidas quando você precisar delas, e o curso explica como trabalhar com elas.
O curso aborda quando você deve e não deve ocultar objetos, não apenas como ocultá-los.

Perguntas Frequentes

O que vou aprender neste curso?

Você aprenderá quais objetos de banco de dados podem ser ocultos, quando você deve e não deve ocultar objetos e como fazê-lo, incluindo a diferença entre ocultar formulários, tabelas e campos de tabela, e como trabalhar com tabelas do sistema.

Este curso é apropriado para iniciantes no Microsoft Access?

O curso se baseia no seu conhecimento existente do Microsoft Access, explicando conceitos como Tabelas do Sistema do Microsoft Access e a diferença entre formulários, tabelas e campos.

Quais lições este curso inclui?

O curso inclui as lições: Quando Ocultar e Quando Não Ocultar, Formulários Ocultos, Tabelas Ocultas e Campos Ocultos.

O curso inclui exemplos práticos?

Sim, o curso explora diferentes cenários para ocultar objetos de banco de dados com exemplos que você pode acompanhar.

Quais habilidades este curso aborda?

Aborda habilidades incluindo Controles de Acesso, Linguagens de Consulta de Acesso, Microsoft Access, Componentes de Acesso a Dados da Microsoft, Métodos de Acesso a Objetos e Acesso Simples a Banco de Dados de Objetos.