Microsoft Access 2021 für Fortgeschrittene: Arbeiten mit ausgeblendeten Objekten

Name: Microsoft Access 2021 für Fortgeschrittene: Arbeiten mit ausgeblendeten Objekten
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.

Kurs: On-Demand

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.

Fortgeschritten Anbieter : John Varan 4 Lektionen · 21m auf Arabisch, Deutsch, Englisch, Spanisch, Französisch, Portugiesisch, Chinese

Kursbeschreibung

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.

Was Sie lernen werden

Besprechen Sie Best Practices für versteckte Objekte und wann Sie diese verwenden sollten
Identifizieren Sie, welche Datenbankobjekte ausgeblendet werden können, und wann Sie diese ausblenden sollten oder nicht
Blenden Sie Formulare, Tabellen und Tabellenfelder in Microsoft Access aus
Unterscheiden Sie zwischen dem Ausblenden von Formularen, Tabellen und Feldern und was jedes für Ihre Datenbankanwendung bewirkt
Arbeiten Sie mit Microsoft Access-Systemtabellen und zeigen Sie diese bei Bedarf an

Wichtige Erkenntnisse

Es gibt mehrere Szenarien, in denen das Ausblenden von Datenbankobjekten vorteilhaft sein kann, und dieser Kurs untersucht jedes mit Schritt-für-Schritt-Beispielen.
Das Ausblenden von Formularen, Tabellen und Tabellenfeldern funktioniert unterschiedlich und erfüllt einen anderen Zweck in einer Datenbankanwendung.
Das Kennen des Unterschieds zwischen Datenbankobjekten wie Formularen, Tabellen und Feldern hilft Ihnen, Datenbanken besser zu verwalten.
Microsoft Access-Systemtabellen können angezeigt werden, wenn Sie sie benötigen, und der Kurs erklärt, wie Sie damit umgehen.
Der Kurs behandelt, wann Sie Objekte ausblenden sollten und wann nicht, nicht nur wie Sie diese ausblenden.

Häufig gestellte Fragen

Was werde ich in diesem Kurs lernen?

Sie lernen, welche Datenbankobjekte ausgeblendet werden können, wann Sie Objekte ausblenden sollten und wann nicht, und wie Sie dies tun, einschließlich des Unterschieds zwischen dem Ausblenden von Formularen, Tabellen und Tabellenfeldern, und wie Sie mit Systemtabellen arbeiten.

Ist dieser Kurs für Anfänger in Microsoft Access geeignet?

Der Kurs basiert auf Ihrem vorhandenen Verständnis von Microsoft Access und erläutert Konzepte wie Microsoft Access-Systemtabellen und den Unterschied zwischen Formularen, Tabellen und Feldern.

Welche Lektionen sind in diesem Kurs enthalten?

Der Kurs umfasst die Lektionen: Wann Sie ausblenden sollten und wann nicht, Versteckte Formulare, Versteckte Tabellen und Versteckte Felder.

Enthält der Kurs praktische Beispiele?

Ja, der Kurs untersucht verschiedene Szenarien zum Ausblenden von Datenbankobjekten mit Beispielen, denen Sie folgen können.

Welche Fähigkeiten behandelt dieser Kurs?

Er behandelt Fähigkeiten einschließlich Zugriffskontrolle, Access-Abfragesprachen, Microsoft Access, Microsoft Data Access Components, Objektzugriffsmethoden und einfacher Objektdatenbankzugriff.